by ·0 Comments

Product:
Cognos BI 10.2.2
Microsoft Windows 2012 R2 server

Problem:
When starting the Cognos BI service, it takes long time and we get a error.
[Start Service]
[ ERROR ] CFG-ERR-0106 IBM Cognos Configuration did not receive a response from the IBM Cognos service in the time allotted.
Check that IBM Cognos service is available and properly configured.

In this cbs_start_WebSphereLiberty.logfile the text is:
Wed Apr 26 15:13:27 2017 ERROR t[1a08] CBSSocketCommand failed to connect, CAM error: -12CAM-CRP-0026 The underlying socket: ‘10.151.38.35:9300’ returned an error.10061Could not connect the socket, errno: 0x274d(10061)
Wed Apr 26 15:13:29 2017 INFO t[1a08] CBSBootstrapService testReadyByPingingWin – child processes are not ready, stop trying.

Solution:
The windows service account that run the IBM Cognos service does not have enough rights in the Windows box. IT department have a process that every night they remove accounts direct from the local administrator group. This service account was in there the other day when system was installed. But as of removing it then the Cognos BI process not successfully started.

Ensure that the Cognos BI service account has needed rights on the server.

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

by ·0 Comments

Product:
Cognos TM1 architect 10.2.2
Microsoft Windows 2012 R2 standard server

Problem:
Login dialog when you start TM1 architect, and you have configured it to be SSO to the Cognos BI Cognos Connection.
If you surf to http://cognosBIserver.domain.com/ibmcognos you are automatically logged in.

Login dialog titled : Windows Security

tm1a.exe connecting to biservername.domain.com

User name

Password

…

Solution:
On the computer where you start TM1 architect, go to control panel and internet options.
Go to Security tab.
Select Local Intranet and click on sites button.
Click on advance button.
Enter the URL to the Cognos BI server;
http://biservername.domain.com
Click on Add button.
Click Close.
Click OK.

Restart TM1 architect, and see if the SSO are working.

For SSO to work with TM1 clients and Cognos BI the CAM authentication Bi server must be in local intranet or trusted intranet zone of Internet Explorer on client computer.

by ·0 Comments

Product:
Cognos TM1 10.2.2
Microsoft Windows 2012 R2 standard server

Problem:
When inside TM1 architect try to add a new user (clients – add new client) you get a error message about the CAM. The dialog will not show up.

Possible solution:
The value in the file tm1p.ini for that user is not updated with a URL to the cognos bi server.

You update the TM1S.CFG file for the TM1 server – but this change is not copied to the TM1 architect users.

IntegratedSecurityMode=2
ServerCAMURI=http://biservername:9300/p2pd/servlet/dispatch
ClientCAMURI=http://biservername.domain.com:80/ibmcognos/cgi-bin/cognosisapi.dll
ClientPingCAMPassport=900
CAMPortalVariableFile=portal\variables_TM1.xml

Only new TM1 architect users will get value from file E:\Program Files\ibm\cognos\tm1_64\bin64\tm1p.ini.

You need to close TM1 architect and update this file
C:\Users\%username%\AppData\Roaming\Applix\TM1\tm1p.ini in notepad.

Add values for
AllowImportCAMClients = T
CognosGatewayURI = http://biservername.domain.com:80/ibmcognos/cgi-bin/cognosisapi.dll

save the tm1p.ini file and start the TM1 architect program again.

by ·0 Comments

Product:
Cognos Controller 10.3
Oracle 12c database
Microsoft Windows 2008 R2 Server

Problem:
Standard Error generated when running Multi Period Locking report, and you have not selected a “Use Filter”.

Error message:
“Number: 5
Source: FrangoDirect.PerLockHandler.SelectMultiPerLocks#System.Web.Services
Description: System.Web.Services.Protocols.SoapException:
Server was unable to process request. —> System.InvalidCastException:
Conversion from type ‘DBNull’ to type ‘Date’ is not valid……..”

Possible Solution:
Set a Selected filter when using “Multi Period Locking” and run the report for a specific period.

This is different behavior since Controller version 10.1.1 where this did not give a error.

Other workaround is to enter a date in the column for date in the “Define Submission” dialog in Cognos Controller for all rows.

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

by ·0 Comments

Product:
Cognos Controller 10.3
Oracle 12c database
Microsoft Windows 2008 R2 server

Problem:
Got error in Cognos Controller client when doing a database optimization or run a Reconcile – Intercompany Balances.

Error message:
An unexpected error has occurred

System.ArgumentException: System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.Exception: fgsql c:\program files\ibm\cognos\ccr_64\server\progs\fgsql.prg Error in line 324 Connection handle is invalid. 1466……

Solution:
Only the 64 bit oracle drivers are installed. Install the 32 bit oracle drivers on the Cognos Controller server.
The small calculations component is still 32 bit in the 64 bit version of Cognos Controller. Therefor you must have both 64 bit and 32 bit database drivers installed on the Controller servers.

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

by ·0 Comments

Product:
Cognos Controller 10.3
Microsoft Windows 2012 server

Problem:
At start of cognos controller client, from a new installation, you get a error message.

Error message:
An error occurred while trying to access the server.
http://localhost/ibmcognos/controllerserver

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 Cognos.Controller.ControllerSoapHttpClientProtocol.Invoke(String methodname, Object[] parameters)
at Cognos.Controller.Proxy.Light.WSLight.CheckServerConnection(String sGuid, String sUser)
at Cognos.Controller.Direct.ServerInfoD.CheckServerConnection()
at CCR.AppContext.CheckConnectionToServer()

Solution:
The app folder in IIS for controllerserver was misspelled, recreate the application controllerserver in IIS manager.

by ·0 Comments

Product:
Cognos Analytics 11.0.6
Microsoft Windows 2012 server
DB2 11.1.1 database server

Problem:
How create a content store in DB2?

Solution:
Install Cognos Analytics 11 on the windows server.
Install DB2 11 on the database server, ensure the local administrator is administrator on the db2 database to.

From the DB2 server copy the jar files needed from folder
C:\Program Files\IBM\SQLLIB\java. Place the two files
d2jcc_license_cu.jar
db2jcc4.jar
in folder c:\program files\ibm\cognos\analytics\drivers on the Cognos BI server.

Start Cognos Configuration and setup up the values for the environment.
On the Content Store tab enter the values for the DB2:
database server and port number: Enter ipadress:50000
User id and password: Enter the namn and password you want the schema to have.
Database name: Enter the name of the database you want it to have.

Click save.
Right click on Content store and select “Generate DDL”.
This will create a SQL script you should run on the DB2 server to create the needed database.
Copy the file C:/Program Files/ibm/cognos/analytics/configuration/schemas/content/db2/createDb.sql to the DB2 server.
Place the file in folder c:\install.

On the DB2 server login as Windows administrator.
Start a DB2 Command Windows – Administrator.
Enter this command:
db2 -tvf c:\install\createDb.sql

This will run the steps to create the content store database.
Will be similar to this;

CREATE DATABASE cm AUTOMATIC STORAGE YES ALIAS cm USING CODESET UTF-8 TERRITORY
US COLLATE USING SYSTEM PAGESIZE 8192
DB20000I Kommandot CREATE DATABASE har utförts.
CHANGE DATABASE cm COMMENT WITH ‘IBM Cognos Content Store’
DB20000I Kommandot CHANGE DATABASE COMMENT har utförts.
CONNECT TO cm
Information om databasanslutning
Databasserver = DB2/NT64 11.1.1.1
SQL-användar-ID = ADMINIST…
Lokalt databasalias = CM
UPDATE DATABASE CONFIGURATION USING APPLHEAPSZ 1024 DEFERRED
DB20000I Kommandot UPDATE DATABASE CONFIGURATION har utförts.
UPDATE DATABASE CONFIGURATION USING LOCKTIMEOUT 240 DEFERRED
DB20000I Kommandot UPDATE DATABASE CONFIGURATION har utförts.
CONNECT RESET
DB20000I Kommandot SQL har utförts.
CONNECT TO cm
Information om databasanslutning
Databasserver = DB2/NT64 11.1.1.1
SQL-användar-ID = ADMINIST…
Lokalt databasalias = CM
CREATE BUFFERPOOL cm_08KBP IMMEDIATE SIZE 1000 PAGESIZE 8K
DB20000I Kommandot SQL har utförts.
CREATE BUFFERPOOL cm_32KBP IMMEDIATE SIZE 1000 PAGESIZE 32K
DB20000I Kommandot SQL har utförts.
CONNECT RESET
DB20000I Kommandot SQL har utförts.
CONNECT TO cm
Information om databasanslutning
Databasserver = DB2/NT64 11.1.1.1
SQL-användar-ID = ADMINIST…
Lokalt databasalias = CM
CREATE SYSTEM TEMPORARY TABLESPACE TSN_SYS_cm IN DATABASE PARTITION GROUP IBMTEM
PGROUP PAGESIZE 32K BUFFERPOOL cm_32KBP
DB20000I Kommandot SQL har utförts.

When the database is finish created in DB2 server, then go to the Cognos Analytics 11 server and from inside Cognos Configuration click on START. This will start the Cognos BI service, and connect it to the database and create the tables needed.

The Cognos status will show this for a successful start;
[Launching a JVM using ‘Maximum memory in MB’]
Successfully launched a test JVM with the memory setting of ‘4096’. Note that this does not guarantee that the IBM Cognos service will start and run successfully.

To see which JVM options are based on this setting, view ibmcognos_location/bin64/bootstrap_wlp_.xml and see your JVM documentation for an explanation of those options.

[Archive Local File System Root]
Since the value is empty, the feature is disabled. There is nothing to test.

[Validate mail server properties.]
[ ERROR ] The mail server cannot be reached.

[Archive Local File System Root]
Since the value is empty, the feature is disabled. There is nothing to test.

[Start Service]
21:21:53, ‘LogService’, ‘StartService’, ‘Success’.
21:21:54, CAF-WRN-0010 CAF input validation enabled.
21:21:54, CAF-WRN-0021 CAF Third Party XSS checking disabled.
21:22:06, ”, ‘StartService’, ‘Success’.
21:22:08, CM-SYS-2057 Creating content store tables (schema version 7.0045).
21:22:16, CM-SYS-2215 A Content Manager internal PRECACHEINITACTIONS task started.
21:22:16, CM-SYS-2216 A Content Manager internal PRECACHEINITACTIONS task is complete.
21:22:16, CM-SYS-2093 The Content Manager cache initialization is complete. 1 objects loaded in 0,11 seconds.
21:22:17, CM-SYS-2216 A Content Manager internal POSTINITACTIONS task is complete.
21:22:16, CM-SYS-2215 A Content Manager internal POSTINITACTIONS task started.
21:22:39, CM-SYS-5159 Content Manager is running in active mode.
21:22:39, ‘ContentManagerService’, ‘StartService’, ‘Success’.
21:22:39, CM-SYS-2215 A Content Manager internal CMUPGRADESCRIPT task started.
21:22:41, DPR-DPR-1002 Successfully registered the dispatcher http://winca:9300/p2pd in Content Manager.
21:22:43, ‘idVizService’, ‘StartService’, ‘Success’.
21:23:25, ‘SACamService’, ‘StartService’, ‘Success’.
21:23:24, ‘camAsyncService’, ‘StartService’, ‘Success’.
21:23:27, ”, ‘Run’, ‘Run’.
21:23:34, ‘AnnotationService’, ‘StartService’, ‘ANN DB Validation successful.’.
21:23:34, ”, ‘Run’, ‘Run’.
21:23:36, ‘EventService’, ‘StartService’, ‘NC DB Validation successful.’.
21:23:43, ‘HumanTaskService’, ‘StartService’, ‘HTS DB Validation successful.’.
21:23:49, ‘zipiService’, ‘StartService’, ‘Success’.
21:23:49, ‘PDC’, ‘StartService’, ‘Success’.
21:23:50, ‘PresentationService’, ‘StartService’, ‘Success’.
21:23:51, Start a cgsLauncher because the start count 1 is larger than 0.
21:23:51, ‘BUX Service’, ‘StartService’, ‘Success’.
21:24:04, ‘RepositoryService’, ‘StartService’, ‘Success’.
21:24:04, ‘burstDistributionService’, ‘StartService’, ‘Success’.
21:24:04, ‘GraphicsService’, ‘StartService’, ‘Success’.
21:24:41, ‘QueryService’, ‘StartService’, ‘Success’.
21:24:48, ‘QueryService’, ‘StartService’, ‘Success’.
21:24:55,
21:24:55, ‘ReportService’, ‘StartService’, ‘Success’.
21:24:55, ‘visualisationGalleryService’, ‘StartService’, ‘Success’.
21:25:13, ‘camAsyncAA’, ‘StartService’, ‘Success’.
21:25:13, ‘ReportDataService’, ‘StartService’, ‘Success’.
21:25:14, ‘relationalMetadataService’, ‘StartService’, ‘Success’.
21:25:13, ‘Fragment Server Service’, ‘StartService’, ‘Success’.
21:25:14, ‘SACamSrvcInternal’, ‘StartService’, ‘Success’.
21:25:14, ‘QLSService’, ‘StartService’, ‘Success’.
21:25:13, ‘SystemService’, ‘StartService’, ‘Success’.
21:25:14, ‘BatchReportService’, ‘StartService’, ‘Success’.
21:25:13, ‘MobileService’, ‘StartService’, ‘Success’.
21:25:13, ‘ContentManagerCacheService’, ‘StartService’, ‘Success’.
21:25:13, ‘CacheService’, ‘StartService’, ‘Success’.
21:25:14, ‘QLSImportService’, ‘StartService’, ‘Success’.
21:25:14,
21:25:14, ‘SACamSrvc’, ‘StartService’, ‘Success’.
21:25:14, ‘idVizServer’, ‘StartService’, ‘Success’.
21:25:15, ‘MetadataService’, ‘StartService’, ‘Success’.
21:25:14, ‘idVizServer’, ‘StartService’, ‘Success’.
21:25:14, ‘DeliveryService’, ‘StartService’, ‘Success’.
21:25:14, ‘SMDService’, ‘StartService’, ‘Success’.
21:25:14, ‘QLSBIService’, ‘StartService’, ‘Success’.
21:25:14, ‘idVizService’, ‘StartService’, ‘Success’.
21:25:14, ‘idVizService’, ‘StartService’, ‘Success’.
21:25:15, ‘HumanTaskService’, ‘StartService’, ‘Success’.
21:25:15, ‘AnnotationService’, ‘StartService’, ‘Success’.
21:25:15, ‘MonitorService’, ‘StartService’, ‘Success’.
21:25:15, ‘AgentService’, ‘StartService’, ‘Success’.
21:25:15, ‘JobService’, ‘StartService’, ‘Success’.
21:25:15, ‘EventService’, ‘StartService’, ‘Success’.
21:25:25, ‘CPS Producer Registration Service’, ‘StartService’, ‘Success’.
21:25:26, ‘Dispatcher’, ‘Start’, ‘Success’.
21:25:31, ”, ”, ‘Success’.
21:25:56, ”, ‘Run’, ‘Run’.
21:25:56, ”, ‘Run’, ‘Run’.
21:25:56, ”, ‘Run’, ‘Run’.
21:25:56, ”, ‘Run’, ‘Run’.
21:25:56, ”, ‘Run’, ‘Run’.

by ·0 Comments

Product:
Cognos Controller 10.3
Microsoft Windows 2008 R2 Server

Problem:
When setup the “database connections for publish to datamart” and click save, you get a error like this:
The ConnectionString property has not been initialized.
An unkown error occurred. Please contact your system administrator for assistance.

Solution:
Ensure that all the steps for upgrade of the Controller/datamart database have been done with the controller DBCONV program.

Open Database Conversion Utility
Select the UDL file and click connect
Select Controller DB or Datamart DB accordingly
Click on Upgrade button, if the current version number is lower than the Upgrade to number.

Please also ensure that the timeout on IIS are long.
http://www-01.ibm.com/support/docview.wss?uid=swg21963432

by ·0 Comments

Product:
Cognos Controller 10.3
Microsoft Windows 2008 R2 Server

Problem:
After new installation of Cognos Controller on old server, you get a error when you surf to Cognos Connection.

Error Message:
Server Error in Application “DEFAULT WEB SITE”Internet Information Services 7.5
Error Summary
HTTP Error 403.14 – Forbidden
The Web server is configured to not list the contents of this directory. Detailed Error Information
Module DirectoryListingModule
Notification ExecuteRequestHandler
Handler StaticFile
Error Code 0x00000000
Requested URL http://localhost:80/ibmcognos/
Physical Path C:\Program Files (x86)\ibm\cognos\c10\webcontent\
Logon Method Anonymous
Logon User Anonymous

Solution:
You need to change the virtual directory’s and applications inside IIS to point to the correct folder. The new controller program uses this folder C:\Program Files\ibm\cognos\ccr_64\webcontent
Change all settings inside IIS manager for Cognos Controller and try again.

by ·0 Comments

Product:
Cognos Controller 10.3
Microsoft Windows 2008 R2 Server

Problem:
Error when you start Cognos Controller client and login to the program. Happens when CAM authentication is selected.

If you surf to Cognos Connection with IE, that works fine.

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

Solution:
This can be different causes, please check this:
Ensure the user is part of the Cognos security groups
Controller Users or
Controller Administrators
Ensure that Cognos Configuration for authentication have then the setting “Allow Anonymous Access” configured to be “FALSE”

Error message:
AAA-AUT-0013 The user is already authenticated in all available namespaces.

Solution:
Ensure that the user exist in the Cognos Controller database and that he have rights to login.
Ensure that you are not already logged in to a different session.
Ensure in Cognos configuration gateway URI is configured with server name instead of the localhost
Ensure CAF should be set to False
Make sure namespace bind credential password is set in Cognos Configuration
Ensure the correct LDAP server is connected in the namespace.

 

You can check file C:\Program Files\ibm\cognos\ccr_64\logs\pogo_YYYY-MM-DD.log for more information.

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