cancel
Showing results for 
Search instead for 
Did you mean: 

Table Comparisons and Deadlocks

Former Member
0 Kudos

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?

Thanks

Thang

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Post Author: Thang Nguyen

CA Forum: Data Integration

If anyone is interested the solution I've got from BO is:

"Can you put the following parameter in your DSConfig / al_engine section : SQLServerReadUncommitted=1 "

Beware that this sets your changes the SQL server Transaction Isolation level to allow dirty reads which isn't ideal