SCSM - Reports not updated

hi,

we have a new installation of SCSM 2012 server,  the SQl server is separate on a cluster

my SCSM 2012 reports show only data prior to 09-01-2015. records prior to that are shown in all reports.

how can I troubleshoot this ?   any help would be appreciated :( 

regards

ZUF

January 30th, 2015 5:24pm

Sounds like problem with the data warehouse. 

1. Look at the data warehouse jobs and see if they are in a failed status

2. Look at the operation managers logs on the data warehouse management server and see if you can find any errors there. 

Free Windows Admin Tool Kit Click here and download it now
January 30th, 2015 5:32pm

When did the cubes last process?
January 30th, 2015 6:04pm

all cubes were processed today at 8pm non of them failed

software update cube

service manager workitem cube

service manager configitem cube

power mgmt. cube

change and activity mgmt. cube

service manager service catalog library cube

all the data warehouse jobs are showing not started.

I can see alerts in the event vwr ops manager section but donw know what to make out of it..



  • Edited by ZaidUmer Friday, January 30, 2015 6:56 PM
Free Windows Admin Tool Kit Click here and download it now
January 30th, 2015 9:55pm

all cubes were processed today at 8pm non of them failed

software update cube

service manager workitem cube

service manager configitem cube

power mgmt. cube

change and activity mgmt. cube

service manager service catalog library cube

all the data warehouse jobs are showing not started.

I can see alerts in the event vwr ops manager section but donw know what to make out of it..



  • Edited by ZaidUmer Friday, January 30, 2015 6:56 PM
January 30th, 2015 9:55pm

all cubes were processed today at 8pm non of them failed

software update cube

service manager workitem cube

service manager configitem cube

power mgmt. cube

change and activity mgmt. cube

service manager service catalog library cube

all the data warehouse jobs are showing not started.

I can see alerts in the event vwr ops manager section but donw know what to make out of it..



  • Edited by ZaidUmer Friday, January 30, 2015 6:56 PM
Free Windows Admin Tool Kit Click here and download it now
January 30th, 2015 9:55pm

can't see "last run"
January 30th, 2015 9:59pm

Resume MPSyncJob.
Free Windows Admin Tool Kit Click here and download it now
January 30th, 2015 11:40pm

the last runs are available.  they were hidden below. most of them are scheduled to run every 24 hours except for

Extract_DW_EBMSM  - 5 minutes

load.CMDWDatamart  - 1 hour

load.OMDWDatamart - 1 hour

load.common - 1 hour

Extract_EBMSM_MS - 5 minutes

Transform.Common - 30 minutes

MSPSync - 1 hour

I have started the MPSync, it ran and now it shows next run after 1 hour status not running.

how do I verify if this was run successfully.

January 31st, 2015 3:16am

Hi,

Here is an artilce about using powershell to check DataWarehouse Job Module Status, it should be helpful:

http://blogs.technet.com/b/georgewallace/archive/2013/06/11/check-datawarehouse-job-status.aspx

Regards,

Yan Li

Free Windows Admin Tool Kit Click here and download it now
February 1st, 2015 10:24pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics