SQL Server Odbc driver returned an error

Question

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)

user8680861 · Answer

Please find below the details:

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

sql server 15.0.600

Joel Acha · Answer

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.