Hitachi Vantara Pentaho Community Forums
Results 1 to 12 of 12

Thread: unable to export query output to .xls from cda editor

  1. #1
    Join Date
    Feb 2013
    Posts
    530

    Default unable to export query output to .xls from cda editor

    Today in pentaho 5.0.1 BA server I've tried to export the output of a query result to .xls file. I did clicked on Export button but I didn't find any popup saying save or open with instead I found blank web page.

    CDA file location is : Filename: /public/Projects/Explore/Explore.cda (bold is my project structure)

    Export blank page url : http://localhost:8086/pentaho/plugin...tableComponent&outputType=xls&path=%2Fpublic%2FProjects%2FExplore%2FExplore.cda
    How to fix this ?
    Last edited by sadakar; 01-30-2014 at 09:00 AM.

  2. #2
    Join Date
    Jul 2007
    Posts
    2,500

    Default

    Can you check the logs? Do other outputTypes work?
    Pedro Alves
    Meet us on ##pentaho, a FreeNode irc channel

  3. #3
    Join Date
    Dec 2013
    Posts
    5

    Default

    Hi,

    i have the same problem connections from CDA of type="sql.jndi" or type="sql.jdbc" are not working to export you can test it with the /public/plugin-samples/cda/cdafiles/sql-jndi.cda
    exception is with jndi on this part and export to xls:

    SEVERE: Mapped exception to response: 500 (Internal Server Error)
    javax.ws.rs.WebApplicationException: pt.webdetails.cda.exporter.ExporterException: Kettle exception during xls query
    at pt.webdetails.cda.CdaUtils$2.write(CdaUtils.java:215)
    at com.sun.jersey.core.impl.provider.entity.StreamingOutputProvider.writeTo(StreamingOutputProvider.java:71)
    at com.sun.jersey.core.impl.provider.entity.StreamingOutputProvider.writeTo(StreamingOutputProvider.java:57)

    Caused by: pt.webdetails.cda.exporter.ExporterException: Kettle exception during xls query
    at pt.webdetails.cda.exporter.DefaultStreamExporter.export(DefaultStreamExporter.java:141)
    at pt.webdetails.cda.exporter.ExportedStreamQueryResult.writeOut(ExportedStreamQueryResult.java:12)
    at pt.webdetails.cda.CdaUtils$2.write(CdaUtils.java:213)
    ... 68 more
    Caused by: org.pentaho.di.core.exception.KettleException:
    The number of step copies does not resolve to a positive non-zero value (null) for step Input.


    at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:689)
    at plugins.org.pentaho.di.robochef.kettle.DynamicTransformation.execute(DynamicTransformation.java:172)
    at plugins.org.pentaho.di.robochef.kettle.DynamicTransformation.executeCheckedSuccess(DynamicTransformation.java:154)
    at pt.webdetails.cda.exporter.DefaultStreamExporter.export(DefaultStreamExporter.java:128)

    same issue also if CDA is integrated in a prpt and added to CDE but this is a different error, perhaps i bases on the same

    call via Query String: http://localhost:8080/pentaho/plugin...01&outputType=[pdf|xls|csv|html]

    other types on direct link working are
    pdf:
    Caused by: pt.webdetails.cda.exporter.UnsupportedExporterException: Could not find exporter for pdf
    Caused by: java.lang.ClassNotFoundException: pt.webdetails.cda.exporter.PdfExporter

    csv:
    Caused by: pt.webdetails.cda.exporter.ExporterException: Kettle exception during csv query
    at pt.webdetails.cda.exporter.DefaultStreamExporter.export(DefaultStreamExporter.java:141)
    at pt.webdetails.cda.exporter.ExportedStreamQueryResult.writeOut(ExportedStreamQueryResult.java:12)
    at pt.webdetails.cda.CdaUtils$2.write(CdaUtils.java:213)
    ... 68 more
    Caused by: org.pentaho.di.core.exception.KettleException:
    The number of step copies does not resolve to a positive non-zero value (null) for step Input.


    html: working

    funny with different connection types it's working like mdx or so

    i hope you find the problem

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

    Default

    I'm not getting those errors. Are you using the latest CDA ?
    Pedro Vale
    --
    CTools Product Development
    http://www.webdetails.pt

  5. #5

    Default

    Same thing here. When I try to export a sql query it doesn't work, but a mdx query works fine.

  6. #6
    Join Date
    Feb 2013
    Posts
    530

    Default

    Still the problem is there... Yes, I am using the latest CDA with 5.0.1 server + all the latest C-Tools

  7. #7
    Join Date
    Nov 2010
    Posts
    2

    Default

    Hi

    We have the same problem.

    Juan Carlos

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

    Default

    Can one of you open a jira at jira.pentaho.com, CDA project ?
    This requires a more thorough investigation, it seems.
    Pedro Vale
    --
    CTools Product Development
    http://www.webdetails.pt

  9. #9

    Default

    Same problem here... using a kettle datasource it exports from CDA but not from export button in dashboard.

    log here:
    mar 06, 2014 12:54:28 PM org.apache.coyote.http11.AbstractHttp11Processor process
    Información: Error analizando cabecera de requerimiento HTTP
    Note: further occurrences of HTTP header parsing errors will be logged at DEBUG level.
    I'm in debug level but don't see anything else.
    Tried modifing the maxHttpHeaderSize in tomcat/conf/server.xml but still not working.
    With jndi datasource it doesn't work neither in CDA.

  10. #10

    Default

    Try updating all components from marketplace (CDE, CDA, CDF).

  11. #11
    Join Date
    Dec 2013
    Posts
    5

    Default

    hi all,

    now are all parts working except pdf export because of missing class

    i have updated the marketplace parts, to current

    pentaho-cda (cda-TRUNK-SNAPSHOT.zip) Wed Apr 02 15:05:26 CEST 2014

    pentaho-cdf (pentaho-cdf-TRUNK-SNAPSHOT.zip) Tue Apr 01 12:12:32 CEST 2014

    webdetails-cde-5.0 (pentaho-cdf-dd-TRUNK-SNAPSHOT.zip) Wed Apr 02 12:08:09 CEST 2014


    with this versions i have tested and it's working


    thanks



  12. #12
    Join Date
    Nov 2010
    Posts
    2

    Default

    I updated the plugins from Marketplace, the export to XLS is working now.

    Thanks,

    Juan Carlos

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.