Product:

Cognos Controller 10.1

Windows 7

Symptom:

How do I uninstall Cognos controller client from my computer ?

So I can install a new version of Cognos controller client.

Solution:

Log on the computer

Go to control panel

Go to program and features

Find Cognos Controller Client in list

Click to uninstall the program

Remove this folders (if they exist).

c:\program files (x86)\cognos\ccr\

%appdata%\cognos\ccr

%localappdata%\VirtualStore\Program Files (x86)\cognos\ccr\

Reboot client computer

Turn off the UAC (user access controller) in control panel

Install the Cognos Controller client from the dos-prompt,

Select CMD from start menu, and right click and select “Run As Administrator”

Change to the folder where you have copied the MSI file locally.

Then enter this to start the installation

msiexec /i CCRLocalClient.msi

Answer the questions with the appropriate server name.

http://servername.domain.com/ibmcognos/controllerserver

Do not select a cache folder.

Unzip the Integration.zip and jre.zip files in the C:\Program Files\cognos\ccr directory.

 

More information on how to install Cognos Controller

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

http://pic.dhe.ibm.com/infocenter/cfpm/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ctrl_inst.10.1.0.doc%2Fctrl_inst_id4389remote_Excel_add-in_single.html

More information on what type of Cognos controller clients there are

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

Product:

Cognos Contoller 10.1.1

Windows 2008 R2 Server

Oracle 11g

Symptom:

New installation of Cognos controller 10, to be used with Oracle database.

When click connect in Cognos Controller DBCONV program you get a error message.

Error message:

** ERROR: java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 50

** ERROR: java.sql.SQLRecoverableException: IO-Fel: could not resolve the connect identifier

 

Solution:

Change the tnsnames.ora file for the oracle client on the Cognos Controller server.

Ensure the tnsnames.ora file only contain the values for the cognos controller database, not reference to other oracle schema or databases.

Ensure the information is written in several lines, as shown below, and not in a single line in the tnsnames.ora file.

FRANGO=  (DESCRIPTION=    (ADDRESS=(PROTOCOL=TCP)(HOST= SERVERNAME.DOMAIN.COM)(PORT=1521) )   (CONNECT_DATA= (SERVICE_NAME=service_name)))

Replace italic above with the schema/oracle server name.

 

More information

http://pic.dhe.ibm.com/infocenter/cfpm/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ctrl_inst.10.1.0.doc%2Fctrl_inst_id311UpdatedinstallationinstructionsforCreateanIBMCogno.html

http://docs.oracle.com/cd/B28359_01/network.111/b28317/tnsnames.htm

Product:

Cognos Controller 10.1.1

Windows 2008 R2 Server

Oracle database

Symptom:

New installation of Cognos Controller 10.1.1. When user select maintain – jobs – define menu, they get a error message after some time.

Problem message:

Could not create the view: !Could not create controller of type com.ibm.cognos.ccr.integration.internal.job.ui.JobDialogDefinitionViewController for composite class com.ibm.cognos.ccr.integration.internal.job.ui.JobDialogDefinitionUI!

java.lang.reflect.InvocationTargetException

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:44)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:516)

at com.ibm.cognos.ccr.core.ui.databinding.widgets.AbstractControllableComposite.createController(AbstractControllableComposite.java:67)

at com.ibm.cognos.ccr.core.ui.databinding.widgets.AbstractControllableComposite.getController(AbstractControllableComposite.java:58)

at com.ibm.cognos.ccr.core.ui.view.AbstractViewPart.initializeController(AbstractViewPart.java:547)

at com.ibm.cognos.ccr.core.ui.view.AbstractViewPart.initializeController(AbstractViewPart.java:490)

at com.ibm.cognos.ccr.integration.internal.job.ui.JobDialogDefinitionView.createPartControl(JobDialogDefinitionView.java:55)

at org.eclipse.ui.internal.ViewReference.createPartHelper(ViewReference.java:375)

at org.eclipse.ui.internal.ViewReference.createPart(ViewReference.java:229)

at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:595)

at org.eclipse.ui.internal.PartPane.setVisible(PartPane.java:313)

at org.eclipse.ui.internal.ViewPane.setVisible(ViewPane.java:534)

at org.eclipse.ui.internal.presentations.PresentablePart.setVisible(PresentablePart.java:180)

at org.eclipse.ui.internal.presentations.util.PresentablePartFolder.select(PresentablePartFolder.java:270)

at org.eclipse.ui.internal.presentations.util.LeftToRightTabOrder.select(LeftToRightTabOrder.java:65)

at org.eclipse.ui.internal.presentations.util.TabbedStackPresentation.selectPart(TabbedStackPresentation.java:473)

at org.eclipse.ui.internal.PartStack.refreshPresentationSelection(PartStack.java:1245)

at org.eclipse.ui.internal.PartStack.setSelection(PartStack.java:1198)

at org.eclipse.ui.internal.PartStack.showPart(PartStack.java:1597)

at org.eclipse.ui.internal.PartStack.createControl(PartStack.java:643)

at org.eclipse.ui.internal.PartStack.createControl(PartStack.java:570)

at org.eclipse.ui.internal.PartSashContainer.createControl(PartSashContainer.java:568)

at org.eclipse.ui.internal.PerspectiveHelper.activate(PerspectiveHelper.java:272)

at org.eclipse.ui.internal.Perspective.onActivate(Perspective.java:981)

at org.eclipse.ui.internal.WorkbenchPage.onActivate(WorkbenchPage.java:2714)

at org.eclipse.ui.internal.WorkbenchWindow$27.run(WorkbenchWindow.java:3023)

at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)

at org.eclipse.ui.internal.WorkbenchWindow.setActivePage(WorkbenchWindow.java:3004)

at org.eclipse.ui.internal.WorkbenchWindow.busyOpenPage(WorkbenchWindow.java:799)

at org.eclipse.ui.internal.Workbench$23.runWithException(Workbench.java:1224)

at org.eclipse.ui.internal.StartupThreading$StartupRunnable.run(StartupThreading.java:31)

at org.eclipse.swt.widgets.Synchronizer.syncExec(Synchronizer.java:180)

at org.eclipse.ui.internal.UISynchronizer.syncExec(UISynchronizer.java:150)

at org.eclipse.swt.widgets.Display.syncExec(Display.java:4683)

at org.eclipse.ui.internal.StartupThreading.runWithWorkbenchExceptions(StartupThreading.java:50)

at org.eclipse.ui.internal.Workbench.busyOpenWorkbenchWindow(Workbench.java:1220)

at org.eclipse.ui.internal.Workbench.access$31(Workbench.java:1196)

at org.eclipse.ui.internal.Workbench$58.run(Workbench.java:2215)

at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)

at org.eclipse.ui.internal.Workbench.openWorkbenchWindow(Workbench.java:2212)

at com.ibm.cognos.ccr.core.ui.util.WorkbenchUtil.openPerspective(WorkbenchUtil.java:685)

at com.ibm.cognos.ccr.integration.application.internal.IntegrationServiceImpl$MyPerspectiveOpener.openNewPerspective(IntegrationServiceImpl.java:136)

at com.ibm.cognos.ccr.integration.application.internal.IntegrationServiceImpl$MyPerspectiveOpener.run(IntegrationServiceImpl.java:112)

at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)

at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:135)

at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4140)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3757)

at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2696)

at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2660)

at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2494)

at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:674)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:667)

at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)

at com.ibm.cognos.ccr.integration.application.internal.IntegrationApplication.start(IntegrationApplication.java:85)

at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)

at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:144)

at java.lang.Thread.run(Thread.java:736)

Caused by: com.ibm.cognos.ccr.common.InvalidContextException: !Could not load model: job!

at com.ibm.cognos.ccr.integration.application.AbstractLifeCycleManager.getModel(AbstractLifeCycleManager.java:235)

at com.ibm.cognos.ccr.integration.application.AbstractLifeCycleManager.<init>(AbstractLifeCycleManager.java:100)

at com.ibm.cognos.ccr.integration.application.AbstractLifeCycleManager.<init>(AbstractLifeCycleManager.java:89)

at com.ibm.cognos.ccr.integration.application.ValidatingLifeCycleManager.<init>(ValidatingLifeCycleManager.java:47)

at com.ibm.cognos.ccr.integration.application.views.AbstractDialogController.<init>(AbstractDialogController.java:91)

at com.ibm.cognos.ccr.integration.internal.job.ui.JobDialogDefinitionViewController.<init>(JobDialogDefinitionViewController.java:39)

… 63 more

Caused by: com.ibm.cognos.ccr.common.NoSuchModelException: !Unable to find instance of model of type: job[JobModel]!

at com.ibm.cognos.ccr.common.DefaultModelContext.throwNewNoSuchModelException(DefaultModelContext.java:422)

at com.ibm.cognos.ccr.common.DefaultModelContext.getModelByIdentifier(DefaultModelContext.java:396)

at com.ibm.cognos.ccr.common.DefaultModelContext.getModel(DefaultModelContext.java:255)

at com.ibm.cognos.ccr.integration.application.AbstractLifeCycleManager.getModel(AbstractLifeCycleManager.java:233)

… 68 more

Caused by: com.ibm.cognos.ccr.common.WebServiceConnectionException: exceptionId=ERR.ANY.WEBSERVICECONNECTIONEXCEPTION.CANNOT_EXECUTE_SERVICE, argument(s)=[FAIL:!Array index out of range: 50!, http://servername/ibmcognos/cgi-bin/cognosisapi.dll?t=controller, ?]

at com.ibm.cognos.ccr.ccrws.JAXWSClient.executeTask(JAXWSClient.java:107)

at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.executeTask(RemoteDao.java:91)

at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.getLatestSequenceNumber(RemoteDao.java:63)

at com.ibm.cognos.ccr.common.persistence.caching.CachingDao.getLatestSequenceNumber(CachingDao.java:78)

at com.ibm.cognos.ccr.common.persistence.caching.CachingDao.isUpToDate(CachingDao.java:175)

at com.ibm.cognos.ccr.common.persistence.caching.CachingDao.load(CachingDao.java:90)

at com.ibm.cognos.ccr.common.AbstractModel.load(AbstractModel.java:572)

at com.ibm.cognos.ccr.common.AbstractModel.load(AbstractModel.java:562)

at com.ibm.cognos.ccr.common.AbstractModelFactory.getNewModel(AbstractModelFactory.java:74)

at com.ibm.cognos.ccr.common.AbstractModelFactory.getNewModel(AbstractModelFactory.java:66)

at com.ibm.cognos.ccr.common.DefaultModelContext.getModelByIdentifier(DefaultModelContext.java:394)

… 70 more

Caused by: java.lang.RuntimeException: MTsxMDE6MjM4ZmZkZWUtZDdhMC1hZTc5LTI1MDQtMjEyYjQ5MTJjNzQwOjMzNDkxMjM0OTQ7MDszOzA7

at com.ibm.cognos.ccr.common.WebServiceConnectionException.<init>(WebServiceConnectionException.java:65)

at com.ibm.cognos.ccr.common.WebServiceConnectionException.<init>(WebServiceConnectionException.java:52)

… 81 more

 

Cause:

The tnsnames.ora file is to large for Cognos Controller to use.

Solution:

Create a smaller tnsnames.ora file and place in a separate folder on the controller server, for example d:\oracle.

Make the tnsnames.ora file only contain the information for the Cognos Controller database, and no other oracle database or oracle schemas.

 

Then update the ccr-system-properties.properties file, often located in folder, c:\Program Files (x86)\Cognos\C8\Server\integration.

 

# IBM SOURCE CODE HEADER START

# =====================================================================

# OCO Source Materials

#

# BI and PM: ccr

#

# (C) Copyright IBM Corp. 2004, 2009. All Rights Reserved

#

# The source code for this program is not published or

# otherwise divested of its trade secrets, irrespective of

# what has been deposited with the U.S. Copyright Office.

# =====================================================================

# IBM SOURCE CODE HEADER END

# User defined System properties

# Oracle Network admin directory path, the location of the TNSNAMES.ORA file

oracle.net.tns_admin=D:\\oracle

You must reboot the Controller server to make changes to file ccr-system-properties.properties take affect.

More Information:

http://pic.dhe.ibm.com/infocenter/cfpm/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ctrl_inst.10.1.0.doc%2Fctrl_inst_id311UpdatedinstallationinstructionsforCreateanIBMCogno.html

Product:

Cognos Controller 10.1.1

Microsoft Windows 2008 R2 server

Citrix server

Symptom:

Cognos Controller client program is slow to start. The citrix server that run the Cognos Controller client have no access to internet. When checking the Internet Explorer settings for  “Check for publisher’s certificate revocation” it is marked. Removing the mark, makes the program start faster.

 

Solution:

You can force the setting in Internet explorer for the user by create a power shell script, and then make it run before the users starts the cognos controller client on the citrix server.

Below a example of a script to update the registry:

# Change registry key to uncheck IE security setting: “Check for publisher’s certificate revocation”

Push-Location

  Set-Location “HKCU:\Software\Microsoft\Windows\CurrentVersion\WinTrust\Trust        Providers\Software Publishing”

Set-ItemProperty . State “dword:00023e00”

Pop-Location

 

More information:

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

Product:

Cognos Controller 10.1.1

Microsoft Excel 2007

Windows 2008 R2 Server

Citrix server

Symptom:

When user run a standard report in Cognos Controller, and select to view the report in Microsoft Excel 2007 ( or Excel 2010) they get a dialog, telling the file content is wrong.

Error message:

“The file you are trying to open, [File_name.xls] is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?”  (Yes | No | Help)

 

Solution:

Excel 2007 introduced the concept of Extension Hardening.  Extension Hardening does checks ahead of time to ensure that the file content matches the extension and, if applicable, the MIME type. The upside of Extension Hardening is that it blocks one vector for malformed Excel content attacks, like Trojans. The downside is that it also breaks the classic ASP method of Excel reporting, and the opening of Cognos Controller reports in Excel.

 

There is no granularity in the setting. Extension Hardening cannot be turned off for some websites or content sources, and on for others. It can only be disabled, enabled with a prompt, or enabled with blocking. Extension Hardening can be controlled during installation by the Office Deployment files, or afterwards by group policy or editing the registry.

 

Registry:

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security]

“ExtensionHardening”=dword:00000000

Possible value settings: Allow different (dword:00000000); Allow different, but warn (dword:00000001); Always match file type (dword:00000002). If the

ExtensionHardening value is not present, Excel defaults to Allow different, but warn.

 

Create a powershell script that is run before the Cognos Controller client program on the citrix server, to set the value off.

This is a example of the script:

Push-Location

If (!(Test-Path “HKCU:\Software\Microsoft\Office\12.0\Excel\Security”))

{

New-Item “HKCU:\Software\Microsoft\Office\12.0\Excel\Security” -force

}

Set-ItemProperty “HKCU:\Software\Microsoft\Office\12.0\Excel\Security” -Name  ExtensionHardening -Value “0” -Type DWORD -force

Pop-Location

 

More information:

http://www.jwgoerlich.us/blogengine/post/2009/08/11/Excel-Extension-Hardening-and-Web-Applications.aspx

Product:
Cognos Controller 10.1
Windows 2008 Server

Problem:
How do I list all the members that are part of a Microsoft Active Directory group ?

Solution:
Log on to a Microsoft Windows 2008 server in the domain.
Start a CMD prompt
Create a temp folder
Go to the temp folder
Enter following command to get a list of users in a AD group:

dsquery group -domain EU -samid citrix_app_cognoscontroller | dsget group -members > cognoscontrollerusers.txt

Replace above EU with your domain name
Replace above citrix_app_cognoscontroller with the AD group you want to list
Replace above cognoscontrollerusers.txt with the name of the text file you want created.

The file is crated in the temp folder, you are standing inside.

To find out if a group exist in your domain you can enter:
dsquery group -samid citrix_app_cognoscontroller

If the group exist in the domain you are, it will print the CN string in AD for that group.

To find out what groups a user are member of you can enter:
dsquery user -samid roger | dsget user -memberof -expand

This will list all Active Domain groups the user “roger” is part of.
Replace above roger with the username you want to check.

Product:
Cognos Controller 10
Windows 2008 R2 server

Problem:
How do i add a new user to a local group on the server from the command line ?

Cause:
Can be needed in testing purpose on a new installation of Cognos software, to see if the issue is because of the windows profiles temp files. Test with a new user can be good.

Solution:
Start CMD as administrator on the Server ( or client computer).

Enter ; to create user mike
NET USER /ADD MIKE

Enter ; to set his password to password
NET USER MIKE PASSWORD

Enter ; to add mike to the local administrator group
NET LOCALGROUP ADMINISTRATORS MIKE /ADD

Enter ; to list users in the local group
NET LOCALGROUP ADMINISTRATORS

Enter ; to start a remote desktop session
MSTSC /v:127.0.0.1 /w:1024 /h:768

/v enter the name of the server or IP
/w set the width of the window
/h set the height of the window

More Information:
http://ss64.com/nt/net_useradmin.html
http://ss64.com/nt/mstsc.html

Product:
Cognos Controller 10.1.1
Windows 2008 server

Symptom:
Can not send mail from inside Cognos Controller client.

Error message:
Email server reported an error, some or all messages could not be sent. Please check with your local administrator that the email server is operational and that the system configuration is correct (connection details can be found in details and or log file).

java.lang.NullPointerException
com.ibm.cognos.ccr.configproperty.EmailSettings.fromURI(EmailSettings.java:70)
…

Cause:
The value for General Configuration – Server Preferences are not filled in for
variable name: C4_EMAIL_SERVER
variable value: mailrelay.domain.se:25

http://pic.dhe.ibm.com/infocenter/cfpm/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.ctrl_ug.10.1.1.doc%2Fc_syparlist.html

Solution:
Start Cognos Controller client
Log in as administrator
Go to Maintain – General Configuration – Server Preferences
Add new variable name C4_EMAIL_SERVER
Add new variable value to your mail server name (FQDN) and include the port number (:25)
Click Save.
All users need to log off Cognos controller to make the change take affect.

Above is for the new dialog boxes in Cognos controller like Group – Command Center.
Where after you have listed the status for a group/company’s on the right side have a icon to send notification email.
To get this to work, the user you logged in with to Cognos Controller must have a valid email address added to its user account information in Cognos controller.

To add email address to user in Cognos Controller client, go to
Maintain – Rights – Users dialog
Click on the user in the list on left side, and add a email address on the right side for the user.
The email address must be allowed by the company email server to send email, often a address that exist inside the company.

If the sending users email address is wrong, you get a error message like this:
Unable to proceed, please address errors listed below.
Cannot send without email address for sender (ADM). Please check system configuration.
…

The mail setting inside Maintain – Configuration – General Configuration
tab general 3 is for all the old mail functions in old controller dialogs.
Here you should also specify the mail server at SMTP server line:
mailrelay.company.se
and select the email format you want to use, recommend CSV.

To test this you can go to Transfer – Export Structures.
Mark E-mail and enter an email address to receive the mail on the line at the right.
Mark what to send, for example Country Structure.
Click RUN icon.
Click CLOSE on message that temp file is created.
Enter the message text and click OK to send the email.

You need to logout from Cognos Controller client, to make any changes take affect from the General Configuration dialog.

Product:
Cognos Controller 10.1.1
Windows 2008 R2 server

Symptom:
Limit memory on Cognos Controller server, how do I tune Cognos Controller system to use less RAM ?

Possible Solution:
The Cognos Controller standard reports use the old CQM report engine, so you can turn off the new DQM report engine in the new Cognos BI that is shipped with Cognos Controller.
This will save you one JAVA session.

Go to Cognos Configuration on your Controller Application server.
Go to Environment
Go to IBM Cognos services
Under Component Properties – set “Query Service Enabled?” to false.
Save settings and restart the Cognos BI services.

In windows task manager you should now only see one JAVA.EXE*32 process instead of two that you had before.
Will save around 343 Mb of RAM from the Controller application server.

Product:

Cognos Controller 10.1.x

Windows 2008 R2 Server

Citrix Xenapps

Symptom:

When user run the a standard report in Cognos controller the application seem to hang.

Can be for reports like group – reconcile – Between Accounts/Opening Balances.

 

Error message in preview of report:

please wait, loading the report.

 

Cause:

You  must have Adobe Reader installed on the Citrix server where you have the Cognos Controller client installed.

When you run a standard report in Cognos Controller – it will in the background start Adobe Reader to prepare to show the report in PDF format, and not only HTML format.

Solution:

Install Adobe Reader on Citrix server.

Also ensure that:

Internet explorer enhanced security settings are turned off  (IE ESC)

That the cognos controller web server is in the local intranet zone in Internet explorer

That internet explorer is the default web browser on the Citrix server.

Microsoft Excel on the Citrix server is of the latest Service pack.

 

Check supported version of Excel here:

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

More about reconcile:

http://publib.boulder.ibm.com/infocenter/c8fpm/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ctrl_ug.8.5.0.doc/ctrl_ug_id14462E1K14_2_ReconcilingbetweenAccountsandOpe.html