Troubleshooting
Problem
A Planning Analytics installation is configured for SSO, based on Kerberos / SPNEGO.
In Planning Analytics for Excel, the first connection with single sign-on is working correctly.
However, when we click a SUBNM formula, either the Internet Explorer login page is displayed again or a blank page is displayed.
The connection is falling into a loop.
Cause
For single sign-on with Kerberos and SPNEGO to work correctly, only fully qualified domain names (FQDN) must be used.
Resolving The Problem
On the Planning Analytics Workspace machine, in /config/paw.ps1, verify that all URLs are using the FQDN syntax.
On the Planning Analytics for Excel machines, in C:\Users\<UserName>\AppData\Local\Cognos\Office Connection\CommManagerSettings.xml, verify FQDN syntax is used too.
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":"a8m50000000KzKMAA0","label":"Security-\u003ESSO"},{"code":"a8m0z000000blfjAAA","label":"Troubleshooting"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
16 February 2022
UID
ibm16557016