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

SQL Server Odbc driver returned an error

Received Response
12
Views
2
Comments
user8680861
user8680861 Rank 2 - Community Beginner
edited Aug 13, 2024 5:46PM in Oracle Analytics Cloud and Server

Hi experts,

When i'm trying to create the reports based on SQL server cloud db in OBIEE12c , The following error occurs.

Please guide.

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: 16001. [nQSError: 16001] ODBC error state: 01004 code: 0 message: [Microsoft][SQL Server Native Client 11.0]String data, right truncation. (HY000)

State: HY000. Code: 16011. [nQSError: 16011] ODBC error occurred while executing SQLExtendedFetch to retrieve the results of a SQL statement. (HY000)

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    You haven't provided the specific version numbers of SQL Server & OBIEE. Also, can you check your BI server log file and presentation server log for some clues.

  • user8680861
    user8680861 Rank 2 - Community Beginner

    Please find below the details: 

    image Oracle Business Intelligence Product Version 12.2.1.3.0 (Build BIPS-20170820114118 64-bit)

    sql server 15.0.600