Concurrent Manager - Sytem Hold, Fix Manager before resetting Status

Concurrent Processing – SYSTEM HOLD, FIX MANAGER BEFORE RESETTING [ID 985835.1]
==========================================================================
On 12.1 in Production:
When attempting to run requests the Scheduler/Prereleaser is showing the
following error:
The actual value of the manager is 0.
ERROR:
———————–

"System Hold, Fix Manager before resetting counters".

This issue could appear also for all the concurrent managers not only for Scheduler/Prereleaser.
Steps to Reproduce
Responsibility System administrator >Concurrent > Manager > Administer

Cause

One of manager “Scheduler/Prereleaser Manager” is showing status “System Hold, Fix Manager before resetting counters”.
Solution suggested as per:
Bug 8446080
Bounced CM, Ran Cm clean & Issue resolved.
Bug 8240251
Bounced DB listener
Compiled apps schema using adadmin
Bug 8264854
SELECT
a.user_concurrent_queue_name,c.CONCURRENT_PROCESSOR_NAME,d.control_code
FROM
fnd_concurrent_queues_tl a , fnd_concurrent_queues
b,FND_CONCURRENT_PROCESSORS c , FND_CONCURRENT_QUEUES_VL d
WHERE a.concurrent_queue_id=b.concurrent_queue_id AND d.enabled_flag=’Y’
AND
d.control_code=’H’ AND d.concurrent_queue_name = a.concurrent_queue_name
AND a.LANGUAGE=’US’ AND b.concurrent_processor_id=c.concurre
nt_processor_id;
Select owner, name, enqueue_enabled, dequeue_enabled
From dba_queues
Where upper (name) like ‘%GSM%’
and owner=’APPLSYS’
order by name;

Solution

To implement the solution, please execute the following steps:
1. Stop all middle tier services including the concurrent managers.
Please make sure that no FNDLIBR, FNDSM, or any dead process is
running.
2. Stop the database.
3. Start the database.
4. Go to cd $FND_TOP/bin
$ adrelink.sh force=y link_debug=y “fnd FNDLIBR”
$ adrelink.sh force=y link_debug=y “fnd FNDFS”
$ adrelink.sh force=y link_debug=y “fnd FNDCRM”
$ adrelink.sh force=y link_debug=y “fnd FNDSM”
5. Run the CMCLEAN.SQL script from the referenced note below (don’t forget to commit).
Note 134007.1 CMCLEAN.SQL – Non Destructive Script to Clean Concurrent Manager Tables
6. Execute the following SQL:
select CONCURRENT_QUEUE_NAME from FND_CONCURRENT_QUEUES where
CONCURRENT_QUEUE_NAME like ‘FNDSM%’;
7. Start the middle tier services including your concurrent manager.

8. Retest the issue.