Product:
Cognos Controller 10.4
https://www-01.ibm.com/support/docview.wss?uid=ibm10735239
Microsoft Windows 2016 Server

Problem:
After upgrade to a later version of Cognos Controller 10.4, where also BI 10 have been replaced by CA11, the PDF shown inside Cognos Controller client is small. HTML reports works fine.

Solution:
The user profile of the user executing the report is referencing a style (also known as skin) from IBM Cognos Business Intelligence 10.

In IBM® Cognos® Analytics, in the lower-left corner, click icon for administration, select Administration Console.
On the Security tab, click Users, Groups, and Roles.
Click the namespace that contains the user.
Find the user whose preferences you want to view or change. You can use the Search feature to find a user Searching for entries using name, description, and name or description.
For that user – in the Actions column, click More.
Click Set preferences.
Click the different tabs to view or change the settings.
In the Preferences tab, choose Style Corporate.
Make the change and click OK.

Test again to run a report in Cognos Controller as PDF.

More Information:
https://www-01.ibm.com/support/docview.wss?uid=ibm10739581
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cra.doc/t_viewchange_userprofile.html

Product:
Cognos Controller 10.4
Microsoft Windows 2016 server

Problem:
When doing currency conversation in a consolidation you get a error “ActiveX component can’t create object”.

When you check the Windows event log you find a error similar to this:
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{4DAC0D14-D942-47CD-9A74-CBFC5BBFA14E}
and APPID
{6591F1B8-A9EF-45FA-A403-2850BD72D910}
to the user DOMAIN\USERNAME SID (S-1-5-21-55472620-132315974-3481569866-49656) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Service

Suggested Solution:
Login to the Cognos Controller Window server.
Go into IIS Manager
Go to the application pools.
Select the application pool for controller, can be NET v4.5 or Controller (depending what you have named it), and click advanced settings.

Under Process Model, change Identity from ApplicationPoolIdentity to LocalSystem.
Also ensure the Idle Time-out is 600 minutes, and not the default 20 minutes.
Click OK
Restart the IIS service.


You need also go into Controller Configuration
Change COM+ server to us Local System Account
Save the changes.

Retry the currency conversation.

More information:

https://www-01.ibm.com/support/docview.wss?uid=swg21608353
https://www-01.ibm.com/support/docview.wss?uid=swg21347488
https://www-01.ibm.com/support/docview.wss?uid=swg21459682

Product:
Cognos Controller 10.3.1
Microsoft Windows 2012 R2 server

Problem:
Cognos Controller Users are disconnected from Server, and have to start there Cognos Controller client again and login.

Suggested Solution:
Change the Recycle from default 29 hours to a specific time at night, when few users are using Cognos Controller.

Login to the Cognos Controller Server.
Open Internet Information Services (IIS) Manager
Click on Applications Pools
Click on DefaultAppPool or the one created for Controller.
On the right side click on Recycle…


Unmark the default of 1740 minutes intervals.
Mark Specific times
Enter 3:00 AM


Click Next


Click Finish.

Let the user test Cognos Controller more than a day before you define if this solve your issue.

More information:
https://www-01.ibm.com/support/docview.wss?uid=swg21990348
https://www-01.ibm.com/support/docview.wss?uid=swg21969315

Product:
Cognos Controller 10.3.1
CONTRL_version=CCR-AW64-ML-RTM-10.3.1100.216-0
CONTRL_name=IBM Cognos Controller
Microsoft Windows 2012 R2 Server
Microsoft SQL 2012 database server

Problem:
How setup a dedicated server that will only run the schedules consolidation jobs?

Suggested solution:
Install complete CA11 (Cognos Bi) on the main server, and get it working.
Install complete Cognos Controller 10.3.1 on the main server and get it working.
Instructions on how
https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=3&ved=2ahUKEwjQsKjir4XdAhUJOpoKHU2qCucQFjACegQICBAC&url=https%3A%2F%2Fwww-01.ibm.com%2Fsupport%2Fdocview.wss%3Fuid%3Dswg21608353%26aid%3D1&usg=AOvVaw2dMBi4aGy__1hcdEVBaXU6

On the secondary server, that should only do controller schedule jobs.
Install the prerequisite components like IIS and SQL drivers.
Download SQLNCLI from here https://www.microsoft.com/en-us/download/details.aspx?id=50402

Install main Cognos Controller 10.3.1 on this secondary server.
Copy the SQL driver sqljdbc42.jar file to folder c:\program files\ibm\cognos\ccr_64.
Configure Controller Configuration to have one database connection to your main controller database. This will create the DATA folder.
Copy the UDL files from the main controller server to the consolidation server in folder c:\program files\ibm\cognos\ccr_64\data.
Configure Controller Configuration to COM+ server setup, as of documentation.
Start the Batch Service in Controller Configuration.
Enter the url to the first server, as Report Server values;
Report server:
http://firstservername.domain.com/ibmcognos/bi/v1/disp
Dispatcher URI:
http://firstservername.domain.com:9300/p2pd/servlet/dispatch

Check that all the Cognos Controller services are installed.
Set IBM Cognos FAP Service and IBM Cognos Controller User Manager to Disabled.

controllerservices

Disable the IBM Cognos Controller Batch Service on the main controller server.
Check that IBM Cognos Controller Consolidation in Component Services is running when you do a scheduled consolidation.

If you do not have “IBM Cognos Controller User Manager” running on the same server where you have “IBM Cognos Controller Batch Service running”, then you can not schedule optimization of the Controller database – only schedule consolidation jobs.

Load balance as describe below, is not used in above setup;
http://www-01.ibm.com/support/docview.wss?uid=swg21677206

IBM Cognos Controller Web is manually installed in above picture, on this consolidation server. http://www-01.ibm.com/support/docview.wss?uid=swg22014043

Product:
Cognos Controller 10.3.1 (version 10.3.1100.166)
Cognos Analytics 11.0.8.11
Microsoft Windows 2012 R2 Server

Problem:
After upgrade of Cognos Controller Client on Citrix server, the help menu does not work.

Error message:
Error Launching menu item “Help”.
Could not find a part of the path ‘c:\program files (x86)\IBM\IBM Cognos Controller\ctrl_ug_fapug_contectlinks.csv’.
at system.Net.FileWebRequest.EndGetResponse(IAsyncResultasyncResult) at…

Possible solution:
The file ccr.exe.config contain the wrong path. Open C:\Program Files\ibm\IBM Cognos Controller Local Client\ccr.exe.config in notepad.
Change the value

<add key=”CASUrl” value=”C:\Program Files (x86)\IBM\IBM Cognos Controller\”/>

to

<add key=”CASUrl” value=”C:\Program Files\ibm\IBM Cognos Controller Local Client\”/>

Save the file and try again.
Check also that <add key=”HelpUrl” value=”http://www.ibm.com/support/knowledgecenter“/>  point to the correct web address.

Example of the ccr.exe.config file:

<?xml version=”1.0″ encoding=”utf-8″?>
<!–
IBM SOURCE CODE HEADER START
# =====================================================================
# IBM Confidential
#
# OCO Source Materials
#
# IBM Cognos Products: ccr
#
# (C) Copyright IBM Corp. 2004, 2014
#
# 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
–>
<configuration>

<configSections>
<sectionGroup name=”profile”>
<section name=”Settings” type=”System.Configuration.NameValueSectionHandler, System, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, Custom=null”/>
</sectionGroup>
<section name=”log4net” type=”log4net.Config.Log4NetConfigurationSectionHandler, log4net” requirePermission=”false”/>
</configSections>
<profile>
<Settings>
<add key=”SelectDb” value=”true”/>
<add key=”Language” value=”2057″/>
<add key=”CASUrl” value=”C:\Program Files\IBM\IBM Cognos Controller Local Client\”/>
<add key=”WSSUrl” value=”http://servername/ibmcognos/controllerserver”/>
<add key=”HelpUrl” value=”http://www.ibm.com/support/knowledgecenter”/>
<add key=”InstallExcelLink” value=”false”/>
<add key=”CacheDir” value=””/>
</Settings>
</profile>
<system.web>
<webServices>
<soapExtensionTypes>
<add type=”ClientExtension, ControllerExtension” priority=”0″ group=”0″/>
</soapExtensionTypes>
</webServices>
</system.web>

<log4net>
<root>
<level value=”ERROR”/>
<appender-ref ref=”CCRClient”/>
</root>
<appender name=”CCRClient” type=”log4net.Appender.FileAppender”>
<staticLogFileName value=”false”/>
<file type=”log4net.Util.PatternString”>
<conversionPattern value=”${LOCALAPPDATA}\CCRClientLogs\%date{MM_dd_yyyy}.txt”/>
</file>
<appendToFile value=”true”/>
<layout type=”log4net.Layout.PatternLayout”>
<conversionPattern value=”%date %-5level %logger – %message%newline”/>
</layout>
</appender>
</log4net>

</configuration>
Then in the users profile, check the same values are correct, in the file /appdata/roaming/cognos/ccr/ccr.config.

Product:
Cognos Controller 10.3.1
Microsoft Windows 2016 Server
Cognos Analytics 11.0.9

Issue:
Standard reports in Cognos Controller does not work.

Possible solution:
You have to manually change the database connection string from SQLOLEDB to Native SQL.

Surf to Cognos Connection.
Go to old Administration page.
Go to Data Source.
Go to Set Properties for the connection.
Change the value and save it.

The Cognos Datasource connection string that is automatic created from Cognos Controller Configuration repair button creates non-supported data connections in CA11.
ca11 databas kopplingar

Above is the supported data sources in Cognos Analytics 11.

Product:
Cognos Controller 10.3.1
Microsoft Windows 2008 R2 server
Microsoft SQL database
Cognos Analytics 11.0.8

Issue:
When logging in to Cognos Controller 10.3.1 after a new setup some users get a error.
This setup is with 3 citrix servers and 3 controller application servers, where the controller functions is scaled out over the different controller application servers. On each citrix server the ccr.exe.config file point one of the controller application servers – to allow some kind of load balance to the controller applications server layer.
This is setup from this instructions:
http://www-01.ibm.com/support/docview.wss?uid=swg21677206

Error message:
Error occured at 3/22/2018 8:18:10 AM in IBM Cognos Controller, Error No=5, Source=FrangoDirect.ConnectionDirect.SetSelectDb#System.Web.Services, Description=System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.Net.WebException: The request failed with HTTP status 404: Not Found.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at CCRRemoteServerProxy.Proxy.FrServerB.WSFrServerB.ConnectionBusiness_SetSelectDb(String sGuid, String sUser, Boolean bSelectDb)
at FrServerB.RemoteConnectionBusiness.SetSelectDb(String sGuid, String sUser, Boolean bSelectDb)
at FrServerB.ConnectionBusiness.SetSelectDb(String sGuid, String sUser, Boolean bSelectDb)

Possible solution:
The web.config file have not a correct servername for the ccrRemoteServer value, it can be a extra special character or something that make the “http” string not work. Test the string in Internet Explorer from the slave server – can it surf to the master server?

Enter this to get a response:
http://masterserver/ibmcognos/controllerserver/ccrws.asmx

If above does not solve it – check that you can from the client and server surf to;
http://masterserver/ibmcognos
http://caservername/ibmcognos

If you have CA11 on the same server as your cognos controller installation, then the caservername and masterserver is the same address.

The key setup point for more controller application servers is this;

On the Slave server:

  • Browse to the ‘ControllerProxyServer’ folder (by default, this is located here: C:\Program Files\ibm\cognos\ccr_64\ControllerProxyServer)
  • Open the file ‘web.config’ inside Notepad.exe
  • Locate the section ‘<appSettings>’
  • Add the following entry, inside that section:
        <add key=”ccrRemoteServer” value=”

http://MASTERSERVER/ibmcognos/controllerserver

      ” />

Naturally, modify the value ‘MASTERSERVER’ with the name of your ‘master’ application server.

https://www.ibm.com/support/knowledgecenter/SS9S6B_10.3.1/com.ibm.swg.ba.cognos.ctrl_inst.10.3.1.doc/t_ctrl_loadballacing.html

Product:
Cognos Controller 10.3.1
Microsoft Windows 2008 R2 Server
Cognos Analytics 11.0.8

Issue:
After installation of a interim fix on top of a Cognos Controller 10.3 installation, some of the Cognos Controller windows services are missing.

Solution:
Here instructions on how to install a upgrade, on top of Cognos Controller.
http://www-01.ibm.com/support/docview.wss?uid=swg22001683

After the installation check that all Cognos windows services are in place.
ctrl1

If your are missing IBM Cognos Controller Java Proxy you should run this line from cmd:
sc create “IBM Cognos Controller Java Proxy” binpath= “d:\Program Files\ibm\cognos\ccr_64\server\CCRProxy.exe” DisplayName= “IBM Cognos Controller Java Proxy” depend= RpcSs start= demand

if you are missing IBM Cognos Controller User Manager you should run this line from cmd:
sc create frLicServer binpath= “d:\Program Files\ibm\cognos\ccr_64\server\FrLicServer.exe” DisplayName= “IBM Cognos Controller User Manager” depend= RpcSs start= auto

More Information:
http://www-01.ibm.com/support/docview.wss?uid=swg21680801
http://www-01.ibm.com/support/docview.wss?uid=swg21680788

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

Product:
Cognos Controller 10.3.1
Microsoft Windows 2012 R2 Server

Issue:
Error when you try to login to Cognos Controller client, after you have selected the database to use, and you have been logged in as a CAM user.

Error message:
System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.Exception: invalid_user

at Cognos.Controller.Proxy.SoapExtension.ServerExtension.ValidateCAMUser(SoapMessage& message)

at Cognos.Controller.Proxy.SoapExtension.ServerExtension.ProcessMessage(SoapMessage message)

at System.Web.Services.Protocols.SoapMessage.RunExtensions(SoapExtension[] extensions, Boolean throwOnException)

at System.Web.Services.Protocols.SoapServerProtocol.CreateServerInstance()

at System.Web.Services.Protocols.WebServiceHandler.Invoke()

at System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()

— End of inner exception stack trace —

at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object Source, Object Description, Object HelpFile, Object HelpContext)

at Cognos.Controller.Common.RaiseErrCli.RaiseError(Int32 lErrNo, String sErrSource, String sErrDesc, String sErrHelpFile, Int32 lErrHelpContext)

at Cognos.Controller.Direct.ServerInfoD.GetServerInfo()

at CCR.AppContext.InitServerInfo()

at CCR.AppContext.Login()

Solution:
Login to your windows computer as a user who have rights to use Cognos Controller.
Then it will work. This user is not added inside Cognos controller, and therefor can not login.

Other solutions:
http://www-01.ibm.com/support/docview.wss?uid=swg21692450

Product:
Cognos Controller 10.3.1
Microsoft Windows 2012 R2 Server

Issue:
An error occurred while trying to access the server when you start the Cognos Controller client and try to login.

Error message:
System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.ArgumentException: Requested registry access is not allowed.

at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object Source, Object Description, Object HelpFile, Object HelpContext)

at ControllerServerCommon.RaiseErrSrv.RaiseError(String sUser, Int32 lErrNo, String sErrSource, String sErrDesc, String sErrHelpFile, Int32 lErrHelpContext)

at FrServerB.LocalConnectionBusiness.SetSelectDb(String sGuid, String sUser, Boolean bSelectDb)

at FrServerB.ConnectionBusiness.SetSelectDb(String sGuid, String sUser, Boolean bSelectDb)

— End of inner exception stack trace —

at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object Source, Object Description, Object HelpFile, Object HelpContext)

at Cognos.Controller.Common.RaiseErrCli.RaiseError(Int32 lErrNo, String sErrSource, String sErrDesc, String sErrHelpFile, Int32 lErrHelpContext)

at Cognos.Controller.Direct.ConnectionDirect.SetSelectDb(Boolean bSelectDb)

at CCR.AppContext.SelectDb()

at CCR.AppContext.Login()

Solution:
In the IIS manager change the user account used by the Application pool that Controllerserver is using.

Start Internet Information Servers Manager
Go to Application pools
Select NET v4.5
Click on Advance Settings
Change Application pool identity to LocalSystem from ApplicationPoolIdentity
Click OK
Restart IIS services.

More information:
http://www-01.ibm.com/support/docview.wss?uid=swg21691747