Error saving Network System; "Save of network system failed." for java.sql.SQLException: ORA-01438

(Doc ID 1306906.1)

Last updated on SEPTEMBER 25, 2017

Applies to:

Oracle Communications MetaSolv Solution - Version: 6.0.10 and later   [Release: 6.0.10 and later ]
Information in this document applies to any platform.

Symptoms

Users are unable to save a Network System due to "data-related" and "Save of network system failed" errors for java.sql.SQLException: ORA-01438: value larger than specified precision allowed for this column.  Below are screenshots and details of the error messages.

Screenshot of error message 1

 Details of error message 1

A data-related error occurred. Please use the detail button for more information.

The server encountered the following Exception: java.sql.SQLException: ORA-01438: value larger than specified precision allowed for this column
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:182)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:630)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1081)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2905)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2977)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:147)
at com.metasolv.jdbc.MSVPreparedStatement.executeUpdate(MSVPreparedStatement.java:85)
at MetaSolv.persistent.jdbc.JDSC.issueUpdate(JDSC.java:621)
at MetaSolv.persistent.jdbc.JDSC.issueUpdate(JDSC.java:446)
at MetaSolv.persistent.jdbc.JDSC.issueUpdate(JDSC.java:488)
at com.mslv.core.api.internal.shared.networkDrawing.DrawingData.update(DrawingData.java:223)
at com.mslv.core.api.internal.netmgmt.delegate.pbpackage.ns.InvProcessNetworkDesign.storeGraphicCanvas(InvProcessNetworkDesign.java:284)
at com.mslv.core.api.internal.netmgmt.delegate.pbpackage.ns.InvProcessNetworkDesign.processRequest(InvProcessNetworkDesign.java:250)
at com.mslv.core.api.internal.netmgmt.delegate.pbpackage.ns.InvNetworkDesignRoot.process(InvNetworkDesignRoot.java:95)
at MetaSolv.utilities.powerbuilder.BusinessObject.processRequest(BusinessObject.java:67)
at com.mslv.webapp.pblistener.PBListener.invokeClass(PBListener.java:648)
at com.mslv.webapp.pblistener.PBListener.doPost(PBListener.java:425)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1072)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:348)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6981)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3892)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2766)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)

 

Screenshot of error message 2

Details of error message 2

Save of network system failed.

The server encountered the following Exception: java.sql.SQLException: ORA-01438: value larger than specified precision allowed for this column
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:182)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:630)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1081)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2905)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2977)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:147)
at com.metasolv.jdbc.MSVPreparedStatement.executeUpdate(MSVPreparedStatement.java:85)
at MetaSolv.persistent.jdbc.JDSC.issueUpdate(JDSC.java:621)
at MetaSolv.persistent.jdbc.JDSC.issueInsert(JDSC.java:716)
at MetaSolv.persistent.jdbc.JDSC.issueInsert(JDSC.java:861)
at com.mslv.core.api.internal.shared.networkDrawing.DrawingData.add(DrawingData.java:152)
at com.mslv.core.api.internal.netmgmt.delegate.pbpackage.ns.InvProcessNetworkDesign.storeGraphicCanvas(InvProcessNetworkDesign.java:282)
at com.mslv.core.api.internal.netmgmt.delegate.pbpackage.ns.InvProcessNetworkDesign.processRequest(InvProcessNetworkDesign.java:250)
at com.mslv.core.api.internal.netmgmt.delegate.pbpackage.ns.InvNetworkDesignRoot.process(InvNetworkDesignRoot.java:95)
at MetaSolv.utilities.powerbuilder.BusinessObject.processRequest(BusinessObject.java:67)
at com.mslv.webapp.pblistener.PBListener.invokeClass(PBListener.java:648)
at com.mslv.webapp.pblistener.PBListener.doPost(PBListener.java:425)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1072)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:348)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6981)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3892)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2766)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)


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