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

OBIEE 12c to TIBCO® Data Virtualization 8.2 DB connection issues

Received Response
11
Views
2
Comments
3710499
3710499 Rank 1 - Community Starter
edited Aug 13, 2024 5:18PM in Oracle Analytics Cloud and Server

Hi All ,

We are trying to connect to Tibco data virtualization 8.2 DB from OBIEE 12c using the ODBC driver (oracle.bi.datadirect.odbc/7.1.5/lib/libcomposite82_x64.so)  but we are getting below errors in OBIEE report.

Previously we connected to  Tibco 7.0 version from OBIEE using odbc driver " libcomposite70_x64.so" -- we didn't face any issues in 7 version

Did anyone face the same issue in Tibco 8 version driver?

Please help me to resolve the issue.

View Display Error

Odbc driver returned an error (SQLExecDirectW).

  Error Details

Error Codes: OPR4ONWY: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: 16001. [nQSError: 16001] ODBC error state: IM003 code: 0 message: [DataDirect][ODBC lib] Specified driver could not be loaded. (HY000)

Thanks in advance!

Thanks ,

Bharath

Answers

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

    [DataDirect][ODBC lib] Specified driver could not be loaded

    That points to a much more basic problem. It looks like the driver isn't even accessible/usable on OS level resp. when OBI tries to access it.

  • 3710499
    3710499 Rank 1 - Community Starter

    Thanks Christian for your prompt reply.

    we have configured/installed 8 version driver same way how we did 7 version drivers configuration.

    I would like to know whether OBIEE supports Tibco data virtualization 8.2 version driver or not ?

    Thanks ,

    Bharath