FAP service manager give error that the FAP service is not started

Product:

Cognos Controller 8.5.1

Windows 2008 R2

Symptom:

FAP service is started but the FAP service manager give error that the FAP service is not started.

You have rebooted the server, but it has not helped.

There are no error log files in the C:\Program Files (x86)\Cognos\c8\Server\FAP folder.

Error Message:

It seems that no FAPService is running or FABdb is started/restarted after FAPService.

Start/restart FAPService to make FAP work correctly.

Cause:

Can be that the CCR_JAVA_HOME is pointing to a 64 bit jre instead of a 32 bit jre.

Ensure that the CCR_JAVA_HOME is pointing to a JRE folder.

You get a FAPFatalError.log like below when the FAP service is setup to point to a different database than the one you enter when you login in to the FAP Connect

Thu Oct 27 10:12:34 CEST 2011 - Fatal error when starting or running FAPService. Connection exceptionCould not connect to: jdbc:JSQLConnect://sslwin/database=controllerfap

Possible Solution:

Unpack jre.zip from the Controller folder C:\Program Files (x86)\cognos\c8\webcontent\ccr

to a folder on the FAP server named C:\Program Files (x86)\Cognos\java60\jre

Go to System and click on Advance system settings

Select Advance tab

Click on Environment Variables

Click on New system variables

Enter name: CCR_JAVA_HOME

Enter value: C:\Program Files (x86)\Cognos\java60\jre

Click OK

Click OK

Restart the FAP service.

The other issue is solve as below:

Open the FAPService.properties file in notepad and ensure that there is right database server name and database enter into the file. Save the file after changes and restarte the FAP service.

Below an example.

IBM SOURCE CODE HEADER START

# =====================================================================

# OCO Source Materials

#

# BI and PM: ccr

#

# (C) Copyright IBM Corp. 2004, 2009. All Rights Reserved

#

# The source code for this program is not published or

# otherwise divested of its trade secrets, irrespective of

# what has been deposited with the U.S. Copyright Office.

# =====================================================================

# IBM SOURCE CODE HEADER END

db=controllerfap

host=servername

dbType=sqlserver

user=cognos

passwd=cognos

#clientcamuri=http://<camservername>/cognos8/cgi-bin/cognos.cgi

www.cogknowhow.com