PO100 Job Needs Recovery

 6 Replies
 1 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
Shannon S
Basic Member
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
    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
      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
        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
          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
            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
              Posts: 28
              Basic Member
                Thanks Jim