Chapter 6: Cognos 10 on Windows 2008 R2 – Need to know subjects

IBMCognos

Environment:

Server Operating system: Windows 2008 R2

DB: Oracle 11G

Cognos version: 10.1

  • Oracle:

Oracle 11G 32 Bit (!!!) needs to be installed – Cognos engine (Datasources) needs 32 bit Installation.

JDBC Driver: Need to move ojdbc5.jar file driver from <Oracle direcotory>\jdbc\lib to <Cognos directory>\webapps\p2pd\WEB-INF\lib directory

Please note: Cognos doesn’t support jdbc 1.6 !

  • SQL Server via ODBC:

When connecting SQL Server via ODBC needs to know that there are 2 different ODBC managers:

  1. C:\Windows\SysWOW64\odbcad32.exe
  2. C:\Windows\System\odbcad32.exe
  • Security

Need to open the Cognos configuration with administrator rights. (Problem creating Lock files – Getting an error that the configuration is already opened)

  • Installation directories:
    1. Server installation directory – Program files (x86)\C10
    2. Frameowrk + Powerplay – Program files (x86)\C10-64
  • IIS 7.0
    1. Need PDF of IIS configuration – How to configure the ISAPI and CGI modules on the IIS 7.
    2. dll –
      1. Change of default.htm file (from cgi.bin to cognosisapi.dll
      2. Add the allowPathinfo=True to both file (CGI – applicationhost.config , ISAPI – web.config)
    3. Need to change the IIS Application Pools to Enable 32-bit =True (Problem with the homepage)
    4. Application pool – allow 32 bit need to update it.
  • Language
    1. Need to add Hebrew to default languages in the configuration tool
    2. Need to change the regional language to Hebrew (Problems with Powerplay)
  • Framework manager
    1. Problems with the data sources on the FM projects will happen due to credentials problems – You should copy the three folders enkrypt keypair,singekeypair and CSK from <crnlocation> configuration and paste it in <FM location>configuration – that will resolve the issue with FM.
    2. Internet Explorer doesn’t open the FM application due to security restrictions – You should open the FM application with administrator rights and add the app to the trusted applications.
  • Cognos administration – Having problems connecting Cognos administration page? Open IE with administrator rights and add FM to trusted sites.
  • Webdav – enable webdav on IIS7 in order to see cognos images.

 

 

Related links:

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s