1 Reply Latest reply on Nov 29, 2013 11:42 AM by Srikanth Mandadi

    Authentication error while logging in to analytics url

    SrikarSoma

      Hi,

       

      I have installed OBIEE 11g on Windows XP 64 bit server recently.

      I’m unable to login to analytics page "http://xxxxxx:7001/analytics"/"http://xxxxxx:9704/analytics"  But  able to login to enterprise manager('http://xxxxxx:7001/em')and console .

      I’m using the default 'weblogic' user id and the password I have given during the installation.

      Also I’m able to access RPD with default password .

      The policy manager is operational and also all the services are running even though we are unable to login to analytics page.

      Can any one help me in this regard

      below is the error extracted from log file:

       

      [2013-11-29T11:52:02.000+01:00] [OBIPS] [ERROR:31] [] [saw.security.odbcuserpopulationimpl.searchidentities] [ecid: 00iIiDxw41x72FYidpedKL0001gK000000,0:1351] [tid: 9868] Error retrieving user/group data from Oracle BI Server's User Population API.
      Unable to create a system user connection to BI Server while running user population queries
      Authentication Failure.
      Odbc driver returned an error (SQLDriverConnectW).
      State: 08004.  Code: 10018.  [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.
      [nQSError: 43113] Message returned from OBIS.
      [nQSError: 43126] Authentication failed: invalid user/password. (08004)[[
      File:odbcuserpoploaderimpl.cpp
      Line:726

       

      please help me out from this error

       

      Thanks

        • 1. Re: Authentication error while logging in to analytics url
          Srikanth Mandadi

          Hi,

           

          First try restarting BI Services including Admin Server, Node Manager if issue still persists try below two options -

           

          - Make sure passwords are same in below to locations

          Oracle weblogic Server : Console / Home >Summary of Security Realms > myrealm > Users and Groups > BISystemUser

          EM: weblogic domain > bifoundation_domain > Security > Credentials > oracle.bi.system -> system.user


          - Refresh GUID's

           

          Regards,

          Srikanth