Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Dial Chart Component error

  1. #1

    Default Dial Chart Component error

    I'm running CDF2.1-RC1 with Pentaho 2.0 and I've been running one Dial Chart component so I made a copy of it, changed the parameters and the new version won't run. It gives me the following error.
    Error: Base.ERROR_0002 - Component execution failed - java.lang.NumberFormatException: For input string: "" (org.pentaho.platform.plugin.action.jfreechart.ChartComponent) Debug: Starting execute of dashboards/sales_dashboard/currentMarginDialChart.xaction (org.pentaho.platform.engine.services.solution.SolutionEngine)
    Debug: Getting runtime context and data (org.pentaho.platform.engine.services.solution.SolutionEngine)
    Debug: Loading action sequence definition file (org.pentaho.platform.engine.services.solution.SolutionEngine)
    Debug: audit: instanceId=4cc1cca4-ed87-11dd-bf03-f529d60dc3b9, objectId=org.pentaho.platform.engine.services.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: validateComponent validating component SQLLookupRule (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: Validating component for action currentMarginDialChart.xaction (org.pentaho.platform.plugin.action.sql.SQLLookupRule)
    Debug: validateComponent validating component JavascriptRule (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: Validating component for action currentMarginDialChart.xaction (org.pentaho.platform.plugin.action.javascript.JavascriptRule)
    Debug: validateComponent validating component JavascriptRule (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: Validating component for action currentMarginDialChart.xaction (org.pentaho.platform.plugin.action.javascript.JavascriptRule)
    Debug: validateComponent validating component ChartComponent (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: Validating component for action currentMarginDialChart.xaction (org.pentaho.platform.plugin.action.jfreechart.ChartComponent)
    Debug: Executing action sequence (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: Executing action definition: Iteration 0 (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: audit: instanceId=4cc1cca4-ed87-11dd-bf03-f529d60dc3b9, objectId=SQLLookupRule, messageType=component_execution_started (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: execute pre-audit (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: Setting component log level to DEBUG (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: Initializing component (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: executeComponent starting audited execute (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: execute validation=true (org.pentaho.platform.plugin.action.sql.SQLLookupRule)
    Debug: Running query - SELECT (SUM(SalesActualMargin)/SUM(Sales))as ActualMarginPct FROM Fact_Sales fs WHERE fs.Date >= '20090101' AND fs.Date <= '20090128' AND fs.Company IN ( '0001' ) (org.pentaho.platform.plugin.action.sql.SQLLookupRule)
    Debug: Executing query with timeout value of [0] (org.pentaho.platform.plugin.action.sql.SQLLookupRule)
    Debug: executeComponent finished audited execute (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: execute post-audit (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: audit: instanceId=4cc1cca4-ed87-11dd-bf03-f529d60dc3b9, objectId=SQLLookupRule, messageType=component_execution_ended (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: audit: instanceId=4cc1cca4-ed87-11dd-bf03-f529d60dc3b9, objectId=JavascriptRule, messageType=component_execution_started (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: execute pre-audit (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: Setting component log level to DEBUG (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: Initializing component (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: executeComponent starting audited execute (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: execute validation=true (org.pentaho.platform.plugin.action.javascript.JavascriptRule)
    Debug: script=ActMarginPct = query_result.getValueAt(0,0); (org.pentaho.platform.plugin.action.javascript.JavascriptRule)
    Debug: executeComponent finished audited execute (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: execute post-audit (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: audit: instanceId=4cc1cca4-ed87-11dd-bf03-f529d60dc3b9, objectId=JavascriptRule, messageType=component_execution_ended (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: audit: instanceId=4cc1cca4-ed87-11dd-bf03-f529d60dc3b9, objectId=JavascriptRule, messageType=component_execution_started (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: execute pre-audit (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: Setting component log level to DEBUG (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: Initializing component (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: executeComponent starting audited execute (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: execute validation=true (org.pentaho.platform.plugin.action.javascript.JavascriptRule)
    Debug: script=minval = -100; maxval = 100; Range1Max = -50; Range2Max = 50; (org.pentaho.platform.plugin.action.javascript.JavascriptRule)
    Debug: executeComponent finished audited execute (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: execute post-audit (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: audit: instanceId=4cc1cca4-ed87-11dd-bf03-f529d60dc3b9, objectId=JavascriptRule, messageType=component_execution_ended (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: audit: instanceId=4cc1cca4-ed87-11dd-bf03-f529d60dc3b9, objectId=ChartComponent, messageType=component_execution_started (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: execute pre-audit (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: Setting component log level to DEBUG (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: Initializing component (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: executeComponent starting audited execute (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: execute validation=true (org.pentaho.platform.plugin.action.jfreechart.ChartComponent)
    Error: Base.ERROR_0002 - Component execution failed - java.lang.NumberFormatException: For input string: "" (org.pentaho.platform.plugin.action.jfreechart.ChartComponent)
    Debug: executeComponent finished audited execute (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Error: RuntimeContext.ERROR_0012 - ActionDefinition for ChartComponent did not execute successfully (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Debug: audit: instanceId=4cc1cca4-ed87-11dd-bf03-f529d60dc3b9, objectId=org.pentaho.platform.engine.services.runtime.RuntimeContext, messageType=action_sequence_failed (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (org.pentaho.platform.engine.services.solution.SolutionEngine)


    Server Version: Pentaho Platform Engine Core 2.0.0-RC1.33017
    I've attached a copy of the xaction. All I'm doing is calling this from the dashboard using a listener and passing in the WHERECLAUSE string. I'm frustrated because I have another xaction that produces a dial chart that I copied this one from and the former works fine.

    Thanks!
    Attached Files Attached Files

  2. #2

    Default

    I got this working. It seems as though the Design Studio changes some settings or something, because when I opened up the xaction for the one that worked in just a regular editor, made the changes and saved it as the new xaction, it worked fine.

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.