Archive for the ‘Concurrent Manager’ Category

Managers down – Status show “Target node/queue unavailable   5 comments

Concurrent Managers Status shows  ”Target node/queue unavailable”  in Concurrent–>Manager–>Administer Screen form.

target

 

Solution:

Ensure Database is Running and Middle Tier Services are down.

Connect SQLPLUS as APPS user and run the following :

EXEC FND_CONC_CLONE.SETUP_CLEAN;

COMMIT;

EXIT;

  • Run AutoConfig on all tiers, firstly on the DB tier and then the APPS tiers and webtier to repopulate the required systemtables
  • Run the CMCLEAN.SQL script from the referenced note below (don’t forget to commit).
  • Note.134007.1 – ‘CMCLEAN.SQL – Non Destructive Script to Clean Concurrent  Manager Tables‘
  • Start the middle tier services including your concurrent manager.
  • Retest the issue.
Advertisements

Managers down – Status “System Hold, Fix Manager”   Leave a comment

Concurrent Managers Status shows  “System Hold, Fix Manager”  in Concurrent–>Manager–>Administer Screen form.

sys

 

Solution:

• Ensure Concurrent :GSM Enabled profile is set to ‘Y’

• Run $FND_TOP/patch/115/sql/afdcm037.sql

• Go to $FND_TOP/bin

adrelink.sh force=y “fnd FNDLIBR”

adrelink.sh force=y “fnd FNDSM”

adrelink.sh force=y “fnd FNDFS”

adrelink.sh force=y “fnd FNDCRM”

• Run cmclean.sql

• Start Application Service (adstrtal.sh)

R12 Opp(output Post Processor) and Workflow Mailer is down   Leave a comment

When i see the Status OPP Manger and Workflow Mailer from Concurrent–>Manager–>Administer Screen. I see below status

oppwf

Solution :

• Ensure Concurrent:GSM Enabled profile is set to ‘Y’

• Verify Service Manager status in Administer Form.

• Verify Service Manager Definition.

• Ensure FNDSM Entries available in FND_CONCURRENT_QUEUES Table

• FNDSM entry should be correct in Tnsnames.ora file and tnsping  FNDSM_hostname should work fine.

• Then Bounce the Services.

Ensure Concurrent:GSM Enabled profile is set to ‘Y’

stat

all

all2

ORA-06512: at “APPS.FND_CP_FNDSM”, line 29 Concurrent Manger not starting   Leave a comment

When i checked concurrent manager log under $APPLCSF/log/<SID>.mgr

I see below error:

Cause: cleanup_node failed due to ORA-01427: single-row subquery returns more than one row

ORA-06512: at “APPS.FND_CP_FNDSM”, line 29
ORA-06512: at line 1.

The SQL statement being executed at the time of Routine AFPEIM encountered an error while starting concurrent manager STANDARD with library /dev/applmgr/R12/apps/apps_st/appl/fnd/12.0.0/bin/FNDLIBR.

Check that your system has enough resources to start a concurrent manager process. Contact your syst : 08-OCT-2013 00:30:51

Starting IEU_WL_CS Concurrent Manager : 08-OCT-2013 00:30:51

Could not initialize the Service Manager FNDSM_apps01_dev. Verify that apps01 has been registered for concurrent processing.
ORACLE error 1427 in cleanup_node

Cause: cleanup_node failed due to ORA-01427: single-row subquery returns more than one row
ORA-06512: at “APPS.FND_CP_FNDSM”, line 29
ORA-06512: at line 1.

The SQL statement being executed at the time of
Routine AFPEIM encountered an error while starting concurrent manager IEU_WL_CS with library /dev/applmgr/R12/apps/apps_st/appl/fnd/12.0.0/bin/FNDLIBR.

Solution

———-

sqlplus apps/apps

sql>exec fnd_conc_clone.setup_clean;

commit;

sql>@cmclean.sql

Started the concurrent manager on the application tier and it worked

 

 

Concurrent Processing – R12 Output Post Processor Service Not Coming Up   3 comments

Reason :

If Service Manager for the node is not running.  Possible cause might be service manager definition is missing under

Concurrent ->Manager ->Define form. If the Service Manager is not present/defined for a particular node,then this causes all the services provided by Service Manager like OPP,WF etc.. not to work.

1. Shutdown all the services.

——Below Step 2 will create  Service Manager “FNDSM”——-

2. Log in as applmgr
cd to $FND_TOP/patch/115/sql
Run the script: afdcm037.sql

3. Relink FNDSM and FNDLIBR executables as mentioned below:

$ adrelink.sh force=y link_debug=y “fnd FNDLIBR”
$ adrelink.sh force=y link_debug=y “fnd FNDSM”

4. Run cmclean.sql

5. Start up the managers/services

Output Post Processor is Down with Actual Process is 0 And Target Process is 1   Leave a comment

If you see OPP is Down with Actual Process is 0 And Target Process is 1 then do the following
1. Shutdown concurrent server via command adcmctl.sh under $COMMON_TOP/admin/scripts/<context_name>

2. To ensure concurrent manager down; check there is no FNDLIBR process running.
ps -ef | grep applmgr | grep FNDLIBR

3. Run adadmin to relink FNDSVC executable.

a. Invoke adadmin from command prompt
b. Choose option 2 (2. Maintain Applications Files menu)
c. Choose option 1 (1. Relink Applications programs )
d. Then type “FND” When prompted; ( Enter list of products to link (‘all’ for all products) [all] : FND )
e. Ensure adrelink is exiting with status 0
4. Start Concurrent Managers using adcmctl.sh

Posted October 5, 2013 by balaoracledba.com in Concurrent Manager, Issues