3C Engine Process is Failing with Error "ORA-00060: deadlock detected while waiting for resource"
(Doc ID 2513282.1)
Last updated on APRIL 04, 2025
Applies to:
PeopleSoft Enterprise CS Campus Community - Version 9.2 and laterInformation 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 |