Standard Manager Not Picking Up Request .Managers are working not working after specifc changes have done:
================================================================
.
Stop the CM
Run AutoConfig
Run cmclean.sql script -- Concurrent Processing - CMCLEAN.SQL - Non Destructive Script to Clean Concurrent Manager Tables [ID 134007.1]
Run ccml.sql script -- Concurrent Processing - CCM.sql Diagnostic Script to Diagnose Common Concurrent Manager Issues [ID 171855.1]
Start the CM
How to find ICM log on Oracle Apps 11i and R12?
All Concurrent Mangers log files are located in the $APPLCSF/$APPLLOG location.The following bellow options are available to get the latest log files.
Option1:
Login to Apps User and source environment file
cd $APPLCSF/$APPLLOG
ls -lrt *$TWO_TASK*
Internal Concurrent Manager Log:<SID>_MMDD.mgr
Here you can see other list of log files which are related to concurrent mangers.The name conversation for the concurrent manger log files are
Standard manager log: w<XXXXXXX>.mgr
Transaction manager log: t<XXXXXXX>.mgr
Conflict Resolution manager log: c<XXXXXXX>.mgr
Where: <XXXXXXX> is the concurrent process id of the manager
Option2:
Log-in to the Apps User
Run Source environment file
Connect to sqlplus and run this query
SELECT 'ICM_LOG_NAME=' || fcp.logfile_name
FROM fnd_concurrent_processes fcp, fnd_concurrent_queues fcq
WHERE fcp.concurrent_queue_id = fcq.concurrent_queue_id
AND fcp.queue_application_id = fcq.application_id
AND fcq.manager_type = '0'
AND fcp.process_status_code = 'A';
Sample Output:
'ICM_LOG_NAME='||FCP.LOGFILE_NAME
-------------------------------------------------------------
ICM_LOG_NAME=/d01/test/inst/apps/VIS_vis1/logs/appl/conc/log/VIS_0918.mgr
Option3:
Log in to Sysadmin Responsibility
Go to ->Concurrent -> Manager -> Administer -Processes -> Click button Internal Manager Log.
Concurrent Processing - ORA-00060: Deadlock Detected - UPDATE FND_CONCURRENT_QUEUES (Doc ID 866298.1)
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
To be continued
Other References
BUG:8724518 - ORA-60 SELF-DEADLOCK ERRORS FROM ICM WHILE UPDATING FND_CONCURRENT_QUEUES
NOTE:1304305.1 - Concurrent Processing - Product Information Center (PIC)
NOTE:179661.1 - E-Business Suite Diagnostics 11i Test Catalog
NOTE:421245.1 - E-Business Suite Diagnostics References for R12
PATCH:8724518
================================================================
.
Stop the CM
Run AutoConfig
Run cmclean.sql script -- Concurrent Processing - CMCLEAN.SQL - Non Destructive Script to Clean Concurrent Manager Tables [ID 134007.1]
Run ccml.sql script -- Concurrent Processing - CCM.sql Diagnostic Script to Diagnose Common Concurrent Manager Issues [ID 171855.1]
Start the CM
How to find ICM log on Oracle Apps 11i and R12?
All Concurrent Mangers log files are located in the $APPLCSF/$APPLLOG location.The following bellow options are available to get the latest log files.
Option1:
Login to Apps User and source environment file
cd $APPLCSF/$APPLLOG
ls -lrt *$TWO_TASK*
Internal Concurrent Manager Log:<SID>_MMDD.mgr
Here you can see other list of log files which are related to concurrent mangers.The name conversation for the concurrent manger log files are
Standard manager log: w<XXXXXXX>.mgr
Transaction manager log: t<XXXXXXX>.mgr
Conflict Resolution manager log: c<XXXXXXX>.mgr
Where: <XXXXXXX> is the concurrent process id of the manager
Option2:
Log-in to the Apps User
Run Source environment file
Connect to sqlplus and run this query
SELECT 'ICM_LOG_NAME=' || fcp.logfile_name
FROM fnd_concurrent_processes fcp, fnd_concurrent_queues fcq
WHERE fcp.concurrent_queue_id = fcq.concurrent_queue_id
AND fcp.queue_application_id = fcq.application_id
AND fcq.manager_type = '0'
AND fcp.process_status_code = 'A';
Sample Output:
'ICM_LOG_NAME='||FCP.LOGFILE_NAME
-------------------------------------------------------------
ICM_LOG_NAME=/d01/test/inst/apps/VIS_vis1/logs/appl/conc/log/VIS_0918.mgr
Option3:
Log in to Sysadmin Responsibility
Go to ->Concurrent -> Manager -> Administer -Processes -> Click button Internal Manager Log.
Concurrent Processing - ORA-00060: Deadlock Detected - UPDATE FND_CONCURRENT_QUEUES (Doc ID 866298.1)
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
To be continued
Other References
BUG:8724518 - ORA-60 SELF-DEADLOCK ERRORS FROM ICM WHILE UPDATING FND_CONCURRENT_QUEUES
NOTE:1304305.1 - Concurrent Processing - Product Information Center (PIC)
NOTE:179661.1 - E-Business Suite Diagnostics 11i Test Catalog
NOTE:421245.1 - E-Business Suite Diagnostics References for R12
PATCH:8724518
No comments:
Post a Comment