Question
Wells Fargo & Company
IN
Last activity: 3 Mar 2020 8:45 EST
Resetting "Last Reserved Id" before shipping the build
Hi Team,
What is the recommended way to reset "Last Reserved Id" of work objects before shipping the build?
Thanks & Regards
-------------------------
Venkata Naga Ganesh Murukuntla
Pegasystems Inc.
US
The class is Data-UniqueID. Can be updated using an Activity or by a DBA.
Using the LSA course's LLVM you would do the following:
cd "opt/PostgreSQL/9.6/pgAdmin 4/bin"
./pgAdmin4
localhost
> Databases
> pega
> Schema
> pegadata
> Tables
> pc_data_uniqueid
Right click > View/Edit > All rows
Click on pylastreserveid in the appropriate row
Wells Fargo & Company
IN
Hi PEDEL,
Thank you very much for the response. Actually I want to know what all steps we need to take care to avoid unique key violation issue in target environment before shipping a product from source environment.
The feedback which I got earlier was "case creation was failing as work objects were shipped without updating the last reserved id, this had to be fixed to proceed with case creation".
So could you please help me with details steps to be followed in this regards.
Thanks & Regards
--------------------------
Ganesh.MVN
Wells Fargo & Company
IN
Hi PEDEL,
When I check in the 8.3 LSA Exercise VM instance, upon cases creation pylastreserveid is not getting updated for the respective Data-UniqueID instance.
Do we need to set any DSS or any other settings.
Thanks & Regards,
Murukuntla, Venkata Naga Ganesh