IBM Support

CM-SYS-5006 CM-STS-5027: Error message seen when user attempts to access any Studio

Troubleshooting


Problem

A user logging into Cognos and launching one of the Studios get the following error message when trying to launch any Studio in Cognos Connection.

Symptom

CM-SYS-5006

Content Manager is unable to process your request because an unexpected event occurred in the
content store database subsystem.

Details

CM-SYS-5027 A Content Manager internal error occurred while querying the content store cache.
CacheQuery::Parse::/1:*:*[F28(L33:iEBF665F260A0430FA4AE92C38390098D)]Unknown Exception while
parsing steps::Step #=0MultilingualStringsCache.Parse::Invalid function specified in cache expression

Cause

The user profile is corrupted in the content store.

Resolving The Problem

Remove and re-add the user profile from Cognos connection:

Steps:

  1. Login as System Administrator or Directory Administrator and delete the user profile from Cognos Connection (Launch -> IBM Cognos Administration, select Security and then the authentication source, navigate to the user's name and click More under the actions column, and then select Delete this user's profile)
  2. Leave the account in-tact in your third-party authentication source.
  3. Ask the user to login to Cognos Connection with the same credentials, and verify that the account is re-established automatically.

** NOTE: ****

Please read the following first before recreating the user profile:

  1. Before you delete a user profile, you may want to view the content to ensure that you are not deleting anything important. Please see the View or Change a User Profile reference below for more information.
  2. Backup the contents of My Folder for this user (you may want to move the objects to "Public Folders" temporarily).
  3. Perform a backup of the content store as a precaution.

References:

See the following references from the Cognos 8 Administration and Security Guide:
Delete a User Profile
View or Change a User Profile Steps::Step #=0MultilingualStringsCache.Parse::Invalid function specified in cache expression


Root Cause:

The user profile is corrupted in the content store.

Solution:

Remove and re-add the user profile from Cognos connection:

Steps:

  1. Login as System Administrator or Directory Administrator and delete the user profile from Cognos Connection (Tools -> Directory, select the authentication source, navigate to the user's name and click More under the actions column, and then select Delete this user's profile)
  2. Leave the account in-tact in your third-party authentication source.
  3. Ask the user to login to Cognos Connection with the same credentials, and verify that the account is re-established automatically.

** NOTE: ****

Please read the following first before recreating the user profile:

  1. Before you delete a user profile, you may want to view the content to ensure that you are not deleting anything important. Please see the View or Change a User Profile reference below for more information.
  2. Backup the contents of My Folder for this user (you may want to move the objects to "Public Folders" temporarily).
  3. Perform a backup of the content store as a precaution.

References:

See the following references from the Cognos 8 Administration and Security Guide:
Delete a User Profile
View or Change a User Profile

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cognos Connection","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1;10.1.1;10.2;10.2.1;10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Install and Config","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Report Studio","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
28 November 2022

UID

swg21341527

Page Feedback