Troubleshooting
Problem
After upgrading to 11.1.6 or later, the login page shows
AAA-SYS-0001 An internal error occurred or AAA-AUT-0013 The user is already authenticated in all available namespaces.
No changes have been made to the configured namespace.
Cause
There was a trailing space in the <Namespace Name> set in Cognos Configuration before the Upgrade. Newer versions of Cognos do not allow that trailing space.
Diagnosing The Problem
Errors in cogaudit.log
ADDNAMESPACE Warning CM-CFG-5139 Duplicate namespace id '<Namespace ID>'. Namespace with the same id but different name already exists.StartService NameSpace CAMID("<Namespace ID>") Warning AAA-SYS-0007 The request to add namespace '<Namespace Name> ' received a response for namespace 'Bluepages'. <exception><![CDATA[com.ibm.cognos.camaaa.internal.common.exception.LocalizableException: AAA-SYS-0007 The request to add namespace '<Namespace Name> ' received a response for namespace '<Namespace ID>'.
Resolving The Problem
Step 1:
Edit the namespace name in Cognos Configuration and remove the trailing space.
Steps 2:
Update the namespace name in the content store
***NOTE: Make sure that Cognos is stopped before doing this step, and that you have a database backup.
1) The first query you run is:
select * from CMOBJPROPS1 where OBJID like '<Namespace ID>'
This query returns a specific CMID value.
2) Run another query to find the namespace name associated with that ID:
select * from CMOBJNAMES where CMID=<id returned from the first query>
Example:
select * from CMOBJNAMES where CMID=144
Once you find the name of the namespace in the content store, you notice that it contains the trailing space as well. Simply update this name to match what is already in Cognos Configuration. Make sure to commit and save the change.
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":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl6OAAS","label":"Installation and Configuration->Authentication"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1.6;11.1.7;11.2.0"}]
Was this topic helpful?
Document Information
Modified date:
24 September 2021
UID
ibm16491931