Support Article
Rename, Delete, and Copy wizards fail with pyCommitError
SA-63455
Summary
The Rename a Class, Delete a Class, and Copy/Merge Ruleset wizards fail with pyCommitError in Designer Studio.
Error Messages
pyCommitError - using an insert failed
Steps to Reproduce
Run the Rename a Class, Delete a Class, or Copy/Merge Ruleset wizard.
Root Cause
A defect or configuration issue in the operating environment.
After upgrading from Pega 7.1 to Pega 7.3 there are two databases, one for PegaRules and another for PegaData. The pyID is generated from one database running the store procedue sppc_data_uniqueid_withouttran and getting pyLastReservedID from the table pc_data_uniqueid. This ID was then inserted in the pc_work_accel table in the other database. There was a mismatch between these tables.
Resolution
Perform the following local-change:Update the pyLastReservedId column in pc_data_uniqueid table to a number higher than that of pyID column in the pc_work_accel table.
Published September 19, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.