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

by ·0 Comments

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 restart 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:///cognos8/cgi-bin/cognos.cgi