My Oracle Support Banner

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

Last updated on SEPTEMBER 05, 2018

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

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
Solution


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