WORKSHEET PERFORMANCE DM ORA600 Deadlock Updating Records
(Doc ID 1514916.1)
Last updated on MARCH 08, 2017
Applies to:Oracle Demantra Demand Management - Version 7.3.1 and later
Information in this document applies to any platform.
On : 7.3.1 version, Technical
We are trying to update records for DC Events (a general level) at a high aggregation level. Even when only one user is updating the records, we are facing the issue as attached in the screenshot.
Also the collaborator log gives the following message 'java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource'.
Attaching the complete log for you review as well as the other relevant screenshot for the error poping up on the worksheet.
Please note, we bounced the server afresh and checked for any existing locks. There were no prior locks on the tables and no 2 users was logged in simultaneously.
ERROR java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource'.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!