Cognos Analytics

Cognos Analytics

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

 View Only
Back to discussions
Expand all | Collapse all

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.

  • 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 yesterday

    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 5 hours ago
    Edited by Chadman Hult 4 hours 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 4 hours ago
    Edited by Chadman Hult 4 hours ago

    Odd you are getting the error as dbo. You shouldn't be having that problem. Need execute permissions on CMPARSECOPYIDS lke the support articles say.

    My user can't be dbo so I need the following..  Need execute permissions on CMPARSECOPYIDS like the support articles mentions.

    • Create and Drop table privileges for the database to the User account.
    • A member of the db_ddladmin, db_datareader, and db_datawriter, db_execallsp roles.
    • Ensure that the user is the owner of their default schema.
    • If not dbo, Execute on "dbo" schema granted by "dbo.

    This is db_owner example. Shouldn't need the other roles only the db_owner



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

    Original Message


Related Content