OBIEE Can Not Connect To DB/2
(Doc ID 2421247.1)
Last updated on MARCH 18, 2021
Applies to:
Business Intelligence Server Enterprise Edition - Version 11.1.1.9.0 and laterInformation in this document applies to any platform.
Symptoms
Environment
===========
11.1.1.9.0
OS: IBM AIX 7.1
DB2: IBM DB2 UDB 10.5.5
DB2 Installed OS: IBM AIX 7.1
Getting error messages and can not access DB/2 database in OBIEE.
Connection open failed:
[DataDirect][ODBC lib] The driver is incapable of supporting the current environment attributes.
Give data source name:
logs:
[<TIMESTAMP>] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: <ECID>] [tid: <TID>] [nQSError: 16017] Memory allocation error occurred while allocating ODBC environment. [[
[DataDirect][ODBC lib] You are not licensed to use this ODBC driver with the DataDirect ODBC Driver Manager under the license you have purchased. You can order a license by calling DataDirect Technologies at xxx-xxx-xxxx in North America and +xx (0) xxxx-xxx xxx elsewhere. Thank you for your cooperation.
Statement execute failed
NQServer logs
[nQSError: 43119] Query Failed: Could not load module . System error: No such file or directory (HY000)
nqserver logs after correcting path of DB2 lib
[ERROR:1] [] [] [ecid:
<ECID>] [tid: <TID>] [nQSError: 16017] Memory
allocation error occurred while allocating ODBC environment. [[
file:
server/Query/Execution/DbGateway/Db2Cli35/../Odbc/Src/SQXDGOdbcConnection.cpp;
line: 246
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |