job running forever

 5 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Xin Li
Veteran Member
Posts: 133
Veteran Member
    Recently we had experienced some weired thing. We had a job AP150 for pay group 4 was running forever. However, if this job was submitted by Lawson it finished in 10 second. Any other users submitted the same job and same pay group it will run forever.

    Anyone out there could help will be greatly appreciated,

    Thanks
    Jimmy Chiu
    Veteran Member
    Posts: 641
    Veteran Member
      For troubleshooting purpose, turn security off and resubmit your AP150 job using one of the account with long runtime. If it finishes in 10 seconds, then it's security issue.
      Xin Li
      Veteran Member
      Posts: 133
      Veteran Member
        Thanks Jimmy. We tried that and it has the same result.
        Jimmy Chiu
        Veteran Member
        Posts: 641
        Veteran Member
          I would delete the job, recreate the job and try again. It's strange indeed.
          Venkat
          Advanced Member
          Posts: 22
          Advanced Member
            what database are you running ?
            Xin Li
            Veteran Member
            Posts: 133
            Veteran Member
              We use Oracle database.