Product:
Cognos Controller 10.1

Symptom:
Error before login to Cognos Controller you get an error message. You get the message after you have selected the controller database to use.

Error message:
Log On IBM Cognos Controller

AAA-AUT-0011
Invalid namespace was selected

Cause:
Cognos Controller 10 is setup to talk to a Cognos BI 8 installation.

The Dispatcher URI in Controller Configuration Report Server is not only used when you run the standard reports – it is also used when validate the login when using Server Authentication. The Report Server Dispatcher value is inherited to Server Authentication.

The values for Report Server will be reset to default values when you install the Cognos Controller Update Components Fix Pack on a existing Cognos Controller installation.
https://www-304.ibm.com/support/docview.wss?uid=swg27020782

Solution:
On the Cognos Controller application server
Start IBM Cognos Controller Configuration
Select Report Server in the list
Change the Dispatcher URI to be a valid URL

To something like this
http://SRV001:9300/p2pd/servlet/dispatch

Click Save
Exit Controller Configuration
Start Cognos Controller client and test again.

More Information:
If the Cognos BI service is not available you will get an error of this kind instead:
IBM Cognos Business Intelligence
Error executing request. Please verify that the target URI is valid and that IBM Cognos is online.

Below error message in Swedish:

”IBM Cognos-gatewayen kan inte ansluta till IBM Cognos BI-servern. Servern kan vara otillgänglig eller så kan gatewayen vara felaktigt konfigurerad.”
”Försök igen eller kontakta administratören.”

Product:
Cognos Controller 8.5

Problem:
How to install the Cognos Controller client automatic?

Cause:
Sometimes the IT department want to automate the installation of the Cognos Controller Client on the client computer or Citrix server.

Solution:
You can from a script start the CCRLOCALCLIENT.MSI file and add parameters that will respond to the questions you get when you install.

Copy first the CCRLOCALCLIENT.MSI file to the Client Computer.
You can download it from
http://servername/cognos8/controllerbin/ccrlocalclient.msi

Enter below on ONE row in a DOS prompt on the client computer:
msiexec.exe /qb /i ccrlocalclient.msi WSSURL=http://servername/cognos8/controllerserver HELPURL=http://servername/cognos8/controllerhelp

Replace servername above with the name of your Cognos Controller server.

Product:
Cognos Controller 8.5
Microsoft Excel 2003

Symptom:
Error message in Cognos controller when you start Excel, by click on Excel icon or run data entry.

Error:
IBM Cognos 8 Controller Link
CoCreateInstance(ControllerXLDisp.MsgPusher) failed with 0x80131700

Cause:
A possible cause can be that the file EXCEL.EXE.CONFIG is missing from the folder where EXCEL.EXE is on the client computer.

Solution:
Create a text file in the \program files\microsoft office\office11\ folder
Name the file to be EXCEL.EXE.CONFIG

Inside the file add this text;

<configuration>

<startup>

<supportedRuntime version=”v2.0.50727″/>

</startup>

</configuration>

Product:
Cognos Controller 8.5

Symptom:
Error message when using the Cognos Controller program

Error:
Model not found in context: job
Unable to find instance of model of type: job, type interface com.cognos.ccr.models.job.JobModel (load=LAST)
exceptionId=ERR.ANY:WEBSERIVCECONNECTIONEXCEPTION.CANNOT_EXECUTE_SERVICE, argument(s)=[http://localhost/cognos8/controllerserver/CCRWS.asmx, 010:608b9fd0-fc2b-11de-9650-d3922c4dc45a:1756974638]
FAIL: Message: ActiveX component can’t create object Source: FrJavaProxyB

Cause:
One possible cause can be that The Visual C++ 2005 package is not installed on the Cognos Controller application server.

Solution:
Install VC++2005 redistributable package on the Cognos Controller application server.
Reinstall Cognos Controller on the server.

Download vcredist_x86.exe from here
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=32bc1bee-a3f9-4c13-9c99-220b62a191ee&displaylang=en

Product:
Cognos Controller FAP version 8.5.1
Microsoft Windows 2008 server

Symptom:
When doing a IP (initial publish) for datamart in FAP get error “Could not login to TM1, host …. Server name: …. User name: …

If you have the mouse pointer over the error message a screen tip will say
“could not logon with to CAM with user: tm1servername to ClientCAMURI http://cognoscontroller…..

Cause:
The CAM user we try to connect to the TM1 cube is not set as ADMIN in the TM1 cube.

The TM1 cube security is changed from 1 to 5 in the tm1s.cfg file to allow access from Cognos Connection and use of the Cognos Access Management (CAM) users. But we have forgotten to set the CAM user to be ADMIN.

Possible Solution:

Start Tm1 Architect and open the TM1 cube for FAP.
Right click on the TM1 cube and select Security – Clients/Groups.
Find the CAM user in the list and mark ADMIN under Administrative Group Assignment.
Click OK
Exit Tm1 Architect.

Try to publish again in FAP program.

Product:
Cognos Controller FAP version 8.5.1

Symptom:
When doing a IP (initial publish) for datamart in FAP get error “Could not login to TM1, host …. Server name: …. User name: …

If you have the mouse pointer over the error message a screen tip will say
C8ITKShared (Not found in java.library.path)

You may find a FAPFatalErrorlog file in the FAP folder with this line;
Tue Mar 22 14:24:05 CET 2011 – Fatal error when starting or running FAPService. com.cognos.ccf.c8itk.ITKProxySession (initialization failure)

Cause:
FAP service can not find the TM1 dll files on the server. You need to add the path to the BIN folder to the PATH variable.

Solution:

Installing the TM1 Client (Optional)
This step is required when the Financial Analytics Publisher service and the TM1 application server
reside on different servers.
The TM1 client includes the dll files that are required for the Financial Analytics Publisher server
and the client to communicate with the TM1 server.

Steps to Add a Path for the TM1 Client System Variables
1. In Windows Explorer, right-click on My Computer, and select Properties.
2. Go to the Advanced tab.
3. Click Environment Variables.
4. Under System Variables, select Path, and click Edit.
5. Copy the path to the TM1\bin directory on your client, and paste it in at the end of the shown
path.
6. Click OK to all dialog boxes that follow.

Product:
Cognos Controller 8.5 FixPack 1

Symptom:
When you start Cognos Controller client for the first time you get the message
“An error occurred while trying to access the server”

In the Windows Event log you can find this message:
Event Type: Warning
Event Source: Cognos Controller
Event Category: None
Event ID: 0
Date: 2010-05-20
Time: 15:03:37
User: N/A
Computer: COMPUTER
Description:
Error occured at 2010-05-20 15:03:37 in IBM Cognos 8 Controller, Error No=5, Source=FrangoDirect.ConnectionDirect.SetSelectDb#ControllerProxyClient, Description=System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {114133CF-5DC0-4DB1-8796-4642553B2499} failed due to the following error: 80040154.
at Cognos.Controller.Proxy.CCRWS.ConnectionBusiness_SetSelectDb(String sGuid, String sUser, Boolean bSelectDb)
— End of inner exception stack trace —, HelpFile= HelpContext=0

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Cause:
During the installation of Cognos Controller not all parts was correct installed.
You find this if you look on the Cognos Controller application server in Component Services under Administrative tools.
Expand the Com+ Applications branch and then expand IBMCOGNOSCONTROLLER Components branch – if there is only 30 objects in here then you have the cause of the problem.

Solution:
Uninstall Cognos Controller 8.5 from the Application server.
Install same Cognos Controller 8.5 to the same folder on the Application server.

Then you have all the components in the Component Services.

Cognos Controller 8.5 Fixpack 1 should have 259 Objects in Components Services.

Product:
Cognos Controller 85

Symptom:
Error when you try to start Cognos controller client, after the selection of the database.
“An error occurred while trying to access the server.”

Message in Windows event log:

Event Type: Warning
Event Source: Cognos Controller
Event Category: None
Event ID: 0
Date: 2010-05-11
Time: 15:03:15
User: N/A
Computer: SERVER
Description:
Error occured at 2010-05-11 15:03:15 in IBM Cognos 8 Controller, Error No=5, Source=FrangoDirect.ConnectionDirect.GetUserInfo#ControllerProxyClient, Description=System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0.
at System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue)
at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value)
at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
at Cognos.Controller.Proxy.DAL.Xcamusers..ctor(String sGuid, String sUser)
at Cognos.Controller.Proxy.ControllerReportNetService.RepNet.GetUserInfo(String sGuid, String sUser, String passportId)
at Cognos.Controller.Proxy.CCRWS.GetUserInfo(String sGuid, String sUser, String passportId)
— End of inner exception stack trace —, HelpFile= HelpContext=0

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Cause:
The SQL login that is used to access the Cognos Controller database have a = sign in the password.

Solution:
Change the password used by the SQL login Cognos to the controller database to only contain letters and numbers (e.g. A-Z, 1-9)
Then change in Cognos Controller Configuration for the database connection to the new password for access to the Controller database.
Save the change and restart the Controller Application server to allow the controller services to understand the change in connection to the database.

Product:
Cognos Controller 8.4

Symptom:
It takes long time to start the Cognos Controller Client.

Problem:
It takes exactly 90 seconds between you enter your name and password in Cognos Controller until the program is open and you can start to work with it.

Cause:
The Cognos Controller program is signed with a certificate. During start of Cognos Controller the application will try to contact the certificate authority to check if the certificate is valid. If the computer (or citrix server) where Cognos Controller software is run from does not have internet access, the Cognos Controller program will try for 90 sec before it times out and shows the program anyway.

Solution:
Uncheck the “check for publisher certificate revocation” in Internet Explorer for the user on the server.
Easy is to create a script that set it to all users that logon to the Citrix Server:
The script will set values in the users Windows profile for Internet Explorer.
To make the script run for all persons add it to the file c:\windows\system32\usrlogon.cmd

Create a text file name UNCHECK.REG with this content in the c:\ root;

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\WinTrust\Trust Providers\Software Publishing]
“State”=dword:00023e00

Then add the following line to the beginning of the USRLOGON.CMD file

regedit /s c:\uncheck.reg

Save the file.
Ensure that all users have read rights to the file uncheck.reg on the server.

This should also be done on the Cognos Controller Applications server, to ensure fast start of the Cognos Controller Configuration program.

Product:
Cognos Controller 8.4 FixPack 1

Symptom:
User is trying to print a standard report as Trail Balance to there printer in there office, or try to send the report to a application like Microsoft Excel 2003.
They get a Cognos controller error when doing this.
Click OK and they are back in Cognos Controller.

This only happens for a few users, other users can successfully print the trail balance report.
The users having the issue are running Cognos Controller in a Citrix Farm.

Problem:
Error message when showing Trial Balance.

Error message in windows event log:
Event Type: Warning
Event Source: Cognos Controller
Event Category: None
Event ID: 0
Date: 2010-01-14
Time: 06:34:22
User: N/A
Computer: CITRIXSERVER
Description:
Standard Error
Source: C1.Win.C1FlexGrid.2
Description: CellRange is invalid.
at C1.Win.C1FlexGrid.CellRange.d()
at C1.Win.C1FlexGrid.CellRange.get_Clip()
at C1.Win.C1FlexGrid.Classic.C1FlexGridClassic.get_Cell(CellPropertySettings setting, Int32 row1, Int32 col1, Int32 row2, Int32 col2)
at C1.Win.C1FlexGrid.Classic.C1FlexGridClassic.get_Cell(CellPropertySettings setting, Int32 row, Int32 col)
at Cognos.Controller.Forms.Form.frmTrialBalance.DrillSet()
at Cognos.Controller.Forms.Form.frmTrialBalance.grdReport_RowColChange(Object eventSender, EventArgs eventArgs)
at C1.Win.C1FlexGrid.C1FlexGridBase.OnRowColChange(EventArgs e)
at C1.Win.C1FlexGrid.C1FlexGridBase.bb()
at C1.Win.C1FlexGrid.C1FlexGridBase.OnGridChanged(Object sender, GridChangedEventArgs e)
at C1.Win.C1FlexGrid.C1FlexGrid.OnGridChanged(Object sender, GridChangedEventArgs e)
at C1.Win.C1FlexGrid.v.a8(GridChangedTypeEnum A_0, Int32 A_1, Int32 A_2, Int32 A_3, Int32 A_4)
at C1.Win.C1FlexGrid.v.bm(GridChangedTypeEnum A_0)
at C1.Win.C1FlexGrid.g.j()
at C1.Win.C1FlexGrid.v.a8(GridChangedTypeEnum A_0, Int32 A_1, Int32 A_2, Int32 A_3, Int32 A_4)
at C1.Win.C1FlexGrid.RowColCollection.v(GridChangedTypeEnum A_0, Int32 A_1, Int32 A_2, Int32 A_3, Int32 A_4)
at C1.Win.C1FlexGrid.RowCollection.aa(Int32 A_0, Boolean A_1, q A_2, Int32 A_3)
at C1.Win.C1FlexGrid.C1FlexGridBase.AddItem(String item, Int32 index)
at Cognos.Controller.Forms.Form.frmTrialBalance.PrepareGridForPrinter(String& sGroup, String& sGroupName, String& sForm, String& sFormName, Boolean& bChangeFont, Boolean& bSpillHeader)
at Cognos.Controller.Forms.Form.frmTrialBalance.SendGridToPrinter(String& sGroup, String& sGroupName, String& sForm, String& sFormName)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event Type: Warning
Event Source: Cognos Controller
Event Category: None
Event ID: 0
Date: 2010-01-14
Time: 06:34:06
User: N/A
Computer: CITRIXSERVER
Description:
Standard Error
Number: 5
Source: C1.Win.C1FlexGrid.2
Description: CellRange is invalid.
at C1.Win.C1FlexGrid.CellRange.d()
at C1.Win.C1FlexGrid.CellRange.get_Clip()
at C1.Win.C1FlexGrid.Classic.C1FlexGridClassic.get_Cell(CellPropertySettings setting, Int32 row1, Int32 col1, Int32 row2, Int32 col2)
at C1.Win.C1FlexGrid.Classic.C1FlexGridClassic.get_Cell(CellPropertySettings setting, Int32 row, Int32 col)
at Cognos.Controller.Forms.Form.frmTrialBalance.DrillSet()
at Cognos.Controller.Forms.Form.frmTrialBalance.grdReport_RowColChange(Object eventSender, EventArgs eventArgs)
at C1.Win.C1FlexGrid.C1FlexGridBase.OnRowColChange(EventArgs e)
at C1.Win.C1FlexGrid.C1FlexGridBase.bb()
at C1.Win.C1FlexGrid.C1FlexGridBase.OnGridChanged(Object sender, GridChangedEventArgs e)
at C1.Win.C1FlexGrid.C1FlexGrid.OnGridChanged(Object sender, GridChangedEventArgs e)
at C1.Win.C1FlexGrid.v.a8(GridChangedTypeEnum A_0, Int32 A_1, Int32 A_2, Int32 A_3, Int32 A_4)
at C1.Win.C1FlexGrid.v.bm(GridChangedTypeEnum A_0)
at C1.Win.C1FlexGrid.g.j()
at C1.Win.C1FlexGrid.v.a8(GridChangedTypeEnum A_0, Int32 A_1, Int32 A_2, Int32 A_3, Int32 A_4)
at C1.Win.C1FlexGrid.RowColCollection.v(GridChangedTypeEnum A_0, Int32 A_1, Int32 A_2, Int32 A_3, Int32 A_4)
at C1.Win.C1FlexGrid.RowCollection.p(Int32 A_0, Boolean A_1)
at C1.Win.C1FlexGrid.RowCollection.set_Count(Int32 value)
at C1.Win.C1FlexGrid.Classic.C1FlexGridClassic.set_Rows(Int32 value)
at Cognos.Controller.Forms.Form.frmTrialBalance.FillReport(DataSet[]& m_rsReport, String& sGroup, String& sCurrencyType)
at Cognos.Controller.Forms.Form.frmTrialBalance.LoadReport(String& sPerAct, String& sForm, Object& varCompanies, String& sAccount, String& sGroup, String& sConsType, String& sCloseVer, String& sContVer, String& sCurrencyType, String[]& sClosVers, String[]& sContVers, String[]& sDims)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Type: Warning
Event Source: MetaFrameEvents
Event Category: Printer Management
Event ID: 1103
Date: 2010-01-14
Time: 06:29:57
User: N/A
Computer: CITRIXSERVER
Description:
An error occurred while retrieving client printer properties. Default printer properties will be used instead. Client name: (EUR-gmuehle) Printer: (PN776154 on SPHAMLX3517 (from EUR-gmuehle) in session 3) Printer driver: (LEXMARK UNIVERSAL)

Event Type: Error
Event Source: Microsoft Office 11
Event Category: None
Event ID: 1000
Date: 2010-01-14
Time: 05:50:59
User: N/A
Computer: CITRIXSERVER
Description:
The description for Event ID ( 1000 ) in Source ( Microsoft Office 11 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: excel.exe; 11.0.6560.0; 4296b6f2; excel.exe; 11.0.6560.0; 4296b6f2; 0; 0002b34f.
Data:
0000: 41 00 70 00 70 00 6c 00 A.p.p.l.
0008: 69 00 63 00 61 00 74 00 i.c.a.t.
0010: 69 00 6f 00 6e 00 20 00 i.o.n. .
0018: 46 00 61 00 69 00 6c 00 F.a.i.l.
0020: 75 00 72 00 65 00 20 00 u.r.e. .
0028: 20 00 65 00 78 00 63 00 .e.x.c.
0030: 65 00 6c 00 2e 00 65 00 e.l…e.
0038: 78 00 65 00 20 00 31 00 x.e. .1.
0040: 31 00 2e 00 30 00 2e 00 1…0…
0048: 36 00 35 00 36 00 30 00 6.5.6.0.
0050: 2e 00 30 00 20 00 34 00 ..0. .4.
0058: 32 00 39 00 36 00 62 00 2.9.6.b.
0060: 36 00 66 00 32 00 20 00 6.f.2. .
0068: 69 00 6e 00 20 00 65 00 i.n. .e.
0070: 78 00 63 00 65 00 6c 00 x.c.e.l.
0078: 2e 00 65 00 78 00 65 00 ..e.x.e.
0080: 20 00 31 00 31 00 2e 00 .1.1…
0088: 30 00 2e 00 36 00 35 00 0…6.5.
0090: 36 00 30 00 2e 00 30 00 6.0…0.
0098: 20 00 34 00 32 00 39 00 .4.2.9.
00a0: 36 00 62 00 36 00 66 00 6.b.6.f.
00a8: 32 00 20 00 66 00 44 00 2. .f.D.
00b0: 65 00 62 00 75 00 67 00 e.b.u.g.
00b8: 20 00 30 00 20 00 61 00 .0. .a.
00c0: 74 00 20 00 6f 00 66 00 t. .o.f.
00c8: 66 00 73 00 65 00 74 00 f.s.e.t.
00d0: 20 00 30 00 30 00 30 00 .0.0.0.
00d8: 32 00 62 00 33 00 34 00 2.b.3.4.
00e0: 66 00 0d 00 0a 00 f…..

Solution:
Exit there Cognos controller session.
The user should change there default printer driver to some thing else (go from HP to LEXMARK) then start there Controller session in Citrix. Maybe they have a different printer in the office corridor they can select instead of there default printer at there desk.

In Cognos controller they should now try to print the same report again.
Go to group – reports – trail balance – and click on the print button.
In the citrix printer dialog that comes up – the user should be able to select the printer they used before and then print out on that printer.

The issue seems to be with the selected printer when they start there Citrix session.