ETL 8.x, 9.0:Time Administration concurrent Runs Abend with Deadlock at Step TL_TA001300.TA001300.Step013C (SQL) -- RC = 60 (108,524)
(Doc ID 953586.1)
Last updated on JULY 21, 2023
Applies to:PeopleSoft Enterprise HCM Time and Labor - Version 8.9 to 9.1 [Release 8.9 to 9]
Information in this document applies to any platform.
Running Time Administration (TL_TIMEADMIN )as 8 concurrent processes. It ran successfully for smaller numbers of employees but agains a big load, we receive the following deadlock errors in about half the processes each time the process is run:
Starting TL_TA001300 - Update TR Status (13507,13)
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1603 Error Position: 7 Return: 60 - ORA-00060: deadlock detected while waiting for resource
Failed SQL stmt:UPDATE PS_TL_TR_STATUS SET TA_STATUS = 'Y', LASTUPDDTTM = SYSDATE, EARLIEST_CHGDT = TO_DATE('2009-09-14','YYYY-MM-DD') WHERE EMPLID = '014725' AND EMPL_RCD = 0
Process 1124470 ABENDED at Step TL_TA001300.TA001300.Step013C (SQL) -- RC = 60 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
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