Skip to content

System Hold, Fix Manager before resetting counters

We have seen this error couple of times in the Concurrent manager Administer screen in our 11i/R12 EBS instances.

Below steps have proven helpful in sorting out this issue:

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 and commit..

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.

 

References:

R12 E-Business Suite Concurrent Processing Managers Including OPP, Workflow Agent, and Workflow Listener Show Status “System Hold, Fix Manager before resetting counters” (Doc ID 2330129.1)

Manager Status Shows System Hold, Fix Manager before resetting counters (Doc ID 1507580.1)

[Post Views: 136]

Brijesh Gogia

I’m an experienced Oracle Applications DBA with more than a decade of full-time DBA experience. I have gained a wide knowledge of the Oracle software stack and have worked on several big projects for multi-national companies. I enjoy working with the leading-edge technology and have passion for database performance and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
  
You can connect with me on LinkedIn.

2 Comments

  1. Qadar Qadar

    Hi,

    You have to provide MOS document, blindly we cannot do anything on Prod and other servers

    • Brijesh Gogia Brijesh Gogia

      You are right. I have added the MOS documents links now.

Leave a Reply

Required fields are marked *

error: Alert: Content is protected !!