question

ResearchAli-4720 avatar image
0 Votes"
ResearchAli-4720 asked ·

SCSM Data WarehouseJob Status is running from 2 days after rebuild the old Data Warehouse

At first, the issue was SCSM report did not come after some specific date. so we had tried to resolve that issue but the report was not there after some specific date.

so we decided to rebuild the old Data Warehouse and then we had follow bellow task

  1. unregister the old Data Warehouse

  2. remove the old Data Warehouse server

  3. configure a new server as a Data Warehouse with the same name and ip as like old Data Warehouse server

  4. successfully register the new Data Warehouse server

but after registering the new Data Warehouse the Data Warehouse job is stuck on running from 2 days and no report is their.


Note: as the SCSM Data retention period was long so all data was in SCSM operational databse.

68957-1.png




msc-service-manager-generalmsc-service-manager-setup
1.png (30.9 KiB)
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

XinGuo-MSFT avatar image
0 Votes"
XinGuo-MSFT answered ·

Hi,

Found a document which seemed helpful for our question, please refer to the link below.

Troubleshoot stuck data warehouse jobs in System Center Service Manager

https://docs.microsoft.com/en-us/troubleshoot/system-center/scsm/troubleshoot-stuck-data-warehouse-jobs

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.