Home
Follow us on Twitter


Countries

48.1%United States United States
7.4%India India
7%United Kingdom United Kingdom
5.6%Canada Canada
5.4%Australia Australia

Visitors

Today: 394
Yesterday: 552
This Week: 1770
Last Week: 3022
This Month: 946
Last Month: 10936
Total: 717078


When you start ODBC Data source administrator to add ODBC connections to xls files you get a error PDF Print E-mail
Written by Roger   
Product:
Cognos Planning 10.1.1
Analyst on Microsoft Windows 7 64 bit

Symptom:
When you start ODBC Data source administrator to add ODBC connections to xls files you get a error on your brand new Windows 7 computer.

You need to add ODBC connection to be able to import xls files into Cognos Analyst for Planning.  Inside Analyst how you selected New D-Link and then click on source, and selected ODBC (SQL) database. But then there are no connections to select, you have to create the connections in the ODBC tool.

Problem:
The setup routines for the Microsoft Excel Driver (xls xlsx xlsm xlsb) ODBC driver could not be found. Please reinstall the driver.

Cause:
In windows 7 the odbc icon in administrative tools are for  64 bit connections, and cognos planning use only 32 bit connections.

Solution:
Create a shortcut to the file c:\windows\syswow64\odbcad32.exe

Use this icon to edit the ODBC connection for Excel to be used in Cognos Planning.


www.cogknowhow.com

 
How do i change the startup picture when I start the Cognos Controller program locally? PDF Print E-mail
Written by Roger   
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

www.cogknowhow.com

 
Error to start Cognos BI service, only errors in file catalina.log PDF Print E-mail
Written by Roger   
Product:
Cognos Controller FAP 10.1.1
Microsoft Windows 2008 R2 server
Cognos BI 10.1.1

Symptom:
Error to start Cognos BI service.
No error in Cogserver.log file, you find any errors in file catalina.2014-03-27.log


Cause:
When publish in FAP you get error C8ITKShared (not found in java.library.path) after you have changed TM1 from native security to use CAM (Cognos BI) security on the FAP cube.
You added the folder to TM1 Bin folder to PATH, c:\program files\ibm\cognos\tm1_64\bin
This disturbs Cognos Bi, and it will not start the service.

Solution:
Remove the folder to tm1 bin from the Windows PATH environment variable.

Copy two files from folder c:\program files\ibm\cognos\tm1_64\bin to the folder c:\program files(x86)\ibm\cognos\c10\server\fap folder.

C8ITKproxy.dll
C8ITKshared.dll

Restart the Cognos FAP service.
Test to do an Initial Publish in FAP again.

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

www.cogknowhow.com

 
Option inside TI Turbo Integrator dialog for “IBM Cognos Package” is greyed out PDF Print E-mail
Written by Roger   
Product:
IBM Cognos TM1 10.2 server (version 10.2.5000.367-0)
IBM Cognos TM1 package connector (version 10.2.5000.14-0)
IBM Cognos BI 10.2.1 Fix Pack 1 (version 10.2.5001.156-0)
IBM Cognos BI 10.2.1 Fix Pack 2 (version 10.2.5002.78-0)
Windows 2008 R2 server

Symptom:
After installation of TM1 Package Connector (tm1pc_10.1.1_bi_10.2.1_win_ml.tar) on the same computer where you have TM1 Architect and Framework Manager installed, the option inside TI Turbo Integrator dialog for “IBM Cognos Package” is greyed out and not selectable.

You only get this issue on the Developer computer where you have also installed frame work manager for Cognos BI 10.2.1 fix pack 1.
If there is only TM1 installed or there is not a Cognos BI fix pack installed, it will work.

Solution:
Uninstall TM1 package connector from your computer.
Leave the Framework Manager and other software still installed.
Run installation of TM1 Package Connector again, but
Select a new folder, like:
C:\program files (x86)\ibm\cognos\c10pack
And also remember to set a new shortcut folder name to “IBM Cognos 10 Package Connector”
Finish the installation.
Then go to start menu and open Cognos configuration from “IBM Cognos 10 Package Connector”.
Update the environment tab with values for you Cognos Gateway server;
http://BIgatewayname.domain.com:80/ibmcognos/cgi-bin/cognosisapi.dll
And for you Dispatcher URI for external applications set it to;
http://BIservername.domain.com:9300/p2pd/servlet/dispatch
Save the settings.
Exit Cognos Configuration.
Start TM1 Architect
Click on a TM1 application to login.
Inside a TM1 application right click on “processes” and select “create new process”
Try to click on “IBM Cognos Package” – if it works, then you have succeeded.

TM1 architect use the windows variable TM1_PACKAGE_CONNECTOR to find the installation files its needs, so this variable should be a system variable. You can type SET in the command prompt on the server to check its current value, it should be
TM1_PACKAGE_CONNECTOR=c:\program files (x86)\ibm\cognos\c10pack\bin

You need to replace the URL/PATHS with the correct values for your servers.

www.cogknowhow.com

 
DPR-ERR-2107 - The User Capabilities Cache cookie cannot be decoded PDF Print E-mail
Written by Roger   
Product:
Cognos BI 10.1.1
Cognos Controller 10.1.1
Windows 2008 R2 Server
Internet Explorer 10

Symptom:
When user surf to Cognos connection and try to login they get a error message.
You have more than one Cognos System that you work with at the same time, so you surf to Cognos Connection in one Internet Explorer session, and work with the other Cognos environment in a different tab of Internet Explorer.

Error message:
DPR-ERR-2107 - The User Capabilities Cache cookie cannot be decoded


Possible Solution:
For Each Cognos Environment do the following:
Logon to server as local administrator
Check the URL the users use to surf to the Cognos connection.
http://servername.domain.com/ibmcognos
Open IBM Cognos Configuration on the server, right click and select "run as administrator".

Open Actions menu, then click on Edit Global Settings

Click the General tab

Under Cookie Settings, enter the details for "Domain" and "Path"
Domain = servername.domain.com  (this should be unique for each environment)
Path = ibmcognos
Click save from inside Cognos configuration.
Restart the Service.

Do this for each environment.
One for Cognos BI and one for Cognos Controller, if they do not share Cognos BI server.

Test that Cognos Framework manager works to login after the change.

 

www.cogknowhow.com

 

 

 
«StartPrev12345NextEnd»

 

CogKnowHow Newsletter

Newsletter
Please register to the site before you can sign for a list.
No account yet? Register
Banner

Polls

How many users are working on your Cognos environment?