IBM Support

After an upgrade of Cognos Analytics, none of the Planning Analytics components can log in anymore with CAM security: blank page or HTTP 404 error

Troubleshooting


Problem

After IBM Cognos Analytics was upgraded, the IBM Planning Analytics components cannot connect to CAM security anymore.
The web browser shows either a blank page or an HTTP 404 error (page not found)

Cause

TM1 interoperability files were removed from Cognos Analytics installation

Resolving The Problem

When Planning Analytics is configured with Cognos Analytics security (CAM), it uses TM1 interoperability files that need to be placed in the Cognos Analytics installation.

The entry page of the documentation is here:

Cognos security
 

Here are the places where these files need to be placed:

- <Cognos Analytics dispatcher Install Dir>\templates\ps\portal\variables_plan.xml
- <Cognos Analytics dispatcher Install Dir>\templates\ps\portal\variables_TM1.xml

If Planning Analytics is connecting directly to Cognos Analytics the dispatchers (or "application tier components"):
- <Cognos Analytics dispatcher Install Dir>\webcontent\planning.html
- <Cognos Analytics dispatcher Install Dir>\webcontent\pmhub.html
- <Cognos Analytics dispatcher Install Dir>\webcontent\tm1\web\tm1web.html

If Planning Analytics is connecting to Cognos Analytics through a gateway (like IIS):
- <Cognos Analytics Gateway Install Dir>\webcontent\bi\planning.html
- <Cognos Analytics Gateway Install Dir>\webcontent\bi\pmhub.html
- <Cognos Analytics Gateway Install Dir>\webcontent\bi\tm1\web\tm1web.html

Cognos Analytics does not know about these files, and deletes them each time Cognos Analytics is upgraded, unless the preserve.txt file was correctly edited. These steps are described in the Cognos Analytics documentation:

Preserved files and folders when upgrading Cognos Analytics

Here is an example of content to preserve TM1 interoperability files (from <CA_install_path>\configuration\preserve\preserve.txt):

[...]

# Specify files to exclude first
# Specify files or folders to preserve
webcontent/planning.html
webcontent/bi/planning.html
webcontent/pmhub.html
webcontent/bi/pmhub.html
webcontent/tm1/web/tm1web.html
webcontent/bi/tm1/web/tm1web.html
templates/ps/portal/variables_TM1.xml
templates/ps/portal/variables_plan.xml
webcontent/tm1
webcontent/bi/tm1
webcontent/tm1/web
webcontent/bi/tm1/web
 

If a backup of the previous Cognos Analytics installation exists, then restore the files and folders from that backup. Eventually, Cognos Analytics needs to be restarted.

If some of the files are deleted despite the preserve.txt file was correctly set, then contact IBM Cognos Analytics support.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[{"code":"a8m3p000000LQtUAAW","label":"Planning Analytics"},{"code":"a8m50000000KzJ4AAK","label":"Planning Analytics-\u003EPlanning Analytics For Microsoft Excel"},{"code":"a8m50000000KzIzAAK","label":"Planning Analytics-\u003EPlanning Analytics Workspace"},{"code":"a8m50000000KzIkAAK","label":"Planning Analytics-\u003ESecurity"},{"code":"a8m3p000000PC9LAAW","label":"Planning Analytics-\u003EServer Data Tier"},{"code":"a8m3p000000PC7XAAW","label":"Planning Analytics-\u003EWeb PASS Contributor Application"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]

Document Information

Modified date:
02 February 2023

UID

ibm16951943

Page Feedback