Concurrent Troubleshooting:
=======================
R12 Opp(output Post Processor) and Workflow Mailer is down:
===============================================
When i see the Status OPP Manger and Workflow Mailer from Concurrent–>Manager–>Administer Screen. I see below status
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’
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’
ORA-06512: at “APPS.FND_CP_FNDSM”, line 29 Concurrent Manger not starting:
===============================================
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
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:
------------------------------------------------------------------------------
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
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
No comments:
Post a Comment