Smartview Drill Through Report Giving Out Of Memory Error:" RequestListener.outOfMemory " (Doc ID 1953318.1)

Last updated on AUGUST 02, 2016

Applies to:

Hyperion Essbase - Version 11.1.2.2.100 and later
Information in this document applies to any platform.

Symptoms

On 11.1.2.2.100 version, Smart View


Unable to use Drill Through in Smart View

Brand new install of EPM 11.1.2.2.1 version, using the embedded weblogic server without OHS. The same drill through the same intersection works in previous version 11.1.2.0.

DTR is working in 11.1.2.0 studio, java set to 4048m

But in 11.1.2.2.100, new installation with java set to 6 g

 [SRC_METHOD: runSayStatement] run
DTR name: form : \'MAIN'\'Drill thru reports'\'TEST_INC'; args: hierarchy :
\'MAIN'\'Hierarchies'\'Time' :: class : \'MAIN'\'Dim
Elements'\'Time'\'DETAIL' :: "Sep"

[SRC_CLASS: com.hyperion.cp.server.RequestListener$NetworkTask] [SRC_METHOD:
run] RequestListener.outOfMemory

This is ASO application.

SQL from EPM 11.1.2.0

SELECT cp_148."TIME" as "TIME" FROM "HYPADMIN2"."VIEW_MAIN_FACT" cp_148 INNER
JOIN "HYPADMIN2"."MANUAL_ESSBASE_TIME" cp_121 ON
(cp_121."DETAIL"=cp_148."TIME") WHERE ($$Time-COLUMN$$ IN ( $$Time-VALUE$$))

SQL from EPM 11.1.2.2.100

SELECT cp_148."TIME" as "TIME" FROM "HYPADMIN2"."VIEW_MAIN_FACT" cp_148 FULL
JOIN "HYPADMIN2"."MANUAL_ESSBASE_TIME" cp_121 ON
(cp_121."DETAIL"=cp_148."TIME") WHERE ($$Time-COLUMN$$ IN ( $$Time-VALUE$$))


Relational database oracle.
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms