In System Center Service Manager 2010, 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.

      Copy Code
    Add-PSSnapIn SMCmdletSnapIn
    
  3. Type the following command, and then press ENTER.

      Copy Code
    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.

      Copy Code
    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.

      Copy Code
    Resume-SCDWJob -JobName Transform.Common