Strange workflow error

Imran_Yusubov

Hello Experts,

In our environment a strange workflow error has occurred.

2013-01-17T10:50:02.183000

4308[3228]

01026c198001254e

[DM_OBJ_MGR_E_DELETE_FAIL]error:  "attempt to delete attributes of object 4a026c1980017c66 in table DMI_WORKITEM_S failed: error from database system was ORA-00060: deadlock detected while waiting for resource"

Does anyone have an idea on the possible reason of this error? Please let me know the bestpractices on for xCP database parameters. We are using oracle, please let me  know if someone has encountered such an error.

Thanks in advance

sanjeev6282

Hi Imran,

The error lines does say that it has detected a deadlock, so probably you should consider getting in touch with the DBA and ask him to release the resource as in your case 2 threads are vying for the same resource at the same time.

"error from database system was ORA-00060: deadlock detected while waiting for resource""