PO100 Job Needs Recovery

 6 Replies
 1 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
Shannon S
Basic Member Send Private Message
Posts: 28
Basic Member

We had our PO100RQ job go into Needs Recovery this morning and are trying to understand the error we received. The error stated 'database deadlock on a non-restartable step.' Can anyone help with this error?

 

Thanks,

Shannon

Lynne
Veteran Member Send Private Message
Posts: 122
Veteran Member
Shannon- We've had this issue for years. I logged an incident over a year ago, and went round and round w/ Infor about this. They were never able to resolve it and I got tired of the run around. They want to blame it on more than one PO100 or RQ500 running at the same time. We have never run them at the same time. I'm hoping this will get resolved in v10. Are you on 10? I had to write a process flow to check for jobs in recovery due to this happening frequently. Our processes are time dependent and this has helped get notification. We just recover it and move on. Not the best solution though.
Shannon S
Basic Member Send Private Message
Posts: 28
Basic Member
Thanks for your reply Lynne! Yes, we are on v10. We have had this happen on a few occasions, but normally due to downtime. I didn't see anything this morning that seemed off or would cause this error, so I was a little confused. We attempted to get AMS to inform us when jobs went into recovery, but not sure if they are working on that or not anymore? Could you possibly share your process flow for notifying you when jobs are in a needs recovery status? Thanks again for your response!
Lynne
Veteran Member Send Private Message
Posts: 122
Veteran Member
Shannon- my process flow runs on v9, so you may need to do some tweaking for v10. We aren't that far yet, so I haven't been able to run it on 10. I don't see where I can upload an attachment, so if you give me your email, I can send it directly to you.
Shannon S
Basic Member Send Private Message
Posts: 28
Basic Member
Thanks so much! Just a start would be helpful, then we can definitely tweak as needed for the v10. My email is shannon.shoemaker@childrensal.org Thanks again for your help!
JimY
Veteran Member Send Private Message
Posts: 510
Veteran Member
You might want to check out JT-478024 on the Infor Support site. It deals with this issue.
Shannon S
Basic Member Send Private Message
Posts: 28
Basic Member
Thanks Jim