[resolved] CDC fails on insert because of NULL values in tcdc_view (TIS)
Hi,
I use TIS (CDC) for replication on 2 databases , i my case MYSQL. So i catch changes in one database and replicate them on the other database in asynchronous mode.
When i insert a row and delete the same row in the table i want to replicate, the process fails during replication because the row has been deleted from the original table (link between tcdc_MYTABLE, MYTABLE and tcdc_view_MYTABLE) so that NULL values are reported in tcdc_view for the insertion operation ; and as i can't insert NULL values in the table the process fails.
This is a very blocking problem for the CDC component.
I'm blocked if i don't want to create (manually of course) a temporary table instead of the view
Hi,
In fact the problem come from "INSERT" action in the output component.
You have to uncheck "extent insert" in advance parameters and use a single CDCinput to capture "insert", "delete" or "update". Don't also forget to tSortRow before connectiong the tMap;
Regards
Regarding your screenshot 4, when you change manually the cdc_state from 0 to 1, you only get 2 types of operations (I, D). Therefore, you've done 3 operations (I,D,I). There's no trace of the first insertion in the database in tcdc_view_customer1. Probably at the end the result are the same (trying to delete a row that doesn't exist before inserting a row and inserting a row, deleting the row and inserting the same row) but in my version, after a delete there is NULL value in the other fields and i don't know why. Problem of version?
Hi dko,
I am facing the same issue as you stated below and exactly similar order of operations in cases like INSERT, DELETE, INSERT the same keys for many reasons, my database does not pick the last insert or get deleted. I followed one input oracle component and three change of operations in the order of Insert, update, delete. Did you resolve your issue? If you did, what was the design approach you took for CDC? what do you mean by
You have to uncheck "extent insert" in advance parameters. I did not find that option of extent insert anywhere, can you please advise?
Thanks!!!
