ETL9.2:TL_TIMEADMIN Abends With An Error on Table PS_TL_ABS_NT_TAO

(Doc ID 2309089.1)

Last updated on SEPTEMBER 27, 2017

Applies to:

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

Symptoms

On : 9.2 version, Time Administration

ACTUAL BEHAVIOR
---------------
TL_TIMEADMIN abends

Getting error:

File: E:\pt85517b-retail\peopletools\src\psappeng\psaesql.cppSQL error. Stmt #: 3086 Error Position: 0 Return: 601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot find the object "PS_TL_ABS_NT_TAO4" because it does not exist or you do not have permissions.
Failed SQL stmt: TRUNCATE TABLE PS_TL_ABS_NT_TAO4

Temporary Table processing failure during allocation phase. (108,530)


 
<META http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3Dwindows-1252">
<META name=3D"GENERATOR" content=3D"MSHTML 11.00.9600.18538"></HEAD>
<BODY>
<PRE>PeopleTools 8.55.17 - Application Engine Server=0A=
Copyright (c) 1988-2017 Oracle and/or its affiliates.=0A=
All Rights Reserved=0A=
=0A=
=0A=
PSAESRV started service request at 09.18.48 2017-09-19=0A=
=0A=
=0A=
File: E:\pt85517b-retail\peopletools\src\psappeng\psaesql.cppSQL error. =
Stmt #: 3086 Error Position: 0 Return: 601 - [Microsoft][SQL Server =
Native Client 11.0][SQL Server]Cannot find the object =
"PS_TL_ABS_NT_TAO4" because it does not exist or you do not have =
permissions.=0A=
Failed SQL stmt: TRUNCATE TABLE PS_TL_ABS_NT_TAO4=0A=
=0A=
Temporary Table processing failure during allocation phase. (108,530)=0A=
=0A=
PSAESRV completed service request at 09.18.48 2017-09-19=0A=
=0A=

EXPECTED BEHAVIOR
-----------------------
Time admin should not abend

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run time admin process
2.It abends with above error

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