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):
Example #2 - Controller 10.3.1 RTM with Cognos Analytics 11.0.7:
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.
Related Information
[{"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"}}]
Was this topic helpful?
Document Information
Modified date:
11 February 2019
UID
swg22013912