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 FEBRUARY 03, 2019

Applies to:

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

Symptoms

On : 12.2.1.1.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:

ERROR
-----------------------
[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 [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;


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

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.