TL8.x: AppEngine/Temp Table Allocation Errors in Time Administration (Doc ID 610933.1)

Last updated on JULY 13, 2016

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 8 and later
Information 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

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