Core Concurrent Processing - EBS (MOSC)

MOSC Banner

OPP.jpg

User_1K4DF
User_1K4DF Posts: 11 Blue Ribbon
edited Jul 16, 2014 8:31AM in Core Concurrent Processing - EBS (MOSC) 11 comments

Comments

  • Kevin M-Oracle
    Kevin M-Oracle Posts: 12,388 Diamond - Community Leader

    Moved to Core Concurrent Processing.

  • User_1K4DF
    User_1K4DF Posts: 11 Blue Ribbon

    Moved to Core Concurrent Processing.

    Thanks for replying Kevin,

    i am new to EBS and i need help in this problem.

    Is it Ok for OPP to be in core as you said ??

    How can i access XML publisher responsibility ?

    my output post processor shows the reports only in XML format it doesn't convert to PDF and the status of the report

    is Completed with warning i researched this problem and i did almost all solutions but nothing comes with a solution,

    Regards.

  • Kevin M-Oracle
    Kevin M-Oracle Posts: 12,388 Diamond - Community Leader

    Thanks for replying Kevin,

    i am new to EBS and i need help in this problem.

    Is it Ok for OPP to be in core as you said ??

    How can i access XML publisher responsibility ?

    my output post processor shows the reports only in XML format it doesn't convert to PDF and the status of the report

    is Completed with warning i researched this problem and i did almost all solutions but nothing comes with a solution,

    Regards.

    Is it Ok for OPP to be in core as you said ?

    Yes our CP team can help you with issues you  run into while creating a new OPP service.

    How can i access XML publisher responsibility ?

    If you are assigned this responsibility by your system admin, you select it after logging in to EBS.

    my output post processor shows the reports only in XML format it doesn't convert to PDF and the status of the report

    is Completed with warning i researched this problem and i did almost all solutions but nothing comes with a solution,

    Get the OPP log to see the actual error for each report.

    Kevin

  • User_1K4DF
    User_1K4DF Posts: 11 Blue Ribbon

    When i run a report it gives me this log :

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

    +---------------------------------------------------------------------------+

    Human Resources: Version : 12.0.0

    Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

    BIRTH_EMP_NAME module: GSC Date of Birth For Employee

    +---------------------------------------------------------------------------+

    Current system time is 21-JUL-2014 10:57:38

    +---------------------------------------------------------------------------+

    +-----------------------------

    | Starting concurrent program execution...

    +-----------------------------

    Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing

    Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

    American_America.AR8MSWIN1256

    '.,'

    Enter Password:

    Report Builder: Release 10.1.2.3.0 - Production on Mon Jul 21 10:57:40 2014

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    +---------------------------------------------------------------------------+

    Start of log messages from FND_FILE

    +---------------------------------------------------------------------------+

    +---------------------------------------------------------------------------+

    End of log messages from FND_FILE

    +---------------------------------------------------------------------------+

    +---------------------------------------------------------------------------+

    Executing request completion options...

    +------------- 1) PUBLISH -------------+

    Unable to find an Output Post Processor service to post-process request 503291.

    Check that the Output Post Processor service is running.

    +--------------------------------------+

    +------------- 2) PRINT -------------+

    Not printing the output of this request because post-processing failed.

    +--------------------------------------+

    Finished executing request completion options.

    +---------------------------------------------------------------------------+

    Concurrent request completed

    Current system time is 21-JUL-2014 10:57:41

    +---------------------------------------------------------------------------+

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

    The Internal Manager Log :

    Starting PROD_0717@PROD Internal Concurrent Manager -- shell process ID 22328

    Routine &ROUTINE has attempted to start the internal concurrent manager. The ICM is already running. Contact you system administrator for further assistance.afpdlrq received an unsuccessful result from PL/SQL procedure or function FND_DCP.Request_Session_Lock.

    Routine FND_DCP.REQUEST_SESSION_LOCK received a result code of 1 from the call to DBMS_LOCK.Request.

    Possible DBMS_LOCK.Request resultCall to establish_icm failed

    The Internal Concurrent Manager has encountered an error.

    Review concurrent manager log file for more detailed information. : 17-JUL-2014 12:56:33 -

    Shutting down Internal Concurrent Manager : 17-JUL-2014 12:56:33

    List of errors encountered:

    .............................................................................

    _ 1 _

    Routine AFPCSQ encountered an ORACLE error. .

    Review your error messages for the cause of the error. (=<POINTER>)

    .............................................................................

    List of errors encountered:

    .............................................................................

    _ 1 _

    Routine AFPCAL received failure code while parsing or running your

    concurrent program CPMGR

    Review your concurrent request log file for more detailed information.

    Make sure you are passing arguments in the correct format.

    .............................................................................

    The PROD_0717@PROD internal concurrent manager has terminated with status 1 - giving up.

    Shutting down Internal Concurrent Manager : 17-JUL-2014 12:56:42

    The PROD_0717@PROD internal concurrent manager has terminated successfully - exiting.

      logfile=/u01/oracle/PROD/inst/apps/PROD_gscprod/logs/appl/conc/log/PROD_0717.mgr  PRINTER=noprint  mailto=oracle  restart=N  diag=N  sleep=30  pmon=4  quesiz=1  Reviver is ENABLED
  • Nalbadin-Oracle
    Nalbadin-Oracle Posts: 6,169 Bronze Crown

    When i run a report it gives me this log :

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

    +---------------------------------------------------------------------------+

    Human Resources: Version : 12.0.0

    Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

    BIRTH_EMP_NAME module: GSC Date of Birth For Employee

    +---------------------------------------------------------------------------+

    Current system time is 21-JUL-2014 10:57:38

    +---------------------------------------------------------------------------+

    +-----------------------------

    | Starting concurrent program execution...

    +-----------------------------

    Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing

    Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

    American_America.AR8MSWIN1256

    '.,'

    Enter Password:

    Report Builder: Release 10.1.2.3.0 - Production on Mon Jul 21 10:57:40 2014

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    +---------------------------------------------------------------------------+

    Start of log messages from FND_FILE

    +---------------------------------------------------------------------------+

    +---------------------------------------------------------------------------+

    End of log messages from FND_FILE

    +---------------------------------------------------------------------------+

    +---------------------------------------------------------------------------+

    Executing request completion options...

    +------------- 1) PUBLISH -------------+

    Unable to find an Output Post Processor service to post-process request 503291.

    Check that the Output Post Processor service is running.

    +--------------------------------------+

    +------------- 2) PRINT -------------+

    Not printing the output of this request because post-processing failed.

    +--------------------------------------+

    Finished executing request completion options.

    +---------------------------------------------------------------------------+

    Concurrent request completed

    Current system time is 21-JUL-2014 10:57:41

    +---------------------------------------------------------------------------+

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

    The Internal Manager Log :

    Starting PROD_0717@PROD Internal Concurrent Manager -- shell process ID 22328

    Routine &ROUTINE has attempted to start the internal concurrent manager. The ICM is already running. Contact you system administrator for further assistance.afpdlrq received an unsuccessful result from PL/SQL procedure or function FND_DCP.Request_Session_Lock.

    Routine FND_DCP.REQUEST_SESSION_LOCK received a result code of 1 from the call to DBMS_LOCK.Request.

    Possible DBMS_LOCK.Request resultCall to establish_icm failed

    The Internal Concurrent Manager has encountered an error.

    Review concurrent manager log file for more detailed information. : 17-JUL-2014 12:56:33 -

    Shutting down Internal Concurrent Manager : 17-JUL-2014 12:56:33

    List of errors encountered:

    .............................................................................

    _ 1 _

    Routine AFPCSQ encountered an ORACLE error. .

    Review your error messages for the cause of the error. (=<POINTER>)

    .............................................................................

    List of errors encountered:

    .............................................................................

    _ 1 _

    Routine AFPCAL received failure code while parsing or running your

    concurrent program CPMGR

    Review your concurrent request log file for more detailed information.

    Make sure you are passing arguments in the correct format.

    .............................................................................

    The PROD_0717@PROD internal concurrent manager has terminated with status 1 - giving up.

    Shutting down Internal Concurrent Manager : 17-JUL-2014 12:56:42

    The PROD_0717@PROD internal concurrent manager has terminated successfully - exiting.

      logfile=/u01/oracle/PROD/inst/apps/PROD_gscprod/logs/appl/conc/log/PROD_0717.mgr  PRINTER=noprint  mailto=oracle  restart=N  diag=N  sleep=30  pmon=4  quesiz=1  Reviver is ENABLED

    Hi,

    A. Run the following sql:

    SQL> select CONCURRENT_QUEUE_NAME, ENABLED_FLAG, MAX_PROCESSES, RUNNING_PROCESSES

        from FND_CONCURRENT_QUEUES

        WHERE CONCURRENT_QUEUE_NAME='FNDCPOPP';

    SQL> select CONCURRENT_QUEUE_NAME, TARGET_NODE, node_name, control_code

       from fnd_concurrent_queues

        WHERE CONCURRENT_QUEUE_NAME='FNDCPOPP';

    -SQL> SELECT outfile_name, outfile_node_name

      FROM fnd_concurrent_requests

      WHERE request_id = 503291;

    Regards,

  • User_1K4DF
    User_1K4DF Posts: 11 Blue Ribbon

    SQL> select CONCURRENT_QUEUE_NAME, ENABLED_FLAG, MAX_PROCESSES, RUNNING_PROCESSES

      2  from FND_CONCURRENT_QUEUES

      3  WHERE CONCURRENT_QUEUE_NAME='FNDCPOPP';

    CONCURRENT_QUEUE_NAME          E MAX_PROCESSES RUNNING_PROCESSES

    ------------------------------ - ------------- -----------------

    FNDCPOPP                       Y             4                 4

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

    SQL> select CONCURRENT_QUEUE_NAME, TARGET_NODE, node_name, control_code

      2   from fnd_concurrent_queues

      3  WHERE CONCURRENT_QUEUE_NAME='FNDCPOPP';

    CONCURRENT_QUEUE_NAME          TARGET_NODE

    ------------------------------ ------------------------------

    NODE_NAME                      C

    ------------------------------ -

    FNDCPOPP                       GSCPROD

    GSCPROD

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

    SQL> SELECT outfile_name, outfile_node_name

      2  FROM fnd_concurrent_requests

      3  WHERE request_id = 503291;

    OUTFILE_NAME

    --------------------------------------------------------------------------------

    OUTFILE_NODE_NAME

    ------------------------------

    /u01/oracle/PROD/inst/apps/PROD_gscprod/logs/appl/conc/out/o503291.out

    GSCPROD

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

  • Nalbadin-Oracle
    Nalbadin-Oracle Posts: 6,169 Bronze Crown

    SQL> select CONCURRENT_QUEUE_NAME, ENABLED_FLAG, MAX_PROCESSES, RUNNING_PROCESSES

      2  from FND_CONCURRENT_QUEUES

      3  WHERE CONCURRENT_QUEUE_NAME='FNDCPOPP';

    CONCURRENT_QUEUE_NAME          E MAX_PROCESSES RUNNING_PROCESSES

    ------------------------------ - ------------- -----------------

    FNDCPOPP                       Y             4                 4

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

    SQL> select CONCURRENT_QUEUE_NAME, TARGET_NODE, node_name, control_code

      2   from fnd_concurrent_queues

      3  WHERE CONCURRENT_QUEUE_NAME='FNDCPOPP';

    CONCURRENT_QUEUE_NAME          TARGET_NODE

    ------------------------------ ------------------------------

    NODE_NAME                      C

    ------------------------------ -

    FNDCPOPP                       GSCPROD

    GSCPROD

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

    SQL> SELECT outfile_name, outfile_node_name

      2  FROM fnd_concurrent_requests

      3  WHERE request_id = 503291;

    OUTFILE_NAME

    --------------------------------------------------------------------------------

    OUTFILE_NODE_NAME

    ------------------------------

    /u01/oracle/PROD/inst/apps/PROD_gscprod/logs/appl/conc/out/o503291.out

    GSCPROD

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

    Hi,

    1. Upload the latest Output Post Processor manager log file which is under:

      $APPLCSF/log/<SID>/FNDOPP####.txt

    2. What is the values for the following profile option:

    1. Concurrent:OPP Process Timeout

    2.  Concurrent:OPP Response Timeout

    Regards,

  • User_1K4DF
    User_1K4DF Posts: 11 Blue Ribbon

    [7/10/14 1:19:13 PM] [main] Starting GSF service with concurrent process id = 50837.

    [7/10/14 1:19:13 PM] [main] Initialization Parameters: oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=5

    [7/10/14 1:19:13 PM] [Thread-20] Service thread starting up.

    [7/10/14 1:19:13 PM] [Thread-21] Service thread starting up.

    [7/10/14 1:19:13 PM] [EXCEPTION] [OPPServiceThread0] java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SYS.I_PARENTOBJ) violated

    ORA-06512: at "APPS.FND_CP_OPP_IPC", line 85

    ORA-06512: at line 1

            at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85)

            at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)

            at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)

            at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

            at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

            at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)

            at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)

            at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)

            at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1225)

            at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)

            at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488)

            at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3857)

            at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)

            at oracle.apps.fnd.cp.opp.OPPAQMonitor.initAQ(OPPAQMonitor.java:558)

            at oracle.apps.fnd.cp.opp.OPPAQMonitor.init(OPPAQMonitor.java:534)

            at oracle.apps.fnd.cp.opp.OPPAQMonitor.initialize(OPPAQMonitor.java:89)

            at oracle.apps.fnd.cp.opp.OPPServiceThread.init(OPPServiceThread.java:94)

            at oracle.apps.fnd.cp.gsf.BaseServiceThread.run(BaseServiceThread.java:135)

    [7/10/14 1:20:40 PM] [GSMServiceController:50837] Received shutdown request.

    [7/10/14 1:20:40 PM] [OPPServiceThread0] Received immediate shutdown request. Service Thread will shutdown once all running requests have completed.

    [7/10/14 1:20:40 PM] [GSMServiceController:50837] Preparing to shutdown service.

    [7/10/14 1:20:40 PM] [GSMServiceController:50837] Stopping all Service Threads.

    [7/10/14 1:20:40 PM] [OPPServiceThread1] Preparing to shut down service thread.

    [7/10/14 1:21:00 PM] [EXCEPTION] [OPPAQMON:50837] java.sql.SQLException: ORA-24035: AQ agent OPP50837 is not a subscriber for queue APPLSYS.FND_CP_GSM_OPP_AQ

    ORA-06512: at "APPS.FND_CP_OPP_IPC", line 108

    ORA-06512: at line 1

            at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

            at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)

            at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)

            at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

            at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

            at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)

            at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)

            at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)

            at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1225)

            at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)

            at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488)

            at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3857)

            at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)

            at oracle.apps.fnd.cp.opp.OPPAQMonitor.unsubscribeFromAQ(OPPAQMonitor.java:593)

            at oracle.apps.fnd.cp.opp.OPPAQMonitor.run(OPPAQMonitor.java:135)

            at java.lang.Thread.run(Thread.java:619)

    [7/10/14 1:21:00 PM] [OPPServiceThread0] Preparing to shut down service thread.

    [7/10/14 1:21:00 PM] [OPPServiceThread0] Service thread has shutdown.

    [7/10/14 1:21:10 PM] [OPPServiceThread1] Service thread has shutdown.

    [7/10/14 1:21:10 PM] [GSMServiceController:50837] All Service Threads have completed.

    [7/10/14 1:21:10 PM] [GSMServiceController:50837] Service has shut down.

    This was 10 days ago no other log file similar to this is available with higher date.

    The Values for both is 1500

    Thanks

  • Nalbadin-Oracle
    Nalbadin-Oracle Posts: 6,169 Bronze Crown

    [7/10/14 1:19:13 PM] [main] Starting GSF service with concurrent process id = 50837.

    [7/10/14 1:19:13 PM] [main] Initialization Parameters: oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=5

    [7/10/14 1:19:13 PM] [Thread-20] Service thread starting up.

    [7/10/14 1:19:13 PM] [Thread-21] Service thread starting up.

    [7/10/14 1:19:13 PM] [EXCEPTION] [OPPServiceThread0] java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SYS.I_PARENTOBJ) violated

    ORA-06512: at "APPS.FND_CP_OPP_IPC", line 85

    ORA-06512: at line 1

            at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85)

            at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)

            at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)

            at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

            at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

            at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)

            at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)

            at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)

            at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1225)

            at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)

            at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488)

            at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3857)

            at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)

            at oracle.apps.fnd.cp.opp.OPPAQMonitor.initAQ(OPPAQMonitor.java:558)

            at oracle.apps.fnd.cp.opp.OPPAQMonitor.init(OPPAQMonitor.java:534)

            at oracle.apps.fnd.cp.opp.OPPAQMonitor.initialize(OPPAQMonitor.java:89)

            at oracle.apps.fnd.cp.opp.OPPServiceThread.init(OPPServiceThread.java:94)

            at oracle.apps.fnd.cp.gsf.BaseServiceThread.run(BaseServiceThread.java:135)

    [7/10/14 1:20:40 PM] [GSMServiceController:50837] Received shutdown request.

    [7/10/14 1:20:40 PM] [OPPServiceThread0] Received immediate shutdown request. Service Thread will shutdown once all running requests have completed.

    [7/10/14 1:20:40 PM] [GSMServiceController:50837] Preparing to shutdown service.

    [7/10/14 1:20:40 PM] [GSMServiceController:50837] Stopping all Service Threads.

    [7/10/14 1:20:40 PM] [OPPServiceThread1] Preparing to shut down service thread.

    [7/10/14 1:21:00 PM] [EXCEPTION] [OPPAQMON:50837] java.sql.SQLException: ORA-24035: AQ agent OPP50837 is not a subscriber for queue APPLSYS.FND_CP_GSM_OPP_AQ

    ORA-06512: at "APPS.FND_CP_OPP_IPC", line 108

    ORA-06512: at line 1

            at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

            at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)

            at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)

            at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

            at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

            at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)

            at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)

            at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)

            at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1225)

            at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)

            at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488)

            at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3857)

            at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)

            at oracle.apps.fnd.cp.opp.OPPAQMonitor.unsubscribeFromAQ(OPPAQMonitor.java:593)

            at oracle.apps.fnd.cp.opp.OPPAQMonitor.run(OPPAQMonitor.java:135)

            at java.lang.Thread.run(Thread.java:619)

    [7/10/14 1:21:00 PM] [OPPServiceThread0] Preparing to shut down service thread.

    [7/10/14 1:21:00 PM] [OPPServiceThread0] Service thread has shutdown.

    [7/10/14 1:21:10 PM] [OPPServiceThread1] Service thread has shutdown.

    [7/10/14 1:21:10 PM] [GSMServiceController:50837] All Service Threads have completed.

    [7/10/14 1:21:10 PM] [GSMServiceController:50837] Service has shut down.

    This was 10 days ago no other log file similar to this is available with higher date.

    The Values for both is 1500

    Thanks

    Hi,

    A. 1. Navigate to Concurrent Manager Administer -> Select the Output Post Processor.

    2.  Click the "Processes" button.  Select the process that was active

    3.  Choose the "Manager Log" button and upload this log

    B. Navigate to Concurrent Manager Administer and upload the screen shot <make sure OPP manager shows from this screen shot>.

    C. Upload the internal manager log file

    Regards,

  • User_1K4DF
    User_1K4DF Posts: 11 Blue Ribbon

    Hii,

    This is the Manager Log :

    +---------------------------------------------------------------------------+

    Application Object Library: Concurrent Processing version 11.5

    Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

    FNDCPOPP Concurrent Manager started : 17-JUL-2014 13:05:34

    +---------------------------------------------------------------------------+

    17-JUL-2014 19:13:35

    Starting concurrent program FNDOAMCOL for concurrent request 502739 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    17-JUL-2014 20:37:38

    Starting concurrent program FNDOAMCOL for concurrent request 502747 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    17-JUL-2014 22:01:41

    Starting concurrent program FNDOAMCOL for concurrent request 502755 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    17-JUL-2014 23:01:45

    Starting concurrent program FNDWFBES_CONTROL_QUEUE_CLEANUP for concurrent request 502652 (MODULE=FNDWFBES_CONTROL_QUEUE_CLEANUP)

    17-JUL-2014 23:25:45

    Starting concurrent program FNDOAMCOL for concurrent request 502764 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    18-JUL-2014 00:49:48

    Starting concurrent program FNDOAMCOL for concurrent request 502773 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    18-JUL-2014 02:13:51

    Starting concurrent program FNDOAMCOL for concurrent request 502781 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    18-JUL-2014 03:37:54

    Starting concurrent program FNDOAMCOL for concurrent request 502789 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    18-JUL-2014 05:01:58

    Starting concurrent program FNDOAMCOL for concurrent request 502797 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    18-JUL-2014 06:26:01

    Starting concurrent program FNDOAMCOL for concurrent request 502805 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    18-JUL-2014 07:50:04

    Starting concurrent program FNDOAMCOL for concurrent request 502813 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    18-JUL-2014 09:14:07

    Starting concurrent program FNDOAMCOL for concurrent request 502821 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    18-JUL-2014 10:38:11

    Starting concurrent program FNDOAMCOL for concurrent request 502829 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    18-JUL-2014 11:22:14

    Starting concurrent program FNDLGPRG for concurrent request 502655 (MODULE=FNDLGPRG)

    18-JUL-2014 12:02:14

    Starting concurrent program FNDOAMCOL for concurrent request 502842 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    18-JUL-2014 13:26:17

    Starting concurrent program FNDOAMCOL for concurrent request 502850 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    18-JUL-2014 14:50:20

    Starting concurrent program FNDOAMCOL for concurrent request 502858 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    18-JUL-2014 16:14:24

    Starting concurrent program FNDOAMCOL for concurrent request 502866 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    18-JUL-2014 17:38:27

    Starting concurrent program FNDOAMCOL for concurrent request 502874 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    18-JUL-2014 18:20:30

    Starting concurrent program FNDOAMCOL for concurrent request 502878 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    18-JUL-2014 19:02:33

    Starting concurrent program FNDOAMCOL for concurrent request 502882 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    19-JUL-2014 03:37:37

    Starting concurrent program FNDOAMCOL for concurrent request 502935 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    19-JUL-2014 04:40:40

    Starting concurrent program FNDOAMCOL for concurrent request 502941 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    19-JUL-2014 06:04:44

    Starting concurrent program FNDOAMCOL for concurrent request 502949 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    19-JUL-2014 07:28:47

    Starting concurrent program FNDOAMCOL for concurrent request 502957 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    19-JUL-2014 08:52:50

    Starting concurrent program FNDOAMCOL for concurrent request 502965 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    19-JUL-2014 10:16:53

    Starting concurrent program FNDOAMCOL for concurrent request 502973 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    19-JUL-2014 11:01:56

    Starting concurrent program FNDWFBES_CONTROL_QUEUE_CLEANUP for concurrent request 502906 (MODULE=FNDWFBES_CONTROL_QUEUE_CLEANUP)

    19-JUL-2014 11:21:57

    Starting concurrent program FNDLGPRG for concurrent request 502836 (MODULE=FNDLGPRG)

    19-JUL-2014 11:23:57

    Starting concurrent program FNDWFMLRSTATCC for concurrent request 502837 (MODULE=FNDWFMLRSTATCC)

    19-JUL-2014 11:23:57

    Starting concurrent program FNDWFWITSTATCC for concurrent request 502838 (MODULE=FNDWFWITSTATCC)

    19-JUL-2014 11:23:57

    Starting concurrent program FNDWFAASTATCC for concurrent request 502839 (MODULE=FNDWFAASTATCC)

    19-JUL-2014 12:22:58

    Starting concurrent program FNDOAMCOL for concurrent request 502990 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    19-JUL-2014 21:40:02

    Starting concurrent program FNDOAMCOL for concurrent request 503043 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    19-JUL-2014 23:02:05

    Starting concurrent program FNDWFBES_CONTROL_QUEUE_CLEANUP for concurrent request 502979 (MODULE=FNDWFBES_CONTROL_QUEUE_CLEANUP)

    19-JUL-2014 23:04:05

    Starting concurrent program FNDOAMCOL for concurrent request 503051 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    20-JUL-2014 00:28:09

    Starting concurrent program FNDOAMCOL for concurrent request 503061 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    20-JUL-2014 01:52:12

    Starting concurrent program FNDOAMCOL for concurrent request 503069 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    20-JUL-2014 03:16:15

    Starting concurrent program FNDOAMCOL for concurrent request 503077 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    20-JUL-2014 04:40:18

    Starting concurrent program FNDOAMCOL for concurrent request 503085 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    20-JUL-2014 06:04:21

    Starting concurrent program FNDOAMCOL for concurrent request 503093 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    20-JUL-2014 07:28:25

    Starting concurrent program FNDOAMCOL for concurrent request 503101 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    20-JUL-2014 08:52:28

    Starting concurrent program FNDOAMCOL for concurrent request 503109 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    20-JUL-2014 10:16:31

    Starting concurrent program FNDOAMCOL for concurrent request 503117 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    20-JUL-2014 11:19:34

    Starting concurrent program FNDOAMCOL for concurrent request 503127 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    20-JUL-2014 12:22:38

    Starting concurrent program FNDOAMCOL for concurrent request 503137 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    20-JUL-2014 13:46:41

    Starting concurrent program FNDOAMCOL for concurrent request 503145 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    20-JUL-2014 14:29:44

    Starting concurrent program SALARY_DETIELS for concurrent request 503156 (MODULE=SALARY_DETIELS)

    20-JUL-2014 15:30:51

    Starting concurrent program FNDMLSUB for concurrent request 503167 (MODULE=FNDMLSUB)

    20-JUL-2014 15:30:51

    Starting concurrent program PAYROLL_RUN for concurrent request 503168 (MODULE=/u01/oracle/PROD/apps/apps_st/appl/pay/12.0.0/bin/PYUGEN)

    20-JUL-2014 15:30:58

    Starting concurrent program FNDMLSUB for concurrent request 503167 (MODULE=FNDMLSUB)

    20-JUL-2014 18:40:59

    Starting concurrent program FNDOAMCOL for concurrent request 503193 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    20-JUL-2014 20:05:02

    Starting concurrent program FNDOAMCOL for concurrent request 503201 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    20-JUL-2014 21:29:05

    Starting concurrent program FNDOAMCOL for concurrent request 503209 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    20-JUL-2014 22:32:08

    Starting concurrent program FNDOAMCOL for concurrent request 503215 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    20-JUL-2014 23:56:12

    Starting concurrent program FNDOAMCOL for concurrent request 503224 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    21-JUL-2014 01:20:15

    Starting concurrent program FNDOAMCOL for concurrent request 503233 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    21-JUL-2014 02:44:18

    Starting concurrent program FNDOAMCOL for concurrent request 503241 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    21-JUL-2014 04:08:21

    Starting concurrent program FNDOAMCOL for concurrent request 503249 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    21-JUL-2014 05:32:24

    Starting concurrent program FNDOAMCOL for concurrent request 503257 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    21-JUL-2014 06:56:28

    Starting concurrent program FNDOAMCOL for concurrent request 503265 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    21-JUL-2014 08:20:31

    Starting concurrent program FNDOAMCOL for concurrent request 503273 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    21-JUL-2014 09:23:34

    Starting concurrent program FNDOAMCOL for concurrent request 503279 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    21-JUL-2014 10:47:37

    Starting concurrent program FNDOAMCOL for concurrent request 503287 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    21-JUL-2014 12:11:40

    Starting concurrent program FNDOAMCOL for concurrent request 503303 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    22-JUL-2014 14:59:38

    Starting concurrent program FNDOAMCOL for concurrent request 503463 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    22-JUL-2014 16:02:42

    Starting concurrent program FNDOAMCOL for concurrent request 503469 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    22-JUL-2014 17:05:45

    Starting concurrent program FNDOAMCOL for concurrent request 503475 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    22-JUL-2014 18:29:48

    Starting concurrent program FNDOAMCOL for concurrent request 503483 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    22-JUL-2014 19:53:51

    Starting concurrent program FNDOAMCOL for concurrent request 503491 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    22-JUL-2014 21:17:54

    Starting concurrent program FNDOAMCOL for concurrent request 503499 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    22-JUL-2014 22:41:58

    Starting concurrent program FNDOAMCOL for concurrent request 503507 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    23-JUL-2014 00:00:01

    Starting concurrent program PER_FND_SESSIONS_CLEANUP for concurrent request 503373 (MODULE=PER_FND_SESSIONS_CLEANUP)

    23-JUL-2014 02:54:07

    Starting concurrent program FNDOAMCOL for concurrent request 503533 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    23-JUL-2014 03:57:11

    Starting concurrent program FNDOAMCOL for concurrent request 503539 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

    23-JUL-2014 05:21:14

    Starting concurrent program FNDOAMCOL for concurrent request 503547 (MODULE=oracle.apps.fnd.oam.concprogs.dashboard.CollectionProg)

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

    This is the internal Manager Log :

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

    Starting PROD_0717@PROD Internal Concurrent Manager -- shell process ID 22328

      logfile=/u01/oracle/PROD/inst/apps/PROD_gscprod/logs/appl/conc/log/PROD_0717.mgr  PRINTER=noprint  mailto=oracle  restart=N  diag=N  sleep=30  pmon=4  quesiz=1  Reviver is ENABLED

    Routine &ROUTINE has attempted to start the internal concurrent manager. The ICM is already running. Contact you system administrator for further assistance.afpdlrq received an unsuccessful result from PL/SQL procedure or function FND_DCP.Request_Session_Lock.

    Routine FND_DCP.REQUEST_SESSION_LOCK received a result code of 1 from the call to DBMS_LOCK.Request.

    Possible DBMS_LOCK.Request resultCall to establish_icm failed

    The Internal Concurrent Manager has encountered an error.

    Review concurrent manager log file for more detailed information. : 17-JUL-2014 12:56:33 -

    Shutting down Internal Concurrent Manager : 17-JUL-2014 12:56:33

    List of errors encountered:

    .............................................................................

    _ 1 _

    Routine AFPCSQ encountered an ORACLE error. .

    Review your error messages for the cause of the error. (=<POINTER>)

    .............................................................................

    List of errors encountered:

    .............................................................................

    _ 1 _

    Routine AFPCAL received failure code while parsing or running your

    concurrent program CPMGR

    Review your concurrent request log file for more detailed information.

    Make sure you are passing arguments in the correct format.

    .............................................................................

    The PROD_0717@PROD internal concurrent manager has terminated with status 1 - giving up.

    Shutting down Internal Concurrent Manager : 17-JUL-2014 12:56:42

    The PROD_0717@PROD internal concurrent manager has terminated successfully - exiting.

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

    Starting PROD_0717@PROD Internal Concurrent Manager -- shell process ID 23720

    +---------------------------------------------------------------------------+

    Application Object Library: Concurrent Processing version 11.5

    Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

    Internal Concurrent Manager started : 17-JUL-2014 13:05:32

    +---------------------------------------------------------------------------+

      Process monitor session started : 17-JUL-2014 13:05:32

    Starting FFTM Concurrent Manager : 17-JUL-2014 13:05:32

    Starting INVTMRPM Concurrent Manager : 17-JUL-2014 13:05:32

    Starting RCVOLTM Concurrent Manager : 17-JUL-2014 13:05:32

    Starting PODAMGR Concurrent Manager : 17-JUL-2014 13:05:32

    Starting XDP_Q_ORDER_SVC Concurrent Manager : 17-JUL-2014 13:05:32

    Starting OAMGCS_GSCPROD Concurrent Manager : 17-JUL-2014 13:05:33

    Starting XDP_SMIT_SVC Concurrent Manager : 17-JUL-2014 13:05:33

    Starting XDP_Q_TIMER_SVC Concurrent Manager : 17-JUL-2014 13:05:33

    Starting XDP_Q_IN_MSG_SVC Concurrent Manager : 17-JUL-2014 13:05:33

    Starting XDP_Q_EVENT_SVC Concurrent Manager : 17-JUL-2014 13:05:33

    Starting XDP_Q_FE_READY_SVC Concurrent Manager : 17-JUL-2014 13:05:33

    Starting XDP_Q_FA_SVC Concurrent Manager : 17-JUL-2014 13:05:33

    Starting XDP_Q_WI_SVC Concurrent Manager : 17-JUL-2014 13:05:33

      logfile=/u01/oracle/PROD/inst/apps/PROD_gscprod/logs/appl/conc/log/PROD_0717.mgr  PRINTER=noprint  mailto=oracle  restart=N  diag=N  sleep=30  pmon=4  quesiz=1  Reviver is ENABLED
  • User_1K4DF
    User_1K4DF Posts: 11 Blue Ribbon

    OPP.jpg

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center