job running forever

 5 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Xin Li
Veteran Member Send Private Message
Posts: 134
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 Send Private Message
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 Send Private Message
Posts: 134
Veteran Member
Thanks Jimmy. We tried that and it has the same result.
Jimmy Chiu
Veteran Member Send Private Message
Posts: 641
Veteran Member
I would delete the job, recreate the job and try again. It's strange indeed.
Venkat
Advanced Member Send Private Message
Posts: 22
Advanced Member
what database are you running ?
Xin Li
Veteran Member Send Private Message
Posts: 134
Veteran Member
We use Oracle database.