Posted: 15 Sep 2020 23:52 EDT Last activity: 19 May 2021 6:31 EDT
Where is the case sequence ID stored in each node after 8.3?
Case ID generation mechanism is changed from Pega 8.3. Prior to this version, Pega used to hold the last sequence ID in the PC_DATA_UNIQUEID table, but not any more. PC_DATA_UNIQUEID table is still used, but slightly differently. The sequence ID is managed by each node now. I tried to search clipboard but couldn't find it. Can someone tell me where exactly the latest ID is stored on the node? Isn't that in memory if not table?
***Edited by Moderator: Pooja Gadige to add platform capability tag***
Have a look at the API call getUniqueID in the java step of activity Work- GenerateID.
The table PC_DATA_UNIQUEID is still being used and the IDs are stored in batch level.
For example, if you keep the batch size as 1000, and if you have two nodes in your environment, then the first node gets the first batch and pylastreserveid will be updated. if this node is crashed, then you will lose the IDs in this batch.
This is introduced to improve the performance and this can be changed by using below DSS:
•Set to 1000 by default, can be changed
•Applies globally to all case-types
•Can be overridden for a specific case-type by using idGenerator/<case-type-prefix with hyphen>/batchSizeto a different value
Thanks, but I know all the details from 2nd line. Table stores the batch size ID (ex. 1000, 2000, ...), not exact ID. My question is specifically about where this exact ID is stored - memory (app node), or table (database server). If it is memory, clipboard or some other area. If the answer for this is "engine level", can you please elaborate it because when someone refers to "engine", it usually means database? This 8.3 change is meant for performance improvement and I don't think it goes to database any more.