My Oracle Support Banner

Terriroty Management Fails With ORA-00060 Deadlock Detected. (Doc ID 2167740.1)

Last updated on MARCH 01, 2018

Applies to:

Siebel Territory Management - Version 8.1.1.14.9 [IP2014] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.14.9 [IP2014] version, Territory Management

We ran an alignment in UAT this afternoon that fails with a status "Run Tasks Failed". Looking at the Batch Assign task, we found out 4 tasks out of 10 with an error message ORA-00060 Deadlock detected.

While looking at My Oracle Support, we found out the reference to the following Doc:

Alignment Fails With Error In Task (Doc ID 2071862.1).

How can this be an acceptable solution ?

Should we tell the user to not update the data while the alignments are running? Even if just restarting the Alignment was possible without direct update on the database, this means we have lost around 3 hours.

Could you please let us know if there is something more Production acceptable to solve this situation?

ERROR:

DBCLog DBCLogError 1 000000115742001c:0 2016-05-25 15:47:28 [DataDirect][ODBC Oracle driver][Oracle]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!


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