Question
Accenture
IN
Last activity: 16 Oct 2023 8:06 EDT
Case ID generating random number instead of 1 for the first case
Hi All,
When I tried to create a case, the case ID starts from ABC-1218. Ideally it should be ABC-1 because this is the very first case created. This is happening in one of the higher environment, but working correctly in the lower environment.
I checked idGenerator/defaultBatchSize rule. The value is set to 1.
Any help is appreciated.
Thanks in advance,
Sakhib Hussain
Tekclan Software Solutions
IN
@SakhibHussain we have class called Data-UniqueID for prefix ABC will have a one entry, in that row check pyLastReservedID column once if that value is 1218 update to 0 or 1, so that next ID generation will happen in sequence.
Accenture
IN
@DhanasekarC0202 I checked Data-UniqueID, when I filtered out ABC-, I can see after clicking the ABC- label, there is pyLastReservedID which is set to 1218. How can I make it to 0 or 1.
I checked there is a pyDefault DT, having pyLastReservedID equals blank. I tried to save as this rule to my ruleset and set pyLastReservedID=0. Still I am not able to solve this. Still cases are creating from 1218 onwards.
Pegasystems Inc.
CA
Bits in Glass
IN
@SakhibHussain please try this one too. Obj-openbyhandle last instance change value from 1218 to 0 or 1.
Accenture
IN
@Anoop Krishna I tried this, but the ID 1218 reamains in instance list along with 0. 0 will be the duplicate of 1218. Then 1218 may cause issue in future!
Tech Mahindra
IN
@SakhibHussain if you are into pega cloud, raise a cc ticket and give them update query.
example : update pc_data-uniqueid set pylastreservedid='1' where pxinsname='!ABC-' and pyprefix='ABC'
Updated: 13 Oct 2023 5:53 EDT
Accenture
IN
@Birupakhya@Anoop Krishna @sangr2
I see we have the solution for this, but what is the cause of this ? Ideally it should start from 1 right? What might be the reason for this?
Thanks,
Sakhib Hussain
NCS Pte. Ltd
SG
Hi @SakhibHussain: How is your DB setup done for higher environment? Is it cloned from the lover environment?
Or, please check if you have the instances included in any of your package.
Thanks.
Tech Mahindra
IN
@SakhibHussain please go trough the "https://support.pega.com/discussion/case-id-generation-mechanism", which one is already mentioned by @sangr2