Product:
Cognos Controller 10
Excel Link
Windows 2003 Server
Citrix Server

Symptom:
When working in Excel with Cognos Controller link you get an error message.

Error message:
Standard Error
Number: 7
Source: mscorlib
Description: Execption of type ‘System.outOfMemoryException’ was thrown.
At System.IO.MemoryStream.set_Capacity(Int32 value)
At System.IO.MemoryStream.EnsureCapacity(Int32 value)
At System.IO.MemoryStream.Write(Byte[] buffer, Int32 offset, Int32 count)
Xxx

Solution:
The Windows check if there is memory free that the application can use, and at this moment there is not enough memory free on client computer/terminal server, so this error is sent from the Windows Operation system, to not allow the program to access the memory.

In the case of Excel reports, consider to make them smaller with less amount of formulas.
Also ensure the client/citrix server have enough memory.
At least do you need 8 GB of ram on a citrix server, which should handle a few Cognos Controller users.

Run the same excel sheet on a computer/server with a lot of memory and see if the problem is gone.

Product:

IBM Cognos Controller 10.1.1

Excel 2010

Windows 2008 R2 Server

Citrix Server

Symptom:

When you start Microsoft Excel 2010 and open a large xls sheet, you get a error message.

You have changed from Excel 2007 to Excel 2010 recently.

Error message:

Microsoft Excel

Not enough system resources to display completely.

 

Possible Solution:

This strange behavior can be solved sometimes by erase temp files, see below how to do this:

You need to be administrator on the computer, to do many of the steps.

 

Deleted all temp files by:

Go to Start menu

Select Run

Enter %temp% in the box and press Enter

(mostly this is c:\temp)

Delete everything from this folder

 

Cleared Recent Docs List & Lower Number Displaying:

Start Excel 2010

Select File menu

Select Options from menu

Select Advanced

Scroll to Display category

Change number of recent documents.  To clear the list, set this to 0 and save.  Set it to a low value, like 5, to prevent it from happening again.

 

Delete files from the following folders:

Some of the folders may be hidden, so you need to active “show hidden files” in Windows Explorer.

Go to control panel

Select folder options

Select view tab

Mark “show hidden files, folders, or drives.”

Click OK.

Start windows explorer again.

 

Local Service:

%windir%\ServicesProfiles\LocalService\AppData\LocalLow\Microsoft\CryptnetUrlCache\Content

%windir%\ServicesProfiles\LocalService\AppData\LocalLow\Microsoft\CryptnetUrlCache\MetaData

Network Service:

%windir%\ServicesProfiles\NetworkService\AppData\LocalLow\Microsoft\CryptnetUrlCache\Content

%windir%\ServicesProfiles\NetworkService\AppData\LocalLow\Microsoft\CryptnetUrlCache\MetaData

LocalSystem:

%windir%\System32\config\systemprofile\AppData\LocalLow\Microsoft\CryptnetUrlCache\Content

%windir%\System32\config\systemprofile\AppData\LocalLow\Microsoft\CryptnetUrlCache\MetaData

Above can solve your problem, if there is still problems, check if Microsoft update 2597166 is installed, and if you remove that – it may work.

 

More information:

http://social.technet.microsoft.com/Forums/en-US/excel/thread/878e2e02-8f0f-4740-9b15-5e718725ea2a

After your changes, you can also repair you Microsoft Office installation

Go to Control Panel

Go to Add/Remove Programs

Select Office 2010

Right click and select Change

Run Repair

Test the XLS file again after you have cleaned the system as shown above.

Product:

IBM Cognos Controller 10.1.1

(RTM controller version 10.1.1306)

(Integrated version 10.1.1294)

on

Microsoft Windows 2008 R2

Symptom:

When user starts local installed Cognos Controller (ccr.exe) they get a error message before the login dialog.

An error occurred while trying to access the server

http://localhost/ibmcognos/controllerbin

The request failed with HTTP status 404: Not Found.

 

Solution:

Inside Cognos Controller Configuration under Client Distribution Server Configuration

you can see the correct value for WSSurl

http://localhost/ibmcognos/controllerserver

During install of the Controller Client (ccrlocalclient.msi) you may have enter the wrong value for the WSSUrl.

On the client machine, or the citrix server, go to the folder

C:\Program Files (x86)\ibm\IBM Cognos Controller

open the file CCR.exe.config in notepad

change the line;

<add key=”WSSUrl” value=”http://localhost/ibmcognos/controllerbin”/>

to a correct line like this;

<add key=”WSSUrl” value=”http://localhost/ibmcognos/controllerserver”/>

Save the file and start the Controller client again.

You may need to start the client twice to make the effect work.

 

(you need to replace “localhost” with your server name)

Product:

Cognos Controller 10.1.1

Windows 2008 R2 Server

Symptom:

When you surf to http://localhost/ibmcognos you get a error.

On a newly installed Cognos BI / Cognos Controller setup.

Problem:

HTTP Error 404.2 – Not Found

The page you are requesting cannot be served because of the ISAPI and CGI Restriction list settings on the Web server. Detailed Error Information

Module CgiModule

Notification ExecuteRequestHandler

Handler cgi-bin

Error Code 0x800704ec

Requested URL http://localhost:80/ibmcognos/cgi-bin/cognos.cgi?b_action=xts.run&m=portal/main.xts&startwel=yes

Physical Path C:\Program Files (x86)\ibm\cognos\c10\cgi-bin\cognos.cgi

Logon Method Anonymous

Logon User Anonymous

 

Solution:

Go to Internet Information (IIS) Manager

Mark the server in the list to the left

Click on icon for “ISAPI and CGI Restrictions”

Note that there is no line for cognos.cgi

Click ADD from the right panel

Enter the path to the cognos.cgi file in field ISAPI or CGI path:

C:\Program Files (x86)\ibm\cognos\c10\cgi-bin\cognos.cgi

Enter cognos.cgi as Description

mark “Allow extension path to execute”

Click OK

 

Test again to surf to http://localhost/ibmcognos

Product:

Cognos Controller 10.1.1

Windows 2008 R2 Server

Symptom:

When you surf to http://localhost/ibmcognos you get a error.

On a newly installed Cognos BI / Cognos Controller setup.

Error message:

HTTP Error 500.19 – Internal Server Error

The requested page cannot be accessed because the related configuration data for the page is invalid. Detailed Error Information

Module IIS Web Core

Notification BeginRequest

Handler Not yet determined

Error Code 0x8007000d

Config Error Unrecognized attribute ‘allowpathInfo’

Config File \\?\C:\Program Files (x86)\ibm\cognos\c10\cgi-bin\web.config

Solution:

Change the value inside web.config file to be allowPathInfo  instead of  allowpathInfo

Should look like this:

<?xml version=”1.0″ encoding=”UTF-8″?>

<configuration>

<system.webServer>

<handlers accessPolicy=”Read, Execute, Script”>

<add name=”cgi-bin” path=”*.cgi” verb=”*” modules=”CgiModule” resourceType=”Unspecified” allowPathInfo=”true” />

</handlers>

</system.webServer>

</configuration>

Product:

Cognos Controller 10.1

Windows 2008 R2 Server

Problem:

How do I see the domain and username of the logged in user in a computer ?

Possible Solution:

On the client workstation you can run below script to display username and domain, that the user is logged into.

echo %userdomain% > finduser.txt

echo %username% >> finduser.txt

notepad.exe finduser.txt

Open notepad

enter above text

save as finduser.cmd

in windows explorer ensure the file is ended with cmd and not cmd.txt.

Let the user run the finduser.cmd file,

it will in notepad display

what domain and user is logged in to the computer.

This to ensure that he is logged in to Windows computer with the correct user.

Product:

Cognos Controller 10.1.1  CCR-AW32-ML-RTM-10.1.6235.57-0

FAP 1.0.13.0  CCRFAPCLIENT-AW32-ML-RTM-10.1.6235.57-0

Microsoft Windows 2008 R2 server

Symptom:

When install FAP manager on citrix server, the values are empty when the user starts the program.

Cause:

Default values for IBM Cognos Controller Financial Analytics Publisher are stored in a user.config file for each user in folder C:\Users\Administrator\AppData\Local\IBM_Corp\FAPClient.exe_Url_hizg5pd121eg2yxnq50fgzjzluvgy4wb\1.0.13.0 on the server.

Solution:

Create a batch file, that look something like this:

===================================

@echo off mkdir %userprofile%\AppData\Local\IBM_Corp\FAPClient.exe_Url_hizg5pd121eg2yxnq50fgzjzluvgy4wb\1.0.13.0  copy user.config %userprofile%\AppData\Local\IBM_Corp\FAPClient.exe_Url_hizg5pd121eg2yxnq50fgzjzluvgy4wb\1.0.13.0\user.config

cmd.exe /C start “FAP Manager” “C:\Program Files (x86)\ibm\cognos\c10\webcontent\ccr\FAPClient.exe”

=============================================

Copy a working user.config file and place it in same folder as above batch file.

Add the batch file to the publish FAP manager icon, to be run before the start of the application.

Now the file is in place before the FAP manager starts, and the default values are there.

Then the user only need to type in the SQL login password to the FAP database to work.

 

The user.config should look like this:

<?xml version=”1.0″ encoding=”utf-8″?>

<configuration>

<userSettings>

<FAPClient.My.MySettings>

<setting name=”DatabaseType” serializeAs=”String”>

<value>MSSqlServer2008</value>

</setting>

<setting name=”Server” serializeAs=”String”>

<value>localhost</value>

</setting>

<setting name=”Database” serializeAs=”String”>

<value>adam</value>

</setting>

<setting name=”User” serializeAs=”String”>

<value>bertil</value>

</setting>

</FAPClient.My.MySettings>

</userSettings>

</configuration>

…………………………………………………………………………….

localhost should be replace with the SQL server name

adam should be replaced with the FAP controller database name

bertil should be replaced with the SQL server login username

 

A easier way is to update the FAPClient.exe.config file in folder c:\program files (x86)\ibm\cognos\c10\webcontent\ccr folder.

This will affect all users that login to the Citrix server.

Product:
Cognos Controller 10.1.1
Windows 2008 R2 server
FAP Financial Analytics Publisher
Citrix server

Symptom:
When you click Start for the data mart in FAP manager you get a error message. You have installed the FAP client software on several Citrix servers, but it does not work on one of the servers.
You can login – and you can see the log table in FAP manager, you can even click on STOP button under data mart tab, to stop the FAP process. But you can not start it again.

Error message:
Data mart can’t be started. couldn’t connect to source database. check your settings.

Cause:
On the not working Citrix server you have installed this SQL driver
SQL Server 2008 R2 Native Client version 10.52.4000.0
but on the working Citrix server you have installed this SQL driver
SQL Server Native Client version 9.00.1399.06
SQL Server Native Client version 9.00.5000.00 will also work fine.

Solution:
Log in to Citrix Windows Server as local administrator
Go to Control Panel
Go to Program and Features
Uninstall Microsoft SQL Server 2008 native client
Download and install sqlncli_x64.msi from Microsoft web site.

Test the FAP client program again.

Product:
Cognos Controller 10.1.1
Microsoft Excel 2010
Windows 2008 R2 server

Symptom:
After upgrade to new version of Excel 2010 on the Citrix servers where they have Cognos Controller client installed, the xls files saved from Cognos Controller link, contain values instead of only the formulas as they did before.

Problem:
In excel you import values from the company result from Cognos Controller application.
Then you want to share your Excel sheet, that contain Cognos Controller formulas, with your Cognos Controller college. So you place the XLS file on a file share in the network.
If someone else open the XLS file in there Excel – they should not see values only the formulas.
Because they have not installed Cognos Controller client, they can not update the excel sheet with values.
In this case, we notice, that the XLS file contain the company result values in the XLS file.
This is not what we wanted. How to change it ?

Solution:
Inside Microsoft Excel you can turn on or off the function that excel save the value with the formula in the XLS file when you save it.
Open Microsoft Excel 2010 program
Click on File menu
Select Options
Select Advance
Scroll down to the formulas section
Untick “Save external link values”
Click OK
Now when you save a XLS file to a file share, the values is gone.

Product:

Cognos Controller 10.1.1

Windows 2008 R2 Server

Office 2010 excel

Citrix Server

Symptom:

When you start excel from inside Cognos Controller you get error message.

The error is before Excel is started on the Citrix server, as you can see in Citrix Program Neighborhood Connection Center.

Error message:

The Excel-link is not installed.

Cause:

Visual Basic For Application is not installed or deactivate on the Citrix server.

Cognos Controller Excel add in demands that Visual Basic For Applications is enabled.

Solution:

Login to Citrix server as Local Administrator

Go to Control panel

Go to programs and features

Right-Click on Microsoft Office 2010 and select change

Select Add/remove features

Check that Visual Basic for Applications is installed.

 

If you start Excel and check if the controller link is installed, if the VBA support is disabled then the controller link is shown as controllerXL.xll inside excel add-in dialog, under File menu – Excel Options. If VBA support is enabled then it will show “IBM Cognos Controller Link” inside excel add-in dialog.

 

When you are inside Excel, press ALT+F11 to active the Visual Basic editor. If this does not work, then the VBA support is disabled in your excel installation. Cognos Controller excel link demands that the VBA support is working in excel before Cognos Controller can work.

 

There can be a group policy that have deactivate the VBA support in Microsoft Office.

On the citrix server;

Go to start menu

Go to RUN

Enter REGEDIT

Click OK

Expand tree to [HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Common]

If the value for vbaoff is 1 , then Visual Basic for Applications is disabled in Excel 2010.

Change the value to 0 (zero)

Exit REGEDIT

Test the Cognos Contoller Excel link again.

If you do not find the GPO that set the value, you can add below text to a file named vbaon.reg and include the file in a login script on the Citrix server to set it on the user profile.

 

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Common]

“vbaoff”=dword:00000000