Output Post Processor Down : Actual 0 Target 3

“Output Post Processor” Concurrent Manager not able to start

OPP manager log file path :- /u01/apps/inst/apps/QA_QA01/logs/appl/conc/log

[qa1@QA01 log]$ ls -lrt |grep FNDOPP

Error in OPP log file.

[qa1@QA01 log]$ cat FNDOPP2127409.txt

Unable to initialize state monitor.

oracle.apps.fnd.cp.gsm.GenCartCommException: ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at "APPS.FND_CP_GSM_IPC", line 539

ORA-06512: at line 1

        at oracle.apps.fnd.cp.gsm.GenCartComm.initService(GenCartComm.java:233)

        at oracle.apps.fnd.cp.gsm.GenCartComm.<init>(GenCartComm.java:80)

        at oracle.apps.fnd.cp.gsf.GSMStateMonitor.init(GSMStateMonitor.java:74)

        at oracle.apps.fnd.cp.gsf.GSMStateMonitor.<init>(GSMStateMonitor.java:62)

        at oracle.apps.fnd.cp.gsf.GSMServiceController.init(GSMServiceController.java:111)

        at oracle.apps.fnd.cp.gsf.GSMServiceController.<init>(GSMServiceController.java:66)

        at oracle.apps.fnd.cp.gsf.GSMServiceController.main(GSMServiceController.java:428)

.0002460 secs]

                                                          SOLUTION

1. Shutdown the internal manager by using adcmctl.sh stop apps/****
2. Make sure there is no FNDLIBR processe running:
            $ ps -ef| grep FNDLIBR 
3. If there is any FNDLIBR processe please kill it $ kill -9 pid
4. Run cmclean.sql script as document from Note 134007.1
5. Restart the internal manager by using adcmctl.sh start apps/*****

Retest issue. I hope issue has been resolved.

                                             OR 

For performance issue please increase java heap size

Maximum Memory Usage Per Process:

The maximum amount of memory or maximum Java heap size a single OPP process can use is by default set to 512MB. 

This value is seeded by the Loader Data File: $FND_TOP/patch/115/import/US/afoppsrv.ldt which specifies that the 

DEVELOPER_PARAMETERS is “J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx512m”.

How to determine the current maximum Java heap size:

SELECT service_id, service_handle, developer_parameters

FROM fnd_cp_services

WHERE service_id = (SELECT manager_type

FROM fnd_concurrent_queues

WHERE concurrent_queue_name = ‘FNDCPOPP’);SERVICE_ID SERVICE_HANDLE DEVELOPER_PARAMETERS

———- ————– ——————————————————–

1091 FNDOPP J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx512m

Increase the maximum Java heap size for the OPP to 1024MB (1GB):

UPDATE fnd_cp_services

SET developer_parameters =

‘J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx1024m’

WHERE service_id = (SELECT manager_type

FROM fnd_concurrent_queues

WHERE concurrent_queue_name = ‘FNDCPOPP’);

The OPP queue can be Recreated the using $FND_TOP/patch/115/sql/afopp002.sql file as ‘APPLSYS’ user. 

OPP Running process status.

SQL> select sid,serial#,status,logon_time,module from v$session where module like'%OPP%';

SID SERIAL# STATUS LOGON_TIM MODULE
--- ------- ------- --------- ------
5769 31 ACTIVE 14-APR-15 FNDCPOPP

5773 10 ACTIVE 14-APR-15 FNDCPOPP

5780 4 ACTIVE 14-APR-15 FNDCPOPP


Check from front end.

Actual and Target processes should both be 3.