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

Question

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.

Answer 1

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://learn.microsoft.com/en-us/troubleshoot/system-center/scsm/troubleshoot-stuck-data-warehouse-jobs