Old Incidents which not exist in Servicemanager DB

Ozgur_Sahin

Hello
There are many IRs or SRs(not closed status) on CİRESON PORTAL
They do not exist in Service manager DB
it is because the WorkItem table(in Servicemanagemend DB) is not actual
I want to use this query in order to solve this problem
-TRUNCATE TABLE WorkItem
after using this query will the CIRESON  work correctly?

will the "WorkItem" table update automatically?

Dakota_Green

Hello Ozhur,

If I'm correct, you have work items in the Portal/ServiceManagement DB, which are not available in the CMDB.

If that is the case, it may be due to the work items being put in a data warehouse, or outright deleted.

To resolve this, you want to run the following against your ServiceManagement DB:

TRUNCATE TABLE LastModified;
TRUNCATE TABLE WorkItem;

Afterward, restart the Cache Builder system service. This will bring into the ServiceManagement DB what work items are actually in the CMDB, resolving your issue.

I hope this helps.

Dakota_Green

Hello Ozhur,

If I'm correct, you have work items in the Portal/ServiceManagement DB, which are not available in the CMDB.

If that is the case, it may be due to the work items being put in a data warehouse, or outright deleted.

To resolve this, you want to run the following against your ServiceManagement DB:

TRUNCATE TABLE LastModified;
TRUNCATE TABLE WorkItem;

Afterward, restart the Cache Builder system service. This will bring into the ServiceManagement DB what work items are actually in the CMDB, resolving your issue.

I hope this helps.

Ozgur_Sahin

Dear Dakota_Green
I have done it . Thank you
I have a question
may I get any error if I delete something in DB "Servicemanagement" ?
do the tables of Servicemanagement DB update after restarting the cache ?