ORA-12899: value too large for column "ASAP"."DESIGN_LAYOUT_REPORT"."INTEREXCHANGE_CARRIER_NAME" (actual 25, maximum 20) Error Working Circuits Related to PSR Orders (Doc ID 2898322.1)

Last updated on SEPTEMBER 29, 2022

Applies to:

Symptoms

After upgrading from MetaSolv Solution version 6.3.0.982 to 6.3.1.417.10, users started reporting "ORA-12899: value too large for column" errors when working with circuits related to PSR orders.

Image of Error Displayed in GUI

Error Text

The server encountered the following Exception: java.sql.SQLException: ORA-12899: value too large for column "ASAP"."DESIGN_LAYOUT_REPORT"."INTEREXCHANGE_CARRIER_NAME" (actual 25, maximum 20)

              at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
              at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
              at oracle.jdbc.driver.T4TTIfun.receive(T4TTIfun.java:550)
              at oracle.jdbc.driver.T4TTIfun.doRPC(T4TTIfun.java:268)
              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91)
              at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)
              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
              at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426)
              at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3756)
              at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3736)
              at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1063)
              at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:170)
              at com.metasolv.jdbc.MSVPreparedStatement.executeUpdate(MSVPreparedStatement.java:98)
              at MetaSolv.persistent.jdbc.JDSC.issueUpdate(JDSC.java:616)
              at MetaSolv.persistent.jdbc.JDSC.issueUpdate(JDSC.java:448)
              at MetaSolv.persistent.jdbc.JDSC.issueUpdate(JDSC.java:488)
              at com.mslv.core.api.internal.NetProv.ConnDesign.ConnectionDesignManager.getDLR(ConnectionDesignManager.java:713)
              at com.mslv.core.api.internal.NetProv.ConnDesign.ConnectionDesignManager.getDesignIssue(ConnectionDesignManager.java:1102)
              at com.mslv.core.api.internal.NetProv.delegate.pbpackage.ConnDesign.InvInitConnDesign.process(InvInitConnDesign.java:131)
              at MetaSolv.utilities.powerbuilder.BusinessObject.processReequest(BusinessObject.java:67)
              at com.mslv.webapp.pblistener.PBListener.invokeClass(PBListener.java:640)
              at com.mslv.webapp.pblistener.PBListener.doPost(PBListener.java:431)

              <<< REMAINDER OF STACK TRACE IRRELEVANT >>>

              at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
Caused by: Error : ORA-12899, Position : 67, Sql = UPDATE ASAP.DESIGN_LAYOUT_REPORT SET INTEREXCHANGE_CARRIER_NAME = :1 , LAST_MODIFIED_DATE = SYSDATE, LAST_MODIFIED_USERID = :2 where
CIRCUIT_DESIGN_ID = :3 AND ISSUE_NBR = :4, Original Sql = UPDATE ASAP.DESIGN_LAYOUT_REPORT SET INTEREXCHANGE_CARRIER_NAME =?, AST_MODIFIED_DATE = SYSDATE, LAST_MODIFIED_USERID = ? where
CIRCUIT_DESIGN_ID = ? AND ISSUE_NBR = ?, Error Msg = ORA-12899: value too large for column "ASAP"."DESIGN_LAYOUT_REPORT"."INTEREXCHANGE_CARRIER_NAME" (actual 25, maximum 20)

              at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
              ...51 more

Changes

MetaSolv Solution was upgraded from version 6.3.0.982 to 6.3.1.417.10.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.