TALEND CDC Issues

Attunity_user — Fri, 14 Oct 2016 14:19:36 GMT

Hello,
We are facing an issue implementing CDC config for the Source (Oracle) as a View, please let us know if it is possible to do?

Thanks,
MVK

Re: TALEND CDC Issues

Anonymous — Mon, 17 Oct 2016 08:42:17 GMT

Hi,
There is not enough information for us to address your issue. Could you please give us more information about your problem?
What's the error message you are getting when set up CDC environment?
Best regards
Sabrina

Re: TALEND CDC Issues

Attunity_user — Mon, 31 Oct 2016 03:57:43 GMT

Hi,
The table from source was a view and not a table. So when you right-click to add CDC on database view, to create triggers on view, it did not allow it. So we move forward with real database table to configure CDC. Doesn't source as a view works with CDC?
Now issue is when we create a new record in the source database, then go and update that row and later delete it, if we trigger a job to capture all three updates, I get null error.
Exception in component
java.lang.nullpointerexception.
I added null check on every column in the tmap expression on target, but rows that were deleted after update does not work and produce null values.
But sequences like insert, update and delete if trigger it three different times immediately after, it works but not working all three on one run. I also used tschemacompliancecheck, that still does not reject on this sequence. I set it up tmap expression already with default values on both source and target. Please help on how to remove null with default value or 0.

topic TALEND CDC Issues in Talend Studio

TALEND CDC Issues

Re: TALEND CDC Issues

Re: TALEND CDC Issues