DeadLock Issue with T Connector Stage
Posted: Tue Jan 31, 2012 6:05 am
Dear All,
I am facing dead lock issue with tconnector stage with update (Tpump) ,the details are as follows,
My design:
SeqFilestage---->XFm----->Tconnector(Upsert)
this is current prodution job design with dead lock issue after that i have splited into 2 jobs
First job will update the existing tables successfully then only second job will trigger to insert the data ,i assume the dead lock issue never happend in this scnario but still we are facing the same.
After this we have changed node configuration 4 node to single node its working without dead lock issue .
Kindly suggest the ways to prevent dead lock issue with Upsert logic in single job design with 4 node configuration .
Thanks in advance
I am facing dead lock issue with tconnector stage with update (Tpump) ,the details are as follows,
My design:
SeqFilestage---->XFm----->Tconnector(Upsert)
this is current prodution job design with dead lock issue after that i have splited into 2 jobs
First job will update the existing tables successfully then only second job will trigger to insert the data ,i assume the dead lock issue never happend in this scnario but still we are facing the same.
After this we have changed node configuration 4 node to single node its working without dead lock issue .
Kindly suggest the ways to prevent dead lock issue with Upsert logic in single job design with 4 node configuration .
Thanks in advance