ORA-01455: Converting Column Overflows Integer Datatype In SRPCARD1 Cobol - Process SRPCAATP
(Doc ID 2987071.1)
Last updated on FEBRUARY 06, 2024
Applies to:
PeopleSoft Enterprise CS Academic Advisement - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
When attempting to run the Update Self-Service Reports process (SRPCAATP), the following error the following error occurs:
Application Program Failed
Action Type : SQL SELECT
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 01455
Error Message : ORA-01455: converting column overflows integer datatype
Stored Stmt : SRPCARD1_S_CLSTDTL
SQL statement text not available.
See the SQL trace for statement text
when this cursor was last compiled.
PTPSQLRT - Error Encountered
No longer have connection to DB due to an error from previous
action: SQL SELECT. Bypassing current action: SQL SELECT.
Terminating Program.
Action Type : SQL SELECT
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 01455
Error Message : ORA-01455: converting column overflows integer datatype
Stored Stmt : SRPCARD1_S_CLSTDTL
SQL statement text not available.
See the SQL trace for statement text
when this cursor was last compiled.
PTPSQLRT - Error Encountered
No longer have connection to DB due to an error from previous
action: SQL SELECT. Bypassing current action: SQL SELECT.
Terminating Program.
The issue can be reproduced at will with the following steps:
1. Update Self-Service Reports process (SRPCAATP),
2. Note errors
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 |