Hitachi Vantara Pentaho Community Forums
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: CDE - Error parsing view - possible permission problem? :(

  1. #1

    Default CDE - Error parsing view - possible permission problem? :(

    Hey everyone,
    I'm trying to follow a tutorial on creating a basic Dashboard using CDE here, and I'm getting some errors with my username on pentaho.log and I'm not quite sure what can be causing this since it doesn't appear to be a problem with de components of the dashboard I've just created.

    Any ideas?
    Thanks


    -04-25 13:16:00,740 ERROR [pt.webdetails.cpf.persistence.PersistenceEngine] com.orientechnologies.orient.core.exception.OQueryParsingException: Error on parsing query at position #27: Error on parsing query
    Query: org.pentaho.cdf.views.View where (name = "" and user = "c058512")
    --------------------------------^
    2013-04-25 13:16:00,743 ERROR [org.pentaho.cdf.CdfContentGenerator] Error creating cdf content:
    com.orientechnologies.orient.core.command.OCommandExecutorNotFoundException: Cannot find a command executor for the command request: OCommandSQL [text=create cluster org.pentaho.cdf.views.View PHYSICAL]

  2. #2
    Join Date
    Nov 2011
    Posts
    1,229

    Default

    I think you might have some installation issues there. Which versions of ctools have you installed and how?
    Pedro Vale
    --
    CTools Product Development
    http://www.webdetails.pt

  3. #3

    Default

    hey pedro!
    well, i got them individually from webdetails website yesterday. i'm under windows and thought it would be easier than the ctool.sh since my linux server is not on the internet.

    here it goes (wanna try them all)

    CDA 13.03.25
    CDB 12.12.11
    CDC 13.02.07
    CDE 13.03.25
    CDF 13.03.25
    CDV 13.03.25
    CGG 13.03.25

  4. #4
    Join Date
    Nov 2011
    Posts
    1,229

    Default

    Are those errors affecting your dashboard?
    Does it stop you from seeing it properly?

    Did you have an earlier version of the ctools installed? If so, stop the server, delete the system/.orient folder and restart the server, please.
    Pedro Vale
    --
    CTools Product Development
    http://www.webdetails.pt

  5. #5

    Default

    Pedro, I've removed the chart component and added a new one and it seemed to have worked. But I'm stuck on another problem and I don't know if it has to do with installation issues.
    I've added a select, a text input and a parameter. I think everything worked fine, because the text input shows the parameter content when the select is changed.
    but when I add a chart, it seems to have a problem executing the query and passing the parameter to it.
    when I change the ${periodo} on the query below to '01/2013', for example, it works fine. I'm attaching screens of both the sql and chart.

    I'm using CDE/CDF as a proof of concept to a BI project i'm working on to a federal bank in Brazil.

    Thanks!


    2013-04-29 09:20:33,357 ERROR [pt.webdetails.cda.CdaContentGenerator] doQuery: Failed at query: SELECT
    r."NO_RACA_COR_PESSOA",
    SUM(f."NU_PESSOAS") as "NU_PESSOAS"
    FROM
    "IPSTB061_AGG_TOTAIS_FAMILIAS_POR_RACA" f,
    "IPSTB027_DIM_RACA_COR_PESSOA" r,
    "IPSTB046_DIM_MUNICIPIOS" m
    WHERE
    r."CO_RACA_COR_PESSOA" = f."CO_RACA_COR_PESSOA" AND
    m."CO_IBGE" = f."CO_IBGE"
    AND "NU_ANO"=substring(${periodo},4,4)::int
    AND "NU_MES"=substring(${periodo},1,2)::int
    GROUP BY
    r."NO_RACA_COR_PESSOA"
    ORDER BY
    r."NO_RACA_COR_PESSOA"
    pt.webdetails.cda.dataaccess.QueryException: Failed at query: SELECT
    r."NO_RACA_COR_PESSOA",
    SUM(f."NU_PESSOAS") as "NU_PESSOAS"
    FROM
    "IPSTB061_AGG_TOTAIS_FAMILIAS_POR_RACA" f,
    "IPSTB027_DIM_RACA_COR_PESSOA" r,
    "IPSTB046_DIM_MUNICIPIOS" m
    WHERE
    r."CO_RACA_COR_PESSOA" = f."CO_RACA_COR_PESSOA" AND
    m."CO_IBGE" = f."CO_IBGE"
    AND "NU_ANO"=substring(${periodo},4,4)::int
    AND "NU_MES"=substring(${periodo},1,2)::int
    GROUP BY
    r."NO_RACA_COR_PESSOA"
    ORDER BY
    r."NO_RACA_COR_PESSOA"
    at pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:180)
    at pt.webdetails.cda.dataaccess.SimpleDataAccess.queryDataSource(SimpleDataAccess.java:123)
    at pt.webdetails.cda.dataaccess.AbstractDataAccess.doQuery(AbstractDataAccess.java:268)
    at pt.webdetails.cda.CdaEngine.doQuery(CdaEngine.java:74)
    at pt.webdetails.cda.CdaContentGenerator.doQuery(CdaContentGenerator.java:163)
    at sun.reflect.GeneratedMethodAccessor196.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at pt.webdetails.cpf.SimpleContentGenerator.invokeMethod(SimpleContentGenerator.java:324)
    at pt.webdetails.cpf.SimpleContentGenerator.createContent(SimpleContentGenerator.java:157)
    at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261)
    at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:80)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:142)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    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:103)
    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 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Unknown Source)
    Caused by: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT
    r."NO_RACA_COR_PESSOA",
    SUM(f."NU_PESSOAS") as "NU_PESSOAS"
    FROM
    "IPSTB061_AGG_TOTAIS_FAMILIAS_POR_RACA" f,
    "IPSTB027_DIM_RACA_COR_PESSOA" r,
    "IPSTB046_DIM_MUNICIPIOS" m
    WHERE
    r."CO_RACA_COR_PESSOA" = f."CO_RACA_COR_PESSOA" AND
    m."CO_IBGE" = f."CO_IBGE"
    AND "NU_ANO"=substring(${periodo},4,4)::int
    AND "NU_MES"=substring(${periodo},1,2)::int
    GROUP BY
    r."NO_RACA_COR_PESSOA"
    ORDER BY
    r."NO_RACA_COR_PESSOA"
    at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:258)
    at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:171)
    at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:135)
    at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:85)
    at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:434)
    at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData(CachingDataFactory.java:326)
    at pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:154)
    ... 74 more
    Attached Files Attached Files
    Last edited by alexsousa; 04-29-2013 at 12:34 PM.

  6. #6

    Default

    no, there was no problem on loading the dashboard actually.
    i've tried starting fresh and installing ctools again with a clean version of my biserver and those errors didn't show up so far.
    what i'm trying to do now is quite simple. guess i'm out of luck. haha

  7. #7

    Default

    weirdest thing is that when i type '01/2013' on the textinput and press enter the chart works just fine..but no other component will..the chart always returns "Error processing component"

    just tried them all.. =(

    btw i'm using biserver 4.8

  8. #8
    Join Date
    Nov 2011
    Posts
    1,229

    Default

    hmm, check the network logs. there will be a call to CDA (/content/cda/doQuery) after you change the select value. Check the parameters on that call (there will be a paramperiodo). what's the value of that?
    Pedro Vale
    --
    CTools Product Development
    http://www.webdetails.pt

  9. #9

    Default

    pedro, this may sound n00bish, but could you point the location to those logs? haha
    so far i only could find pentaho.log and catalina and those only point the error on the query with no value on the ${periodo} parameter.

    thanks

  10. #10

    Default

    got it. the audit log.
    i guess there's a space before the text...
    fixed it

    obrigado pedro! quando tiver finalizado te dou um retorno sobre como ficou.
    abraço


    2013/04/30 8:55:39 cda 89FC9F2ED7F54886857E4C300E3AA692 doQuery pt.webdetails.cda.CdaContentGenerator c058512 instance_start 64c2109b-9799-4721-b5f7-2afb1ae16c17 dataAccessId=queryPeriodo;sortBy=;outputIndexId=1;path=/Admin/familias_raca_uf_tmp.cda;pageSize=0;pageStart=0; 0.0
    2013/04/30 8:55:39 cda 89FC9F2ED7F54886857E4C300E3AA692 doQuery pt.webdetails.cda.CdaContentGenerator c058512 instance_start 0c681fe7-ec83-494f-9102-76a73472db4c dataAccessId=queryChart;sortBy=;outputIndexId=1;path=/Admin/familias_raca_uf_tmp.cda;pageSize=0;pageStart=0;paramperiodo=01/2013; 0.0
    2013/04/30 8:55:39 cda 89FC9F2ED7F54886857E4C300E3AA692 doQuery pt.webdetails.cda.CdaContentGenerator c058512 instance_end 64c2109b-9799-4721-b5f7-2afb1ae16c17 0.11299999803304672
    2013/04/30 8:55:39 cda 89FC9F2ED7F54886857E4C300E3AA692 doQuery pt.webdetails.cda.CdaContentGenerator c058512 instance_end 0c681fe7-ec83-494f-9102-76a73472db4c 0.35100001096725464
    2013/04/30 8:55:42 cda 89FC9F2ED7F54886857E4C300E3AA692 doQuery pt.webdetails.cda.CdaContentGenerator c058512 instance_start 5541c821-286e-4435-8b95-8f56adc7f336 dataAccessId=queryChart;sortBy=;outputIndexId=1;path=/Admin/familias_raca_uf_tmp.cda;pageSize=0;pageStart=0;paramperiodo= 12/2012; 0.0
    2013/04/30 8:55:42 cda 89FC9F2ED7F54886857E4C300E3AA692 doQuery pt.webdetails.cda.CdaContentGenerator c058512 instance_end 5541c821-286e-4435-8b95-8f56adc7f336 0.07400000095367432
    2013/04/30 9:09:13 cda 89FC9F2ED7F54886857E4C300E3AA692 doQuery pt.webdetails.cda.CdaContentGenerator c058512 instance_start 6dfaf20d-99ba-46c9-9d80-f48b416004d9 dataAccessId=queryChart;sortBy=;outputIndexId=1;path=/Admin/familias_raca_uf_tmp.cda;pageSize=0;pageStart=0;paramperiodo= 01/2013; 0.0
    2013/04/30 9:09:13 cda 89FC9F2ED7F54886857E4C300E3AA692 doQuery pt.webdetails.cda.CdaContentGenerator c058512 instance_end 6dfaf20d-99ba-46c9-9d80-f48b416004d9 0.15000000596046448
    2013/04/30 9:20:41 cda 89FC9F2ED7F54886857E4C300E3AA692 doQuery pt.webdetails.cda.CdaContentGenerator c058512 instance_start b8a3669e-9671-4b05-9400-377d75322917 dataAccessId=queryChart;sortBy=;outputIndexId=1;path=/Admin/familias_raca_uf_tmp.cda;pageSize=0;pageStart=0;paramperiodo= 12/2012; 0.0
    2013/04/30 9:20:41 cda 89FC9F2ED7F54886857E4C300E3AA692 doQuery pt.webdetails.cda.CdaContentGenerator c058512 instance_end b8a3669e-9671-4b05-9400-377d75322917 0.15600000321865082

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.