Remove From My Forums

Report problem in SCSM data warehouse server

Question
0

Sign in to vote

Hi All,

I have installed SCSM 2016 management server and register with SCSM data ware house server.Now after successful registration there is no reports are visible in SQL and also in scsm console.

Monday, July 1, 2019 10:12 AM

Reply

|

Quote

All replies

0

Sign in to vote

Check the logs in the Temp folders for the SCSM Data Warehouse server role was installed, it will give a detail on each management pack which was processed.

Also Try to run the Powershell command Get-SCSMDWJob and get some more details on why they failed
Website: www.walshamsolutions.com Technical Blog: https://www.walshamsolutions.com/technical-blog Personal Blog: https://www.walshamsolutions.com/personal-blog Twitter: Dwalshampro

Monday, July 1, 2019 3:09 PM

Reply

|

Quote
0

Sign in to vote

If you run the following in PS to see if any jobs have failed

Get-SCDWJob -ComputerName ********

Then run this for the failed job, in this example its the DWMaintenance job, this will then show you more info on that job

Get-SCDWJobModule -ComputerName ******* -JobName DWMaintenance

Tuesday, July 2, 2019 8:13 AM

Reply

|

Quote
0

Sign in to vote
Hi James,

Below are the results of the Get SCDWJobs.In first pic the deployment status of all the reports management packs are failed and the same status in scsm console.
- Edited by NajeebUllah Wednesday, July 3, 2019 5:02 AM
Wednesday, July 3, 2019 5:01 AM

Reply

|

Quote
0

Sign in to vote

Hi all

After the un-registration of the data warehouse server with SCSM management server and then re register still reports not working.

Wednesday, July 3, 2019 7:06 AM

Reply

|

Quote
1

Sign in to vote

Hello,

It seems the DW jobs are stuck in your case. You need to mark the stuck jobs as completed in sql and release lock if any job has taken it.Then you need to create new batches for all DW jobs. Once you see all DW jobs are in Not started state, then you need to manually start the jobs like DWMaintenance and MPSync and see if it completes successfully.

You can follow the below blog which has detailed steps for fixing this-

https://support.microsoft.com/en-in/help/4040022/troubleshooting-hung-data-warehouse-job-in-service-manager

Thursday, July 4, 2019 8:43 PM

Reply

|

Quote
0

Sign in to vote

Hi SWati06, I have followed the same steps that are in the shared artical but still the problem exsit.

Monday, July 8, 2019 6:31 AM

Reply

|

Quote
0

Sign in to vote

Hello,

What is the output of below sql query -

SELECT * FROM LockDetails

and what is the output of below PS commands-

Get-SCDWJob

Get-SCDWJobSchedule

Monday, July 8, 2019 9:47 AM

Reply

|

Quote
0

Sign in to vote

Hi Swati,

I have followed the above shared link step wise but still the problem exist.

Thursday, July 11, 2019 4:45 PM

Reply

|

Quote
0

Sign in to vote

Have you prepared the SSRS server correctly and given the service account the correct rights over the SQL server?

Check your install checklist once more: https://docs.microsoft.com/en-us/system-center/scsm/prepare-remote-ssrs?view=sc-sm-2019
Brett Moffett

Monday, July 15, 2019 10:55 PM

Reply

|

Quote
0

Sign in to vote

Well, you can always try this.

https://social.technet.microsoft.com/Forums/systemcenter/en-US/ff4aef12-dd06-4472-9ea0-d61f6190d262/install-scsm-2016-without-datawarehouse?forum=dwreportingdashboards#b2a4d4d3-c479-4859-b56b-6b7f325a097b

Tuesday, August 6, 2019 9:35 PM

Reply

|

Quote