Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: error en windows 2003 server y Openflash

  1. #1
    Join Date
    Dec 2009
    Posts
    12

    Default error en windows 2003 server y Openflash

    Hola a todos

    Tengo instalado Pentaho 3.5 Stable en windows XP y todos los graficos Steel Wheels --> Charts se ven bien, todo lo que es openflash pero cuando corro la misma version en Windows 2003 Server Enterprise Edition no funcionan los graficos, se ve bien solo "Buble" y "Area" el error que me daen los demas graficos es:


    [es_161] Error: RuntimeContext.ERROR_0012 - [es_33] ActionDefinition for OpenFlashChartComponent did not execute successfully (org.pentaho.platform.engine.services.runtime.RuntimeContext) [es_116] Debug: [es_21] Starting execute of steel-wheels/charts/pentahoxml_picker.xaction (org.pentaho.platform.engine.services.solution.SolutionEngine)
    [es_116] Debug: [es_30] Getting runtime context and data (org.pentaho.platform.engine.services.solution.SolutionEngine)
    [es_116] Debug: [es_33] Loading action sequence definition file (org.pentaho.platform.engine.services.solution.SolutionEngine)
    [es_116] Debug: [es_34] audit: instanceId=fc29cec3-1b0c-11df-89d9-6916c53170f8, objectId=org.pentaho.platform.engine.services.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_1] validateComponent validating component SecureFilterComponent (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: Component alias SecureFilterComponent will be resolved by the platform (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_75] Validating component for action pentahoxml_picker.xaction (org.pentaho.platform.plugin.action.builtin.SecureFilterComponent)
    [es_116] Debug: [es_1] validateComponent validating component SQLLookupRule (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: Component alias SQLLookupRule will be resolved by the platform (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_75] Validating component for action pentahoxml_picker.xaction (org.pentaho.platform.plugin.action.sql.SQLLookupRule)
    [es_116] Debug: [es_1] validateComponent validating component OpenFlashChartComponent (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: Component alias OpenFlashChartComponent will be resolved by the platform (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_75] Validating component for action pentahoxml_picker.xaction (org.pentaho.platform.plugin.action.openflashchart.OpenFlashChartComponent)
    [es_116] Debug: [es_1] validateComponent validating component OpenFlashChartComponent (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: Component alias OpenFlashChartComponent will be resolved by the platform (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_75] Validating component for action pentahoxml_picker.xaction (org.pentaho.platform.plugin.action.openflashchart.OpenFlashChartComponent)
    [es_116] Debug: [es_1] validateComponent validating component OpenFlashChartComponent (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: Component alias OpenFlashChartComponent will be resolved by the platform (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_75] Validating component for action pentahoxml_picker.xaction (org.pentaho.platform.plugin.action.openflashchart.OpenFlashChartComponent)
    [es_116] Debug: [es_1] validateComponent validating component OpenFlashChartComponent (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: Component alias OpenFlashChartComponent will be resolved by the platform (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_75] Validating component for action pentahoxml_picker.xaction (org.pentaho.platform.plugin.action.openflashchart.OpenFlashChartComponent)
    [es_116] Debug: [es_1] validateComponent validating component OpenFlashChartComponent (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: Component alias OpenFlashChartComponent will be resolved by the platform (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_75] Validating component for action pentahoxml_picker.xaction (org.pentaho.platform.plugin.action.openflashchart.OpenFlashChartComponent)
    [es_116] Debug: [es_1] validateComponent validating component OpenFlashChartComponent (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: Component alias OpenFlashChartComponent will be resolved by the platform (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_75] Validating component for action pentahoxml_picker.xaction (org.pentaho.platform.plugin.action.openflashchart.OpenFlashChartComponent)
    [es_116] Debug: [es_1] validateComponent validating component OpenFlashChartComponent (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: Component alias OpenFlashChartComponent will be resolved by the platform (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_75] Validating component for action pentahoxml_picker.xaction (org.pentaho.platform.plugin.action.openflashchart.OpenFlashChartComponent)
    [es_116] Debug: [es_1] validateComponent validating component OpenFlashChartComponent (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: Component alias OpenFlashChartComponent will be resolved by the platform (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_75] Validating component for action pentahoxml_picker.xaction (org.pentaho.platform.plugin.action.openflashchart.OpenFlashChartComponent)
    [es_116] Debug: [es_1] validateComponent validating component SQLLookupRule (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: Component alias SQLLookupRule will be resolved by the platform (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_75] Validating component for action pentahoxml_picker.xaction (org.pentaho.platform.plugin.action.sql.SQLLookupRule)
    [es_116] Debug: [es_1] validateComponent validating component OpenFlashChartComponent (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: Component alias OpenFlashChartComponent will be resolved by the platform (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_75] Validating component for action pentahoxml_picker.xaction (org.pentaho.platform.plugin.action.openflashchart.OpenFlashChartComponent)
    [es_116] Debug: [es_1] validateComponent validating component SQLLookupRule (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: Component alias SQLLookupRule will be resolved by the platform (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_75] Validating component for action pentahoxml_picker.xaction (org.pentaho.platform.plugin.action.sql.SQLLookupRule)
    [es_116] Debug: [es_1] validateComponent validating component OpenFlashChartComponent (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: Component alias OpenFlashChartComponent will be resolved by the platform (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_75] Validating component for action pentahoxml_picker.xaction (org.pentaho.platform.plugin.action.openflashchart.OpenFlashChartComponent)
    [es_116] Debug: [es_1] validateComponent validating component SQLLookupRule (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: Component alias SQLLookupRule will be resolved by the platform (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_75] Validating component for action pentahoxml_picker.xaction (org.pentaho.platform.plugin.action.sql.SQLLookupRule)
    [es_116] Debug: [es_1] validateComponent validating component OpenFlashChartComponent (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: Component alias OpenFlashChartComponent will be resolved by the platform (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_75] Validating component for action pentahoxml_picker.xaction (org.pentaho.platform.plugin.action.openflashchart.OpenFlashChartComponent)
    [es_116] Debug: [es_42] Executing action sequence (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_24] Executing action definition: Iteration 0 (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_34] audit: instanceId=fc29cec3-1b0c-11df-89d9-6916c53170f8, objectId=SecureFilterComponent, messageType=component_execution_started (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_3] execute pre-audit (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_21] Setting component log level to DEBUG (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_11] Initializing component (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_4] executeComponent starting audited execute (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_94] execute validation=true (org.pentaho.platform.plugin.action.builtin.SecureFilterComponent)
    [es_116] Debug: [es_15] executeComponent finished audited execute (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_19] execute post-audit (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_34] audit: instanceId=fc29cec3-1b0c-11df-89d9-6916c53170f8, objectId=SecureFilterComponent, messageType=component_execution_ended (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_34] audit: instanceId=fc29cec3-1b0c-11df-89d9-6916c53170f8, objectId=SQLLookupRule, messageType=component_execution_started (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_3] execute pre-audit (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_21] Setting component log level to DEBUG (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_11] Initializing component (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_4] executeComponent starting audited execute (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_94] execute validation=true (org.pentaho.platform.plugin.action.sql.SQLLookupRule)
    [es_116] Debug: Running query - timeout [-1 seconds] - SELECT PRODUCTS.PRODUCTLINE AS LINE, SUM(CASE ORDERFACT.YEAR_ID WHEN '2003' THEN (ORDERFACT.TOTALPRICE) ELSE 0 END) AS "2003", SUM(CASE ORDERFACT.YEAR_ID WHEN '2004' THEN (ORDERFACT.TOTALPRICE) ELSE 0 END) AS "2004", SUM(CASE ORDERFACT.YEAR_ID WHEN '2005' THEN (ORDERFACT.TOTALPRICE) ELSE 0 END) AS "2005" FROM PRODUCTS INNER JOIN ORDERFACT ON PRODUCTS.PRODUCTCODE = ORDERFACT.PRODUCTCODE INNER JOIN CUSTOMER_W_TER ON ORDERFACT.CUSTOMERNUMBER = CUSTOMER_W_TER.CUSTOMERNUMBER GROUP BY LINE ORDER BY 2 DESC (org.pentaho.platform.plugin.action.sql.SQLLookupRule)
    [es_116] Debug: [es_15] executeComponent finished audited execute (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_19] execute post-audit (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_34] audit: instanceId=fc29cec3-1b0c-11df-89d9-6916c53170f8, objectId=SQLLookupRule, messageType=component_execution_ended (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_24] Executing action definition: Iteration 0 (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_90] Actions not executed due to condition. (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_24] Executing action definition: Iteration 0 (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_90] Actions not executed due to condition. (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_24] Executing action definition: Iteration 0 (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_90] Actions not executed due to condition. (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_24] Executing action definition: Iteration 0 (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_90] Actions not executed due to condition. (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_24] Executing action definition: Iteration 0 (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_90] Actions not executed due to condition. (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_24] Executing action definition: Iteration 0 (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_90] Actions not executed due to condition. (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_24] Executing action definition: Iteration 0 (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_34] audit: instanceId=fc29cec3-1b0c-11df-89d9-6916c53170f8, objectId=OpenFlashChartComponent, messageType=component_execution_started (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_3] execute pre-audit (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_21] Setting component log level to DEBUG (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_11] Initializing component (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_4] executeComponent starting audited execute (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_94] execute validation=true (org.pentaho.platform.plugin.action.openflashchart.OpenFlashChartComponent)
    [es_14] Error: Base.ERROR_0002 - Ejecución fallida del Componente - java.lang.RuntimeException: ofc4j.OFCException: {"ofc4j.model.Chart": { "title": { "text": "Chart Title", "style": "font-family: Arial; font-size: 18px; font-weight: bold; font-style: normal;" }, "x_axis": { "stroke": 1, "colour": "#000000", "grid-colour": "#ffffff", "offset": 1, "labels": { "labels": [ "Classic Cars", "Vintage Cars", "Trucks and Buses", "Motorcycles", "Planes", "Ships", "Trains" ] } }, "y_axis": { "stroke": 1, "colour": "#000000", "grid-colour": "#eaeaea", "steps": 306379, "min": 0, "max": 2451032 }, "y_legend": { "text": "Range Title", "style": "font-family: Arial; font-size: 14px; font-weight: normal; font-style: normal;" }, "x_legend": { "text": "Domain Title", "style": "font-family: Arial; font-size: 14px; font-weight: normal; font-style: normal;" }, "bg_colour": "#FFffff", "inner_bg_colour": "#ffffff", "elements": [ { "type": "bar_glass", "alpha": 0.7, "text": "2003", "values": [ { "top": 1514407,42 }, { "top": 679948,55 }, { "top": 420429,93 }, { "top": 397219,71 }, { "top": 347755,01 }, { "top": 244821,09 }, { "top": 72802,29 } ], "colour": "#0f3765" }, { "type": "bar_glass", "alpha": 0.7, "text": "2004", "values": [ { "top": 1838274,85 }, { "top": 997559,65 }, { "top": 531975,89 }, { "top": 590580,25 }, { "top": 528927,94 }, { "top": 375671,69 }, { "top": 124749,57 } ], "colour": "#880a0f" }, { "type": "bar_glass", "alpha": 0.7, "text": "2005", "values": [ { "top": 738737,6 }, { "top": 388718,19 }, { "top": 201874,75 }, { "top": 286325,23 }, { "top": 200074,17 }, { "top": 128178,07 }, { "top": 36917,33 } ], "colour": "#B09A6B" } ] }} (org.pentaho.platform.plugin.action.openflashchart.OpenFlashChartComponent)
    [es_116] Debug: [es_15] executeComponent finished audited execute (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_161] Error: RuntimeContext.ERROR_0012 - [es_33] ActionDefinition for OpenFlashChartComponent did not execute successfully (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_116] Debug: [es_34] audit: instanceId=fc29cec3-1b0c-11df-89d9-6916c53170f8, objectId=org.pentaho.platform.engine.services.runtime.RuntimeContext, messageType=action_sequence_failed (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    [es_161] Error: SolutionEngine.ERROR_0007 - [es_27] Action sequence execution failed (org.pentaho.platform.engine.services.solution.SolutionEngine)


    Server Version: Pentaho Platform Engine Core 3.5.0.stable.39705





    No se a que se debe que en windows Xp si corre todo bien pero no se ejecuta bien en el servidor.

    He cambiado algunos datos como en el archivo server.xml en la ruta:

    biserver-ce-3.5.0.stable\biserver-ce\tomcat\conf\server.xml


    eh cambiado esto:


    <Host name="localhost" appBase="webapps"
    unpackWARs="true" autoDeploy="true"
    xmlValidation="false" xmlNamespaceAware="false">

    por esto:

    <Host name="100.100.100.89" appBase="webapps"
    unpackWARs="true" autoDeploy="true"
    xmlValidation="false" xmlNamespaceAware="false">

    Y aún asi no funcionan los graficos.

    Muchas gracias

    Orison San Juan
    Lima - Peru

  2. #2
    Join Date
    Dec 2009
    Posts
    12

    Default

    Solucionado...

    Bueno como nadie me dijo nada y yo encontre la solicion, pues bien aca va para aquel que le sea de ayuda.


    Les comento que PENTAHO tiene problemas con los idiomas todavia, entonces para solucionar eso de que no se ven los fraficos openflash es solo para aquillos que en su servidor tienen el idioma en configuracion regional diferente a lo que es Ingles, quiere decir que si tu server en configuracion regional esta en español entonces tendras error. Tienes que ponerle Ingles y con eso ya corren todos los graficos.

    Saludos.


    Ing. Orison San Juan G.

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.