Standard manager pending

[big]

Hi,
On R12.2 DB 11.2.0.4 on AIX
Requests for Standard manager stuck in pendin. We have stoped started adcmctl.sh and also Application server and also DB, but it is always the same:



Thanks for advise.

[ErmanArslansOracleBlog]

They are not in the conflict resolution manager's queue. So there must be another reason.
What are those pending concurrent requests ? and why are they waiting? (check them using Concurrent Manager forms using diagnostics..)

[big]

Hi, Thank you.

For each pending job, when clic on diagnostic , we can read:

The next available concurrent manager will process this request.

This request will process as soon as the concurrent manager finishes its current processing


No action required. This is a normal condition. You may expedite the start of the processing of this request by reducing its priority value

Then I reduced the priority to 2 (first it was 50) but they did not proceeded.



Moreover any of them generates no log or out file.

Regards.

[ErmanArslansOracleBlog]

They are in pending status. Standard manager seems up, but it doesn't process those requests.
Please check the standard manager's log. What do you see there?
Did you try restarting the standard manager processes?

[big]

Hi,
Thanks.
The log that I know and verified is  ../../logs/appl/admin/log/adcmctl.txt.

I stopped/started like this:

./adcmctl.sh stop apps/mdpapps
adcmctl.sh: exiting with status 0

./adcmctl.sh start apps/mdpapps
adcmctl.sh: exiting with status 0

Can we specificaly stop/start Standard Manager? How?

Any query to find manager who has processed a request?

Regards.

[ErmanArslansOracleBlog]

Easy. Just use the concurrent manager admin form.. There are those buttons that you can use for restarting specific managers.

Read the documentation also.

[big]

Hi,
 I restarted manager From FORMES, but after a while being in restarting , it came back with pending request:



The pending request is a simple Active Users and it did not generate any log or out file.

With following message when diagnosing:

The next available concurrent manager will process this request.

Any query to find manager who has processed a request knownig its ID?

Thanks.

[ErmanArslansOracleBlog]

So your managers are up but don't process the concurrent requests , am I correct?

Maybe then, that form is not correct.. maybe it shows standard manager is up and running, but maybe it is actually down.

Verify it from the database;

Query to Check All Concurrent Manager Status
byHimanshu-November 07, 2019

We can use below query to check all concurrent managers status with node name and number of actual/target processes.

SELECT   b.user_concurrent_queue_name "Concurrent Manager", a.TARGET_NODE "Node", a.running_processes "ACTUAL Processes", a.max_processes "TARGET Processes"
   ,DECODE (b.control_code
     ,'D', 'Deactivating'
     ,'E', 'Deactivated'
     ,'N', 'Node unavai'
     ,'A', 'Activating'
     ,'X', 'Terminated'
     ,'T', 'Terminating'
     ,'V', 'Verifying'
     ,'O', 'Suspending'
     ,'P', 'Suspended'
     ,'Q', 'Resuming'
     ,'R', 'Restarting'
     ) status
  FROM apps.fnd_concurrent_queues a, apps.fnd_concurrent_queues_vl b
    WHERE a.concurrent_queue_id = b.concurrent_queue_id AND a.running_processes = a.max_processes
 ORDER BY a.max_processes DESC;

Restart the CM stack if neccesary. Check the logs of Internal concurrent manager and standard manager if that s the case and solve the problem.

Other than that, for your specific question; here is a query for you ->

select b.USER_CONCURRENT_QUEUE_NAME
from fnd_concurrent_processes a,
fnd_concurrent_queues_vl b, fnd_concurrent_requests c
where  a.CONCURRENT_QUEUE_ID = b.CONCURRENT_QUEUE_ID
and    a.CONCURRENT_PROCESS_ID = c.controlling_manager
and    c.request_id = &request_id;   ---> HERE you will replace the &request_id with your request id.

Note that, I didn't check those queries.. Just sending you as a quick help. But they look okay.

[big]

Hi,
Thank you.

We have :
$ adcmctl.sh status

You are running adcmctl.sh version 120.19.12020000.7


Enter the APPS username : apps

Enter the APPS password :
Internal Concurrent Manager is Active.

adcmctl.sh: exiting with status 0

But the query about status of manager returns:



Why status is null? What is its meaning?

Regards.

[ErmanArslansOracleBlog]

Seem ok..
For that null, the cause may be the query. Just modify it and make it without decode.. Just get the status. What do you see? But again, your Concurrent managers seems ok. ACTUAL & TARGETs are okay even from the db level control..

So I guess you should revise your question..

[big]

Ok.

Hi problem resolved running :
exec fnd_stats.gather_table_stats ('APPLSYS','FND_CONCURRENT_REQUESTS',PERCENT=>99);

Thanks.