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
(ogiltigt namnutrymme har valts)

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.

Product:

Cognos Controller 10.1.4801.127

Windows 2008 R2 Server

Symptom:

Error when you surf to cognos controller (cognos connection) website after you have applied Cognos Controller fix pack.

Error message:

HTTP Error 404.0 – Not Found

The resource you are looking for has been removed, had its name changed, or is temporarily unavailable. Detailed Error InformationModule IIS Web Core

Notification MapRequestHandler

Handler StaticFile

Error Code 0x80070002

Requested URL http://servername:80/cgi-bin/cognosisapi.dll?b_action=xts.run&m=portal/main.xts&startwel=yes

Physical Path C:\inetpub\wwwroot\cgi-bin\cognosisapi.dll

Logon Method Anonymous

Logon User Anonymous

Cause:

The content of the file default.htm and index.html in folder D:\Program Files (x86)\ibm\cognos\c10\webcontent are wrong.

Solution:

Open file default.html in notepad

Find section that contains:

function genMainContent()

{

document.body.innerHTML = ‘<div align=”center”><img src=”‘ + splashImg.src + ‘” style=”position:relative; top:80px”></div>’;

window.setTimeout(“window.location.replace(‘../cgi-bin/cognosisapi.dll?b_action=xts.run&m=portal/main.xts&startwel=yes’)”,5);

}

</script>

Remove the ../ part in front of cgi-bin so the section looks like this:

function genMainContent()

{

document.body.innerHTML = ‘<div align=”center”><img src=”‘ + splashImg.src + ‘” style=”position:relative; top:80px”></div>’;

window.setTimeout(“window.location.replace(‘cgi-bin/cognosisapi.dll?b_action=xts.run&m=portal/main.xts&startwel=yes’)”,5);

}

</script>

Save the file and exit notepad.

Do the same change in file index.html

Restart iis with the dos command iisreset.

Try to surf to the page again.

Product:
Cognos Controller 10.1.405
Windows 2008 R2 server

Symptom:
Consolidation in Cognos controller does not work after update.
If you look in the help – system info dialog inside Cognos controller client you see version number:

IBM Cognos Controller version: 10.1.405
Integration version: 0.0.0

Cause:
When integration version is showing zeros, then some part of the Cognos Controller has not been installed correct.
Correct value for integration version should be: 10.1.416.

Possible Solution:
On the Cognos Controller Windows server:
Launch a command prompt by clicking “Start” – “Run” and then typing in “CMD”
Change directory using: cd C:\Windows\SysWOW64\common
Here is the file xceedzip, that maybe is not correct installed.
Register the file using: regsvr32.exe xceedzip.dll

Restart then the server.

Cognos Controller client version must be the same as the Cognos Controller version installed on the Application server.

More Information:
http://www-01.ibm.com/support/docview.wss?uid=swg21347488

http://www-01.ibm.com/support/docview.wss?uid=swg21394477

If you still have problems, remove the frangovfp com+ components and add them again.

Product:
Cognos Controller 10.1.405
Tm1 9.5.2
Windows 2008 R2 server

Symptom:
When doing a initial publish in Financial Analytics Publisher you get a error message that it can not login to the TM1 server cube.
This happen after you have upgrade Cognos Controller with a Fix Pack.

Error Message:
FAP Service Scheduler CRITICAL
Could not login to TM1, host: sr01639, server name: tm1fap, user name: AD\username

If you keep the mouse over the error message you will see this message:
com/cognos/ccf/c8itk/ITKProxyJNI.jnIsLoggedOn(J)Z

Cause:
When using Cognos Controller with Cognos BI CAM security to TM1 version 9.5.2 you need to use the correct c8itk4j.jar file.

Solution:
Stop the Cognos FAP service.
Go to folder D:\Program Files (x86)\ibm\cognos\c10\server\FAP\lib
Rename the file c8itk4j.jar to c8itk4j.jar.old
Copy the c8itk4j.jar file from folder D:\Program Files (x86)\ibm\cognos\c10\server\FAP\lib\TM1_9.5_CAM_compatibility
You should now have c8itk4j.jar filesize to be 22 KB.
Start the Cognos FAP service.

Go the the datamarts tab in Financial Analytic s Publisher and click start to test again.

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.

Product:
Cognos Controller 10.2.1 Fix Pack 4
Microsoft Windows 2012 R2 server

Symptom:
Error when importing csv file with data, that have worked fine in previous version of Cognos Controller 10.1. The DiscardedRows are the same number as the Rowsread in Log Reports dialog.

Error message:
The value must be numeric.

The data we try to import contain a decimal value; e.g. 000.00

Solution:
Log on to the Cognos Controller server as the service account that run the Cognos Controller services.
Go to controller panel
Go to regional settings
Change to England (UK)
Click tab ‘Location’
Change this to ‘English (United Kingdom)’
Click tab “Administrative”
Click “Change system locale…” and change this to “English (United Kingdom)”:
Click “Copy Settings”
Tick the box “Welcome screen and system accounts”.
Tick the box “New user accounts”:
Click OK
Reboot the Controller application server

I think it is the value of Decimal symbol need to be changed from comma to a period that solves the issue.

The csv file that is imported to controller must be of a specific format.
Text file should use decimal point (not comma) for decimals and semicolon (not comma or
tab) as delimiter between the data fields.

More information:
http://www-01.ibm.com/support/docview.wss?uid=swg21691867

Product:

Cognos Controller 8.5.1

Windows 2008 R2 server

Cognos BI 8.x

Symptom:

When user run a standard report inside Cognos Controller client they get a login dialog from Cognos Connection inside.  Cognos Controller is working in other areas. But when you select “Verify Account Structure” and run the report – you get a login dialog asking for you User ID and Password for the data source: SQLNCLI.1:… instead of the report result in HTML format.

Error message when you test the data source link in Cognos connection:

QE-DEF-0285

OE-DEF-0321

RQP-DEF-0068

UDA-SQL-0031

UDA-SQL-0129

UDA-SQL-0564 [Microsoft OLE DB provider for SQL server] Login failed

for user ‘cognos’ (SQLSTATE=42000, SQLERRORCODE=18456)

Cause:

The REPAIR button has not worked in Cognos Controller Configuration Report Tab. Can be because the user running Controller Configuration program is not system administrator in Cognos Connection. Data source connections have been manually updated in Cognos.

The correct password is not entered in the Cognos Connection data source connections.

Possible Solution:

Manually update the login value in Cognos Connection for the controller database.

Click on Launch – IBM Cognos Administration

Click on Configuration tab

Click on the data source connection you want to edit, starts mostly with SQLNCLI.1

Click on more time on the SQLNCLI name to go into the login object.

then click on the “SET PROPERTIES” icon on the right side of the login object.

Click on Signon tab

Click on Edit the signon… link

Here you can enter the correct password for the controller data source.

Click OK

Click OK

Click on the SQLNCLI link in the top next to the cognos link, so you are back on the data source connection and not in the signon object.

Click on the “Test the connection” icon at the right side of the data source.

Click the TEST button

If it display “Succeeded” then you are good to go.

Click Close

Click Close

Leave Cognos connection and start Cognos controller client and test the report again.

Product:

Cognos Controller 10.1 FAP

Symptom:

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

Problem:

Correct log level, not set at startup of FAP process.

Solution:

When you setup the Controller FAP process, you must active HIGH logging level to allow the trickling steps to be written to log table.

Go into Cognos Controller FAP Manager.

Edit the source (the controller database) you are using

Set the Log Level to High.

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

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.

Product:

Cognos Controller 10.1.395   (integration version 10.1.408)

IBM Cognos Controller Financial Analytics Publisher

TM1 10.1

Windows 2008 R2 (64 bits)

Symptom:

In FAP logs show error after the New Active source detected and added to scheduling: controller.

Error message:

Could not login to TM1, host: tm1servername, server name:  tm1servicename, user name: AD\service_account

Background information:

All windows server is in one domain called SRV

All users accounts are in one domain called EU

On TM1 server have only installed Cognos TM1 version 10.1 64 bit.

All tm1 service use the a service account in the EU domain.

The FAP service use a service account in the EU domain.

CCR_JAVA_HOME is set to \program files (x86)\ibm\java60\jre, where you have unpacked the jre.zip file that comes with the Cognos Controller media.

A 32 bit ODBC connection called FAP is created to the Controller FAP SQL database.

The Cognos Controller Batch service and COM service use a service account in the SRV domain.

Cognos Configuration for BI have namespace advanced properties set to:

singleSignOnOption      IdentityMapping

multiDomainTrees         True

Solution:

Restart of the Cognos BI service and change of the DC server that Cognos BI authenticate against.

From a DC server for the SRV domain, change to a DC server in the EU domain.

This is made inside Cognos Configuration under the namespace settings.

Host and port:  DC2EU.corp.company.com:389

The FAP service need to use a service account in a domain that Cognos BI service is authentication against.

Other possible solutions:

Install of TM1 32 bit client on the server where the FAP service is installed.

Update the PATH with the folder to the 32 bit TM1 client.

Erase the TM1 cube used for FAP, and start over. It can have become corrupted so the FAP service can not update it.

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 yours server.