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
Deadlock on SQL Server - SQLExecute" reported: SQLSTAT
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 40
- Joined: Thu Jul 10, 2008 12:45 pm
Deadlock on SQL Server - SQLExecute" reported: SQLSTAT
Srikanth Reddy
Integration Consultant
Integration Consultant
See if this helps: viewtopic.php?t=140150
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 40
- Joined: Thu Jul 10, 2008 12:45 pm
Dead Lock SQL Server
Hichulett wrote:See if this helps: viewtopic.php?t=140150
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
Srikanth Reddy
Integration Consultant
Integration Consultant