Issues with Service Manager DW are very common and hard to troubleshoot because you do not want to break the DW where you keep all your data. There is a knowledge base article from Microsoft released a day ago to help you with the issue described in it. You can find it here.
Lately it is troubleshooting period for me. My latest issue was with Service Manager and DW. After unexpected restart of the Service Manager Management Server, Service Manager Data Warehouse server and the SQL server that was holding the databases MPSyncJob couldn’t run fully and one particular MP was stuck in Pending Association. Microsoft.SystemCenter.Datawarehouse.OLAP.Base was associated successfully in another 3 batch ID’s but the last batch ID was always on Pending Association.
In the Operations Manager event log on the Data Warehouse server you will also see error 33527 appearing constantly.
So how do I solved this issue? There is a solution unfortunately it has some downsides. You can follow these steps:
1. Unregister the Service Manager DW from the Service Manager console.
2. Wait at least one day. I’ve waited two days.
4. Logon to the Analysis Services instance for the Service Manager and delete any existing cubes.
5. Register the Service Manager DW again.
6. Wait one day to see if all DW jobs are finishing successful. Check if Reporting pane is appearing in the console and it is working normally.
7. Check the Operations Manager event log for errors on the DW server.
After these steps everything should be ok with DW jobs. Keep in mind that in your case this solution might not work.
Software I’ve used:
- Windows Server 2012
- SCSM 2012 SP1 UR2
- SQL 2012 SP1
It seems you can only apply UR2 only if you’ve registered the DW to a Service Manager Management server and all DW jobs have passed successfully a couple of times.
These days I was installing System Center 2012 Service Manager SP1 and of course with every new SC installation you want to apply the latest Update Rollup too. I was in a hurry so I wanted to apply UR2 for Service Manager as soon as possible. I’ve installed the the Service Manager Management Server and the Data Warehouse Management server. Registered the DW Management server in the Management Server. I’ve waited some of DW jobs to finish but in order the jobs to finish successfully they have to run a couple of times because at the first job of MPSync only a small part of MPs are synchronized. On the second start more MPs are loaded (reporting MPs and etc.) and synced. So I’ve applied UR2 on the management server before MPSync job kicked off for second time and UR2 was applied successful to the management server. But when I’ve applied UR2 to the DW management server I’ve received an error:
An error occurred while executing a custom action:_PatchMP
The solution to this error in my case was to wait DW jobs to finish successful a couple of times. This error can occur for other reasons also.
Lessons learned: Patience is A Virtue with System Center 2012 Service Manager.
P.S. I do not like to install and configure System Center in a hurry. I like to plan and configure SC carefully and verifying if everything is working normally after every step but sometimes sacrifices have to be made .
Here you can find a download link to the new Data Warehouse Architecture Diagram. Thanks Travis for sharing.