ETL9.2: ORA-00060 Deadlocks Occuring During Time Admin Processing (Doc ID 2107213.1)

Last updated on SEPTEMBER 30, 2016

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

Having deadlock issues when multiple threads of Time Admin are processing concurrently.

Sample ABEND

These are deadlock issues
Of the 16 threads, 8 have finished successfully and 8 have abended.


File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1703 Error Position: 7 Return: 60 - ORA-00060: deadlock detected while waiting for resource
Failed SQL stmt: UPDATE PS_TL_TR_STATUS SET PROCESS_INSTANCE = 3631779 WHERE PROCESS_INSTANCE NOT IN ( SELECT PRCSINSTANCE FROM PSPRCSRQST WHERE RUNSTATUS IN ('3','4','7','10')) AND PROCESS_INSTANCE NOT IN ( SELECT E.PROCESS_INSTANCE FROM PS_TL_EMPL_DATA E WHERE E.EMPLID=PS_TL_TR_STATUS.EMPLID AND E.EMPL_RCD = PS_TL_TR_STATUS.EMPL_RCD) AND EXISTS ( SELECT 1 FROM PS_TL_TA_TRLIST14 TL WHERE TL.EMPLID = PS_TL_TR_STATUS.EMPLID AND TL.EMPL_RCD = PS_TL_TR_STATUS.EMPL_RCD)

 

Solution

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