Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So I tried to insert data from one table into another table with straight sql in a talend subjob and I get the following message
Msg 9002, Level 17, State 4, Line 89
The transaction log for database 'xvf' is full due to 'ACTIVE_TRANSACTION'.
However,
when I try to insert the data from the same table into the output table it works just fine
I am curious how I can see what goes on under the hood in terms of SQL that allows this data load. Can anyone shed light?
Can you take a screenshot of your job and you component configurations please?
Hall please let me know - thank you!
It looks like this is a MS SQL issue. I found this post about it....
https://stackoverflow.com/questions/17674973/the-transaction-log-for-the-database-is-full