Runtime error while updating ETTIFN table using workflow

[Former Member]

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.

[Former Member]

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

[Former Member]

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