Jobs fail to process receive ORA-01455 error

Document ID : KB000088142
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.  

Environment:
OS Version: N/A
Cause:
Cause type:
Configuration
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.
Resolution:
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

Fix Version(s):
N/A
Additional Information:
Workaround :
N/A