Error While Reloading Oracle table with CLOB columns
Posted: Thu Mar 03, 2016 11:31 am
We have a job that loads an Oracle table with two CLOB columns.
The CLOB columns have been assigned LongVarchar datatype in the job.
The Oracle connector stage uses run-time generated SQL and is set to load using the "Insert Then Update" mode.
This job runs fine on the first run when the target table is empty (only inserts).
But when the job is rerun, it fails throwing the below warning and error:
Warning - The connector is not able to resume the write operation because multiple arrays of data were written to the database on one or more input links under the transaction that was active at the time of failover.
Error - The variable pStreamReader has value NULL which is not valid in the current context. (CC_OraStatement::piecewiseWriteLobParameters, file CC_OraStatement.cpp, line 7,180)
Is there a way to get around this error?
The CLOB columns have been assigned LongVarchar datatype in the job.
The Oracle connector stage uses run-time generated SQL and is set to load using the "Insert Then Update" mode.
This job runs fine on the first run when the target table is empty (only inserts).
But when the job is rerun, it fails throwing the below warning and error:
Warning - The connector is not able to resume the write operation because multiple arrays of data were written to the database on one or more input links under the transaction that was active at the time of failover.
Error - The variable pStreamReader has value NULL which is not valid in the current context. (CC_OraStatement::piecewiseWriteLobParameters, file CC_OraStatement.cpp, line 7,180)
Is there a way to get around this error?