Concurrent Manager status: "System Hold, Fix Manager"

Concurrent Manager status: "System Hold, Fix Manager"

Solution:

1) Shutdown the Apps Tier cleanly make sure there are no sessions: ps -ef | grep FNDLIBR
 
2) go to cd $FND_TOP/bin
run the below commands:
$ 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”

Check relink logs to make sure the relinks completes sucessfully.

Ex: adrelink is exiting with status 0
End of adrelink session Date/time is  Mon Apr 23 10:50:24 PST 2013 **********************************************************
Line-wrapping log file for readability … Done line-wrapping log file.
Original copy is  /../…/../adrelink.lsv New copy is /../../../../../adrelink.log3)

3. After running the relinks run the cmclean.sql to flush out the status of the CM’s.
Don't forget to commit.

SQL> sqlplus apps/

SQL> @cmclean.sql
DOC>
———————————————————————– Updates complete. Type commit now to commit these updates, or rollback to cancel. ———————————————————————–
SQL> commit;
Commit complete.
 
4) Now Restart the Apps tier:

Notes:
Manager Status Shows System Hold, Fix Manager before resetting counters [ID 1507580.1] Concurrent Processing – CMCLEAN.SQL – Non Destructive Script to Clean Concurrent Manager Tables [ID 134007.1]