TL8.x: AppEngine/Temp Table Allocation Errors in Time Administration
(Doc ID 610933.1)
Last updated on OCTOBER 07, 2024
Applies to:
PeopleSoft Enterprise HCM Time and Labor - Version 8 and laterInformation in this document applies to any platform.
SPECIFIC TO:
Time and Labor, Time and Labour, TL8, T&L, Commercial, Federal, Public Sector, Education & Government, Student Administration, PeopleSoft 8, Time Administration, Release 8, 8SP1, Service Pak 1
This document was previously published as Customer Connection Solution 705521
Symptoms
For any application engine process that is run in Time and Labor there is a potential to have the process abend with no success and a message like:
Application ended due to a problem encountered during the internal housekeeping of Temporary Tables.
The possible failure points are as follows:
C++ Memory allocation for adding new temp tables to the existing internal array.
SQL processing errors for one of the following:
Update to PSAELOCKMGR error
SELECT to get available instance number.
INSERT to PSAETEMPTBLMGR to reserve the instance number.
TRUNCATE/DELETE for the temp table name chosen error.
Cause
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
Symptoms |
Cause |
Solution |
References |