i am running on 2-node processor
and i made the target as HASH partitioning and the job finished successful for a particular job and again for another job, the job got aborted with following error message
my source and target is SQl-Server.I made target as HASH partition and job was successful for 1 job and for another job it was aborted due to LockODBC_Enterprise_76,1: Fatal Error: [IBM(DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 65) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transa
I am doing only UPDATE ONLY in upsert mode.
my job will be
SRC1
-
-
------Lookup-----Transformer------Target(one of the source)
-
SRC2-
my actual query is
can any one help on this?UPDATE Table_name
SET Table_name.HospitalGRP = [Hosp_Grp_Num], Table_name.HospitalFAC = [Hosp_Num]
from Table_name
INNER JOIN Table_name2 ON
( Table_name.SPECIALTY_PRODUCT_INDIC = Table_name2.PROBASE_PRODUCT_TYPE)
AND ( Table_name.EnrollmentFacility = Table_name2.PRVDR_FAC) AND
( Table_name.EnrollmentGroup = Table_name2.PRVDR_GRP) AND
( Table_name.StateCode = Table_name2.StateCode)
WHERE ((( Table_name.StateCode) In ('CA','OK','TX','OR')) AND
(( Table_name.PCP_INDIC)="Y") AND (( Table_name2.PRIMARY_HOSPITAL_INDICATOR)="Y"));
Thanks in Advance