Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Problems with Reporting PRD and Community Data Access CDA

  1. #1
    Join Date
    Dec 2013
    Posts
    5

    Default Problems with Reporting PRD and Community Data Access CDA

    hi,

    i have a problem with reporting when CDA is enabled inside (Datasource Community Data Access).
    system is 5.0.1 and updated CDA to latest (version 107)
    its not possible to execute a report on server PUC, the error in the background is:

    09:52:39,710 ERROR [AbstractReportProcessor] 970849598: Report processing failed.
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to send request
    at org.pentaho.reporting.platform.plugin.connection.CdaPluginLocalQueryBackend.fetchData(CdaPluginLocalQueryBackend.java:82)
    at org.pentaho.reporting.engine.classic.extensions.datasources.cda.CdaQueryBackend.fetchParameter(CdaQueryBackend.java:215)
    at org.pentaho.reporting.engine.classic.extensions.datasources.cda.CdaQueryBackend.queryData(CdaQueryBackend.java:227)
    at org.pentaho.reporting.engine.classic.extensions.datasources.cda.CdaDataFactory.queryData(CdaDataFactory.java:126)


    Caused by: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to acquire cda plugin:
    at org.pentaho.reporting.platform.plugin.connection.CdaPluginLocalQueryBackend.callPlugin(CdaPluginLocalQueryBackend.java:146)
    at org.pentaho.reporting.platform.plugin.connection.CdaPluginLocalQueryBackend.fetchData(CdaPluginLocalQueryBackend.java:73)
    ... 86 more
    Caused by: java.lang.NoSuchMethodException: pt.webdetails.cda.CdaUtils.listParameters(java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, javax.servlet.http.HttpServletResponse, javax.servlet.http.HttpServletRequest)
    at java.lang.Class.getMethod(Class.java:1655)
    at org.pentaho.reporting.platform.plugin.connection.CdaPluginLocalQueryBackend.callPlugin(CdaPluginLocalQueryBackend.java:106)
    ... 87 more
    09:52:39,712 ERROR [SimpleReportingComponent] [execute] Component execution failed.


    09:52:39,713 DEBUG [ExecuteReportContentHandler] Failed to generated content

    in report designer the execution is working without problems but if uploaded on server, the above error occurs, report is tested with the /public/plugin-samples/cda/cdafiles/sql-jndi.cda

    and report sample-report-cda.prpt path is localhost:8080

    question must the report designer also be updated with correct cda libs ? or is it a real bug

    Important Note: this is only happening with sql.jndi with other types its working see also post Thread: unable to export query output to .xls from cda editor

    Last edited by horst.lei; 02-13-2014 at 05:13 AM.

  2. #2
    Join Date
    Dec 2013
    Posts
    5

    Default

    ok solve the problem with finding this post

    ISSUE: PRPT CDA Datasource issue from within PUC

    problem is you are NOT allowed to use the local API calls, this can be configured under Edit Datasource disable "Allow local API calls instead of HTTP calls "
    then you can upload it to PUC and its working

    is the local API call only for Report Designer Usage ?

    thanx for answer

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

    Default

    Actually that's a bug on the 5.0 EE codeline http://jira.pentaho.com/browse/PRD-4767

    It'll be definitely fixed for 5.1. But it should work fine with 5.0.1 CE.
    You should be able to use local API calls.
    Pedro Vale
    --
    CTools Product Development
    http://www.webdetails.pt

  4. #4
    Join Date
    Dec 2013
    Posts
    5

    Default

    hi,

    yes if i use it only in report designer it works perfect, but after upload to server and calling it there i get the exceptions

    there ONLY works at the moment the solution i found here ISSUE: PRPT CDA Datasource issue from within PUC

    thanx for info that it will be fixed in 5.1

Tags for this Thread

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.