OBIEE: "[nQSError: 16002] Cannot obtain number of columns for the query result" While Accessing Data on a SQL Server Database
Last updated on MARCH 16, 2018
Applies to:Business Intelligence Server Enterprise Edition - Version 188.8.131.52.1 and later
Information in this document applies to any platform.
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.
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