Support Article
Commit errors occur when creating cases using a Batch process
SA-51359
Summary
Commit errors occur when creating cases using a Batch process.
Error Messages
Error in commit()
com.pega.pegarules.pub.database.DuplicateKeyException: ORA-00001: unique constraint (PEGA_DATA.XIXI_MY_WORK_CASE) violated
Steps to Reproduce
Create cases using the Batch process.
Root Cause
An issue in the custom application code or rules. Running some code paths deferred the Save actions for an initial case creation and did not perform a commit. Later, the same objects were written using an Obj-Save with Write Now, that is, the deferred list entries were not removed. When the code path performed a commit, the initial Save actions on the deferred list performed the commit.
Resolution
Perform the following local-change:Perform a commit instead of an Obj-Save with Write Now.
Published March 23, 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.