My Oracle Support Banner

OBIEE 12c: Configuring DB2 data source with OBIEE causes error " Data source name not found and no default driver specified " (Doc ID 2570997.1)

Last updated on AUGUST 27, 2021

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.0.0 to 12.2.1.4.190716 [Release 12g]
Information in this document applies to any platform.

Symptoms

After configuring data source DB2 as per the guide, getting the following errors while running the reports.

Compound Layout
Error
View Display Error

Odbc driver returned an error (SQLExecDirectW).
 Error Details
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 16028. [nQSError: 16028] ODBC error state: IM002 code: 0 message: [DataDirect][ODBC lib] Data source name not found and no default driver specified. (HY000)
SQL Issued: SELECT 0 s_0, "Enterprise WAM"."- Device"."OEM Code" s_1 FROM "Enterprise WAM" FETCH FIRST 65001 ROWS ONLY
============================================================

 

saw.log

=========

 

[2019-06-19T13:04:21.946-05:00] [OBIS] [TRACE:2] [] [] [ecid: 62667674-c423-474e-a0f3-b6b139f8da92-0002fc55,0:1:15:5] [sik: ssi] [tid: 18d26700] [messageid: USER-18] [requestid: 7c6e003d] [sessionid: 7c6e0000] [username: weblogic] -------------------- Sending query to database named ABCDEF (id: <<551877>>), connection pool named Connection Pool, logical request hash c255039d, physical request hash 69d62558: [[
WITH
SAWITH0 AS (select distinct T71818."OEM_CODE" as c1
from
    "xyz"."DEVICE" T71818)
select 0 as c1,
    D1.c1 as c2
from
    SAWITH0 D1

]]
[2019-06-19T13:04:21.954-05:00] [OBIS] [TRACE:2] [] [] [ecid: 62667674-c423-474e-a0f3-b6b139f8da92-0002fc55,0:1:15:5] [sik: ssi] [tid: 18d26700] [messageid: USER-34] [requestid: 7c6e003d] [sessionid: 7c6e0000] [username: weblogic] -------------------- Query Status: [nQSError: 16028] ODBC error state: IM002 code: 0 message: [DataDirect][ODBC lib] Data source name not found and no default driver specified. [[
[nQSError: 43119] Query Failed:

]]
[2019-06-19T13:04:34.607-05:00] [OBIS] [TRACE:2] [] [] [ecid: 62667674-c423-474e-a0f3-b6b139f8da92-0002fc5a,0:1:1:3] [sik: ssi] [tid: 18d26700] [messageid: USER-0] [requestid: 7c6e003e] [sessionid: 7c6e0000] [username: weblogic] ############################################## [[
-------------------- SQL Request, logical request hash:
e5800c1b
SET VARIABLE OBIS_REFRESH_CACHE=1,QUERY_SRC_CD='Report';SELECT
  0 s_0,
  "Enterprise WAM"."- Device"."OEM Code" s_1
FROM "Enterprise WAM"
ORDER BY 2 ASC NULLS LAST
FETCH FIRST 65001 ROWS ONLY

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.