SM21 \\ Database error 60 at UPD access to table ZLWAM001

[mohsin_m3]

Hello All,

In sm21 following warnings occured

1) Database error 60 at UPD access to table ZLWAM001

2) Database error 60 at SEL access to table NRIV

Kindly suggest me how to resolve

Regards

Mohsin

[JPReyes · Accepted solution]

Thats related to ORA-00060 - deadlock detected while waiting for resource

Basically if it only happen once you can ignore this as whatever is was, was probably rolled back.

Regards

Juan

[Mujeeb · Accepted solution]

Hi Experts,

     I am facing Database error 60 at SEL access to table NRIV this issue consistently, Can you please let me know how to resolve this.

Thanks and regards,

Mujeeb

[Former Member · Accepted solution]

Hi Mujeeb,

This is related to dead locks.

When ever you face this issue, kindly check SM50 if single instance or SM66 if distributed installation and check for process accessing NRIV table.

Mostly it would be because of same activity scheduled multiple times on same start time.

If there are process, then check also in DB01 and keep refreshing the screen to see if the process are actually running or hanging.

Regards,

Nikhil