Service Manager DW is not appearing in Service Manager Console Error 33566
Description: When you open Service Manager Console you see image blow.
When you check DW server you can see that all Service Manager services started
- System Center Data Access Service
- System Center Management
- System Center Management Configuration
Also you are able to open http://DWdatabase/reports and http://DWdatabase/ReportServer without any problems.
In event viewer we can see that error:
Error 33566
Cannot connect to Data Warehouse Management Server. Message= An unexpected error occured while connecting to Data Warehouse Management Server: Microsoft.EnterpriseManagement.Common.ServerDisconnectedException: The client has been disconnected from the server. Please call ManagementGroup.Reconnect() to reestablish the connection. —> System.ServiceModel.CommunicationObjectFaultedException: The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state.
Solution:
Check time on all SCSM Servers “Management Server and Data warehouse”. DW server time was different from the domain. Once we fixed that DW started to work again
DW Wunderbar is missing on SM Console. However the Reporting Wunderbar is there. http://DWdatabase/reports and http://DWdatabase/ReportServer are working. All services are working. We upgraded from 2010 to 2012. Do you have any clue regarding the cause of the misisng Wunderbar. 8 GB RAM on DW Server.
The errors on DW is below:
Deployment related exception has been caught during ETL. This is either due to a failure in Deployment or we have exceeded the number of retry attempts. Work item will be marked as failed.
Additional information:
ETLModule: etlMod=NULL
RetryAttempts: 0
WorkItem: WorkItemId = 47417683, processModuleId = 3376, isDirty = True, BatchId = 276651, status = Failed, RetryCount = 0, ErrorCount = 2297, TakenTime = 01/08/2013 09:25:04, Module = ModuleName = TransformIncidentStatusDurationFact, ModuleType = System, ModuleDescription = Deployment Execution Step, ProcessCategoryName = Transform, ProcessName = Transform.Common, DeletedBatchId=0
Exception details:
Exception type: Microsoft.EnterpriseManagement.Common.ObjectNotFoundException
Exception message: An object of class ManagementPackDataWarehouseScript with ID a023878a-c066-9b3e-776c-fce62db00ab4 was not found.
Stack trace:
at Microsoft.EnterpriseManagement.ReportingConfigurationManagement.GetDataWarehouseScript(Guid id)
at Microsoft.EnterpriseManagement.EnterpriseManagementGroup.Microsoft.EnterpriseManagement.Configuration.IO.IManagementPackSearch.GetDataWarehouseScript(ManagementPackElementReference`1 reference)
at Microsoft.EnterpriseManagement.Configuration.ManagementPackElementReference`1.FetchElement(IManagementPackSearch searcher)
at Microsoft.EnterpriseManagement.Configuration.ManagementPackElementReference`1.GetElement()
at Microsoft.SystemCenter.Warehouse.Etl.BaseModule.InitializeModule(ManagementPackWarehouseModuleType moduleType)
at Microsoft.SystemCenter.Warehouse.Etl.BaseModule..ctor(ManagementPackWarehouseModuleType moduleType)
at Microsoft.SystemCenter.Warehouse.Etl.Module..ctor(ManagementPackWarehouseModuleType warehouseModule)
at Microsoft.SystemCenter.Warehouse.Etl.TransformModule..ctor(ManagementPackWarehouseModuleType warehouseModule)
at Microsoft.SystemCenter.Warehouse.Etl.ModuleFactory.GetBaseModule(ManagementPackWarehouseModuleType warehouseModule)
at Microsoft.SystemCenter.Etl.ETLModule.GetModule(WorkItem etlWI)
at Microsoft.SystemCenter.Etl.ETLModule.OnDataItem(DataItemBase dataItem, DataItemAcknowledgementCallback acknowledgedCallback, Object acknowledgedState, DataItemProcessingCompleteCallback completionCallback, Object completionState)
Ozge – did you resolve this in the end?
http://social.technet.microsoft.com/Forums/en-US/systemcenterservicemanager/thread/4125b14c-958d-459e-a00b-2a98202c7dea/