Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  CM-REQ-4127 error then CM-SYS-5006 Content Manager is unable to process your request because an unexpected event occurred in the content store database subsystem.

    Posted 24 days ago

    Hi,

    I'm using Cognos Analytics v12.1.0 with a Content Store running on SQL Server.

    I belong to System Administrators role.

    When I try to copy a report from Template folder, I receive the following error message:

    CM-REQ-4127 An error occurred during a copy operation. CM-SYS-5006 Content Manager is unable to process your request because an unexpected event occurred in the content store database subsystem. The EXECUTE permission was denied on the object 'CMPARSECOPYIDS', database 'BI_COGNOS_CS', schema 'dbo'.

    In the logs, I've also found "CM-SYS-5192 An error occurred with Content Manager".

    I've tried the following test : 

    • Renew the credentials
    • Take ownership

    If I open the report then I use the "Save as" feature, I can copy the report without any error.

    I've found an IBM article with similar error messages, the solution in this article is the following:

    The solution is to modify the SQL permissions (for the SQL login user for the Content Store DB) so that it has full permissions (for example 'db_owner') to the Content Store database.

    Question: I would like to avoid to use this solution (full permissions with 'db_owner'), is there anything else I could try?

    Best regards,



    ------------------------------
    Patrick Neveu
    BSL Consulting
    IBM Champion
    ------------------------------


  • 2.  RE: CM-REQ-4127 error then CM-SYS-5006 Content Manager is unable to process your request because an unexpected event occurred in the content store database subsystem.

    Posted 23 days ago
    Edited by Chadman Hult 23 days ago

    Removed



    ------------------------------
    Chadman Hult
    ------------------------------

    Original Message


  • 3.  RE: CM-REQ-4127 error then CM-SYS-5006 Content Manager is unable to process your request because an unexpected event occurred in the content store database subsystem.

    Posted 23 days ago
    Edited by Chadman Hult 9 days ago

    My user can't be dbo so I need the following.. 

    Need execute permissions on CMPARSECOPYIDS like the support articles mentions.

    Content Manager User

    • Create and Drop table privileges for the database to the User account.
    • A member of the db_ddladmin, db_datareader, and db_datawriter roles.
    • Ensure that the user is the owner of their default schema.

    CM-SYS-5006 - The following will help with error.

    • Execute on "dbo" schema granted by "dbo.

               GRANT EXECUTE ON SCHEMA :: DBO TO COGNOS _USER

               Can either run this directly or create a Role to add your users to and give the role execute permissions.

    Securing the content store


    ------------------------------
    Chadman Hult
    ------------------------------

    Original Message


  • 4.  RE: CM-REQ-4127 error then CM-SYS-5006 Content Manager is unable to process your request because an unexpected event occurred in the content store database subsystem.

    Posted 19 days ago

    Hi Patrick,

    Find the table/object in question within the content store db and make sure the CS user has execute privileges on that specific table/object.  I can't remember all of the tables in question on the CS database -- but it appears from the message that there is a table named "CMParse..." -- just make sure that CS user has the execute privilege associated to that table.  That should do the trick.  Curious on why you do not want to provide db_owner permissions to the CS database?  Also curious on how the CS originally got created.

    John



    ------------------------------
    John Cusack
    ------------------------------

    Original Message


Related Content