Product:

IBM Cognos Controller 10.1.1

Windows 2008 / 2003 Citrix server

Symptom:

After upgrade to new version of Cognos Controller the Excel link does not work.

Error message:

Excel link is not installed – when you press excel icon in Cognos controller client.

‘C:\Program Files (x86)\Cognos\ccr\ControllerXL.xll’ not found – when you start Excel on Citrix server.

Cause:

The Path to the controllerxl.xll file has change between the versions of Cognos Controller from

‘C:\Program Files (x86)\Cognos\ccr\ControllerXL.xll’ to ‘C:\Program Files (x86)\IBM\IBM Cognos Controller\ControllerXL.xll’

During uninstall of the Cognos Controller Client, this regvalue  for Excel stored in the users Windows profile is not updated, so next time Cognos Controller believes it is installed and therefore does not update the value.

Possible Solution:

If you do not want to erase the users windows profile on the citrix server you can create a script that update the users registry at start of the Cognos Controller program.

Create two files, and place them on the citrix servers c:\ drive. Ensure the users can read this files from the drive with NTFS security. Publish then the CMD file in Citrix management instead of the CCR.EXE file.

Create a reg file with below contents, name it excelchange.reg

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options]

“OPEN”=”\”C:\\Program Files (x86)\\IBM\\IBM Cognos Controller\\ControllerXL.xll\””

Create a cmd file with below contents, name it startcognos.cmd

regedit.exe /s c:\excelchange.reg

C:\Progra~2\ibm\IBMcog~1\ccr.exe

Exit

The cmd file will call the reg file and import the values into the users HKEY_CURRENT_USER and then there after start the Cognos Controller client program.

Drawback is that the DOS windows is always visible for the Cognos Controller user in the background.

Maybe you have a solution to hide it on the citrix server with the command ctxhide.exe?

http://citrix-xenapp.blogspot.com/2013/01/what-is-ctxhide.html

Product:
Cognos Controller 10.1.1
Windows 2008 R2 Server
Citrix server

Symptom:
User can not log in to Cognos controller. He have been able to do this before.
The user name is part of the Controller User group inside Cognos Connection.
Check if the user have two different windows accounts in the company domain that he can use ?

Error message in Swedish:
Log On IBM Cognos Controller
IBM Cognos-programvara
Det gick inte att autentisera. Det går inte att komma åt IBM Cognos med angivet kreditiv. Kontakta administratören.

Solution:
The user have two windows account to two different domains at the company.
When he start the Citrix session he enters the windows user to use, but select the wrong user who is not part of the Cognos Controller user group.
If he log off Citrix
and start Citrix session again,
and login with the username and domain from the other windows domain
he succeeds.

Product:

IBM Cognos Controller 10.1.1

Windows 2008 R2

Problem:

How do i change the startup picture when I start the Cognos Controller program locally?

I want the company logo to be incorporated in this flash picture.

Solution:

On client or Citrix server go to folder.

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

Open file CCRSplash_en-GB.jpg in mspaint program.

Draw or past in the company logo into the picture.

Save the file.

The file CCRSplash_en-GB.jpg is only used when you have selected ENGLISH as language in Cognos controller configuration.

That settings is stored in the CCR.exe.config file as:

<add key=”Language” value=”2057″/>

If you want to update the picture for SWEDISH users you should edit the CCRSplash_sv-SE.jpg file.

If you want to update the picture on the server for people who start Cognos controller direct from the webserver url, then you should edit the file in folder C:\Program Files (x86)\ibm\cognos\c10\webcontent\ccr

Product:

IBM Cognos Controller 10.1.1

Windows 2008 R2

Symptom:

When you run a standard report in Cognos Controller client program you get a error.

User Rights and Security Group Reports:

<Message Name=”CCLMessage” File=”qemsgs” Severity=”Error” Nesting=”0″ ><MessageComponents ID=”0x35d88fc3″ ><MessageParms><MessageParm Name=”CCLMessageParm” Type=”string” Value=”SQLOLEDB.1:WIN2008:controllerlive:cognos” /></MessageParms></MessageComponents></Message>

Detaljer

RSV-SRV-0042 Spåra bakåt:RSReportService.cpp(722): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(263): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(808): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(260): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(864): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_RequestExecution/RSRenderExecution.cpp(670): QFException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(291): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): QFException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(358): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(179): QFException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(308): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageSetAssembly.cpp(462): QFException: CCL_RETHROW: RSPageSetAssembly::assembleAssembly/RSAssembly.cpp(662): QFException: CCL_RETHROW: RSAssembly::createListIteratorAssembly/RSAssembly.cpp(717): QFException: CCL_RETHROW: RSAssembly::createListIteratorRSQueryMgr.cpp(1055): QFException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(1131): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(1295): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgr.cpp(1569): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgr.cpp(1559): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(168): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHandlerImpl.cpp(160): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()QFSSession.cpp(1147): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1145): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1102): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1078): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(788): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(213): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(2024): QFException: CCL_RETHROW: QECoordinationQFSQuery.cpp(4350): QFException: CCL_RETHROW: CoordinationQFSQuery::CallProviderQFSQuery.cpp(246): QFException: CCL_RETHROW: QFSQuery::EXecute v3Source/RQP_QFSQuery.cpp(492): QFException: CCL_RETHROW: QESource/QE_RsApi.cpp(3604): QFException: CCL_RETHROW: QESource/AQEX_TabularQueryVisitor.cpp(333): QFException: CCL_RETHROW: QESource/QEI_ConnectionFault.cpp(985): QFException: CCL_THROW: QE

Cause:

You have not a data source connection inside Cognos Connection to your Cognos Controller database.

Solution:

Start Cognos Controller Configuration.

Go to Report Server dialog.

Click OK on any information messages.

Click on the green Check icon.

Click on the Repair button to update the Cognos Connection.

Start the Controller Client and test the report again.

You must be logged in to the Windows server with a user account that is System Administrator in Cognos Connection to make the Repair button work.

Product:
Cognos Controller 10.1.1 FP2 (version 10.1.2155)
Windows 2008 R2 server

Symptom:
When user go to dialog Users they get a error message after some time.
Start Cognos Controller client and go to maintain – rights – users dialog.
If you click on a user in the list to the left then you will see that the CAM user field is blank.

Error message:
The user currently logged in is not authorized to use this method.

Cause:
There are doublets of the same user in the AD groups connected to the Cognos connection group Controller Users. This is not a issue in previous versions of Cognos Controller 8.

Solution:
Remove the user that is giving the issue from the Active Directory group you are using.

You can use “Active Directory Users and Computers” on a Domain Controller server to see the users that are part of the different AD groups.
Click on RUN from the Start menu on a Microsoft Windows 2008 server.
Enter DSA.MSC and click OK
If you get message “Windows cannot find dsa.msc. Make sure you typed the name correctly, and then try again” then the role “Active Directory Domain Services” is not installed on that computer.
Check with your local IT department if you can install it on the Server to have access to the tool.

Normally you add the users that should use Cognos Controller to a AD group – ControllerUsers.
If you have more than one domain, you may create a ControllerUsers AD group in each domain.
Then you add users from each domain to these groups.
If a user , KALLE, have a windows account in both domains, he can end up in both groups.
So user EU\KALLE in one group and user STHLM\KALLE in the other group.
Both ControllerUsers group are then added to the cognos group Controller Users inside Cognos Connection.
This will work, the users can login, but you can not add new users to the Cognos Controller User dialog.
You can only have ONE KALLE user in any of the AD groups that are used in the Controller User group inside Cognos Connection.
Remove one user at a time to find the bad one from the AD group ControllerUsers.
You need to exit and login to Cognos Controller Client between every change to test if it works.

Product:
Cognos Controller 10.1.1
Windows 2008 R2 server

Symptom:
Error when you try to import a deployment package to the Content Store from Cognos Connection website in Internet Explorer.

This can happen when you try to import a old deployment file from Cognos 8 to Cognos 10.

Error message:
Illegal InvalidCacheEntry method was called

Possible Solution:
If you click the OK button, it will came up to the results of the import
which was completely successful with no apparent errors produced.

The import choices made were all standard, and “Upgrade all report
specifications” was selected on the last prompt of the import process.

Restart the Internet Explorer browser, and clear the IE cache, will help solve the issue.
The next time you may not have the same issue.

Can also be specific for some web browsers, so try Firefox instead of internet Explorer if that is possible on your client computer.

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.