Sunday, 1 February 2015

Tips for installing Cognos 10.2 64-bit on Windows 7 64-bit

1. Make sure you install all supported software which is listed by IBM report, especially for JDK, version of content store DB and web servers etc. Latest software will cause some unexpected errors. E.g. dynamic query service can't be enabled when using JDK 8 on Cognos 10.2.

2. Make sure all software you installed is in same language, especially for Cognos server itself. Better to have English as default language by changing this setting
IBM Cognos Configuration -> Opertation -> Edit Global Configuration -> General -> Server Language Env = en if you see this error in the cognos server log. "CBSServiceStatusUpdater reached time limit, final status is 2"

3. Make sure Oracle character set is AL32UTF8 and language in AMERICAN if you use Oracle as content store. You can use DBCA to drop or recreate DB and grant DBA to content store user.

4. Follow the links below to finish installation and configuration.

5. Allocate more RAM to Java Virtual Machine if see this error in Event Viewer.
"Could not create the Java Virtual Machine"

6. If you see "QE-DEF-0368" when using FM to connect any source for publishing. Check the link below.