Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Using BIRT OUTPUT with Kettle

  1. #1
    Join Date
    Aug 2006
    Posts
    141

    Default Using BIRT OUTPUT with Kettle

    Using BIRT OUTPUT with Kettle

    I' m using BIRT OUTPUT STEP component to Kette (Matt) for send reports via mail. It work perfect when I run it over graphic interface of kettle but when i run using kitchen (JOBS) and pan (TRANSFORMATIONS) it alway say BIRT Output - java.lang.ClassCastException: org.eclipse.birt.report.engine.api.impl.ReportEngineFactory cannot be cast to org.eclipse.birt.report.engine.api.IReportEngineFactory Somebody has worked with this step, What could be the problem?????.

  2. #2
    Join Date
    Aug 2006
    Posts
    141

    Default

    It look like the version of ReportEngine don't work with pan or kitchen

  3. #3

    Default

    I haven't had the time to investigate what causes this, but this only occurs with the 2.6.2 engine, which is installed by default in the plugin.
    You can easily upgrade the embedded BIRT engine by removing the contents of the plugins/step/BIRTOutput/lib and libext/ReportEngine folders, and copying over the jars from a more recent (e.g. 3.7.2) BIRT runtime (all jars from ReportEngine/lib).

  4. #4
    Join Date
    Aug 2006
    Posts
    141

    Default

    Quote Originally Posted by bamaer View Post
    I haven't had the time to investigate what causes this, but this only occurs with the 2.6.2 engine, which is installed by default in the plugin.
    You can easily upgrade the embedded BIRT engine by removing the contents of the plugins/step/BIRTOutput/lib and libext/ReportEngine folders, and copying over the jars from a more recent (e.g. 3.7.2) BIRT runtime (all jars from ReportEngine/lib).

    Thanks for your answer.

    That is true, I've working with diferent versions of BIRT and I can see that I have to work with the correct version for the BI Pentaho Server that I be working.

  5. #5
    Join Date
    Nov 2015
    Posts
    4

    Default

    Sorry for hijacking an old thread, but I am using this plugin and while it works perfectly well in Spoon, it does not appear to work when using pan or kitchen. I have a feeling it is also related to a library being out of date, but can't for the life of me figure out which one is causing this. Any help you can provide would be greatly appreciated:

    Code:
    2015/11/13 09:00:55 - Pan - Start of run.2015/11/13 09:00:55 - RESULTS_REPORT - Dispatching started for transformation [RESULTS_REPORT]
    2015/11/13 09:00:55 - REPORT INFO.0 - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
    2015/11/13 09:00:58 - BIRT Output.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : Unexpected error
    2015/11/13 09:00:58 - BIRT Output.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : org.pentaho.di.core.exception.KettleException: 
    2015/11/13 09:00:58 - BIRT Output.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : There was an unexpected error processing report '\\fac-storage\Scripts\Automation\DMV\SETUP\DMV_REPORT.rptdesign' to produce file '\\fac-storage\Scripts\Automation\DMV\RESULTS\DMV_REPORT.pdf' with processor: PDF.
    2015/11/13 09:00:58 - BIRT Output.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : Unable to parse the document: ResourceKey{schema=org.pentaho.reporting.libraries.resourceloader.loader.URLResourceLoader, identifier=file:////fac-storage/Scripts/Automation/DMV/SETUP/DMV_REPORT.rptdesign, factoryParameters={}, parent=null}
    2015/11/13 09:00:58 - BIRT Output.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : 
    2015/11/13 09:00:58 - BIRT Output.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : 	at org.pentaho.di.trans.steps.pentahoreporting.PentahoReportingOutput.processReport(PentahoReportingOutput.java:246)
    2015/11/13 09:00:58 - BIRT Output.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : 	at org.pentaho.di.trans.steps.pentahoreporting.PentahoReportingOutput.processRow(PentahoReportingOutput.java:115)
    2015/11/13 09:00:58 - BIRT Output.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : 	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
    2015/11/13 09:00:58 - BIRT Output.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : 	at java.lang.Thread.run(Unknown Source)
    2015/11/13 09:00:58 - BIRT Output.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : Caused by: org.pentaho.reporting.libraries.resourceloader.ResourceCreationException: Unable to parse the document: ResourceKey{schema=org.pentaho.reporting.libraries.resourceloader.loader.URLResourceLoader, identifier=file:////fac-storage/Scripts/Automation/DMV/SETUP/DMV_REPORT.rptdesign, factoryParameters={}, parent=null}
    2015/11/13 09:00:58 - BIRT Output.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : 	at org.pentaho.reporting.libraries.xmlns.parser.AbstractXmlResourceFactory.create(AbstractXmlResourceFactory.java:249)
    2015/11/13 09:00:58 - BIRT Output.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : 	at org.pentaho.reporting.libraries.resourceloader.DefaultResourceManagerBackend.create(DefaultResourceManagerBackend.java:272)
    2015/11/13 09:00:58 - BIRT Output.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : 	at org.pentaho.reporting.libraries.resourceloader.ResourceManager.create(ResourceManager.java:434)
    2015/11/13 09:00:58 - BIRT Output.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : 	at org.pentaho.reporting.libraries.resourceloader.ResourceManager.create(ResourceManager.java:370)
    2015/11/13 09:00:58 - BIRT Output.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : 	at org.pentaho.reporting.libraries.resourceloader.ResourceManager.createDirectly(ResourceManager.java:207)
    2015/11/13 09:00:58 - BIRT Output.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : 	at org.pentaho.di.trans.steps.pentahoreporting.PentahoReportingOutput.loadMasterReport(PentahoReportingOutput.java:151)
    2015/11/13 09:00:58 - BIRT Output.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : 	at org.pentaho.di.trans.steps.pentahoreporting.PentahoReportingOutput.processReport(PentahoReportingOutput.java:167)
    2015/11/13 09:00:58 - BIRT Output.0 - ERROR (version 4.4.2-GA, build 18750 from 2013-07-19 11.23.04 by buildguy) : 	... 3 more
    2015/11/13 09:00:58 - BIRT Output.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
    2015/11/13 09:00:58 - RESULTS_REPORT - RESULTS_REPORT
    2015/11/13 09:00:58 - RESULTS_REPORT - RESULTS_REPORT
    2015/11/13 09:00:58 - Pan - Finished!
    2015/11/13 09:00:58 - Pan - Start=2015/11/13 09:00:55.617, Stop=2015/11/13 09:00:58.902
    2015/11/13 09:00:58 - Pan - Processing ended after 3 seconds.

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 - 2017 Pentaho Corporation. All Rights Reserved.