Skip to main content

Currently we receive an error each time our scheduled task for Update Purchase Lead Time has to perform an update. If no update is needed it runs and the background jobs states it’s ready. Otherwise when it needs to perform an update we get the error “ ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "REST1APP.TRANSACTION_SYS", line 1632
ORA-06512: at "REST1APP.TRANSACTION_SYS", line 683
ORA-06512: at "REST1APP.TRANSACTION_SYS", line 1226”

 

See attached document as well. Has anyone else run into this? 

you only have 1 task in the chain. have you tried scheduling it as a database task schedule rather than a task chain? Does it work like that?


Hi Nathan,

 

Apparently this issue occurs due to a bug in IFS, and it should be fixed from patch 141150.

Could you please let us know whether it is APP9 or APP10 and what is the UPD version.


Hi,

 

I believe this deadlock situation occurs simply because once the update is called it locks the record to update and then the other process waits until this lock is released. Hence, the deadlock. 
 

To resolve this,

  • There could be a patch to overcome this already developed by RnD. 
  • You could make this run as a scheduled task and change the schedule to a time where no other background jobs that run from the same function run. This should resolve the deadlock situation. 

 

Hope this helps or provides some insight. 
 

/Nadeesh


Dear Nathan Gerst,

I would suggest you first try to run the Schedule database task at 10.00 pm daily rather than 5.00 pm daily. Usually, you may get rid of the deadlock situation by changing the execution time of the job.

Thanks,
Raga


Changing the scheduled job time to a different time and verify the status of the execution will be good initiation as an initial investigation step.


Reply