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
Last updated on AUGUST 16, 2017
Applies to:Business Intelligence Server Enterprise Edition - Version 184.108.40.206.150120 and later
Business Intelligence Suite Enterprise Edition - Version 220.127.116.11.150120 and later
Oracle Business Intelligence Enterprise Edition - Version N/A and later
Information in this document applies to any platform.
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:
- Google Biq Query datasource - https://cloud.google.com/bigquery/third-party-tools
- Simba Big Query ODBC driver (note: this is a 3rd party driver) - https://www.simba.com/connectors/google-bigquery-odbc
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 [[
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