KEMBAR78
Concurrent Manager Troubleshooting | PDF | Library (Computing) | Sql
Scribd
Upload
55 views2 pages

Concurrent Manager Troubleshooting

This document provides a checklist for diagnosing and troubleshooting issues with concurrent managers in Oracle Applications. It lists important log files to check, steps to validate that the concurrent manager and listeners are running correctly, and SQL scripts to use to diagnose specific issues like locks, pending requests, and manager processes. It also provides links to Metalink notes with tests and scripts to help setup and test the concurrent processing environment.

Uploaded by

niaam
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
55 views2 pages

Concurrent Manager Troubleshooting

This document provides a checklist for diagnosing and troubleshooting issues with concurrent managers in Oracle Applications. It lists important log files to check, steps to validate that the concurrent manager and listeners are running correctly, and SQL scripts to use to diagnose specific issues like locks, pending requests, and manager processes. It also provides links to Metalink notes with tests and scripts to help setup and test the concurrent processing environment.

Uploaded by

niaam
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 2

Concurrent Manager Checklist

Important Files:

$APPLCSF/$APPLLOG/ <SID>_MM_DD.mgr, l<reqid>.req, adcmctl.txt

$FND_TOP/bin/startmgr, batchmgr

 Submit a Standard Concurrent Report and check if it completes successfully.

 Check if you are able to view the log/output file if not check if your APPS
listener is running.
 If your concurrent report fails check the log report or request log file.
 Check if your standard manager is running from the front end.
 Check if the internal concurrent manager is up and running.
 Check the UNIX background process of your concurrent manager
ps -ef|grep FNDLIBR.
 Check your Concurrent Manager Log files like SID_MM_DD.mgr at
$APPLCSF/$APPLLOG.
 If the managers are failing due a problematic request try running cmclean.sql or
use the recover concurrent manager option from Oracle Applications Manager.
 In case your concurrent managers are not able to start due to failing to acquire
locks, try clearing up the locks from the database.
 If you are still having trouble with your concurrent managers you can try re
creating the concurrent manager views using
FNDLIBR  FND  FNDCPBWV  apps/<passwd>  SYSADMIN  'System
Administrator'  SYSADMIN
 DIAG_PARAM Diagnosis parameter it will take value Y or N with default N,
If you encounter some error while starting Concurrent Manager you change
this to Y and then extra logging will be enabled then check Concurrent
Manager log file.

 CONCSUB stands for CONC(Concurrent) SUB(Submit) , used to submit


concurrent request like shut down concurrent manager

Diagnosing concurrent manager problems:

$FND_TOP/sql
 afimchk.sql - Tells the status of the ICM and PMON method

 afcmstat.sql - Lists active manager processes

 afrqrun.sql - Lists all the running, waiting and terminating requests


 afrqwait.sql - Lists requests that are constrained and waiting for the ICM to
release them.

 afrqscm.sql - Prints log file name of managers that can run a given request. It
can be used to check for possible errors when a request stays in pending status. It requires
a request id value.

 afcmcreq.sql - Prints the log file name of the manager that processed the
request

 afrqstat.sql - Summary of completed concurrent requests grouped by


completion status and execution type. It requires number of days prior to today on which
to report parameter.

 afimlock.sql - Lists locks that the ICM is waiting to get

 afcmrrq.sql - Lists managers that currently are running a request

Important Metalink Docs:

 Note: 244274.1 - Oracle Application Object Library Generic Service Management


(GSM) Setup Test

 Note: 200360.1 - Oracle Application Object Library Concurrent Manager Setup Test

 Note: 398624.1 - Oracle Application Object Library Concurrent Manager Test Set

 Note: 370317.1 - Oracle Application Object Library Concurrent Processing Data


Collection Test

 Note: 134007.1 - CMCLEAN.SQL - Non Destructive Script to Clean Concurrent


Manager Tables

You might also like