Search Blog Post

Wednesday, December 18, 2013

Could not find service instance context for service instance number

Problem:-
I was working on Oracle application 11i cloning  lately and after completing the clone, my conc. manager output post manager (OPP) is not coming up in target system.

I  tried to fix the issue by running "cmclean.sql" and thn ran autoconfig on application node, but still the issue persists

The logfile for FNDOPP(outout post manager) says:-
[12/17/13 5:24:30 PM] [main] Starting GSF service with concurrent process id = 154919.
[12/17/13 5:24:30 PM] [main] Initialization Parameters: oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=5
[12/17/13 5:24:31 PM] [Thread-23] Service thread starting up.
[12/17/13 5:24:31 PM] [Thread-24] Service thread starting up.
[12/17/13 6:52:55 PM] [GSMServiceController:154919] Received shutdown request.
[12/17/13 6:52:55 PM] [GSMServiceController:154919] Preparing to shutdown service.
[12/17/13 6:52:55 PM] [GSMServiceController:154919] Stopping all Service Threads.
[12/17/13 6:52:55 PM] [OPPServiceThread1] Preparing to shut down service thread.
[12/17/13 6:52:55 PM] [OPPServiceThread0] Preparing to shut down service thread.
[12/17/13 6:53:55 PM] [OPPServiceThread0] Service thread has shutdown.
[12/17/13 6:54:00 PM] [OPPServiceThread1] Service thread has shutdown.
[12/17/13 6:54:00 PM] [GSMServiceController:154919] All Service Threads have completed.
[12/17/13 6:54:00 PM] [GSMServiceController:154919] Service has shut down.

FYI, The below metalink note did not help
Concurrent Processing - R12 Output Post Processor Service Not Coming Up. (Doc ID 460578.1)

Cause:-
In ICM log file, I see occurrence of these error messages in bulk.It looks Mangers are wrongly defined or fnd_nodes having some incorrect values.

               Process monitor session started : 17-DEC-2013 21:29:02
Could not find service instance context for service instance number 1072
Could not find service instance context for service instance number 1092
Could not find service instance context for service instance number 1089
Could not find service instance context for service instance number 1090
Could not find service instance context for service instance number 1091
Could not find service instance context for service instance number 1043


 It looks Mangers are wrongly defined or fnd_nodes having some incorrect values.

Solution:
- Shtudown Application Services
- Run cmclean.sql script
- Run following query as apps user:
     EXEC FND_CONC_CLONE.SETUP_CLEAN;
     COMMIT;
     EXIT
- Run autoconfig for Apps Tier
- Start Application Services


Do the below, and check the output of below queries:

select CONCURRENT_QUEUE_NAME, TARGET_NODE
from fnd_concurrent_queues;

select decode(CONCURRENT_QUEUE_NAME,'FNDICM','Internal Manager','FNDCRM','Conflict Resolution Manager','AMSDMIN','Marketing Data Mining Manager','C_AQCT_SVC','C AQCART Service','FFTM','FastFormula Transaction Manager','FNDCPOPP','Output Post Processor','FNDSCH','Scheduler/Prereleaser Manager','FNDSM_AQHERP','Service Manager: AQHERP','FTE_TXN_MANAGER','Transportation Manager','IEU_SH_CS','Session History Cleanup','IEU_WL_CS','UWQ Worklist Items Release for Crashed session','INVMGR','Inventory Manager','INVTMRPM','INV Remote Procedure Manager','OAMCOLMGR','OAM Metrics Collection Manager','PASMGR','PA Streamline Manager','PODAMGR','PO Document Approval Manager','RCVOLTM','Receiving Transaction Manager','STANDARD','Standard Manager','WFALSNRSVC','Workflow Agent Listener Service','WFMLRSVC','Workflow Mailer Service','WFWSSVC','Workflow Document Web Services Service','WMSTAMGR','WMS Task Archiving Manager','XDP_APPL_SVC','SFM Application Monitoring Service','XDP_CTRL_SVC','SFM Controller Service','XDP_Q_EVENT_SVC','SFM Event Manager Queue Service','XDP_Q_FA_SVC','SFM Fulfillment Actions Queue Service','XDP_Q_FE_READY_SVC','SFM Fulfillment Element Ready Queue Service','XDP_Q_IN_MSG_SVC','SFM Inbound Messages Queue Service','XDP_Q_ORDER_SVC','SFM Order Queue Service','XDP_Q_TIMER_SVC','SFM Timer Queue Service','XDP_Q_WI_SVC','SFM Work Item Queue Service','XDP_SMIT_SVC','SFM SM Interface Test Service') as "Concurrent Manager's Name", max_processes as "TARGET Processes", running_processes as "ACTUAL Processes"
from apps.fnd_concurrent_queues
where CONCURRENT_QUEUE_NAME in ('FNDICM','FNDCRM','AMSDMIN','C_AQCT_SVC','FFTM','FNDCPOPP','FNDSCH','FNDSM_AQHERP','FTE_TXN_MANAGER','IEU_SH_CS','IEU_WL_CS','INVMGR','INVTMRPM','OAMCOLMGR','PASMGR','PODAMGR','RCVOLTM','STANDARD','WFALSNRSVC','WFMLRSVC','WFWSSVC','WMSTAMGR','XDP_APPL_SVC','XDP_CTRL_SVC','XDP_Q_EVENT_SVC','XDP_Q_FA_SVC','XDP_Q_FE_READY_SVC','XDP_Q_IN_MSG_SVC','XDP_Q_ORDER_SVC','XDP_Q_TIMER_SVC','XDP_Q_WI_SVC','XDP_SMIT_SVC');


Reference Docs:-
305986.1
368380.1 


1 comment: