Concurrent Processing - How to Cancel a Concurrent Request Stuck in the Queue

Concurrent Processing - How to Cancel a Concurrent Request Stuck in the Queue? [ID 749748.1]
  Modified 13-APR-2011     Type PROBLEM     Status PUBLISHED
In this Document
  Symptoms
  Cause
  Solution
  References

Applies to:

Oracle Application Object Library - Version: 11.0.0 to 12.0 - Release: 11 to
Oracle Concurrent Processing - Version: 11.5.10.0 to 12.0.6   [Release: 11.5.10 to 12]
Information in this document applies to any platform.
11.0.x - 12.0.x
Symptoms

***Checked for relevance on 30-Aug-2010***



Unable to cancel a concurrent request out of the queue that is stuck.

Cause

Tried to Cancel a concurrent request. Used the "Cancel Request" button from the Administer > Concurrent > Manager form.

Got 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

Manually cancel the request out of the queue with the following SQL against the offending
request id(s). This can be safely done while managers are up and running:




SQL> UPDATE fnd_concurrent_requests
     SET phase_code = 'C', status_code = 'X'
     WHERE request_id = ''; 
     commit;



Note:  To obtain request details prior to cancelling the request, use Note 134035.1 ANALYZEREQ.SQL - Detailed Analysis of One Concurrent Request. When prompted, provide the request id to be analyzed.  This can be useful for determining the reason why the request may be stuck in the queue.

References