eTL 5.1.1 throws null pointer exception (Doc ID 1025548.1)

Last updated on AUGUST 28, 2015

Applies to:

Oracle Java CAPS - Version 5.1.0 and later
Information in this document applies to any platform.
***Checked for relevance on 28-Aug-2015***

Symptoms

When executing the eTL collaboration via eDesigner, a java.lang.NullPointerException is thrown.

Error below:

JavaCAPS.[14 Sep 2007 11:27:28,471] DEBUG (org.axiondb.parser.AxionSqlParser) - created new parser
JavaCAPS.[14 Sep 2007 11:27:28,471] DEBUG (org.axiondb.parser.AxionSqlParser) - SqlCommand: created "org.axiondb.engine.commands.InsertCommand@1d83236"
JavaCAPS.[14 Sep 2007 11:27:28,471] ERROR (com.stc.etl.engine.impl.Extractor) - Failed to process SQL: null - java.lang.NullPointerException
at org.axiondb.jdbc.AxionStatement.clearBatch(AxionStatement.java:87)
at com.stc.etl.engine.impl.Extractor.insertData(Extractor.java:509)
at com.stc.etl.engine.impl.Extractor.process(Extractor.java:194)
at com.stc.etl.engine.impl.ETLTaskThread.run(ETLTaskThread.java:147)
at java.lang.Thread.run(Thread.java:534)

JavaCAPS.[14 Sep 2007 11:27:28,471] ERROR (com.stc.etl.ui.view.cookies.ExecuteTestCookie) - <colTEST_eTL_db51:OnePassETL:CSFDET_CSV>: Failed to process SQL: null

JavaCAPS.[14 Sep 2007 11:27:28,487] DEBUG (com.stc.etl.engine.impl.Extractor) - java.lang.NullPointerException - java.lang.NullPointerException
at org.axiondb.jdbc.AxionStatement.clearBatch(AxionStatement.java:87)
at com.stc.etl.engine.impl.Extractor.insertData(Extractor.java:509)
at com.stc.etl.engine.impl.Extractor.process(Extractor.java:194)
at com.stc.etl.engine.impl.ETLTaskThread.run(ETLTaskThread.java:147)
at java.lang.Thread.run(Thread.java:534)

JavaCAPS.[14 Sep 2007 11:27:28,487] ERROR (com.stc.etl.engine.impl.ETLTaskThread) - Failed to process Extractor_0 task. TERMINATING ETLEngine Execution ..."
JavaCAPS.[14 Sep 2007 11:27:28,487] DEBUG (com.stc.etl.engine.impl.Extractor) - Closing source connection oracle.jdbc.driver.T4CConnection@1c5dda3.
JavaCAPS.[14 Sep 2007 11:27:28,487] DEBUG (com.stc.etl.engine.impl.Extractor) - Marking staging/target connection org.axiondb.jdbc.AxionConnection@52d3a8 for release.
JavaCAPS.[14 Sep 2007 11:27:28,487] DEBUG (com.stc.etl.engine.impl.Extractor) - Handling exception for Extractor... - com.stc.etl.utils.ETLException: <OnePassETL:CSFDET_CSV>Failed to process in Extractor: java.lang.NullPointerException - Root Cause: null

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms