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 AUGUST 04, 2017

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 8.9 to 9.1 [Release 8.9 to 9]
Information in this document applies to any platform.
***Checked for relevance on 29-Apr-2011***


Symptoms

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

Cause

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