Workflow Agent Listener Service startup problem

Scenario:
---------

When we add the Resposibility to the user and save the changes, It does not take effect, Due to the Workflow Agent Listener Service, Work Flow Mailer Service and Document Web Services Service is Not up and also If we try to restart from Concurrent --> Administer --> Workflow Agent Listener Service --> Restart, It keep on Says restarting But Not Starts.

Cause :
-------

The Path for appsborg2.zip may not be added in AF_CLASSPATH in the XML file.

Soultion:

1. Check whether the GSM is Up and Running in the system --> Profile option or using the Following Query :

select DECODE(b.profile_option_value, 'Y', 'Enabled', 'Disabled') DETAILS
from fnd_profile_options a, fnd_profile_option_values b
where a.APPLICATION_ID = b.APPLICATION_ID
and a.PROFILE_OPTION_ID = b.PROFILE_OPTION_ID
and a.PROFILE_OPTION_NAME = 'CONC_GSM_ENABLED';

2. Check whether the Service Manager is up and Running by the following Query :

select CONCURRENT_QUEUE_NAME, ENABLED_FLAG, MAX_PROCESSES, RUNNING_PROCESSES
from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME like 'FNDSM%';

3. Check the Path for AF_CLASSPATH by

echo $AF_CLASSPATH and check whether it show the appsborg2.zip

Note : It may show appsborg.zip But Not appsborg2.zip .

4. Check the $AF_CLASSPATH in the XML file. If appsborg2.zip is Not there then add that path in the xml file before the appsborg.zip

For Example :

AF_CLASSPATH=/DBA/oracle/dbacomn/util/java/1.5/jdk1.5.0_11/lib/rt.jar:/DBA/oracle/dbacomn/util/java/1.5/jdk1.5.0_11/lib/i18n.jar:/DBA/oracle/dbacomn/java/appsborg2.zip:/DBA/oracle/dbacomn/java/appsborg.zip:/DBA/oracle/dbacomn/java/apps.zip:/DBA/oracle/dbaora/8.0.6/forms60/java:/DBA/oracle/dbacomn/java

Note : Backup the XML file before Editing.

5. Now Run the Autoconfig .

6. Now If possible Bouce the appsTier and check for the Workflow Agent Listener Service. It will be started.

Refered Note id :

How to Troubleshoot when the Workflow Services Go Down
Doc ID: 564394.1