Cognos Analytics

Cognos Analytics

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


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
Back to discussions
Expand all | Collapse all

Need assistance: CM-REQ-4159, CM-CAM-4005 errors when users try to authenticate to Cognos

  • 1.  Need assistance: CM-REQ-4159, CM-CAM-4005 errors when users try to authenticate to Cognos

    Posted 07/06/26 09:26 AM
    We're encountering a CM-REQ-4159, CM-CAM-4005 Content Store error
    Original Error: CM-REQ-4159 Content Manager returned an error in the response header. The error "cmAuthenticateFailed CM-CAM-4005 Unable to authenticate. Check your security directory server connection and confirm the credentials entered at login." can be found in the response SOAP header. 

    The cognos audit file has this error:
    .CMStoreDuplicateObject: CM-REQ-4036 The object already exists at this location.
    Caused by: java.sql.SQLException: ID_CMOBJECTS
      at com.cognos.cm.dbstore.NameUniqueness.executeMultipleObjectsWithParentStatement(NameUniqueness.java:202)
      at com.cognos.cm.dbstore.NameUniqueness.check(NameUniqueness.java:141)
      at com.cognos.cm.dbstore.CMDbStore.move(CMDbStore.java:1401)
      at com.cognos.cm.dbstore.CMDbStoreCacheObjects.move(CMDbStoreCacheObjects.java:630)
      at com.cognos.cm.dbstore.CMDbStore.move(CMDbStore.java:1086)
      at com.cognos.cm.dbstore.SecurityProxy.moveOrCreateObject(SecurityProxy.java:352)
      at com.cognos.cm.dbstore.SecurityProxy.repairAccountAncestors(SecurityProxy.java:324)
      at com.cognos.cm.dbstore.SecurityProxy.repairAccountAncestors(SecurityProxy.java:156)
      at com.cognos.cm.server.UserSessionCacheEntry.createAccountObjectReference(UserSessionCacheEntry.java:534)
      at com.cognos.cm.server.UserSessionCacheEntry.setIdentity(UserSessionCacheEntry.java:447)
      at com.cognos.cm.server.UserSessionCacheEntry.processUserInfo(UserSessionCacheEntry.java:387)
      at com.cognos.cm.server.UserSessionCacheEntry.<init>(UserSessionCacheEntry.java:107)
      at com.cognos.cm.server.CMExecutionContext.initializeASession(CMExecutionContext.java:472)
      at com.cognos.cm.server.AccMan.processAuthRsp(AccMan.java:303)
      at com.cognos.cm.server.AccMan.invokeCAMAuthenticate(AccMan.java:227)
      at com.cognos.cm.server.AccMan.Authenticate(AccMan.java:111)
      at com.cognos.cm.server.RequestManager.AuthenticateCAMHeader(RequestManager.java:2938)
      at com.cognos.cm.server.RequestManager.handleRequest(RequestManager.java:2472)
      at com.cognos.cm.server.RequestManager.executeTheRequest(RequestManager.java:1200)
      at com.cognos.cm.server.RequestManager.handle(RequestManager.java:550)
      at com.cognos.cm.server.CMServlet.doPost(CMServlet.java:723)
      at com.cognos.cm.server.ContentManager.doPost(ContentManager.java:148)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
      at com.cognos.pogo.pdk.performance.servlet.PerformanceIndicatorWrappedServlet.service(PerformanceIndicatorWrappedServlet.java:31)
      at com.cognos.cm.server.ContentManager.service(ContentManager.java:119)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)

    Has anyone seen this before?  Any insights on cleaning up the content store or resolving these duplicate object errors would be greatly appreciated.


  • 2.  RE: Need assistance: CM-REQ-4159, CM-CAM-4005 errors when users try to authenticate to Cognos

    Posted 07/06/26 09:43 AM

    Hi Mayur,

    What is your security? Do you have Cognos Analytics on-premises or on the cloud? Which version?

    Do you have this issue with any user or just one? On which database your Content Store is located?

    Best regards,



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



  • 3.  RE: Need assistance: CM-REQ-4159, CM-CAM-4005 errors when users try to authenticate to Cognos

    Posted 07/06/26 09:52 AM

    Hi Patrick,

    Security is Microsoft Active Directory. Cognos Analytics on-premises ver 12.1.2-2604231709.

    So far only a handful of users. Content store is in Oracle. 

    We upgraded to er 12.1.2-2604231709 a month ago, but this morning users started experiencing this.



    ------------------------------
    Mayur Madoo
    ------------------------------

    Original Message


  • 4.  RE: Need assistance: CM-REQ-4159, CM-CAM-4005 errors when users try to authenticate to Cognos

    Posted 07/06/26 10:40 AM

    Mayur,

    Did you change anything on your Microsoft AD (such as change/move an OU and/or an unique identifier)?

    Did you change anything on the Content Store DB (Oracle), such as NLS_SORT or NLS_COMP? Or in the JDBC connection string?

    Best regards,



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

    Original Message


  • 5.  RE: Need assistance: CM-REQ-4159, CM-CAM-4005 errors when users try to authenticate to Cognos

    Posted 07/06/26 11:00 AM

    Nothing has changed and this issue only surfaces today. Some user manage to login successfully and after an hour when they tried again that got the error



    ------------------------------
    Mayur Madoo
    ------------------------------

    Original Message


  • 6.  RE: Need assistance: CM-REQ-4159, CM-CAM-4005 errors when users try to authenticate to Cognos

    Posted 07/06/26 11:10 AM

    I guess you need to log a case with IBM Support.



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

    Original Message


  • 7.  RE: Need assistance: CM-REQ-4159, CM-CAM-4005 errors when users try to authenticate to Cognos

    Posted 07/06/26 11:18 AM

    Hello Mayur,

    I usually see this happens on scheduled reports because someone changed their network or Active Directory password. When they change it, the trusted credentials Cognos uses to run schedules in the background stop working. If this is the case then have the person who owns the scheduled report log into Cognos, go to their Profile icon Profile and settings Profile tab. Then scroll down to Advanced options, find Credentials, and click Renew.
     
    In the meantime, could you try restarting both the Cognos services and the Oracle Content Store database to see if that clears it up?
    Thank you,
    Abbas


    ------------------------------
    [Abbas] [Alnamar]
    [Data Management and Analytics System Administrator]
    [Emporia State University]
    [Kansas, USA]
    ------------------------------



  • 8.  RE: Need assistance: CM-REQ-4159, CM-CAM-4005 errors when users try to authenticate to Cognos

    Posted 07/06/26 11:57 AM

    Hi, 

    Thanks for the reply, but the issue is not with schedules. The users cannot log into cognos to run reports.  Cognos servers have been restarted but has not resolved the issue.



    ------------------------------
    Mayur Madoo
    ------------------------------

    Original Message


  • 9.  RE: Need assistance: CM-REQ-4159, CM-CAM-4005 errors when users try to authenticate to Cognos

    Posted 07/06/26 02:27 PM

    Hi,

    This issue is solved just restarting CM. Every weekend we are restarting CM instance because new users are getting this error on first time logon.

    It's a defect in CA 12.



    ------------------------------
    Jeam Coelho
    Cognos Solution Architect

    IBM Champion

    LinkedIn: https://www.linkedin.com/in/jeamcoelho/
    ------------------------------



  • 10.  RE: Need assistance: CM-REQ-4159, CM-CAM-4005 errors when users try to authenticate to Cognos

    Posted 07/07/26 03:45 AM

    Thanks all. I had a call with IBM support and based on the following tech note the issue has been resloved.

    Some users are unable to access Cognos Analytics after an upgrade



    ------------------------------
    Mayur Madoo
    ------------------------------

    Original Message


  • 11.  RE: Need assistance: CM-REQ-4159, CM-CAM-4005 errors when users try to authenticate to Cognos

    Posted 07/07/26 03:55 AM

    Mayur,

    Thank you for sharing this technote, it is very useful.

    Best regards,



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

    Original Message


  • 12.  RE: Need assistance: CM-REQ-4159, CM-CAM-4005 errors when users try to authenticate to Cognos

    Posted 07/07/26 03:46 AM

    Thanks the issue has been resolved based on the following technote : Some users are unable to access Cognos Analytics after an upgrade



    ------------------------------
    Mayur Madoo
    ------------------------------

    Original Message


  • 13.  RE: Need assistance: CM-REQ-4159, CM-CAM-4005 errors when users try to authenticate to Cognos

    Posted 07/07/26 11:26 AM

    Yes, same steps I've posted here that you comment

    https://community.ibm.com/community/user/discussion/issues-after-upgrading-to-cognos-1211-share-your-experience



    ------------------------------
    Jeam Coelho
    Cognos Solution Architect

    IBM Champion

    LinkedIn: https://www.linkedin.com/in/jeamcoelho/
    ------------------------------

    Original Message


Related Content