Insufficient Memory Error When Running Application Transaction Management (SCC_SL_SMP) AE Process
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.
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.
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.
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