Oracle Exalytics OBIEE 112c Integrated With ESSBASE ASO Cube Showing All Zeros For Measure Column
(Doc ID 2309971.1)
Last updated on FEBRUARY 03, 2019
Applies to:Business Intelligence Reporting and Publishing - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
On : 188.8.131.52.0 version, Analytics
When attempting to report on an ASO Cube, see only zeros for data and the following error occurs in the OBIEE query logs at the same time:
[2017-04-07T11:10:15.575-04:00] [OBIS] [ERROR:1]   [ecid: d1839dad-7eb7-42f4-9a0c-bb12e3a5b98f-000172f5,0:1:23:5:1] [sik: ssi] [tid: 2ffff700] Network error : Failed to connect to [XXX.xxx.com:1423]Invalid login id - request [Select Application/Database] failedInvalid login id - request [EssLogout] failed [[
Properties: description=<> DbGateway Exchange: XXXXX.xxx.com.Essabse Connection Pool; producerID=0xbf7a0d18; requestID=0x520b000e; sessionID=0x520b0000; userName=weblogic;
The issue can be reproduced at will with the following steps:
1. In OBIEE report on the ASO Cube.
2. See values with zero returned.
3. Report on BSO cube, or sample ASO cube works. Viewing the ASO Cube from SmartView works.
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