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.

Symptoms

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'.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms