Question

3
Replies
1068
Views
nikhilk7251 Member since 2016 56 posts
Cognizant
Posted: 3 years ago
Last activity: 3 years ago
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

Data Integration
Close popover
Moderation Team has archived post
Posted: 3 years ago

Hi Nikhil,


I have few suggestions to have a look in order to find the root cause of the issue as follows:


  1. Check if the GenerateID OOTB activity is overridden, if so check the logic in it.

  2. We can also check the query history on the database table "PC_DATA_UNIQUEID" around the timestamps when the data got corrupted.

  3. 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: 3 years ago

If all of the counts started again at 1 that sounds like someone truncated the table at the database level. 
Share this page LinkedIn
Copied!