Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Java error on a tOracleInput_1

Hello, i've a java error with a simple job (cf. image). I receveid the following messages :
Exception in component tOracleInput_1
java.sql.SQLException: Dépassement numérique
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:106)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:489)
at migration_stic_carcois.essaixml.essaiXml.tOracleInput_1Process(essaiXml.java:721)
at migration_stic_carcois.essaixml.essaiXml.runJobInTOS(essaiXml.java:1510)
at migration_stic_carcois.essaixml.essaiXml.main(essaiXml.java:1429) The generated cod

To see the whole post, download it here
Labels (5)
1 Reply
Anonymous
Not applicable
Author

I find the problem : it's the column DHM with int(16) which is too long...