5 Replies Latest reply: May 13, 2013 3:02 AM by Veeresh Rayan RSS

    OBIEE 11g OBIA  7.9.6.4

    orag
      Hi,

      I installed OBIEE 11.1.1.7.0 on windows 2003 64 bit machine followed by OBIA , informatica and DAC.
      immediately after installation i was able to login to /em , /console & '9704/analytics' but after machine restart
      I was able to login to /em and /console but unable to login to 'analytics' page '9704/analytics' and getting 'An invalid User Name or Password was entered' error
      using weblogic user id and password given during installation.

      tried
      1. changing "BISystemUser" user password in security releam but not able to login with BISystemUser
      2. changing instanceconfig.xml to include
      <ps:Validate>OnStartup</ps:Validate>
      <ps:ValidateItems>None</ps:ValidateItems>
      <ps:ValidateLinks>None</ps:ValidateLinks>
      <ps:ValidateAccounts>Clean</ps:ValidateAccounts>
      <ps:ValidateHomes>None</ps:ValidateHomes>

      in NQSConfig.INI FMW_UPDATE_ROLE_AND_USER_REF_GUIDS changed its value to YES

      restarted the entire services but no luck



      how to overcome this issue?

      Thanks i
        • 1. Re: OBIEE 11g OBIA  7.9.6.4
          SunilSharma
          user9158217 wrote:

          1. changing "BISystemUser" user password in security releam but not able to login with BISystemUser
          >
          in NQSConfig.INI FMW_UPDATE_ROLE_AND_USER_REF_GUIDS changed its value to YES

          restarted the entire services but no luck



          how to overcome this issue?

          Thanks i
          along with resetting bisystem user pwd in weblogic also change the same in EM for bisystemuser and you need to change the GUID's to NO and restart the services and see how it goes.

          Also check the logs sawlog.log for more details
          • 2. Re: OBIEE 11g OBIA  7.9.6.4
            orag
            hi

            tried changing password in EM for bisystemuser and reset in NQSConfig.INI FMW_UPDATE_ROLE_AND_USER_REF_GUIDS to YES
            but same issue...

            logs sawlog.log

            [2013-05-10T00:33:28.000-07:00] [OBIPS] [ERROR:31] [] [saw.security.odbcuserpopulationimpl.searchidentities] [ecid: 00iEitUp2qY5yW^5xV_AiW0000aS000000,0:80] [tid: 6464] 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
            Location:
                 saw.security.odbcuserpopulationimpl.searchidentities
                 saw.security.userpopulationmanagerimpl.searchidentities
                 saw.catalog.dirCache.getAllSharedFolders
                 saw.CatalogAttributes.cache.cleanup
                 saw.taskScheduler.processJob
                 saw.threadpool.taskscheduler
                 saw.threads
            ecid: 00iEitUp2qY5yW^5xV_AiW0000aS000000,0:80
            ThreadID: 6464
            task: Cache/CatalogAttributes
            ]]

            nqserver.log logs

            [2013-05-10T00:15:16.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00iEiKH0azr5yW^5xV_AiW0001sg000000] [tid: 1dfc] java.security.AccessControlException: access denied (oracle.security.jps.service.credstore.CredentialAccessPermission context=SYSTEM,mapName=oracle.bi.system,keyName=system.user read)
            [2013-05-10T00:15:16.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00iEiKH0azr5yW^5xV_AiW0001sg000000] [tid: 1dfc] [nQSError: 43126] Authentication failed: invalid user/password.


            thanks
            • 3. Re: OBIEE 11g OBIA  7.9.6.4
              Veeresh Rayan
              OBIEE 11g: Unable to Sign In into presentation services & RPD OBIEE analysi

              Check this and mark as correct if it helps,

              Regards,
              Veeresh Rayan
              • 4. Re: OBIEE 11g OBIA  7.9.6.4
                orag
                Hi,

                thank you for pointing out this bug....

                thanks
                • 5. Re: OBIEE 11g OBIA  7.9.6.4
                  Veeresh Rayan
                  Hi,

                  Plz have the habit of making correct or helpful whenever you find the answer in this forum.

                  Regards,
                  Veeresh Rayan