Troubleshooting Concurrent Managers

Nice Post on CM 🙂

Hi Amit,

one concurrent program running for 3 hrs in clone node. but it is completing in 5 mi in production node..

please try to explain the steps to find out the problem..

i am new to oracle apps please try to explain in detail

thanks,
praveen

actually i tried to run
SQL>SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
v$process c,
v$session d
WHERE a.controlling_manager = b.concurrent_process_id
AND c.pid = b.oracle_process_id
AND b.session_id=d.audsid
AND a.request_id = &Request_ID
AND a.phase_code = ‘R’;

in my case concurrent request_id = 6250791.
while entering this it giving error :request id not identified like that……..
please try to tell me the solution for this

@ nallavol,
Replace &Request_ID with 6250791

@ praveen,

For slow running request check my post at

http://onlineappsdba.com/index.php/2008/11/20/troubleshoot-long-running-concurrent-request-in-apps-11ir12/

Atul

hi,
After cloning (single to single) i got an issue icm status is active 1 and target is 0. By checkin g icm log file it shows as like log on denied.

@ Anil,
Post full error message, is this 11i or R12 ?

Did you run post clone on both apps tier and db tier ?

hi,
its 11i,after cloning process DB is up and running and on applications side listener and tns is also good but my icm status is active:1 and target:0 by checking icm log file it shows as previously i told to you.
And on dbside i run exec fnd_conc_clone.setup_clean also

I problem with the concurrent manager after cloning. i run exec fnd_conc_clone.setup_clean
and it still not starting
the starting script does not give any error
but in applicaiton when I activate it, its status remain activating and does not start.
when I check manager log from concurrent processes form It give the following error:

An error occurred while attempting to establish an applicaiton file server connection with the node APPS. there may be a network configuration problem , or the TNS listener on the nodes APPS may not be runing …

please note the APPS is the name of the source machine before the cloning.

@ Akram,
After running setup_clean did you run autoconfig to register nodes (check FND_NODES table in apps schema)?

Your issue seems because apps listener is down. Ensure that all services (including apps listener) on middle tier is running .

the fnd_nodes tabel has two rows
AUTHENTICATION
LEASE1 (the current host name)

I am getting an eror when I run adautocfg.cmd

[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts: Directory: F:\oracleqatar\qtarcomn\admin\install\QTAR_lease1
afcpctx.cmd INSTE8_PRF 3

@ Akram, search for afcpctx in metalink (My Oracle Support) and you will see 6-7 hits.

Hi Atul,

I have one Oracle EBS 11i system,

Setup is like this

DB Tier node (Single instance 32 bit Oracle)
Web+Concurrent mgr node on separate Virtual machine.

Often one of the MRP concurrent manager gets memory error as following. Is it linked with memory usage on DB Tier or on the Concurrent manager node? How to troubleshoot them?

Errors reported on log file:

APP-MRP-22086: mrlgpd_gen_pl_ord_dem: Cannot allocate memory for op_seq_num_list

Cause: The current routine cannot allocate memory for the specified entity.

Action: Contact your customer support representative.

Total memory usage: 1390708

***** End Of Program – Memory-Based Planner *****

Regards

Dilip.