IBM Support

"AAA-AUT-0013 The user is already authenticated in all available namepaces" after logon / logoff / logon of Excel link

Troubleshooting


Problem

User launches Excel. User clicks the 'Controller' add-in, and then clicks 'Log on...'. This works OK. User then clicks "Log off". Again this works OK. User then clicks "Log on...". A message appears.

Symptom

The message varies, depending on environment.

Example #1 - Controller 10.4.0 with Cognos Analytics 11.0.12 (or 10.3.1 IF1 with CA 11.0.7):
  • AAA-AUT-0013
    The user is already authenticated in all available namepaces.

Example #2 - Controller 10.3.1 RTM with Cognos Analytics 11.0.7:
  • IBM Cognos Analytics
    Sign in with your Cognos Users ID

Cause

There are several known causes of the 'AAA-AUT-0013' error.
  • TIP: For more examples, see separate IBM Technote #1346138.
 

This Technote specifically relates to the scenario where the cause is a limitation (reference APAR PI94496) of Controller, when used with Cognos Analytics (CA) if both of the following are true:

  • CA is using anonymous authentication
  • CA is using the default settings inside its 'logoff.xts' file.

Environment

Controller configured to use 'Native' (not Cognos CAM) authentication.

Resolving The Problem

Fix:

Reconfigure the Cognos Analytics 'logoff.xts' file.

Steps:

1. Logon to the Cognos Analytics server

  • TIP: For most 'standard' customers (using Native authentication) the CA server will probably be the same server as the 'main' Controller application server.

2. Browse to the following folder:  .../templates/ps/portal/

  • TIP: By default, this is located here: C:\Program Files\ibm\cognos\analytics\templates\ps\portal
3. As a precaution, create a backup copy of the following file:    logoff.xts
4. Edit the following file (for example in Notepad):    logoff.xts
5. Locate the following section:
<xos: entityBody>
<html>
<head>
<meta http-equiv="refresh" content="0; URL={$loggoffURL}"/>
<title> Logout Redirect </title>
6. Comment the line shown in bold (above)
  • In other words, modify the line so that it looks similar to:
 
<!--<meta http-equiv="refresh" content="0; URL={$loggoffURL}"/>-->
7. Stop the CA service.
  • TIP: By default, this means stopping the Windows service:    IBM Cognos
8. Browse to the following folder:       .../webapps/p2pd/WEB-INF/lib/
  • TIP: By default, this is located here:   C:\Program Files\ibm\cognos\analytics\webapps\p2pd\WEB-INF\lib
9. Rename the following file:   portal.jar
  • For example, rename it to:   portal.jar.backup
10. Start the CA service (by default, called:   IBM Cognos)
---------------------------------------------------------------------
IMPORTANT: If (in the future) you wish to change Controller to using CAM authentication (not 'Native' authentication) then you must revert (undo / reverse) the above changes.
---------------------------------------------------------------------
    

Workaround:

1. Click "File - Exit" (to close Excel)

2. Re-launch Excel

3. Retry.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3.1, 10.4.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
11 February 2019

UID

swg22013912