Ask Your Question

Oracle CDC client origin - NullPointerException

asked 2019-05-02 07:38:37 -0500

Allan gravatar image

updated 2019-05-02 10:15:36 -0500

metadaddy gravatar image

Need help!

I have a pipeline with oracle cdc client origin that ingests data from Oracle 10.2g. I was able to have it worked but when i changed the test db table by adding a new column UUID and add updated a record. I begun getting the exception below. And no record is passing through my pipeline. Please help anyone. Thanks!

DEBUG   Commit SCN = null, SCN = 36919303700, Operation = 3, Txn Id = 10.12.14354637, Timestamp = 2019-05-02T12:25:11, Row Id = AABFmNAAEAAIsgaAAK, Redo SQL = update "SSERVDBA"."TEST_TXN_REPLICATE" set "TTR_NAME" = 'TXN 12 updated - 2019/05/02 12:25:10' where "TTR_ID" = '12' and "TTR_NAME" = 'TXN 12 updated with null error - 2019/05/02 11:52:24' and "UUID" IS NULL and ROWID = 'AABFmNAAEAAIsgaAAK'     OracleCDCSource     *admin      Oracle CDC Data Generator

DEBUG   Found 1 records in transaction ID 10.12.14354637    OracleCDCSource     *admin      Oracle CDC Data Generator

ERROR   java.lang.NullPointerException: value cannot be null:java.util.concurrent.ExecutionException: java.lang.NullPointerException: value cannot be null  OracleCDCSource     *admin      Oracle CDC Data Generator
edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2019-05-02 18:00:08 -0500

metadaddy gravatar image

It looks like you selected 'online catalog' as the LogMiner dictionary source. This option is only for use if you are not expecting the schema to change. You should select 'redo logs' instead. See the Oracle CDC origin documentation for more information.

edit flag offensive delete link more


Thanks! I extracted log miner dict to redo logs. And when I changed to use the dictionary from redo logs, changed the initial change to latest (i.e. either 'From SCN', etc) and restart origin, i got this an error below. java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR

Allan gravatar imageAllan ( 2019-05-03 05:22:25 -0500 )edit

Also noticed that it tries to start logminer from older SCN than the one I specified on the pipeline. I reset the origin a couple of times. Seems it doesn't use the one I specified. Trying to start LogMiner with start SCN: 35142228611 and end SCN: 36920223142

Allan gravatar imageAllan ( 2019-05-03 05:25:09 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-05-02 07:38:37 -0500

Seen: 282 times

Last updated: May 02 '19