3 Replies Latest reply on Dec 18, 2015 5:13 PM by Karthik Appsys

    Concurrent Manager - Actual/Target values mismatch after DB Refresh

    Karthik Appsys

      Dear Legends,

       

      We are facing a issue with Concurrent Managers Actual and Target values are not equal. ENV: R12.0.6 DB-10.2.0.3

       

      - We performed a DB Refresh from PROD backup to TEST Environment

      - Then while performing post cloning

      - Check for FND_NODES tables if it is holding PROD IP or NODE NAME then

      - Clear FND_NODES by running exec FND_CONC.SETUP_CLEAN proc by connecting APPS Schema

      - Truncated FND_CONC related 2 tables

      - Then ran AC on DB Tier first and APPS Tier.

       

      Now we could not start the concurrent manager, even if we start it is mismatching with ACTUAL = 0 and TARGET = 1

       

      Internal Manager log

      ================

      Check that your system has enough resources to start a concurrent manager process. Contact your system admi : 18-DEC-2015 21:00:30

      Starting STANDARD Concurrent Manager : 18-DEC-2015 21:00:30

      ORACLE error 60 in insert_fcp

       

      Cause: insert_fcp failed due to ORA-00060: deadlock detected while waiting for resource

      ORA-06512: at "APPS.FND_CP_FNDSM", line 127

      ORA-06512: at line 1.

       

      The SQL statement being executed at the time of the error was: begin fnd_cp_fndsm.register_fndsm_fcp(:c,:n,:o,:l,:m,:t); end; and was executed from the file &ERRFILE.

      Could not initialize the Service Manager FNDSM_ORATEST_TEST. Verify that ORATEST has been registered for concurrent processing.

      CONC-SM CLIENT ERROR (ROUTINE=afpsmcsm) (SM_NAME=FNDSM_ORATEST_TEST) (ERROR=126)

      Routine AFPEIM encountered an error while starting concurrent manager STANDARD with library /oracle/TEST/apps/apps_st/appl/fnd/12.0.0/bin/FNDLIBR.

       

      Check that your system has enough resources to start a concurrent manager process. Contact your system admi : 18-DEC-2015 21:00:33

      Starting STANDARD Concurrent Manager : 18-DEC-2015 21:00:33

      ORACLE error 60 in insert_fcp

       

      Cause: insert_fcp failed due to ORA-00060: deadlock detected while waiting for resource

      ORA-06512: at "APPS.FND_CP_FNDSM", line 127

      ORA-06512: at line 1.

       

      The SQL statement being executed at the time of the error was: begin fnd_cp_fndsm.register_fndsm_fcp(:c,:n,:o,:l,:m,:t); end; and was executed from the file &ERRFILE.

      Could not initialize the Service Manager FNDSM_ORATEST_TEST. Verify that ORATEST has been registered for concurrent processing.

      CONC-SM CLIENT ERROR (ROUTINE=afpsmcsm) (SM_NAME=FNDSM_ORATEST_TEST) (ERROR=126)

      Routine AFPEIM encountered an error while starting concurrent manager STANDARD with library /oracle/TEST/apps/apps_st/appl/fnd/12.0.0/bin/FNDLIBR.

       

      Check that your system has enough resources to start a concurrent manager process. Contact your system admi : 18-DEC-2015 21:00:37

      Starting STANDARD Concurrent Manager : 18-DEC-2015 21:00:37

       

      Any kind of help would be much appreciated.

      Thanks,

      Karthik