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

Last updated on MARCH 02, 2017

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

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