Please Help me,When I am running the job to fetch data from Oracle DB table and Insert into another Oracle DB table,1310000 records are being inserted succesfully.After that it is throwing the Error "Numeric Overflow".Below is the detailed Error Code.
Please Solve it its Very Urgent.
Thanks,
Shikha
Exception in component tOracleInput_1
java.sql.SQLException: Numeric Overflow
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:6797)
at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:121)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:489)
at datacollection_fact.task_fact_test.Task_Fact_Test.tOracleInput_1Process(Task_Fact_Test.java:567)
at datacollection_fact.task_fact_test.Task_Fact_Test.runJobInTOS(Task_Fact_Test.java:1212)
at datacollection_fact.task_fact_test.Task_Fact_Test.main(Task_Fact_Test.java:1128)
| Code: |
Exception in component tOracleInput_1 java.sql.SQLException: Numeric Overflow at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227) at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:6797) at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:121) at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:489) at datacollection_fact.task_fact_test.Task_Fact_Test.tOracleInput_1Process(Task_Fact_Test.java:567) at datacollection_fact.task_fact_test.Task_Fact_Test.runJobInTOS(Task_Fact_Test.java:1212) at datacollection_fact.task_fact_test.Task_Fact_Test.main(Task_Fact_Test.java:1128) </td></tr></tbody></table> |
