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

ResearchAli 1 Reputation point
2021-02-17T06:30:36.74+00:00

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

Service Manager
Service Manager
A family of System Center products for managing incidents and problems.
210 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. XinGuo-MSFT 14,536 Reputation points
    2021-02-18T02:28:11.96+00:00

    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

    0 comments