Deadlock And Unique Constraint Error While Creating ToDo's From Batch Execution In Multithread Mode
(Doc ID 2975056.1)
Last updated on SEPTEMBER 26, 2023
Applies to:Oracle Financial Services Revenue Management and Billing - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On RMB v126.96.36.199.0, Deadlock and unique constraint error occurs while creating To Do's from batch execution in multithread mode.
We are getting below dead lock and unique constraint errors while creating To Do's from batch execution in multithreaded mode.
There was an issue in To do creation from C1FTRAN batches and received a patch - but this is happening with the patch fix applied as well.
Error 1: Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (CISADM.SYS_C0074596) violated
Error 2: 16:20:58,321  ERROR (org.hibernate.engine.jdbc.spi.SqlExceptionHelper) ORA-00060: deadlock detected while waiting for resource
java.sql.BatchUpdateException: ORA-00001: unique constraint (CISADM.SYS_C0074596) violated
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document