Deadlock on SQL Server - SQLExecute" reported: SQLSTAT

[srireddypunuru]

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

[chulett]

See if this helps: viewtopic.php?t=140150

[srireddypunuru]

See if this helps: viewtopic.php?t=140150

Hi

Still i get the same error message below is my update statement

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.EncounterID = ORCHESTRATE.EncounterID AND dbo.PatientCurrMedFact.LineNumber = ORCHESTRATE.LineNumber AND dbo.PatientCurrMedFact.DataSourceID = ORCHESTRATE.DataSourceID

Thanks
Sri

[chulett]

Still? After you did what?