Insufficient Memory Error When Running Application Transaction Management (SCC_SL_SMP) AE Process (Doc ID 1631584.1)

Last updated on NOVEMBER 08, 2016

Applies to:

PeopleSoft Enterprise CS Recruiting and Admissions - Version 9 and later
PeopleSoft Enterprise CS Campus Community - Version 9 and later
Information in this document applies to any platform.

Symptoms

When running the delivered constituent and transaction processes (SCC_SL_SMP) with the Run Search Match, Post Constituent, and Post Transaction Data options checked, only the constituent data loads into the production tables and the following insufficient memory error are in the logs.

error. Stmt #: 897 Error Position: 21 Return: 8007 - Insufficient memory available
Failed SQL stmt:SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'SYS'
 
Also notice Memory Leaks caused by this process.

 

REPLICATION STEPS

------------------------

1.  Navigate to Campus Community > Constituent Transaction Mgmt > Transaction Management Process.

2.  Select Transaction Name, ID Selection, Process Submitted Transactions, along with Run Search Match, Post Constituent, and Post Transaction Data.

3.  Click Run.

4.  Select the check box for SCC_SL_SMP and click OK.

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