How to Troubleshoot a Data Warehouse Job
Updated: November 1, 2013
Applies To: System Center 2012 - Service Manager, System Center 2012 R2 Service Manager, System Center 2012 SP1 - Service Manager
In System Center 2012 – Service Manager, after the Data Warehouse Registration Wizard is complete and after Reporting becomes available in the Service Manager console, you can start running reports. If you encounter a problem with reports (for example, the incident management report you run does not show the current data), you can use Windows PowerShell cmdlets to troubleshoot the problem. For example, you can use the following procedure to determine whether a transform job failed, and you can evaluate any error messages that the transform job created.
To troubleshoot data warehouse jobs by using Windows PowerShell cmdlets
On the computer that hosts the data warehouse management server, click Start, click All Programs, click All Programs, click Accessories, and then click Windows PowerShell.
Type the following command, and then press ENTER.
Review the output, and locate any job with a status of "Failed."
Type the following command, and then press ENTER. In the command, specify the data warehouse job that failed as the value of the JobName parameter.
Get-SCDWJobModule -JobName Transform.Common
In the output, locate a status of "Failed," and then review the Error Message column for more information about why the data warehouse job failed.
When you are ready to retry the failed job, in the Service Manager console, click Data Warehouse.
Expand Data Warehouse, and then click Data Warehouse Jobs.
In the Data Warehouse Jobs pane, select the failed job in the list, and then click Resume in the Tasks list.
For additional resources, see Information and Support for System Center 2012.
Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.