This content has been marked as final. Show 5 replies
Please post the details of the application release, database version and OS.
As I am fresher joined 7 mnths back, could you please explain how to resolve the alerts coming for Pending Jobs count above threshold.Are you referring to pending concurrent requests? Please provide more details on the alerts you are referring to (like name, description, ..etc).
OS: linux x64
Yes I am talking about Pending Concurrent Requests. do not have details of the alert, we have some scripts internally embedded in tool which alerts us whenever the pending requests are above the threshold. For different clients, we have different thresholds set.
Please do let me know how to proceed to resolve this alert(Pending Concurrent Requests)
We get alert as below --- with instance name
***** This is an auto-generated email alert *****
Pending Jobs Count (1771) EXCEEDS Threshold (50)
How many concurrent managers you have? How many processes are attached for each manager?
Please run cmclean.sql script as per (Concurrent Processing - CMCLEAN.SQL - Non Destructive Script to Clean Concurrent Manager Tables [ID 134007.1]) and check then.
Please also see the following docs.
Performance: Concurrent Requests Hang in Pending Status For Long Time [ID 1360118.1]
Concurrent Processing - CP Analyzer for E-Business Suite [ID 1411723.1
Too Many Standard And Conflict Manager Pending Requests Every Weekend [ID 1334522.1]
Concurrent Processing (CP) / APPS Reporting Scripts [ID 213021.1]