My Oracle Support Banner

WORKSHEET PERFORMANCE DM ORA600 Deadlock Updating Records (Doc ID 1514916.1)

Last updated on JULY 05, 2021

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!

In this Document
 General Deadlocks:
 Demantra Deadlocks
 Permission Levels

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.