topic Runtime error while updating ETTIFN table using workflow in Application Development and Automation Discussions

Runtime error while updating ETTIFN table using workflow

former_member676672 — Mon, 15 Dec 2014 06:05:56 GMT

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.

Re: Runtime error while updating ETTIFN table using workflow

Former Member — Mon, 15 Dec 2014 06:58:55 GMT

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