OBIEE 11g: Queries Using Simba ODBC Driver With Google Big Query Fail With nQSError 16011 ' Unable to read from file buffer.' And Creates Huge Temporary Files

(Doc ID 2030248.1)

Last updated on AUGUST 16, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.150120 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.150120 and later
Oracle Business Intelligence Enterprise Edition - Version N/A and later
Information in this document applies to any platform.

Symptoms

Note: This is not a supported datasource for OBIEE which means there is no specific option in the metadata for it.  Therefore, it must be configured as an ODBC Advanced datasource, with database feature settings customized.  The connection pool has to use an ODBC driver, which is not supplied by Oracle

Per the Certification Matrix: ERP-Apps and Other Datasources tab > Generic ODBC

5. For 3rd party drivers not explicitly certified by Oracle, it is the customer’s responsibility to work with the 3rd party vendor to insure compatible and functional installation of the driver on the Oracle Business Intelligence Server.


 





You are using the following in your environment:

 

Creating queries with small amounts of data creates huge temporary files.

 

In the OBI Server(nqsserver.log) log you may see:

 

General error: Unable to read from file buffer. [nQSError: 16011] ODBC error occurred while executing SQLExtendedFetch to retrieve the results of a SQL statement.

 

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 12002] Socket communication error at call=recv: (Number=9) Bad file descriptor (HY000) and potentially the OBI Server (nqsserver) crashes.


An excerpt from a session log shows an extremely large row size:

Execution Node: <<27278>> Projection, Close Row Count = 4000, Row Width = 524384 bytes [[

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