If you check the OPP log , you may find it was either down or ended with error. Check out this 'section'... it would no longer process requests, but would not shut down either.
I. Known issues (UNSTABLE / UNRELIABLE)
Tuning Output Post Processor (OPP) to Improve Performance (Doc ID 1399454.1)
Hope this helps!
Check out this 'section'... OPP would no longer process requests, but would not shut down either.
I often forget where to find the target OPP logs as there are so many log files.
I got this error in the FNDOPP logs:
[8/5/19 12:02:22 AM] [EXCEPTION] [OPPServiceThread0] java.sql.SQLException: ORA-24067: exceeded maximum number of subscribers for queue APPLSYS.FND_CP_GSM_OPP_AQ
ORA-06512: at "APPS.FND_CP_OPP_IPC", line 85
ORA-06512: at line 1
But I just purged these tables last week for pro-active action plan, since I often encouter this like every 6 months.
po.block := FALSE;
queue_table => 'APPLSYS.FND_CP_GSM_OPP_AQTBL',
purge_condition => NULL,
purge_options => po);
SQL> select count(*) from applsys.FND_CP_GSM_OPP_AQTBL;
SQL> select count(*) from applsys.AQ$_FND_CP_GSM_OPP_AQTBL_S;
SQL> select count(*) from applsys.AQ$_FND_CP_GSM_OPP_AQTBL_T;
SQL> select count(*) from applsys.AQ$_FND_CP_GSM_OPP_AQTBL_H;
SQL> select count(*) from applsys.AQ$_FND_CP_GSM_OPP_AQTBL_I;
SQL> select count(*) from applsys.AQ$_FND_CP_GSM_OPP_AQTBL_G;
Why is it still encountered such error
In addition to the above, as a best practice.. just consider consuming the above patch which would prevent OPP from stop working due to various such errors in future.
Is there a permanent fix for this issue?
Does the patch also purges large AQ tables growing?
Or I need to create a script to purge the table weekly?
How I automate a script the requires input parameter as below?
Enter value for 1: APPLSYS
Enter value for 2: devapps
it seems you missed it.. pasting again.
If there are extra subscribers which are left from previous runs (last shutdown was improper) of OPP processes ; Refer this (Doc ID 2215371.1)
Hope this helps to resolve!
I will check that note....brb
You may try it on test instance if the issue is reproducible and share the results.
Hope the OPP is up and running/functioning.
Responding to your query on searching logs -
You opp logfiles are under $APPLCSF/$APPLLOG.
You can simply search them as follows -
ls -ltr $APPLCSF/$APPLLOG/*OPP*
under System Administrator -> Concurrent -> Manager -> Administer , Check for Output Post Processor -> Click on Processes -> MAnager log.
Depending upon OPP processes, there will be number of logs for each process and one of them will be picking your request id for report generation.