12-15-2014 6:05 AM
Hi Experts,
I am trying to update the ETTIFN table using workflow, it is giving short dump as,
"Dead Lock Created While waiting for the resource". when i am trying to update manually using multiple sessions or with different user, it is shown as "Table entry is currently locked by user-id" as another is trying to update at the same time.
Kindly provide your valuable opinions in order to overcome wit this error for the workflow.
Thanks in Advance.
12-15-2014 6:58 AM
Hi Shoib,
This is a strange error you are getting. It might be a temporary error which should go away in couple of hours. If it is not , you can try putting lock in workflow before updating the table ? if lock is failed , you can give it another try in loop after waiting for 5 sec for example and these kind of 10 iterations. It is just for testing , in real solution , you need to find out why the table is getting unavialble and which you can only narrow down when you check the locking.
Thanks
Rakesh