Job processing stops: U0003592 UCUDB - Status: '' Native error: '1455' Msg: 'ORA-01455 error is displayed

Document ID : KB000084540
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
U0003592 UCUDB - Status: '' Native error: '1455' Msg: 'ORA-01455: converting column overflows integer datatype'

Job processing stops and the above error message is seen in the WP log.
 
Environment:
OS Version: N/A
Cause:
Cause type:
Other
Root Cause: The ORA-01455 error is an Oracle error that is caused by incorrect sequence limit values in the DB. As this is an Oracle error there is nothing that can be done from the Automation Engine database to prevent the error.
Resolution:
Perform a COLD restart of the Automation Engine if 'ORA-01455' is seen in the logs and jobs are not currently running.

BEWARE:  Performing a cold start can have adverse effects on the Automation Engine installation. The general impact of the COLD start is covered in the following Community post: The COLD start 'HOT' topic.


Fix Status: No Fix

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