Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Resultset overflow occured

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Aug 2012
    Posts
    23

    Default Resultset overflow occured

    dopo aver fatto un cubo, quando provo ad esplorarlo con Pentaho user console->new analysis view
    quando clicco su una voce della dimensione per espanderla:
    - la schermata mi resta bianca per un po..(finche la cpu ritorna al 10%)
    - la cpu mi va al 100%
    - nella finestra di tomcat attiva in background vedo scritto: WARN [MondrianModel] Mondrian result limit exceeded: Mondrian Error:Query timeout of 300 seconds reached
    -in pentaho.log vedo quanto segue (anche da prima di fare l'interrogazione del cubo)
    2012-09-20 16:10:44,208 WARN [org.pentaho.reporting.libraries.base.boot.PackageManager] Unresolved dependency for package: org.pentaho.reporting.engine.classic.extensions.datasources.cda.CdaModule
    2012-09-20 16:10:44,239 WARN [org.pentaho.reporting.libraries.base.boot.PackageSorter] A dependent module was not found in the list of known modules.
    2012-09-20 16:10:53,239 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2012-09-20 16:10:54,598 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2012-09-20 16:10:54,739 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2012-09-20 16:10:55,177 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2012-09-20 16:10:55,473 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2012-09-20 16:10:55,614 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2012-09-20 16:10:55,723 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2012-09-20 16:10:55,833 WARN [org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator] We don't support method overloading. Ignoring [public java.lang.String serializeModels(org.pentaho.metadata.model.Domain,java.lang.String,boolean) throws java.lang.Exception]
    2012-09-20 16:10:55,848 WARN [org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator] We don't support method overloading. Ignoring [public java.lang.String serializeModels(org.pentaho.metadata.model.Domain,java.lang.String,boolean) throws java.lang.Exception]
    2012-09-20 16:10:55,864 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2012-09-20 16:10:56,005 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2012-09-20 16:10:56,083 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2012-09-20 16:10:56,130 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2012-09-20 16:10:56,161 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2012-09-20 16:10:56,255 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2012-09-20 16:10:56,427 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2012-09-20 16:10:56,520 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2012-09-20 16:10:56,598 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2012-09-20 16:10:56,692 WARN [org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator] We don't support method overloading. Ignoring [public java.lang.String serializeModels(org.pentaho.metadata.model.Domain,java.lang.String,boolean) throws java.lang.Exception]
    2012-09-20 16:10:56,708 WARN [org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator] We don't support method overloading. Ignoring [public java.lang.String serializeModels(org.pentaho.metadata.model.Domain,java.lang.String,boolean) throws java.lang.Exception]
    2012-09-20 16:10:56,723 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2012-09-20 16:10:56,864 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2012-09-20 16:13:34,239 WARN [org.pentaho.platform.engine.services.runtime.TemplateUtil] not found: [Measures].[unita]
    2012-09-20 16:41:14,302 WARN [com.tonbeller.jpivot.mondrian.MondrianModel] Mondrian result limit exceeded: Mondrian Error:Query timeout of 300 seconds reached



    - quando la cpu ritorna al 10% vedo ricomparire la tabella pivot e la scritta Resultset overflow occured è sopra di questa.. senza nessun cambiamento di visualizzazione..


    come posso fare..? dove è il problema??

  2. #2
    Join Date
    Dec 2010
    Posts
    304

    Default

    La query lanciata da Mondrian non ha restituito un risultato nel tempo massimo del timeout che per default è di 300 secondi.
    Se vuoi aumentare questo tempo modifica il valore della proprietà mondrian.rolap.queryTimeout in pentaho-solutions/system/mondrian/mondrian.properties.
    Ciao

  3. #3
    Join Date
    Aug 2012
    Posts
    23

    Default

    Non capisco alcune cose:
    - perchè non ha restituito il risultato? è solo una questione di tempo?
    - perchè richeiede così tanta cpu? il sistema va in stallo..
    - perchè tutti quei warn nel file di log? sono gravi? si possono risolvere? vale la pena pensarci su?

  4. #4
    Join Date
    Aug 2012
    Posts
    23

    Default

    risolto ragazzi,
    il problema è che avevo dimenticato in alcune tabelle di dichiarare il campo chiave come primary key...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.