Cognos Analytics

Cognos Analytics

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

 View Only
Back to discussions
Expand all | Collapse all

How to capture errors "CM-REQ-4159 CM-CAM-4005 Unable to authenticate." when Scheduled reports fail after password update:

  • 1.  How to capture errors "CM-REQ-4159 CM-CAM-4005 Unable to authenticate." when Scheduled reports fail after password update:

    Posted Tue February 15, 2022 01:38 PM
    My clients want to capture errors "CM-REQ-4159 CM-CAM-4005 Unable to authenticate." when Scheduled reports fail after password update. We were told that audit report will not capture because the report never ran. Any ideas on how to capture these error on scheduled reports?

    ------------------------------
    brenda grossnickle
    BI Programmer Analyst
    FIS
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: How to capture errors "CM-REQ-4159 CM-CAM-4005 Unable to authenticate." when Scheduled reports fail after password update:

    Posted Wed February 16, 2022 04:14 AM
    Hi Brenda,

    After a password update, it would be save to renew your credentials.

    The following pages might be useful:
    Renewing trusted credentials automatically
    or
    Renewing your credentials

    I am not sure that enabling diagnostic logging for AAA (Access Manager Authentication) would be useful. If you think it could be useful, have a look to
    Chapter 5. Configuring system settings (in page 83)

    Best regards,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------

    Original Message


  • 3.  RE: How to capture errors "CM-REQ-4159 CM-CAM-4005 Unable to authenticate." when Scheduled reports fail after password update:

    Posted Thu February 17, 2022 09:35 AM
    Client has had several scheduled reports fail because the owner of the schedule password expired. They do not find out about these failed reports until days later. Currently they are having to check the Cognos Administration everyday. 

    The renewing trusted credentials automatically sounded promising, but it still requires the user who owns the job/schedule to log in to cognos. they just do not have to specifically renew.

    Do you have any idea if enabling AAA logging would give an indication of the report name, or user name? They have the audit log, and the failed authorization is listed in the action table. but it does not give any details about report name or user name. Just that an authentication failed.

    select * from cogipf_action where cogipf_errordetails like '%Auth%'



    ------------------------------
    brenda grossnickle
    BI Programmer Analyst
    FIS
    ------------------------------

    Original Message


  • 4.  RE: How to capture errors "CM-REQ-4159 CM-CAM-4005 Unable to authenticate." when Scheduled reports fail after password update:

    Posted Thu February 17, 2022 04:35 PM
    I have had some success by creating a report from the audit package including [Audit].[User Logon Failures].[Logon failure time].  Filter on [Audit].[User Logon Failures].[Logon failure date] for the range of dates to include and [Audit].[User Logins].[Session ID] = 'null'.  That doesn't tell you which report or which user id is impacted but I can use that date and time to look at past activities in Cognos Administration to see which reports failed and determine the user id from there.  We use single sign on so we don't have a lot of login failures from incorrect user id or password but I think those might show up as well which may create to much "noise" if that happens very often.

    ------------------------------
    Pam Ryan
    ------------------------------

    Original Message