Jobs fail to process receive ORA-01455 error

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

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.  

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.

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

Additional Information

Workaround :
N/A