ETL9.2:App Engine TL_TIMEADMIN - Abends On TRUNCATE

(Doc ID 2372384.1)

Last updated on MAY 09, 2018

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, pum 22, tools 8.55.16 db database Time Administration

App Engine TL_TIMEADMIN - Abends on TRUNCATE

The TL_TIMEADMIN Abends on a TRUNCATE command. It seems to be when data exists in the table.

The SQL Error: [IBM][CLI Driver][DB2/AIX64] SQL0951N The object "ACCESSHR.PS_TL_TA_BATCHC4" of type "TABLE" cannot be altered because it is currently in use by the same application process. SQLSTATE=55007
 (SQLSTATE 55007) -951
 

ERROR
-----------------------
SQLSTATE=55007, -951

ile: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2/AIX64] SQL0951N The object "ACCESSHR.PS_TL_TA_BATCHC4" of type "TABLE" cannot be altered because it is currently in use by the same application process. SQLSTATE=55007
 (SQLSTATE 55007) -951
Failed SQL stmt: TRUNCATE TABLE PS_TL_TA_BATCHC4 REUSE STORAGE IMMEDIATE
 GetNextStateRecord [68] Exception logged: RC=3.
 ExecuteSql [1345] Exception logged: RC=8.
 ExecuteSql [1464] Exception logged: RC=8.
 DoSqlAction [2564] Exception logged: RC=8.
 DoSqlAction [2613] Exception logged: RC=8.
 DoStepActions [2033] Exception logged: RC=8.

Process 2935909 ABENDED at Step TL_TA000300.AA000.Step051 (SQL) -- RC = 8601 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
 DoMessageLogError [1119] Exception logged: RC=7.
 ExecuteStep [1059] Exception logged: RC=8.
 ExecuteSection [713] Exception logged: RC=8.
 CallSection [2219] Exception logged: RC=8.
 DoStepActions [2005] Exception logged: RC=8.
 ExecuteSection [713] Exception logged: RC=8.
 CallSection [2219] Exception logged: RC=8.
 DoStepActions [2005] Exception logged: RC=8.
 ExecuteSection [713] Exception logged: RC=8.
 AeExecExecute [326] Exception logged: RC=8.
 ProcessRequest [1863] Exception logged: RC=8.
 SQL Error: [IBM][CLI Driver][DB2/AIX64] SQL0951N The object "ACCESSHR.PS_TL_TA_BATCHC4" of type "TABLE" cannot be altered because it is currently in use by the same application process. SQLSTATE=55007
 (SQLSTATE 55007) -951
 CommonMain [1750] Exception logged: RC=8.

Timings written to trace file (/psoft/pt855_server_cfg/hrtec/appserv/prcs/HRTEC/log_output/AE_TL_TIMEADMIN_2935909/AE_TL_TIMEADMIN_2935909_0724121849.AET)
 AeMainFromCommandLine [829] Exception logged: RC=8.
 



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run time admin for all employees using all group

Changes

 

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