Terriroty Management Fails With ORA-00060 Deadlock Detected.
Last updated on MARCH 01, 2018
Applies to:Siebel Territory Management - Version 220.127.116.11.9 [IP2014] and later
Information in this document applies to any platform.
On : 18.104.22.168.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?
DBCLog DBCLogError 1 000000115742001c:0 2016-05-25 15:47:28 [DataDirect][ODBC Oracle driver][Oracle]ORA-00060: deadlock detected while waiting for resource
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms