My Oracle Support Banner

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

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
Symptoms
Cause
 Avoidance
Solution
 General Deadlocks:
 Demantra Deadlocks
 INDEX ADVISER
 Permission Levels
 QUERY SERVLET REPORT:
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.