'SEVERE ERROR(14645,999) PI() Program(SRPCWLPR)' on Wait List Process when Enrollment Request Detail Sequence Number > 9999
(Doc ID 2353808.1)
Last updated on FEBRUARY 03, 2019
Applies to:
PeopleSoft Enterprise CS Student Records - Version 9 and laterInformation in this document applies to any platform.
Symptoms
ISSUE STATEMENT
---------------
When running the Waitlist process against the entire term, the process takes over 4 hours and sometimes returns the following error:
ERROR
---------------
> 2015-08-24-04.41.01.380000 SEVERE ERROR(14645,999) PI() Program(SRPCWLPR)
PTPSQLRT error in: INSERT I-ERDT.
This issue occurs when the Bind-2 value reaches 9999 and then begins again at 0. Bind 2 correlates to the ENRL_REQ_DETL_SEQ number in the ENRL_REQ_DETAIL record.
STEPS
---------------
The issue can be reproduced with the following steps:
1. Run the waitlist process against the entire term where there are more than 23000 rows to be processed.
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 |