MP Stuck in Pending Association in MPSyncJob in Service Manager 2012 SP1


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.

image

In the Operations Manager event log on the Data Warehouse server you will also see error 33527 appearing constantly.

image

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
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s