Error Message :
ORA-01455: converting column overflows integer datatype
When running jobs an an Automation Engine (AE) system using an Oracle database all Jobs stop processing and the above error message is seen in the log file.
This issue has been seen when the wrong MAXVALUE for the SQ_MQWP sequence was set in the Oracle database for AE.
OS Version: N/A
Root Cause: When the Automic database is created within Oracle a MAXVALUE of 999999999 is defined with the RECYCLE option. If this value is changed AE will eventually stop running and the ORA-01455 errors occur.
Ensure the Oracle database is configured with a MAXVALUE of 999999999 for the sequences with the RECYCLE option enabled. If the MAXVALUE is set to any other value the sequence must be corrected to resolve the issue.
Fix Status: No Fix