ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Jobs fail to process receive ORA-01455 error
Article ID: 88142
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
Error Message :
ORA-01455: converting column overflows integer datatype
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.
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.
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.
Environment
OS Version: N/A
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
Fix Status: No Fix
Fix Version(s):
N/A
Additional Information
Workaround :
N/A
N/A
Feedback
Yes
No
Powered by
