Skip to Content
Former Member
Jul 23, 2007 at 11:31 PM

Table Comparisons and Deadlocks


Post Author: Thang Nguyen

CA Forum: Data Integration

Hi ,

Pretty new to this DI stuff, but I've got a dataflow where I'm using a Table Comparison Transform to work out my updates and inserts. My database is SQL server 2000.

When it runs the Table Comparison I get SQL errors regarding deadlock victim and the insert fails. I've ran a trace on SQL Server and the insert statement is being blocked by a select statement, so looks like some sort of issue with the Table Comparison looking for the differences and inserting new rows at the same time.

I've tried to split the operation into two Dataflows using Map Operation where one is doing the updates and the other does in the inserts, but I still get the deadlock issue.

Has anyone else experienced this problem?