How to Determine When Data Warehouse Registration Is Complete
Updated: May 13, 2016
Applies To: System Center 2012 SP1 - Service Manager, System Center 2012 R2 Service Manager, System Center 2012 - Service Manager
Several management packs are imported during the data warehouse registration process in System Center 2012 – Service Manager. Data warehouse registration is complete when all of the management packs have been imported. You will have to determine when that process is complete by using the following procedure.
To determine when management pack deployment has completed
Start the Service Manager console.
In the Service Manager console, select Data Warehouse.
In the Data Warehouse pane, expand Data Warehouse, and then click Data Warehouse Jobs.
In the Data Warehouse Jobs pane, click MPSyncJob.
In the MPSyncJob details pane, in the Synchronization Job Details list, scroll to the right to view the Status column, and then click Status to alphabetically sort the status column.
Scroll through the Status list. The management pack deployment process is complete when the status for all of the management packs is Associated or Imported. Make sure that there is no status of either Pending Association or Failed in the status list. In the Data Warehouse Jobs pane, the status of the MPSyncJob will have changed from Running to Not Started when the registration process is complete. This deployment process can take up to two hours to complete.
Use the following steps to periodically refresh the Data Warehouse Job pane to monitor the progress of the registration process:
In the Tasks pane, under Data Warehouse Jobs, click Refresh.
In the Data Warehouse Jobs pane, click MPSyncJob.
In the MPSyncJob details pane, in the Synchronization Job Details list, scroll to the right to view the Status column, and then click Status to alphabetically sort the status column.
After the management packs have been deployed (as determined in step 6), make sure that the following five data warehouse jobs appear in the Data Warehouse Jobs pane:
Extract_<Service Manager management group name>
Extract_<data warehouse management group name>
Load.Common
Transform.Common
MPSyncJob
Note
If these five data warehouse jobs do not appear, complete the following steps:- In the Data Warehouse Jobs pane, click MPSyncJob.
- In the Tasks pane, under Synchronization, click Resume.
- Determine whether management pack deployment is complete by repeating steps 4through 6.