UPDATE M1_TASK_SCHEDULE Encountering ORA-01438 Error (Doc ID 2200017.1)

Last updated on NOVEMBER 09, 2016

Applies to:

Oracle Utilities Mobile Workforce Management - Version 2.2.0.3.0 to 2.2.0.3.13 [Release 2.2]
Oracle Real-Time Scheduler - Version 2.2.0.3.0 to 2.2.0.3.13 [Release 2.2]
Information in this document applies to any platform.

Symptoms

We are having a problem in M1_TASK_SCHEDULE table. We are receiving the below error in the Scheduler logs while it updates the M1_TASK_SCHEDULE table. The version column in the table is 5 digits whereas we have reached to a number '99999' for this column for SCHEDULER_STATUS_FLG='M1IN' in our Test environment. For other SCHEDULER_STATUS_FLG types codes the version number is relatively low.

ERROR

---------
UPDATE M1_TASK_SCHEDULE SET SCHDL_SHIFT_ID = ?, M1_SHIFT_CLASS_FLG = ?, WORK_SEQ = ?, SCHEDULER_STATUS_FLG = ?, UPDATE_DTTM = ?, VERSION = ? WHERE TASK_ID = ? and VERSION = ?
with 'entity-string id' parameter named 'taskId' to : 'Task_Id(35494792149168)' to indices: 7
with 'integer' parameter named 'workSeq' to : '0' to indices: 3
with 'string' parameter named 'shiftClass' to : ' ' to indices: 2
with 'dateTime' parameter named 'updateTime' to : '2016-08-17-08.40.31' to indices: 5
with 'lookup' parameter named 'status' to : 'M1IN' to indices: 4
with 'integer' parameter named 'old_version' to : '99999' to indices: 8
with 'string' parameter named 'shiftId' to : ' ' to indices: 1
with 'integer' parameter named 'version' to : '100000' to indices: 6

java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms