Please solve the problem of "Numeric Overflow"

[shikha1610]

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_1java.sql.SQLException: Numeric Overflowat 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)

[riesvantwisk]

From what I understand you are trying to put some values into a table.

One of this tables cannot old the value you are trying to insert.

Try changing some types in your oracle table to old teh value you are inputting.

 

Ries