My Oracle Support Banner

3C Engine Process is Failing with Error "ORA-00060: deadlock detected while waiting for resource" (Doc ID 2513282.1)

Last updated on DECEMBER 26, 2019

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

The program 3CENGINE will end with a status of No Success.

The reason indicated in the .stdout file, as an example, is this: File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1723 Error Position: 7 Return: 60 - ORA-00060: deadlock detected while waiting for resource
Failed SQL stmt: UPDATE PS_LAST_3CS_TBL SET SEQ_COMM_LAST = SEQ_COMM_LAST + 1 WHERE COMMON_ID = 'NUMERIC_VALUE'


ERROR
-----------------------
 60 - ORA-00060: deadlock detected while waiting for resource


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run 3C Engine process instances concurrently
2. 3C ENGINE will end with a status of No Success. Receive error and this process affects other processes as well as does not commit changes

 

Changes

 

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
Changes
Cause
Solution
References


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