My Oracle Support Banner

OBIEE Displays Partial Result, When Querying SQL Server (Doc ID 2090336.1)

Last updated on DECEMBER 03, 2019

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

You have configured an ODBC connection for a SQL Server data source and then create connection in your RPD, you are able to view data in the RPD successfully.

But when you create an analysis you only get 4 rows populated, and when you execute physical query in the database directly, there are 32 rows.

Below is the query sent to backend DB and log return in the saw.log

[<TIMESTAMP>] [OracleBIServerComponent] [TRACE:5] [] [] [ecid: <ECID>] [tid: <TID>] [messageid: <MESSAGE_ID>] [requestid: <REQUEST_ID>] [sessionid: <SESSION_ID>] [username: <USERNAME>] -------------------- Sending query to database named <database_name> (id: <<482251>>), connection pool named Connection Pool, logical request hash dcebc564, physical request hash 5af27eb0: [[
select 0 as c1,
D1.c4 as c2,
D1.c3 as c3,
D1.c2 as c4,
D1.c1 as c5
from
(select count(T91741.[<column1>]) as c1,
T91741.[<column2>] as c2,
T91741.[<column3>] as c3,
T91741.[<column4>] as c4
from <table> T91741 /* Help_Desk */
group by T91741.[<column1>], T91741.[<column1>], T91741.[<column3>]
) D1
order by c3, c4

]]

--- Execution Node for logical request hash dcebc564 : <<482251>>, Close Row Count = 32, Row Width = 131572 bytes
--- Query Result Cache: [59124] The query for user '<USERID>' was inserted into the query result cache. The filename is '<INSTANCE_HOME>/bifoundation/OracleBIServerComponent/coreapplication_obis1/cache/<name>.TBL'.
--- Execution Node for logical request hash dcebc564 : <<482284>> GroupByNoSort, Close Row Count = 4, Row Width = 131572 bytes
--- Execution Node for logical request hash dcebc564 : <<482285>> Projection, Close Row Count = 4, Row Width = 131572 bytes
--- Execution Node for logical request hash dcebc564 : <<482285>> Sort, Close Row Count = 4, Row Width = 131572 bytes
--- Execution Node for logical request hash dcebc564 : <<482305>> DbGateway Exchange: Help Desk Survey.Connection Pool, Close Row Count = 4, Row Width = 131572 bytes
--- Query Status: Successful Completion
--- Rows 32, bytes 4210304 retrieved from database query id: <<482251>>
--- Physical query response time 50.137 (seconds), id <<482251>>
--- Physical Query Summary Stats: Number of physical queries 1, Cumulative time 50.137, DB-connect time 0.000 (seconds)
--- Rows returned to Client 4
--- Logical Query Summary Stats: Elapsed time 50.374, Total time in BI Server 50.372, Response time 50.373, Compilation time 0.018 (seconds), Logical hash dcebc564
--- Execution Node for logical request hash dcebc564 : <<482284>> GroupByNoSort, Close Row Count = 4, Row Width = 131572 bytes
--- Execution Node for logical request hash dcebc564 : <<482285>> Projection, Close Row Count = 4, Row Width = 131572 bytes
--- Execution Node for logical request hash dcebc564 : <<482285>> Sort, Close Row Count = 4, Row Width = 131572 bytes
--- Execution Node for logical request hash dcebc564 : <<482305>> DbGateway Exchange: Help Desk Survey.Connection Pool, Close Row Count = 4, Row Width = 131572 bytes

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
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.