SQL server table update Deadlock issue :SQLSTATE = 40001
Posted: Sat Feb 16, 2013 6:31 pm
Hi,
I am trying to upsert a SQLserver table,job design is like
SQL Server Enterprise--> CPY --> SQL Server Enterprise
Process is failing with Error :
ODBC_Connector_51,0: ODBC function "SQLParamData" reported: SQLSTATE = 40001: Native Error Code = 1,205: Msg = [Microsoft][SQL Server Native Client 10.0][SQL Server]Transaction (Process ID ##) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (CC_OdbcDBStatement::executeUpdate, file CC_OdbcDBStatement.cpp, line ###)
I tried to replace SQLServer Enterprise with ODBC connector stage , still no hope.
My target table (table I am trying to update) is Indexed and trying to update on Indexed column only.
If I try to write insert/update statement in SQLserver it works fine(in Management Studio)
I seared in DSXchase and foud the below link and tried to change Arrey to readUncommited , still not working
viewtopic.php?t=140177
Is there any other property I need to change?
Thanks in Advance.
I am trying to upsert a SQLserver table,job design is like
SQL Server Enterprise--> CPY --> SQL Server Enterprise
Process is failing with Error :
ODBC_Connector_51,0: ODBC function "SQLParamData" reported: SQLSTATE = 40001: Native Error Code = 1,205: Msg = [Microsoft][SQL Server Native Client 10.0][SQL Server]Transaction (Process ID ##) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (CC_OdbcDBStatement::executeUpdate, file CC_OdbcDBStatement.cpp, line ###)
I tried to replace SQLServer Enterprise with ODBC connector stage , still no hope.
My target table (table I am trying to update) is Indexed and trying to update on Indexed column only.
If I try to write insert/update statement in SQLserver it works fine(in Management Studio)
I seared in DSXchase and foud the below link and tried to change Arrey to readUncommited , still not working
viewtopic.php?t=140177
Is there any other property I need to change?
Thanks in Advance.