Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Error retrieving user/group data from Oracle BI Server's User Population API. - OBIEE11g to 12c upgr

Received Response
131
Views
6
Comments
3914424
3914424 Rank 1 - Community Starter
edited Aug 13, 2024 5:25PM in Oracle Analytics Cloud and Server

We are doing OBIEE 11g  11.1.1.9.1 tto OBIEE12c 12.2.1.3. Its a linux environment. Post Upgrading OBIEE11g code successfully , I logged-into OBIEE12c environment and clicked on "My account" and also "Manage priveileges", I got the below error..

I suspect somewhere the policy is being hit but if you have faced any issues please let me know.

Error retrieving user/group data from Oracle BI Server's User Population API.

  Error Details

Error Codes: GDU6UYHS:WBXPUTP7:IHVF6OM7:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC

Location: saw.security.odbcuserpopulationimpl.getroles, saw.security.userpopulationmanagerimpl.searchidentities, saw.security.userpopulationmanagerimpl.getmultipleaccountdetails, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads

Could not create a system user connection to Oracle BI Server. Please check the error message and try again.

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. (08004)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

State: HY000. Code: 43126. [nQSError: 43126] Authentication failed: invalid user/password. (HY000)

Tagged:

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    3914424 wrote:We are doing OBIEE 11g 11.1.1.9.1 tto OBIEE12c 12.2.1.3.

    You may want to think about what you are doing there. You are upgrading to an out-of-date and no longer supported version. That's questionable at best.

    https://support.oracle.com/epmos/faces/DocContentDisplay?id=2070465.1

  • 3914424
    3914424 Rank 1 - Community Starter

    Hi Chris,

    Thanks for your response.

    I earlier tried with 12.2.1.4  and I was facing the similar issue. I suspected if the issue could be with latest version. So This time I tried with one step back version and facing the same issue. So its confirmed its not Software related one.

    Regards,

    Rathi

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    If you had this with .4 as well then the it looks like catalog corruption. This issue had also been reported in 11g already (see MOS Doc ID 2064955.1).

    Personally I only faced this issue only a handful of times and its resolution was tailor-made for the situations. It's classically backlog of legacy "nastiness" for lack of a better term.

  • 3914424
    3914424 Rank 1 - Community Starter

    Hi Chris,

    Gone through the link and its to do catalog validation and GUID refresh and which I have done it prior to taking the 11g bundle.

    regards,

    Rathinavel D

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    I know. Didn't imply that that's the solution, just saying it got reported already.

  • 3914424
    3914424 Rank 1 - Community Starter

    Thats right Chris. But suspecting some thing at the policy store  issue..