How to Troubleshoot a Data Warehouse Job

  • Article

Applies To: System Center Service Manager 2010 SP1

In System Center Service Manager 2010 Service Pack 1 (SP1), 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

  1. On the computer that hosts the data warehouse management server, click Start, point to Programs, point to Windows PowerShell 1.0, right-click Windows PowerShell, and then click Run as administrator.

  2. At the Windows PowerShell command prompt, type the following command, and then press ENTER.

    Add-PSSnapIn SMCmdletSnapIn

  3. Type the following command, and then press ENTER.

    Get-SCDWJob

  4. Review the output, and locate any job with a status of "Failed."

  5. 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

  6. 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.

  7. When you are ready to retry the failed job, type the following command, and then press ENTER.

    Resume-SCDWJob -JobName Transform.Common

Did you find this information helpful? Please send your suggestions and comments about System Center Service Manager documentation to scsmdocs@microsoft.com.