I created a dynamic cube. The cube starts successfully and loaded in memory aggregates successfully.
When I start using the cube, it retrieves data for higher levels in the dimensional hierarchy. But when i drill down to lower levels it gives me the below error:
DPR-ERR-2056 The Report Server is not responding.
I have modified the default settings of Query Service as mentioned below:
Initial JVM heap size for the query service (MB) (Requires QueryService restart) 4096
JVM heap size limit for the query service (MB) (Requires QueryService restart) 2048
I have only one dispatcher and I am working in dev environment and I don't have any other load on the server except cube.
Can anyone please help me with this.
Thanks in advance
Quote from: akshara_a on 09 Aug 2016 11:44:43 PM
I created a dynamic cube. The cube starts successfully and loaded in memory aggregates successfully.
When I start using the cube, it retrieves data for higher levels in the dimensional hierarchy. But when i drill down to lower levels it gives me the below error:
DPR-ERR-2056 The Report Server is not responding.
I have modified the default settings of Query Service as mentioned below:
Initial JVM heap size for the query service (MB) (Requires QueryService restart) 4096
JVM heap size limit for the query service (MB) (Requires QueryService restart) 2048
I have only one dispatcher and I am working in dev environment and I don't have any other load on the server except cube.
Can anyone please help me with this.
Thanks in advance
Have you done any sort of sizing exercise to see how much memory your cube requires in the Query Service JVM? Take a look at the Hardware Sizing chapter of the redbook for details:
http://www.redbooks.ibm.com/abstracts/sg248064.html?Open
Cheers!
MF.