Database Deadlock Exceptions when Updating Instance Variables (Doc ID 1066773.1)

Last updated on JULY 08, 2014

Applies to:

Oracle Business Process Management Suite - Version 10.3.1 to 10.3.1 [Release AS10gR3]
Information in this document applies to any platform.
***Checked for relevance on 06-Sep-2011***


Symptoms

The following exception occurs intermittently during the execution of an automatic activity. This activity updates the instance variables for an existing instance.

An unexpected error occurred while running an automatic item.
Details: An error occurred while accesing the database.
Detail:SQL statement: ' SELECT INSTANCEDATA, PROCESSID, INSTID, THREADID, NAME, PARENTTHREAD, PRIORITY, CREATIONTIME, AUTHOR, PARTICIPANT, NEXTPARTICIPANT, PROCESSDEADLINE, ACTIVITYDEADLINE, RECEIVETIME, ACTIVITYNAME, NTHREADS, CTHREADS, FCTHREAD, TOTALTHREADS, STATE, SOURCEACTIVITYNAME, ROLEIN, PENDINGITEMID, LASTRESULT, ITEMDEADLINE, NCHANGES , NREMARKS, NATTACHMENTS, HASPARTFORROLE,MICROACTIVITYNAME, V_BILLTYPECODE, V_BOOKINGAGENT, V_BOOKINGPARTY, V_BUSINESSUNIT, V_CSOPAMENDMENT, V_CSOPISSUANCE, V_CSOPMANIFESTING, V_CSOPQUICKSTEP, V_CARGOTYPE, V_CLARIFYDEADLINE, V_CLARIFYSTATUS, V_CLARIFYVIEW, V_CLUSTER, V_CONSIGNEENAME, V_CONTRACTUALCUSTO, V_COUNTRY, V_CUSTOMERNAME, V_ERRORTYPE, V_GSC, V_HOLDVAR, V_INDEXED, V_NEXTTASK, V_NOTIFYPARTYNAME, V_OPERATOR, V_PLACEOFDELIVERY, V_PLACEOFISSUE, V_PLACEOFRECEIPT, V_PLACERECIEPTCODE, V_PORTOFLOADING, V_REQUESTTYPE, V_SLAREMAINING, V_SHIPMENTNUMBER, V_SHIPPER, V_SLA, V_TASKLIST, V_TASKNAME, V_TASKPRIORITY, V_TASKSTATUS, V_TEAMNAME, V_TPDOCNUMBER, V_TPDOCTYPE, V_USERID, V_VESSEL, V_VIEWNAME, V_VOYAGE FROM PPROCINSTANCE WHERE PROCESSID = <id_number> AND INSTID = <id_number> AND THREADID = 0 FOR UPDATE'

Caused by: [BEA][Oracle JDBC 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