Options
Old Incidents which not exist in Servicemanager DB
Ozgur_Sahin
Customer IT Monkey ✭
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?
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?
0
Best Answer
-
Options
Dakota_Green
Member Advanced IT Monkey ✭✭✭
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.
5
Answers
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.
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 ?