Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: jfreechart.xaction.sql : Components with sql queries

  1. #1

    Default jfreechart.xaction.sql : Components with sql queries

    I've changed the jfreeChart.xaction.sql by jfreeChart.xaction to implement charts with sql queries.
    Then I've uncommented the following code in home_dashboard_2/Metalayer.js
    queryType: 'sql',
    var query = "SELECT OFFICES.TERRITORY......
    and I've comented
    //queryType: 'mdx',
    //var query = "select NON EMPTY{....
    //catalog: 'solution:steel-wheels/analysis/steelwheels.mondrian.xml',

    To check it works with sql, and I get this error:
    Error executing component territorySales

    I've tried also doing a new sample with my own data, but I've get the same error.

  2. #2
    Join Date
    Jul 2007


    Hard to tell with such low description... logs would help
    Pedro Alves
    Meet us on ##pentaho, a FreeNode irc channel

  3. #3


    I've checked the log before asking here..but I can't know what's the problem..I've only uncommented your sql code and comment mdx code from your samples.

    Some lines from the log are:

    2009-02-17 12:47:30,221 ERROR [org.pentaho.platform.plugin.action.jfreechart.ChartComponent] Error Start: Pentaho Pentaho Platform Engine Core 2.0.0.stable.35509
    2009-02-17 12:47:30,221 ERROR [org.pentaho.platform.plugin.action.jfreechart.ChartComponent] c18c6a71-fce8-11dd-bf06-150bf5dd06cf:COMPONENT:context-20692657-1234871250080:jfreechart.xactionBase.ERROR_0002 -Component execution failedjava.lang.NullPointerException
        at org.pentaho.commons.connection.PentahoDataTransmuter.pivot(
        at org.pentaho.platform.uifoundation.chart.PieDatasetChartDefinition.setDataByColumn(
    2009-02-17 12:47:30,236 ERROR [org.pentaho.platform.plugin.action.jfreechart.ChartComponent] Error end:
    2009-02-17 12:47:30,236 ERROR [org.pentaho.platform.plugin.action.jfreechart.ChartComponent] Error end:
    2009-02-17 12:47:30,236 ERROR [] c18c6a71-fce8-11dd-bf06-150bf5dd06cf:RUNTIME:context-20692657-1234871250080:jfreechart.xaction RuntimeContext.ERROR_0012 - [es_33] ActionDefinition for ChartComponent did not execute successfully

  4. #4


    i have the same exception on version 3.0 stable. But version 3.0 RC2 run ok
    Last edited by gust_vn; 07-24-2009 at 06:22 AM.

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.