Hitachi Vantara Pentaho Community Forums
Results 1 to 10 of 10

Thread: BISuite 3.5RC1: ChartBean Samples doesn't work

  1. #1

    Default BISuite 3.5RC1: ChartBean Samples doesn't work

    Every ChartBean Example in Version 3.5RC1 doesn't work. Here is the log:

    Code:
    Caused by: ofc4j.org.json.JSONException: Expected a ':' after a key at character 1064
            at ofc4j.org.json.JSONTokener.syntaxError(JSONTokener.java:496)
            at ofc4j.org.json.JSONObject.<init>(JSONObject.java:205)
            at ofc4j.org.json.JSONTokener.nextValue(JSONTokener.java:374)
            at ofc4j.org.json.JSONArray.<init>(JSONArray.java:128)
            at ofc4j.org.json.JSONTokener.nextValue(JSONTokener.java:378)
            at ofc4j.org.json.JSONObject.<init>(JSONObject.java:207)
            at ofc4j.org.json.JSONTokener.nextValue(JSONTokener.java:374)
            at ofc4j.org.json.JSONArray.<init>(JSONArray.java:128)
            at ofc4j.org.json.JSONTokener.nextValue(JSONTokener.java:378)
            at ofc4j.org.json.JSONObject.<init>(JSONObject.java:207)
            at ofc4j.org.json.JSONTokener.nextValue(JSONTokener.java:374)
            at ofc4j.org.json.JSONObject.<init>(JSONObject.java:207)
            at ofc4j.org.json.JSONObject.<init>(JSONObject.java:404)
            at ofc4j.OFC.render(OFC.java:131)
            ... 77 more
    21:49:30,078 ERROR [PojoComponent] Error end:
    21:49:30,078 ERROR [RuntimeContext] 3f42fa5b-8779-11de-b100-e33e16cecb9f:RUNTIME:context-8428152-1250106568984:chartbeans_area.xaction RuntimeCon
    text.ERROR_0012 - Die ActionDefinition f³r ChartBeansComponent wurde nicht erfolgreich ausgef³rht.
    21:49:30,093 ERROR [SolutionEngine] 3f42fa5b-8779-11de-b100-e33e16cecb9f:SOLUTION-ENGINE:chartbeans_area.xaction: SolutionEngine.ERROR_0007 - Feh
    ler beim Ausf³hren der Actionsequenz
    If I trie to execute the Open Flash Chart Samples (Steel-Wheels/Charts/Flash Chart List I got the same error.

    What can I do? Is there some plug-in to install?

    Regards

  2. #2

  3. #3

    Angry

    I have still the same problem. (3.5 GA)

    Now I created my own example with my own data but it still doesn't work.
    Help!

    Code:
    12:49:46,685 ERROR [PojoComponent] Error Start: Pentaho Pentaho Platform Engine Core 3.5.0.stable.39705
    12:49:46,686 ERROR [PojoComponent] 1dfab3ac-bc9d-11de-bd63-0b579ee78901:COMPONENT:context-33377298-1255949386655:umsatz_chart_bar.xactionBase.ERROR_0002 - Fehler beim Ausführen der Komponente.
    java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.pentaho.platform.engine.services.solution.PojoComponent.executeAction(PojoComponent.java:447)
        at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:463)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1331)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1298)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1216)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1165)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1045)
        at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:938)
        at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:413)
        at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:316)
        at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:192)
        at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159)
        at org.pentaho.platform.web.servlet.ViewAction.handleActionRequest(ViewAction.java:148)
        at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:275)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at sun.reflect.GeneratedMethodAccessor94.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:244)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
        at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:276)
        at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:262)
        at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:52)
        at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:171)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
        at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
        at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
        at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
        at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
        at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
        at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
        at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
        at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
        at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
        at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
        at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
        at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
        at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
        at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
        at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
        at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
        at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
        at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
        at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
        at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
        at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
        at sun.reflect.GeneratedMethodAccessor98.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:244)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
        at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:276)
        at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:218)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:52)
        at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:171)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
        at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
        at sun.reflect.GeneratedMethodAccessor97.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:244)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
        at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:276)
        at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:218)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:52)
        at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:171)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
        at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
        at sun.reflect.GeneratedMethodAccessor96.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:244)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
        at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:276)
        at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:218)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:52)
        at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:171)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
        at java.lang.Thread.run(Thread.java:619)
    Caused by: ofc4j.OFCException: {"ofc4j.model.Chart": {
      "title": {
        "text": "Umsatz",
        "style": "text-align: left; color: #ffaa00; font-size: 20px; font-family: courier; font-weight: bold;"
      },
      "x_axis": {
        "colour": "#808080",
        "grid-colour": "#aa6611",
        "labels": {
          "rotate": "diagonal",
          "labels": [
            "2006",
            "2007",
            "2008",
            "2009"
          ]
        }
      },
      "y_axis": {
        "colour": "#808080",
        "grid-colour": "#aa6611",
        "steps": 1600000,
        "min": 0,
        "max": 9600000
      },
      "y_legend": {
        "text": "yAxis",
        "style": "color: #772200; font-style: oblique; font-size: 12px; font-family: san-serif; font-weight: bold;"
      },
      "x_legend": {
        "text": "xAxis",
        "style": "color: #772200; font-size: 10px; font-family: san-serif;"
      },
      "bg_colour": "#b09a6b",
      "inner_bg_colour": "#aa6611",
      "elements": [
        {
          "type": "bar",
          "alpha": 0.75,
          "text": "n.v.",
          "font-size": 18,
          "tip": "#val#",
          "values": [
            {
              "top": 0
            },
            {
              "top": 3588297,8
            },
            {
              "top": 992598,2
            },
            {
              "top": 0
            }
          ],
          "colour": "#880a0f"
        },
        {
          "type": "bar",
          "alpha": 0.75,
          "text": "PG-UE     ",
          "font-size": 18,
          "tip": "#val#",
          "values": [
            {
              "top": 252310
            },
            {
              "top": 8476307,5
            },
            {
              "top": 1190006
            },
            {
              "top": 33000
            }
          ],
          "colour": "#b09a6b"
        }
      ]
    }}
        at ofc4j.OFC.render(OFC.java:133)
        at ofc4j.model.Chart.toString(Chart.java:179)
        at org.pentaho.chart.plugin.openflashchart.outputs.OpenFlashChartOutput.persistChart(OpenFlashChartOutput.java:59)
        at org.pentaho.chart.ChartBeanFactory.createChart(ChartBeanFactory.java:173)
        at org.pentaho.platform.plugin.action.chartbeans.ChartComponent.execute(ChartComponent.java:190)
        ... 120 more
    Caused by: ofc4j.org.json.JSONException: Expected a ':' after a key at character 1074
        at ofc4j.org.json.JSONTokener.syntaxError(JSONTokener.java:496)
        at ofc4j.org.json.JSONObject.<init>(JSONObject.java:205)
        at ofc4j.org.json.JSONTokener.nextValue(JSONTokener.java:374)
        at ofc4j.org.json.JSONArray.<init>(JSONArray.java:128)
        at ofc4j.org.json.JSONTokener.nextValue(JSONTokener.java:378)
        at ofc4j.org.json.JSONObject.<init>(JSONObject.java:207)
        at ofc4j.org.json.JSONTokener.nextValue(JSONTokener.java:374)
        at ofc4j.org.json.JSONArray.<init>(JSONArray.java:128)
        at ofc4j.org.json.JSONTokener.nextValue(JSONTokener.java:378)
        at ofc4j.org.json.JSONObject.<init>(JSONObject.java:207)
        at ofc4j.org.json.JSONTokener.nextValue(JSONTokener.java:374)
        at ofc4j.org.json.JSONObject.<init>(JSONObject.java:207)
        at ofc4j.org.json.JSONObject.<init>(JSONObject.java:404)
        at ofc4j.OFC.render(OFC.java:131)
        ... 124 more
    12:49:46,688 ERROR [PojoComponent] Error end:
    12:49:46,688 ERROR [RuntimeContext] 1dfab3ac-bc9d-11de-bd63-0b579ee78901:RUNTIME:context-33377298-1255949386655:umsatz_chart_bar.xaction RuntimeContext.ERROR_0012 - Die ActionDefinition für ChartBeansComponent wurde nicht erfolgreich ausgefürht.
    12:49:46,688 ERROR [SolutionEngine] 1dfab3ac-bc9d-11de-bd63-0b579ee78901:SOLUTION-ENGINE:umsatz_chart_bar.xaction: SolutionEngine.ERROR_0007 - Fehler beim Ausführen der Actionsequenz

  4. #4
    Join Date
    Aug 2008
    Posts
    16

    Default Region Config

    Change region config for English USA, or decimal separetor from "," to "."
    --
    Diego Muriel
    Brasil-SP

  5. #5
    pstoellberger Guest

  6. #6
    Join Date
    Sep 2008
    Posts
    21

    Default

    I have read in many post that this is a problem with the "," separator.
    How can i do to change it to "." separator?
    Where must i change it?

    I have read olso that it is possible hide the error changing my locale in English.
    How can i do? Can i change it into the web.xml locale params or must i change it in the O.S. and in the browser?

    Last request: were i can find the jsons file?

    Thank you

  7. #7
    Join Date
    Aug 2008
    Posts
    16

    Default change local config

    Hi Braian,
    change local config in server OS. If windows in control panel, in linux distribution dependent.
    --
    Diego Muriel
    Brasil-SP

  8. #8
    Join Date
    Sep 2008
    Posts
    21

    Default

    Quote Originally Posted by diego.muriel View Post
    Hi Braian,
    change local config in server OS. If windows in control panel, in linux distribution dependent.
    Ok, thank you very much.

    Any response for the other questions?

    ------
    I have read in many post that this is a problem with the "," separator.
    How can i do to change it to "." separator?
    Where must i change it?
    ----
    were i can find the jsons file?

  9. #9

    Default

    Same for me in 3.5.2 stable.
    ChartBeans and OpenFlashChartCompoents doesn't work.

  10. #10

    Default

    I've got the chartbeans working adding ROUND in the sql at xaction files.
    Code:
    ROUND(SUM(ORDERFACT.TOTALPRICE),0) AS "PRICE"
    But I can't get openflashchart.xaction working because the "," decimal separator.
    Any Solution?
    Thanks!!

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.