5 Replies Latest reply: May 6, 2013 5:55 AM by 934200 RSS

    Pending Jobs count above threshold

    934200
      Hi Hussein/All,

      As I am fresher joined 7 mnths back, could you please explain how to resolve the alerts coming for Pending Jobs count above threshold.

      Thanks,
      Abdullah
        • 1. Re: Pending Jobs count above threshold
          934200
          Pending Jobs Count (68) EXCEEDS Threshold (60).

          --- How to resolve this alert. Whats need to be checked. Could any1 help me..
          • 2. Re: Pending Jobs count above threshold
            Hussein Sawwan-Oracle
            Hi Abdullah,

            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).

            Thanks,
            Hussein
            • 3. Re: Pending Jobs count above threshold
              934200
              Hi Hussein,

              Apps: 12.1.3
              DB: 11.2.0.3
              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 *****
              CRITICAL:
              Pending Jobs Count (1771) EXCEEDS Threshold (50)
              ==============

              Thanks,
              Abdullah.
              • 4. Re: Pending Jobs count above threshold
                Hussein Sawwan-Oracle
                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]

                Thanks,
                Hussein
                • 5. Re: Pending Jobs count above threshold
                  934200
                  Hussein,

                  We have 1 CM node and 30 processes are attached to it.
                  did not run cmclean.sql After some time it got cleared automatically. but sometimes, it doesn't comes below threshold level.

                  Regards,
                  Abdullah

                  Edited by: Abbu on May 6, 2013 4:25 PM