Solución nº - CS241643
Get Host Data failed due to the error "uncategorized SQLException for SQL;SQL state [99999]; error code [17026]; Numeric Overflow;nested exception is java.sql.SQLException: Numeric Overflow" in Servigistics Service Parts Management
Modificado: 14-Mar-2018
Se aplica a
- Servigistics Service Parts Management 10.7 to 11.4.0.1
Descripción
- Get Host Data failed due to the error: uncategorized SQLException for SQL;SQL state [99999]; error code [17026]; Numeric Overflow;nested exception is java.sql.SQLException: Numeric Overflow
- Get Host Data failed with error:uncategorized SQLException for SQL;SQL state [99999]; error code [17026]; Numeric Overflow;nested exception is java.sql.SQLException: Numeric Overflow
- Autopilot.log contains
- ERROR com.Servigistics.Util.EventLog - Task Get Host Data failed with message: Numeric Overflow [Error=17026] java.sql.SQLException: Numeric Overflow at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208) at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:7465) at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:123) at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:527) at com.Servigistics.Database.Recordset.getInt(Recordset.java:251) at com.Servigistics.Gateway.OrderPlanGateway.insertNewRecords(OrderPlanGateway.java:773) at com.Servigistics.Gateway.OrderPlanGateway.doPopulate(OrderPlanGateway.java:53) at com.Servigistics.Gateway.GatewayPopulator.Populate(GatewayPopulator.java:95) at com.Servigistics.Gateway.Gateway.run(Gateway.java:559) at com.Servigistics.Process.Connector.run(Connector.java:205) at com.Servigistics.AutoPilot.Task.Task.runConnector(Task.java:470) at com.Servigistics.AutoPilot.Task.GetHostData.runConnector(GetHostData.java:58) at com.Servigistics.AutoPilot.Task.Task.run(Task.java:226) at java.lang.Thread.run(Thread.java:834) at com.Servigistics.Util.ThreadUtil$1.run(ThreadUtil.java:80)
This is a PDF version of Article 241643 and may be out of date. For the latest version CS241643