Product:
Cognos Controller 10.1 FAP

Problem:
I do not see the trickle of data in the FAP log dialog.

Solution:
Correct log level, not set at startup of FAP process.
When you setup the Controller FAP process, you must active HIGH logging level to allow the trickling steps to be written to log table.

1.Go into Cognos Controller FAP Manager.
2.Edit the source (the controller database) you are using
3.Set the Log Level to 'High'
4. Click Save.

Edit the data mart  (the tm1 connection) you are using.
Set the Log Level to High.
Click Save.

You need to stop the Data marts and you need to stop the Source
Then you need to start the Source and start the Data mart again to active your change in logging. (this will make a intial publish - who may take long time)
Then you will see a line like;
-Start trickling data
-Finished trickling data.

Then you should be able to see when the trickling is done.

www.cogknowhow.com

Product:
Cognos Controller 10.1
Adobe Reader 10

Symptom:
When Cognos Controller user run a standard report, and it show fine in HTML.
Then user change to view it in Adobe Reader PDF format, then they only get a progress bar and the PDF does not show.

Problem:
PDF report does not show - user see a progress bar instead.

Cause:
Adobe Reader 10 is not supported by Cognos Controller 10.1
More information here
http://www-01.ibm.com/support/docview.wss?uid=swg27020782#eft


Solution:
Start Adobe Reader X on the client computer and under menu
edit - preferences
select general dialog
uncheck "Enable Protected Mode at startup"
click OK
Then start Cognos Controller Client, and test a standard report again.

This change is saved per user on the client, so the best is if the IT department can roll out this change of Adobe Reader with a GPO.

www.cogknowhow.com

Product:
Cognos Controller 8.5.1532 FAP
Windows 2008
Cognos TM1 9.5.2

Symptom:
During IP for Controller FAP you get a error message that the FAP service can not login to the TM1 application. When you change client id and restart the FAP service, you get not error message, the FAP service is only hanging.
If you reboot the physical server, the FAP service will try to login once, and then fail.
There are no "fatalerror.log" in the FAP service folder on the server.

Background:
You have changed to use CAM ID and SSO to access Cognos Controller.
The servers and the users are in different Windows domains with trust between.

Error message:
Severity: CRITICAL
Description: Could not login to TM1, host: SERVERNAME, server name: TM1 SERVER NAME, user name: admin

If you hold the mouse over the error message in FAP manager, you see the text:
SystemServerNotFound

Cause:
The windows account that run the IBM Cognos Controller FAP server must be a domain account in the same domain that the Cognos BI server authenticate against. You must be able to surf to http://servername/cognos8 from the server logged in as the service account, and SSO should work.

Solution:
Create a new windows service account in the domain that contains the users
Make that new windows service account local admin on the FAP server
Change the windows account that start the FAP service, to use the new service account.

You may need to enter the account with domain\name in the field for name to the FAP service to make it possible for the FAP service to use the account.

Start FAP service again and test if the FAP publish works now.

In FAP Manager for the connection edit, ensure you enter the client name and domain in same capital letters as used for the namespace id in cognos configuration.  If the namespace ID is AD then you need to enter AD\username in the FAP manager for the TM1 connection.

www.cogknowhow.com

Product:
Cognos Controller 10.1
Windows 2008 server

Symptom:
After change of the database in Cognos Controller solution, the users are not able to run standard reports. They get a error message when the HTML page should show.

Error message:
AAA-AUT-0011 Invalid namespace was selected

Possible Solution:
Restart the Cognos Controller server including the Cognos BI services.
Note: that if you change the name of the database you need to update the Controller Configuration database connections of that change.
Also you must press the REPAIR button in controller configuration at the Report Server tab.

www.CogKnowHow.com

Product:
IBM Cognos Controller 10.1
Windows 2008 server/Citrix Server for Controller Client
Microsoft Excel 2007

Symptom:
When user inside Cognos Controller click on Reports - Run, Microsoft Excel pop's up and placed Excel spreadsheet in front of Cognos Controller.
This is irritating in a Citrix session, because it is difficult to switch back to Controller window.

Solution:
On the Citrix Server (Windows 2008 server) for the Cognos Controller client, you need to look into registry value below and change values for Excel to change this behavior.

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Terminal Server\Install\Software\Microsoft\Office\12.0\Excel

If possible copy the registry values from a working Citrix server to your server

www.cogknowhow.com

Product:
Cognos Controller 10.1
Windows 2008 R2

Symptom:
Get error when select maintain - manage active users from inside Cognos Controller client.
After we have changed the controller database.

Error message:
System.Web.service.Protocols.SoapException: Server was unable to process request. -->
System.Runtime.InteropService.COMException (0x80070070):
Method '~' of object '~' failed
at FrUserValidator.ValidatorClass.IsMenuItemAllowed(String sMenuIDs, String sMode, String sWebServiceAction)
at....

Possible Solution (workaround):

Restart the physical server.

Restart of the Cognos Controller services in Windows 2008 Server did not help.
This error is from the Component Services COM+ Applications.

www.cogknowhow.com

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

Product:
Cognos Controller 8.5.1
Windows 2008 R2 Server

Symptom:
Change to Cognos 8 authentication in Cognos 8 Controller configuration, from Native authentication does not change it for the users.

Problem:
Controller users still get login dialog to enter username and password

Solution:
On the Windows 2008 server you must start Controller Configuration program by right click and select RUN AS ADMINISTRATOR to allow the changes to be saved.

You do not get a error, but the switch to Cognos 8 is not registered by Windows 8.

Start Controller Configuration program with Run as Administrator, and change selected authentications method to Cognos 8
Click save.

Let the user try again.

www.cogknowhow.com

Product:
Cognos Controller 8.5.1
Windows 2008 Server R2

Symptom:
When you run F9 in excel report you get an error message during the "Calling RunReport" process.  You have activated Enhanced report optimization by doing this in the excel sheet:
1.  Select cell A1 on the first sheet of the workbook.
2.  Go to the menu Insert / Name / Define
3.  Type in the name Optimise2 and click Add and then OK
4.  Save the report
When you next run or refresh the report, ERO is used.

Error message:
Standard Error
Number: 5
Source
FrangoDirect. ExcelLinkD. FetchValuesBulk # ControllerProxyClient
Description: The underlying connection was closed. An unexpected error occurred on a receive.

Cause:
You have create the share \\servername\ero$ on the application server and given everyone full rights on the share.

You have enter the correct values in controller configuration for ERO, as this:
File mode: File Copy
Server: applicationservername
Share: ero$
(and left the rest of the fields blank)

But you have not given the SQL service account access rights to the NTFS.

Solution:
1. Right click on the ERO folder
2. Select Properties
3. Select Security tab
4. Click EDIT to change permissions
5. Click ADD
6. Enter the name of the service account (e.g. domain\username) and click CHECK NAMES
7. Click OK
8. Mark Allow - Modify check box
9. Click APPLY
10. Click OK

www.cogknowhow.com

Product:
Cognos Controller 10.1
Microsoft Windows 2008 R2

Symptom:
When you click on Report Server inside Cognos 8 Controller Configuration you get a Security alert message. Before you had installed SSL certificate and changed the Cognos Configuration to use HTTPS for Cognos Gateway and changed the Controller Configuration for Report Server and Client Distribution Server Configuration.

Error Message:
Revocation information for the security certificate for this site is not available. Do you want to proceed?
Yes - No - View

Cause:
Controller Configuration program ( e.g. IE ) can not access the certificate authority to valid the certificate. Can be because it is a private created certificate from a private CA.

Solution:
On the server ( and on clients ) go into Internet Explorer
Select Tools menu
Select Internet Options
Select Advance tab
remove check mark for "Check for server certificate revocation"
click ok
close internet explorer

Start Cognos Controller Configuration program again, and the message is gone.

www.cogknowhow.com