OBIEE: "[nQSError: 16002] Cannot obtain number of columns for the query result" While Accessing Data on a SQL Server Database

(Doc ID 2371658.1)

Last updated on MARCH 16, 2018

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

You are trying to connect to a SQL Server database as per the instructions in Configuring the DataDirect Connect ODBC Driver for Microsoft SQL Server Database, but when trying to access the database with functions in Repository physical layer (View Data or Update Row Counts) you get this error:


State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS. [nQSError: 16001]
ODBC error state: S0002 code: 208 message: [DataDirect]
[ODBC SQL Server Driver][SQL Server]Invalid object name '<object_name>'..
[nQSError: 16002] Cannot obtain number of columns for the query result. (HY000)

You can connect to this SQL Server Database and retrieve the correct data with the same ODBC driver and connection setting by using SQL Studio and Excel.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms