DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Saturday, December 31, 2016

How to Cancel a Concurrent Request Stuck in the Queue


Some times we get a Request from customers that they are not able to cancel their request because of the following error.

"The concurrent manager process that was running this request has exited abnormally.    The ICM will mark this request as completed with error".


Navigation 

If we try to cancel a concurrent request using "Cancel Request" button from the Administer > Concurrent > Manager form.
We will get the following message:
Request xxxxxx can no longer be cancelled. The Concurrent Manager Process that was running this request has exited abnormally. The ICM will mark this request as completed with error.


Solution

This can be safely done when Concurrent Managers are up and running.

1) Backup fnd_concurrent_requests table

2) SQL> UPDATE fnd_concurrent_requests
SET phase_code = ‘C’, status_code = ‘X’
WHERE Request_id=&request_id
Here Request id is the request which we want to cancel….

3) Commit


Happy Learning...

No comments: