IBM Support

Error logging into Cognos Connection: CM-REQ-4159

Troubleshooting


Problem

A user launches IBM Cognos Connection, logs on with their username/password and receives an error message. Not all users are affected. This problem tends to occur after users have changed their Windows password in their Microsoft domain / Active Directory profile. There are a number of causes of a CM-REQ-4159 error. For other scenarios, search further for CM-REQ-4159 This document deals specifically with the scenario whereby the end user's Cognos Reporting Service user profile in the content store is invalid or corrupt.

Symptom

CM-REQ-4159 Content Manager has returned an error in the response header.

Diagnosing The Problem

Open the 'cogserver.log' file located on the application server in the logs directory of the Cognos install area.
Take a copy of this file *immediately after* the user has reproduced the error. At the end of this file, there should be an entry similar to the following:

    - Cognos User:g:f67438100f8b144db1e6114771ddddd9") | CAMID("Active Directory - Cognos User:u:907ce73b7c251f4287111048259c6dda") ) Warning CM-REQ-4036 The object already exists at this location.
    172.20.194.152:9300 2300 2009-09-29 00:12:05.016 -5 EC10873686A116382D999E7303F00B1D7B9AD21D Gl4jqhvjy89d44Ghj2yyG4ylvGql44GdCCl8l9s8 Thread-20 CM 2539 1 Audit.cms.CM QUERY membership( CAMID("Active Directory - Cognos User") | CAMID("Active Directory - Cognos User:g:0c762f899a8d0040a2e43811c4c8a310") | CAMID("Active Directory - Cognos <.....>
    - Cognos User:g:f67438100f8b144db1e6114771ddddd9") | CAMID("Active Directory - Cognos User:u:ec7be8abbcc80e48abfd92e280a5fad1") ) Warning CM-REQ-4036 The object already exists at this location.

Resolving The Problem

Recreate the 'bad' user's Cognos profile.

Steps:


Part One - Locating the user
  1. Launch Cognos Connection
  2. Logon as a Cognos System administrator
  3. If prompted, click 'Administer IBM Cognos content'
  4. Inside 'IBM Cognos Administration', choose the 'Security' Tab
  5. Click to open the relevant namespace. TIP: This will NOT be the built-in 'Cognos' namespace. Instead, it will be the one which contains all your users (typically may be called the same as your Active Directory domain/forest)
  6. Select "Tools" then "Directory"
  7. Navigate to locate your 'bad' end user. TIP: If you do not know where your end user is located, you can click on the magnifying glass icon in the upper right hand corner. Enter the username in the data field. *Note if you have difficulty with this, try changing the advanced options such as Method: to "starts with the exact string" until you locate your username. Once the username is displayed, click on the username. Click on "My Folders". You should be able to see all the users' personal folders and reports. Use the BACK button of the browser to return to the point where you are able to see the username.
  8. Once you have located the username, select "Set properties" icon for the user. TIP: See if there is anything specific that shows a corruption of the user profile. Compare the settings of the 'bad' user with a 'good' user. If there is something obviously wrong, try to fix it first (before continuing)

Part Two - Creating a backup of the user profile
If you cannot see what is wrong with the user then ideally (as a precaution) it is good practice to copy the contents of the 'bad' end user's profile to another ("test") user account.
TIP: Therefore, before you begin this you will need to have a user account that you can access to copy the content from your profile to the other users profile. This destination user will be used to hold your content until your new profile is created at which point you should be able to copy the content back (if necessary).
  1. Locate the 'bad' user (see above for instructions)
  2. Click on the hyperlink word 'More' to the right of the 'bad' user
  3. Click 'Copy this user's profile...'
  4. Select all 3 options ("Preferences", "Portal tabs and personal folders content", "Personal folders content")
  5. At this point do not check/tick the box "Delete the source user's profile after the copy completes"
  6. Click on "Select the target user". Choose a temporary 'test' user (ideally a brand-new user). TIP: This user profile will store the 'bad' user's content in (until the profile is recreated).
  7. Click the "Copy" button to copy the content across.
  8. Check the destination user profile to confirm that the content has been moved successfully.
  9. Assuming that you can confirm that the content has been moved successfully, it is safe to delete the 'bad' user's profile.

Part Three - Deleting the 'bad' user's profile
  1. Locate the 'bad' user (see above for instructions)
  2. Click on the hyperlink word 'More' to the right of the 'bad' user
  3. Click 'Delete this user's profile'
  4. Ask the 'bad' user to logon and test.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cognos Connection","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.2.2;10.2.1;10.2;10.1.1;10.1","Edition":"Edition Independent","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21341553