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:

java.lang.NegativeArraySizeException

at oracle.net.ano.CryptoNIONSDataChannel.readDataFromSocketChannel(Unknown Source)

at oracle.jdbc.driver.T4CMAREngineNIO.prepareForReading(T4CMAREngineNIO.java:98)

at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:534)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:485)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)

at oracle.jdbc.driver.T4C7Ocommoncall.doOLOGOFF(T4C7Ocommoncall.java:62)

at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:908)

at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:2005)

at org.apache.sqoop.manager.OracleManager$ConnCache.recycle(OracleManager.java:210)

at org.apache.sqoop.manager.OracleManager.close(OracleManager.java:243)

    at org.apache.sqoop.tool.BaseSqoopTool.destroy(BaseSqoopTool.java:298)


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.


https://support.oracle.com/knowledge/Middleware/2437960_1.html


Solution:


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