![\"b\"](\"http:\/\/www.llku.com\/wp-content\/uploads\/2015\/01\/b-300x182.jpg\")
<\/a>\n<\/p>\n\n\t \n\t \n<\/p>\n \n\tusers reports back that reports are not running with no manager error (see below), and when you check manager status, all managers have Description- Target Node\/Queue Unavailable\n<\/p>\n \n\t \n\tSolution One:<\/strong><\/em> \n\t2. Run AutoConfig on all tiers, firstly on the DB tier and then the APPS tiers, to repopulate the required system tables. \n\tApps Tier: \n\t \n<\/p>\n \n\tSolution Two:<\/strong><\/em> \n\tSolution Three (if All else fails, check all the details below:)<\/strong><\/em>\n<\/p>\n \n\tSQL> select node_name,target_node,control_code from fnd_concurrent_queues;\n<\/p>\n \n\tSQL> update apps.fnd_concurrent_queues set node_name = ‘Node NAME’ where node_name=’Existing Node Name’;\n<\/p>\n \n\tSQL> select NODE_NAME,NODE_MODE,STATUS from fnd_nodes;\n<\/p>\n \n\tSQL> select control_code,target_node,node_name,CONCURRENT_QUEUE_NAME from fnd_concurrent_queues;\n<\/p>\n \n\tSQL> UPDATE fnd_concurrent_queues set control_code = null;\n<\/p>\n \n\tSQL> select TARGET_NODE,NODE_NAME from fnd_concurrent_queues where node_name='<Existing Node Name>’;\n<\/p>\n \n\tSQL> select TARGET_NODE,NODE_NAME from fnd_concurrent_queues where TARGET_NODE='<Existing Node Name>’;\n<\/p>\n \n\tSQL> update fnd_concurrent_queues set NODE_NAME='<Node Name>’ where NODE_NAME='<Source\/Existing Node Name>’;\n<\/p>\n \n\tSQL> update fnd_concurrent_queues set TARGET_NODE='<Node Name>’ where TARGET_NODE='<Source\/Exixting Node Name>’;\n<\/p>\n \n\tSQL> UPDATE fnd_concurrent_queues set target_node = ‘<Node Name>’;\n<\/p>\n \n\tSQL> UPDATE fnd_concurrent_queues set node_name = ‘<Node Name>’;\n<\/p>\n \n\tSQL> Commit;\n<\/p>\n \n\tSQL> select control_code,target_node,node_name,CONCURRENT_QUEUE_NAME from fnd_concurrent_queues;\n<\/p>\n \n\tSQL>select TARGET_NODE,NODE_NAME from fnd_concurrent_queues where node_name='<Node Name>’;\n<\/p>\n \n\tSQL>select TARGET_NODE,NODE_NAME from fnd_concurrent_queues where TARGET_NODE='<Node Name>’;\n<\/p>\n \n\tSolution four:<\/strong><\/em><\/em>\n<\/p>\n \n\tSQL> set linesize 1000;\n<\/p>\n \n\tSQL> column CONTROL_CODE format A15\n<\/p>\n \n\tSQL> select CONCURRENT_QUEUE_NAME, CONTROL_CODE , TARGET_NODE, NODE_NAME from FND_CONCURRENT_QUEUES where concurrent_queue_name like ‘OAMGCS_%’;\n<\/p>\n \n\tSample Output:\n<\/p>\n \n\tCONCURRENT_QUEUE_NAME CONTROL_CODE TARGET_NODE NODE_NAME\n<\/p>\n \n\t—————————— ————— —————————– ——————————\n<\/p>\n \n\tOAMGCS_SUPTEBSAL1 E SUPTEBSAL1\n<\/p>\n \n\tTo implement the solution, please execute the following steps:\n<\/p>\n \n\t1. Please set control_code to null for the OAMGCS concurrent queue on the specific node that is affected by this issue.\n<\/p>\n \n\tSQL> update FND_CONCURRENT_QUEUES\n<\/p>\n \n\t set control_code = null\n<\/p>\n \n\t where concurrent_queue_name = ‘OAMGCS_<hostname>’; <Ur Existing Node Name>\n<\/p>\n \n\t2. Make sure the Target_node is correct for the OAMGCS manager:\n<\/p>\n \n\tSQL> update FND_CONCURRENT_QUEUES\n<\/p>\n \n\t set TARGET_NODE='<correct node >’\n<\/p>\n \n\t where CONCURRENT_QUEUE_NAME=’OAMGCS_<hostname>’;\n<\/p>\n \n\tSQL> commit;\n<\/p>\n \n\tReferences:<\/b> \n\tSummary of Possible Reasons and Solutions for the Problem Where All Concurrent Requests Stuck in Pending Phase [ID 182154.1]\n<\/p>\n \n\tOutput Post Processor is Down with Actual Process is 0 And Target Process is 1 [ID 858813.1] \n\tCommon Error: Concurrent Manager shows “Target Node\/Queue Unavailable “<\/a><\/p>\n","protected":false},"excerpt":{"rendered":" \u5728\u9879\u76ee\u4e0a\u9047\u5230\u8fd9\u6837\u4e00\u4e2a\u60c5\u51b5\uff0c\u4ece\u4e00\u4e2a\u6709\u53cc\u8282\u70b9\u7684EBS\u73af\u5883\u4e2d\u514b\u9686\u7684\u4e00\u5957\u7cfb\u7edf\u6d4b\u8bd5\u7cfb\u7edf\u7684\u65f6\u5019 … \u7ee7\u7eed\u9605\u8bfbEBS\u5185\u90e8\u7ba1\u7406\u5668\u8282\u70b9\u95ee\u9898\uff08\u514b\u9686\u540e\uff09<\/span> ![\"a\"](\"http:\/\/www.llku.com\/wp-content\/uploads\/2015\/01\/a-300x199.jpg\")
<\/a>\n<\/p>\n![\"\"](\"http:\/\/www.llku.com\/wp-content\/uploads\/2015\/01\/clone_err-300x177.png\")
<\/a>\n<\/p>\n
\n\t
\n\t1. . Run the following in SQL*Plus:
\n\t
\n\tSQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
\n\t
\n\tCOMMIT;
\n\t
\n\tEXIT;\n<\/p>\n
\n\t
\n\tDb Tier:
\n\t
\n\tcd $ORACLE_HOME\/appsutil\/scripts\/<inst>\/adautocfg.sh\n<\/p>\n
\n\t
\n\tcd $ADMIN_SCRIPTS_HOME\/adautocfg.sh\n<\/p>\n
\n\t
\n\t1. Run cmclean.sql with Apps tier down
\n\t
\n\t2. restart all services and check\n<\/p>\n
\n\t
\n\tConflict Resolution Manager Shows Target Node\/Queue Unavailable [ID 732709.1]
\n\t
\n\tOAM Generic Collection Service shows State: “The target node\/queue unavailable”. [ID 393706.1]
\n\t
\n\tAfter Cloning all the Concurrent Managers do not start for the cloned Instance [ID 555081.1]
\n\t
\n\tConflict Resolution Manager Shows Target Node\/Queue Unavailable [ID 732709.1]
\n\t
\n\tConcurrent Managers Do Not Start After Cloning Nodes Not Updated In Conc_queues [ID 466532.1]\n<\/p>\n
\n\t
\n\tUsing Load-Balancers with Oracle E-Business Suite Release 12 [ID 380489.1]
\n\t
\n\tDocumentation For Specific Load Balancer Hardware [ID 727171.1]
\n\t
\n\tSharing The Application Tier File System in Oracle E-Business Suite Release 12 [ID 384248.1]
\n\t
\n\tAdd new node to application —- 384248.1\n<\/p>\n