CogKnowHow

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.

Product:
Cognos Controller 85

Symptom:
Error message in Cognos Controller 8.5 when you try to access menu Maintain – Jobs – Define.
(This menu is only available when you use a Cognos Controller database in the New Consolidation Engine mode. You can test with a new empty controller database)

Problem:
Model not found in context; job
Unable to find instance of model of type: job, ttype interface com.cognos.ccr.models.job.JobModel (load=LAST)
Exceptionid=ERR.ANY.WEBSERVICECONNECTIONEXCEPTION.CANNOT_EXECUTE_SERVICE, argument(s)=[http://server.domain.com/cognos8/controllerserver/ccrws.asmx,
010:2e850961-51f1-11df-b404-d5d34bef5812:0650936176]
FAIL: Message: Permission denied source: FrJavaProxyB

Cause:
The Cognos service IBM Cognos Controller Java Proxy is run as local system on the controller application server.

Solution:
Change the IBM Cognos Controller Java Proxy service to run as the same windows account used by the Cognos Controller COM+ service.

Product:
Cognos Controller 8.5 fixpack 1

Symptom:
Error message when you start Cognos Controller from the Cognos Connection on a Windows 2008 R2 Terminal Server.

Error message:
Microsoft IE Execute shell
Microsoft IE Execute shell has encountered a problem and needs to close.
We are sorry for the inconvenience.

If you are in the middle of something, the information you were working on might be lost.

Cause:
The Cognos Controller client is a 32 bit application, but the Internet Explorer you are running on the Windows 2008 R2 server may be a 64 bit application.

Solution:
Instead of starting the Cognos Controller application from the web site, install the ccrlocalclient.msi on the Microsoft Windows 2008 R2 terminal server.
This will give you a local ccr.exe program on the start menu – and then you use that instead.

CCRlocalclient.msi is found on the controller application server and can be started from
http://servername/cognos8/controllerbin/ccrlocalclient.msi

When you get the file download – Security warning, you should select RUN.
During installation you will be ask to enter the URL to the application server, should be something like this:
WSS URL: http://servername/cognos8/controllerserver
Help URL: http://servername/cognos8/controllerhelp

You find the correct values in Controller Configuration on the Application server.
Supported version of OS is found here for Cognos Controller
http://www-01.ibm.com/support/docview.wss?rs=3450&uid=swg27017475

Product:
Cognos Controller 8.4

Symptom:
New install of Cognos Controller and when you run a standard report
(Like maintain – rights – reports – users) you get a error when you select the format XLS.

The view of the standard report in HTML and PDF works fine.

Error dialog:
A critical error occurred in Controller Link, probably due to missing file(s),
And you won´t be able to work with it.
Please contact your system administrator.

Error Descr:
Fil- eller sammansättningsnamnet ControllerXLPusher, eller ett av dess beroenden, hittades inte.

Cause:
The excel.exe.config file that direct Excel to use the correct version of NET framework is not in correct folder on the client computer.

Solution:
Copy the excel.exe.config file to same folder as the excel.exe file.
For Excel 2003 that is folder C:\program files\microsoft office\office11.

Product:
Cognos Controller 8.5

Symptom:
Error direct when you start the Cognos Controller Client, before you have selected the database to use.
The user gets this message:
An error occurred while trying to access the server.

This can be because of other things also – but look into the Windows event log to get more clues.

Windows event log shows:

Event Type: Error
Event Source: DCOM
Event Category: None
Event ID: 10016
Date: 2010-06-01
Time: 14:09:57
User: NT AUTHORITY\NETWORK SERVICE
Computer: SERVER
Description:
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{114133CF-5DC0-4DB1-8796-4642553B2499} to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool.
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-06-01
Time: 14:09:57
User: N/A
Computer: SERVER
Description:
Error occured at 2010-06-01 14:09:57 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.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {114133CF-5DC0-4DB1-8796-4642553B2499} failed due to the following error: 80070005.
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:
The user account does not have rights in the Cognos Controller COM parts to perform.

Solution:
You can inside Cognos Controller Configuration on the COM+ server dialog do this;

Uncheck the settings for “Enforce Access checks for the Controller COM+ application”.
OR
Add the group Everyone to the list of users that is allowed to run Cognos Controller in the same Cognos Controller Configuration dialog. It is in the “Controller COM+ roles and users” section.

Product:
Cognos Controller 8.4

Symptom:
When user changes company in there Data Entry reporting session they get an error message and then Excel is hanging.
In this environment the controller client is started from the ccr.exe file that is installed on the citrix servers with use of the ccrlocalclient.msi package.

Problem:
Error found on client in Windows Event log:

Event Type: Warning
Event Source: Cognos Controller
Event Category: None
Event ID: 0
Date: 2009-12-07
Time: 10:27:31
User: N/A
Computer: CITRIX1
Description:
Standard Error
Source: ControllerForms
Description: OpenWorkbook
Object reference not set to an instance of an object.
at Cognos.Controller.ControllerForms.clsDataEntry.ActivateDataEntryForm()
at Cognos.Controller.ControllerForms.clsDataEntry.OpenSelectedForm(UserParameters& UserSelection)

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

Cause:
The NET framework 2.00 on the Cognos Controller Client does not have full trust to the Cognos Controller Application Server.
On the computer you can check if the FULLTRUST is set to the server by run the commando CASPOL –LG from the command prompt.
Go to the command prompt
Go to the folder c:\windows\microsoft.net\framework\v2.0.50727
Enter caspol –lg
You will see a list of the connections to FULLTRUST.
Check the last lines of code group to find the Controller app server name to be listed.

Solution:
On the Cognos Controller Client Computer ( citrix server ) run a commando to set the trust to the server.
Create a text file (named setcaspol.cmd) on a share on the Cognos Controller server:

c:
cd\
cd c:\windows\microsoft.net\framework\v2.0.50727

Caspol.exe -m -q -ag All_Code -url http://cognosserver/cognos8/* FullTrust -n name1a
Caspol.exe -m -q -ag All_Code -url http://151.156.176.97/cognos8/* FullTrust -n name1b
Caspol.exe -m -q -ag All_Code -url http://cognosserver.domain.com/cognos8/* FullTrust -n name1c

Caspol.exe -e off

In above file you need to change “cognosserver” with you controller app server name.
Then run the setcaspol.cmd file from the Citrix servers, to set the trust in NET framework 2.00.

From the start menu – select run
Enter the \\servername\share to connect to the share there the setcaspol.cmd file is saved.
Double click on the setcaspol file to run it on the Client computer (citrix server)
You should briefly see 4 “Success” roll by, if the script is working.

Product:
Cognos Controller 8.5

Symptom:
Error after the selection of database when you login to the Cognos Controller client.

Problem:
Error message to user

System.Web.Services.Protocols.SoapException: Server was unable to process request: Permission denied …

Error in windows event viewer
Event Type: Error
Event Source: DCOM
Event Category: None
Event ID: 10016
Date: 2010-04-27
Time: 14:59:24
User: server\frangoadm
Computer: PTP280
Description:
The machine-default permission settings do not grant Local Activation permission for the COM Server application with CLSID
{BE913F44-118C-11D5-A324-00C04FA0E3B7}
to the user server\frangoadm SID (S-1-5-21-57989841-2049760794-725345543-1924). This security permission can be modified using the Component Services administrative tool.

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

Cause:
In some cases the windows service account used for the Cognos Controller service need more users rights than the default administrator groups gives it.

Solution:
Add the windows user account used for Cognos Controller COM+ package to the local group “Distributed COM users” on the Windows 2003 server for Cognos Controller application.

Product:
Cognos Controller 85

Symptom:
Error message when you try to convert old Frango Controller forms to the new Controller version 85.
You find this on menu MAINTAIN – SPECIAL UTILITIES – CONVERT – FORMS TO NEW DESIGN.
You successes to convert a few – but after a while you get stuck with a error message.

Error message:
Standard Error
Source: frmConvertOldForms
Description: Exception of type ‘System.OutOfMemoryException’ was thrown.
At Cognos.Controller.Forms.Form.frmConvertOldForms.PopulateLayout(String sForm, String sFormType, String sRad1, String sRad2,String sKol1, String sKol2, String& sLayout)
At Cognos.Controller.Forms.Form.frmConvertOldForms.PrepareLayouts()
At Cognos.Controller.Forms.Form.frmConvertOldForms.PerformMigration()
At Cognos.Controller.Forms.Form.frmConvertOldForms.IForm_DoClick(Int32 ICmd, String& sTag)

Information:
Other cause to make this happen can be a damage/not used data entry form.
Remove all forms that you do not need before you start the conversation.

To be able to convert the forms you must install the CONTROLLERCONV.MSI on a client computer with Excel 2000, which is then connected to the Controller Application server.

Workaround:
Export all the forms from the Controller database with use of the Transfer – Export Structures menu in the Cognos Controller client.
Create a new empty Cognos Controller database and import the forms structures into this database.
Then from inside the empty database with only Cognos Controller forms, run the convert of forms to the new version and you may be lucky and it works.
Then you export the forms from the empty database to a file.
Import that file into you old converted database, and you have a working form set.