No. 19878

CONCURRENT MANAGER STARTUP 시의 일반적인 문제 및 해결 방법
=============================================

PURPOSE
-------
Concurrent Manager Startup 시에 발생할수 있는 일반적인 문제및 해결법.

Explanation
-----------
Concurrent Process 의 비정상적인 종료로 인하여, Concurrent Manager 의 Startup 이 정상적으로 되지 않는 경우의 해결방법.

Example
-------
1. Concurrent Manager Log file의 Check.
2. FNDLIBR, FNDCRM 및 실행중인 Concurrent Manager Process 가 없는지
   확인.
3. Update the fnd_concurrent_requests table
                 set phase_code = 'C', status_code = 'X'
                 where status_code = 'T';
4. Update fnd_concurrent_queues set running_processes = 0
5. Update fnd_concurrent_queues set max_processes = 0
6. Check the fnd_concurrent_proccesses table if there is a process with
        process_status_code = A,  change it to 'K'.
7. Check the system to see if any process has a lock on the table
   FND_CONCURRENT_PROCESSES
8. Start the concurrent managers using the script adcmctl.sh

Reference Documents
-------------------
1. <Note:149472.1> How to fix common Concurrent Manager Startup problems

2. <Note:134007.1> CMCLEAN.SQL - Non Destructive Script to Clean
   Concurrent Manager Tables

3. <Note:104541.1> Troubleshooting (Concurrent Manager Generic)

4. <Note:69336.1>  Basic information about Concurrent Managers 
   Step 5 & 6