Problem Description:

Oracle CDC job fails with the below Oracle exception.

[ERROR] 2019-03-26 12:47:31,218 [pool-5-thread-1] infoworks.discovery.dbcrawler.rdbms.utils.IWDataTransfer:58 :: CRAWLING: Got exception running the Job: NegativeArraySizeException:


at Source)

at oracle.jdbc.driver.T4CMAREngineNIO.prepareForReading(

at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(

at oracle.jdbc.driver.T4CTTIfun.receive(

at oracle.jdbc.driver.T4CTTIfun.doRPC(

at oracle.jdbc.driver.T4C7Ocommoncall.doOLOGOFF(

at oracle.jdbc.driver.T4CConnection.logoff(

at oracle.jdbc.driver.PhysicalConnection.close(

at org.apache.sqoop.manager.OracleManager$ConnCache.recycle(

at org.apache.sqoop.manager.OracleManager.close(

    at org.apache.sqoop.tool.BaseSqoopTool.destroy(

Root cause:

This is an issue from the Oracle JDBC driver end (ojdbc8.jar) that we ship with IWX ADE v2.6.x. 

Go to $IW_HOME/lib/shared directory on Infoworks edge node to confirm the jdbc driver.


Need to check with Oracle Support regarding this exception as it is coming from their native jdbc driver.

Applicable to Infoworks versions.

IWX ADE v2.6.x,2.7.x