Deadlock on SQL Server - SQLExecute" reported: SQLSTAT
Posted: Fri May 13, 2011 3:06 pm
I am reading data from staging and writing in to a dataset.
Now i read the dataset and update an SQL Server Table while doing that i get the below message.
SQLExecute" reported: SQLSTATE = 40001: Native Error Code = 1,205: Msg = [IBM (DataDirect OEM)][ODBC SQL Server Native Wire Protocol driver][Microsoft SQL Server]Transaction (Process ID 76) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim
Things Observed and take care till now.
1) Change the Config file to 1 node still same issue.
2) The current volume is 28000 but ran for 7 records it went fine.
Have tried both ways of update
UPDATE
dbo.PatientCurrMedFact
SET
IsActive_YN = ORCHESTRATE.IsActive_YN, UpdateDate = ORCHESTRATE.UpdateDate, SourceOrderMedCode = ORCHESTRATE.SourceOrderMedCode, SourceMedCode = ORCHESTRATE.SourceMedCode,
MedicationID = ORCHESTRATE.MedicationID,ContactDate = ORCHESTRATE.ContactDate
WHERE
dbo.PatientCurrMedFact.PatientID = ORCHESTRATE.PatientID
and
also Direct Update Option from the ODBC Stage
still the same issue..
Appricate any one Inputs here
Thanks
Sri
Now i read the dataset and update an SQL Server Table while doing that i get the below message.
SQLExecute" reported: SQLSTATE = 40001: Native Error Code = 1,205: Msg = [IBM (DataDirect OEM)][ODBC SQL Server Native Wire Protocol driver][Microsoft SQL Server]Transaction (Process ID 76) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim
Things Observed and take care till now.
1) Change the Config file to 1 node still same issue.
2) The current volume is 28000 but ran for 7 records it went fine.
Have tried both ways of update
UPDATE
dbo.PatientCurrMedFact
SET
IsActive_YN = ORCHESTRATE.IsActive_YN, UpdateDate = ORCHESTRATE.UpdateDate, SourceOrderMedCode = ORCHESTRATE.SourceOrderMedCode, SourceMedCode = ORCHESTRATE.SourceMedCode,
MedicationID = ORCHESTRATE.MedicationID,ContactDate = ORCHESTRATE.ContactDate
WHERE
dbo.PatientCurrMedFact.PatientID = ORCHESTRATE.PatientID
and
also Direct Update Option from the ODBC Stage
still the same issue..
Appricate any one Inputs here
Thanks
Sri