Question
3
Replies
1173
Views
Cognizant
Cognizant
IN
Cognizant
Posted: October 3, 2017
Last activity: October 5, 2017
Last activity: 5 Oct 2017 0:33 EDT
Closed
pc_data_uniqueid table got reset
Hi,
The pc_data_uniqueid table got reset the root cause of which is not known . The cases are getting created with existing case id i.e. started from 1,2 .....
What could be the probable cause of the table getting reset .
Thanks
Posted: 4 years ago
PEGA
Pegasystems Inc.
US
Hi Nikhil,
I have few suggestions to have a look in order to find the root cause of the issue as follows:
- Check if the GenerateID OOTB activity is overridden, if so check the logic in it.
- We can also check the query history on the database table "PC_DATA_UNIQUEID" around the timestamps when the data got corrupted.
- Also check in between the timespan around the last correct work object and the corrupted first work object, to see what errors were triggered and what activites were performed at database level.
Hope this information might help you to proceed further in finding the root cause.
Regards
Mahesh
Posted: 4 years ago
PEGA
Pegasystems Inc.
US
If all of the counts started again at 1 that sounds like someone truncated the table at the database level.
Posted: 4 years ago
Cognizant
Cognizant
IN
The table was not truncated .