Question

Database Task Chain/ Schedule Task Error

  • 10 December 2019
  • 5 replies
  • 522 views
N
Rank
Userlevel 5
Badge +8

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? 

1 Attachment

5 replies

Rusiru Dharmadasa
Rank
Userlevel 7
Badge +19

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?

Rusiru
Minoshini Fonseka
Rank
Userlevel 7
Badge +19

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.

/Mino
Nadeesh Herath
Rank
Userlevel 6
Badge +9

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

Nadeesh Herath
Ragaventhan Sathananda
Rank
Userlevel 7
Badge +15

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

Ragaventhan S - https://www.linkedin.com/in/ragaventhan-sathananda/
Charith Epasinghe
Rank
Userlevel 6
Badge +13

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.

- Charith Epasinghe

Reply


Terms & ConditionsCookie settings