deadlock while using Change capture in update
Posted: Wed Nov 10, 2010 5:33 pm
We are using Change data capture + transformer(using constraints to split based on change code) to implement insert/update logic. But in the update link, if a parallel odbc connector stage is used, transaction deadlock message is displayed in the log and job aborts with partial data update.eg:- out of the 10 records to be updated, only 2 will get updated.
If a sequential odbc enteprise stage or sequential drs stage is used, job gets finished with all the records getting updated correctly. The job is running on 4 nodes.
Please advise why the transaction deadlock is happening when the parallel odbc connector stage is used along with change capture.
If a sequential odbc enteprise stage or sequential drs stage is used, job gets finished with all the records getting updated correctly. The job is running on 4 nodes.
Please advise why the transaction deadlock is happening when the parallel odbc connector stage is used along with change capture.