My Oracle Support Banner

Oracle Exalytics OBIEE 112c Integrated With ESSBASE ASO Cube Showing All Zeros For Measure Column (Doc ID 2309971.1)

Last updated on AUGUST 14, 2019

Applies to:

Business Intelligence Reporting and Publishing - Version and later
Information in this document applies to any platform.


On : 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 [111]: Failed to connect to []Invalid login id - request [Select Application/Database] failedInvalid login id - request [EssLogout] failed [[
Properties: description=<> DbGateway Exchange: 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

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