topic Re: tMSSqlSCD does not commit in Talend Studio

tMSSqlSCD does not commit

fjblau — Fri, 15 Nov 2024 22:17:58 GMT

I have a job that is running a tMSSQLSCD component.

I can see the 11000 or so rows running into it, but nothing shows up in the query editor. I have tried setting the AutoCommit in the component, and I have tried turning that off and doing a commit with the tMSSqlCommit component.

I have tried recreating the table, recreating the job and just about anything else.

Is this a bug, or am I missing something?

Re: tMSSqlSCD does not commit

jlolling — Tue, 06 Dec 2022 22:10:35 GMT

Actually I would NEVER recommend to commit inside this component, even it would be possible. This can lead to inconsistent time-slices. The best thing you can do is switch off the auto-commit on the connection and use a tDBCommit component linked by the OnSubjobOk of the whole sub job!

I also recommend to have a tLogCatcher component and take care only tDie and Java Exceptions will be catched and connect its output flow directly to a tDBRollback component. The tLogCatcher should not be triggered, simply keep it alone on a location on the upper part of the job.

Re: tMSSqlSCD does not commit

fjblau — Wed, 07 Dec 2022 07:43:18 GMT

I tried that too and it still didn't load any data into the target.

I have re-written it as a SQL Merge in a tRow component since the SCD clearly isn't working as it should.