OBIEE - ODBC

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)

1 - About

To know the basis of ODBC, check this article: ODBC.

ODBC is closer related to the BI Server. It uses it to:

Advertising

3 - Support Type

The Oracle Business Intelligence Server supports accessing:

  • ODBC 2.0 and 2.1 compliant databases/data sources for 8-bit character sets.
  • ODBC 3.5 compliant databases/data sources for UTF-16 (unicode) character sets.

4 - DataDirect ODBC Drivers

Since Oracle BI EE 10.1.3.3.1, the installation provides DataDirect Connect ODBC drivers and driver managers for Linux and UNIX operating systems for connectivity to

DB2 Wire Protocol=DataDirect 7.1 DB2 Wire Protocol
Informix Wire Protocol=DataDirect 7.1 Informix Wire Protocol
Oracle Wire Protocol=DataDirect 7.1 Oracle Wire Protocol
Sybase Wire Protocol=DataDirect 7.1 Sybase Wire Protocol
Teradata=DataDirect 7.1 Teradata
SQL Server Wire Protocol=DataDirect 7.1 SQL Server Wire Protocol
MySQL Wire Protocol=DataDirect 7.1 MySQL Wire Protocol
PostgreSQL Wire Protocol=DataDirect 7.1 PostgreSQL Wire Protocol
Greenplum Wire Protocol=DataDirect 7.1 Greenplum Wire Protocol
Salesforce=DataDirect 7.1 Salesforce
Sybase IQ Wire Protocol=DataDirect 7.1 Sybase IQ Wire Protocol
Progress OpenEdge Wire Protocol=DataDirect 7.1 Progress OpenEdge Wire Protocol
Apache Hive Wire Protocol=DataDirect 7.1 Apache Hive Wire Protocol
Impala Wire Protocol=DataDirect 7.1 Impala Wire Protocol

5 - Support

5.1 - The connection has failed

The log is nqquery.log

Example:

  • Specified driver could not be loaded
[nQSError: 16001] ODBC error state: IM003 code: 0 message: 
[DataDirect][ODBC lib] Specified driver could not be loaded. [[
[nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement.
[nQSError: 43119] Query Failed: 
  • Driver does not support this function. Change the interface from 3.5 to 2 for instance.
[nQSError: 16001] ODBC error state: IM001 code: 0 message: 
[unixODBC][Driver Manager]Driver does not support this function. 
[nQSError: 16001] ODBC error state: S1000 code: 0 message: 
[unixODBC][Driver Manager]Driver returned SQL_ERROR or SQL_SUCCESS_WITH_INFO but no error reporting API found. (HY000)
Advertising

5.2 - Environment variable of the nqsserver

 cat /proc/`pidof nqsserver`/environ | tr \\0 \\n

5.3 - Backtrace Example

Backtrace Example where we see the call the data direct driver (Merant/7.1.5/lib/libodbc.so)

/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqutilityserver64.so(_ZN71_GLOBAL__N_server_Utility_Server_Src_CrashHandler.cpp_CF4CBC2E_03BAD87B15bisCrashHandlerEiP7siginfoPv+0x1a9)[0x7fcd197dda89]
/lib64/libpthread.so.0[0x35bc60eb70]
/lib64/libc.so.6(cfree+0x1e)[0x35bba7288e]
/u01/app/oracle/product/fmw/Oracle_BI1/common/ODBC/Merant/7.1.5/lib/libodbc.so[0x7fcd0b65cd35]
/u01/app/oracle/product/fmw/Oracle_BI1/common/ODBC/Merant/7.1.5/lib/libodbc.so[0x7fcd0b65c0a0]
/u01/app/oracle/product/fmw/Oracle_BI1/common/ODBC/Merant/7.1.5/lib/libodbc.so[0x7fcd0b65c4d0]
/u01/app/oracle/product/fmw/Oracle_BI1/common/ODBC/Merant/7.1.5/lib/libodbc.so(SQLDriverConnect+0x149)[0x7fcd0b6453d7]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqsdbgatewayodbc64.so(_ZN8NQSQLAPI18NQSQLDriverConnectEPvS0_RKN3sup6StringIwN7_SASSTL9allocatorIwEEEES8_S8_tbS8_+0x1ee)[0x7fcd01cebc1e]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqsdbgatewayodbc64.so(_ZN24OdbcDataSourceConnection7ConnectERK6SignonbjN10ServerInfo17TxnIsolationLevelEi+0x28d)[0x7fcd01cfea2d]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqutilityserver64.so(_ZN20DataSourceConnection7ConnectERK6SignonbRK14GatewayOptions+0x7c)[0x7fcd1977932c]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqsdbconnection64.so(_ZN12DbConnection9FixDamageERK14GatewayOptions+0x7c)[0x7fcd1f71a9ec]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqsdbconnection64.so(_ZN19MultiThreadedDbPool22GetAvailableConnectionERK6SignonR17DbConnectionGuardRbRK14GatewayOptions+0x398)[0x7fcd1f72a138]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqsdbgateway64.so(_ZN11NQDbGateway7PrepareEv+0xc98)[0x7fcd1f5ceaa8]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqsexecutionlist64.so(_ZN8Producer11ExecuteOnceEv+0xa80)[0x7fcd1ed0df40]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqutilitygeneric64.so(_ZN16NQExecutionState17ExecuteSystemMainEv+0x85)[0x7fcd199d4ab5]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqutilitygeneric64.so(_ZN15NQThreadJobBase17ExecuteSystemMainEv+0x55)[0x7fcd19a1a455]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqutilitygeneric64.so(_ZN10PoolThread15ExecuteUserMainEv+0x325)[0x7fcd19a1bd95]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqutilitygeneric64.so(_ZN16NQExecutionState17ExecuteSystemMainEv+0x85)[0x7fcd199d4ab5]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqutilitygeneric64.so(_ZN8NQThread17ExecuteSystemMainEv+0x5b)[0x7fcd19a1964b]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqutilitygeneric64.so(_ZN8NQThread15ThreadMainEntryEPv+0x32)[0x7fcd19a18d52]
/lib64/libpthread.so.0[0x35bc60673d]
/lib64/libc.so.6(clone+0x6d)[0x35bbad44bd]

6 - Documentation / Reference