Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: java.lang.ArrayIndexOutOfBoundsException: 0 after an OLAP query

  1. #1

    Default java.lang.ArrayIndexOutOfBoundsException: 0 after an OLAP query

    Hi,
    I have a XAction with secure filters and an OLAP query. In some cases the OLAP query result is empty, and when this occurs, system throw the error:
    [es_14] Error: MDXBaseComponent.ERROR_0006 - [es_38] Could not execute carl_distribucion_nconvenios.xaction - java.lang.ArrayIndexOutOfBoundsException: 0 (org.pentaho.platform.plugin.action.mdx.MDXLookupRule)

    How can i handle this error?
    Thanks in advance.

  2. #2

    Default

    Some idea?

  3. #3

    Default

    It´s a bug.
    A query like:
    select {[Measures].[N. de Expedientes]} ON COLUMNS,
    {[Provincia].[Todas las provincias].children ON ROWS
    from [Expedientes]

    that should return an empty result-set cause the error java.lang.ArrayIndexOutOfBoundsException: 0
    I have solved the problem with a workaround, including in the query all members i want to select:
    select {[Measures].[N. de Expedientes]} ON COLUMNS,
    {[Provincia.Provincia].[Todas las provincias].[Almería], [Provincia.Provincia].[Todas las provincias].[Cádiz], [Provincia.Provincia].[Todas las provincias].[Córdoba], [Provincia.Provincia].[Todas las provincias].[Granada], [Provincia.Provincia].[Todas las provincias].[Huelva], [Provincia.Provincia].[Todas las provincias].[Jaén], [Provincia.Provincia].[Todas las provincias].[Málaga], [Provincia.Provincia].[Todas las provincias].[Sevilla]} ON ROWS
    from [Expedientes]

    But this workaround have problems when you don´t know how many members has the dimension.
    Hope this help.

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.