Background Processor job for Equipment Spec edit is flagged with status of Not Responding (NOR) and eventually fails with "ORA-12899: value too large for column" error. (Doc ID 2101987.1)

Last updated on MARCH 01, 2016

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.

Symptoms

Equipment Edit jobs sent to the Background Processor intermittently end up in a status of Not Responding (NOR) and fail with "ORA-12899: value too large for column" errors. For example, one failed at 70% and the other at 94%.


Errors in JOB.JOB_LOG.JOB_EVENT table/column 

Job routed to server SERVERNAME
Job Worker sqlerror:1
java.sql.BatchUpdateException: ORA-12899: value too large for column "ASAP"."DLR_CIRCUIT_DESIGN_LINE"."MISCELLANEOUS_INFORMATION" (actual: 17, maximum: 16)
Job Worker Database error code: 12899
Database error message:
ORA-12899: value too large for column "ASAP"."DLR_CIRCUIT_DESIGN_LINE"."MISCELLANEOUS_INFORMATION" (actual: 17, maximum: 16)
Job Worker The server encountered the following Exception: MetaSolv.persistent.jdbc.JDSCException: Value Job Worker The server encountered the following Exception: java.lang.NullPointerException
at com.metasolv.impl.logic.design.connection.block.types.GenericBlockBusObj.getBlockDTO(GenericBlockBusObj.java:956)
at com.metasolv.impl.logic.design.connection.block.types.GenericBlockBusObj.getBlock(GenericBlockBusObj.java:488)
at com.metasolv.impl.logic.design.connection.block.DesignBlockBuilderImpl.getBlo 
Job Worker sqlerror:1
java.sql.BatchUpdateException: ORA-12899: value too large for column "ASAP"."DLR_CIRCUIT_DESIGN_LINE"."MISCELLANEOUS_INFORMATION" (actual: 17, maximum: 16)
Job Worker Database error code: 12899
Database error message:
ORA-12899: value too large for column "ASAP"."DLR_CIRCUIT_DESIGN_LINE"."MISCELLANEOUS_INFORMATION" (actual: 17, maximum: 16)
Job Worker The server encountered the following Exception: MetaSolv.persistent.jdbc.JDSCException: Value Job Worker Update failed while logging error for job 1421.

The server encountered the following Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (JOB.FK_JOB_LOG_JOB_ID) violated - parent key not found
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.

Worker not responding at 70 %

 

Errors in worker.log file



Recreation Steps

The problem is intermittent and cannot be recreated at will.


Business Impact

Due to this issue, some Equipment Edit jobs sent to the Background Processor cannot be completed.

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