Service Manager 2012 R2 Data WareHause Jobs not Enable

Currently I have the following scenario:

A server with Service Manager 2012 R2 RTM
A server with Service Manager DW
A server with SQL Server instance SCSM

aproccimadamente a month ago it was migrated Serive Manager 2012 RTM to SP1, then to 2012 R2 RTM.


After migration, all reports do not show updated data,

In DW server I see problems with warehouse tasks, as shown in the image.

when running Enable-SCDWJobSchedule -JobName XXXX does not work in any of the tasks still false.

can you help me??

September 3rd, 2015 7:11pm

Hi Boris,

i already replied to your first post. Here is my answer:

Hi Boris,

you have a challenge here, as those issues can have different causes. If I were you I would start by verifying my SSRS installation:

Verify a Reporting Services Installation
https://technet.microsoft.com/en-us/library/ms143773%28v=sql.110%29.aspx

Afterwards I would follow this guide and check the related MPs and the logs:

Troubleshooting the Data Warehouse: Reports arent deployed after registering the data warehouse
http://blogs.msdn.com/b/scplat/archive/2010/06/07/troubleshooting-the-data-warehouse-reports-aren-t-deployed-after-registering-the-data-warehouse.aspx

Then I'd go with the following three articles and address the issue with the jobs:

Troubleshooting the Data Warehouse: An overview
http://blogs.technet.com/b/servicemanager/archive/2010/06/07/troubleshooting-the-data-warehouse-an-overview.aspx

Service Manager Data Warehouse Troubleshooting
http://blogs.technet.com/b/mihai/archive/2014/11/25/service-manager-data-warehouse-troubleshooting.aspx

Resetting and running the Service Manager Data Warehouse Jobs separately
http://blogs.technet.com/b/mihai/archive/2013/07/03/resetting-and-running-the-service-manager-data-warehouse-jobs-separately.aspx

They'll give you a good idea of what to look for and how to troubleshoot the issue.

Hope this helps.

Regards,

Free Windows Admin Tool Kit Click here and download it now
September 4th, 2015 12:07pm

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

Other recent topics Other recent topics