AnsweredAssumed Answered

Resultset overflow occured

Question asked by Mayuri Donda on Mar 4, 2019

Hi,

I have created cube in PSW and published it over BI server. Using this cube I have created jPivot view (slice & dice).

When I try to expand the view it gives me "Resultset overflow occured" message. Logs are not showing any error.

 

I am using PSW CE -8.1 and Pentaho Server CE 8.1

Total records in fact table is 25 million

 

Below is done to optimise the performance:

1. Indexes are added in dimensions and fact tables

2. Pentaho query time out increased

     file name - pentahoobjects.spring.xml

     <bean id="connection-SQL" class="org.pentaho.platform.plugin.services.connections.sql.SQLConnection"

        scope="prototype">

         <property name="fallBackToNonscrollableOnError" value="true"/>

         <property name="maxRows" value="2500000" />

           <property name="queryTimeout" value="120" /> <!-- In Seconds -->

           <property name="readOnly" value="true" />

       </bean>

3. Tomcat time out increased

     server.xml -> change connectiontimeout to 0

     <Connector URIEncoding="UTF-8" port="8080" protocol="HTTP/1.1"

               connectionTimeout="0"

               redirectPort="8443" />

4. Below mondrian.properties are changed (mondrian/mondrian.properties)

mondrian.result.limit=0

mondrian.olap.case.sensitive=false

mondrian.native.crossjoin.enable=true

mondrian.native.ExpandNonNative=false

 

Please suggest what is wrong or any other property needs to be optimised.

 

Thanks,

Mayuri

Outcomes