After upgrading OBIEE 12.2.1.0 to 12.2.1.2 .. BISQLGroupProvider is not working - Page 2 — Oracle Analytics

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

After upgrading OBIEE 12.2.1.0 to 12.2.1.2 .. BISQLGroupProvider is not working

Received Response
112
Views
15
Comments
2»

Answers

  • SaQ-Orcl
    SaQ-Orcl Rank 4 - Community Specialist

    After moving the driver in new oracle_home1 above error has vanished and now poping up new error as  below. means OBIEE is net able to find correct odbc entry.(Not sure in which location in need to move odbc.ini file )

    Odbc driver returned an error (SQLExecDirectW).

      Error Details

    Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

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

    State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)

    State: HY000. Code: 16027. [nQSError: 16027] ODBC error state: 28000 code: 18456 message: [DataDirect][ODBC SQL Server Wire Protocol driver][SQL Server]Login failed for user 'obi_user'.. (HY000)

    State: HY000. Code: 16028. [nQSError: 16028] ODBC error state: 08001 code: 4060 message: [DataDirect][ODBC SQL Server Wire Protocol driver][SQL Server]Cannot open database "EDW_DEV" requested by the login. The login failed.. (HY000)

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    Confirm that the database server and its services are up and running and is allowing connections. If you are unsure where to look or how to check, contact your Database Administrator (DBA).

    Ensure the database name used in the parameter, located in odbc.ini file, is correct.

    Open RPD in online mode and check the connectivity by performing "import metadata" operations.

  • 3309099
    3309099 Rank 2 - Community Beginner

    Hi,

    Normally : we have to comment the section during upgrade and uncomment it after upgrade. it will work.

    1) can you chekc if you have datasource to read data in Console ? if not I will just suggest you to create BISQLgroup prover from scratch in new version. It hardly takes 30  minutes

    Thanks

    Venkat

  • SaQ-Orcl
    SaQ-Orcl Rank 4 - Community Specialist

    Hi,

    It was working perfectly before upgrade but triggering error now. I am assuming that we need to move ODBC.ini in new oracle home ( Oracle_home1).

    Thanks

  • SaQ-Orcl
    SaQ-Orcl Rank 4 - Community Specialist

    If yes then I am not sure about the location because there is no folder inside new domain(Oracle_home1).