Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
fjblau
Contributor
Contributor

tMSSqlSCD does not commit

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?

0695b00000aEZn5AAG.png

0695b00000aEZnZAAW.png

Labels (3)
2 Replies
jlolling
Creator III
Creator III

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.

 

fjblau
Contributor
Contributor
Author

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.