Integrate BIRT into Pentaho

Hi All, 
 
i have tried since some days to deploy a birt-report into Pentaho. 
There are some manuals to do that: 
1.) 
<a class='bbc_url' href='http://wiki.pentaho.com/display/ServerDoc1x/1.+Eclipse+BIRT+Report+Definitions'>1. Eclipse BIRT Report Definitions - Pentaho Wiki</a> 
 
2.) 
<a class='bbc_url' href='http://www.stratebi.es/Bugs/birt/Integrating BIRT in Pentaho 2.0.pdf'>http://www.stratebi.es/Bugs/birt/Integrating BIRT in Pentaho 2.0.pdf</a> 
 
3.) 
<a class='bbc_url' href='http://www.osbi.fr/?tag=pentaho'>osbi.fr (Open Source Business Intelligence) Pentaho</a> 
 
4.) 
<a class='bbc_url' href='http://forums.pentaho.org/showpost.php?p=164889&postcount=4'>Pentaho Community Forums - View Single Post - Birt 2.2</a> 
 
 
All the instructions i followed, but i got after starting of pentaho over the 
start-pentaho.bat an exception: 
<pre class='_prettyXprint _lang-auto _linenums:0'>
21:07:29,265 ERROR [Logger] misc-org.pentaho.platform.engine.core.system.Pentaho
System: PentahoSystem.ERROR_0014 - Fehler beim Ausf³hren der Startup Sequenz - o
rg.pentaho.platform.plugin.action.eclipsebirt.BirtSystemListener
org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014
- Fehler beim Ausf³hren der Startup Sequenz - org.pentaho.platform.plugin.actio
n.eclipsebirt.BirtSystemListener
at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemLis
tenersOfStartup(PentahoSystem.java:324)
at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSys
tem.java:299)
at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSys
tem.java:220)
at org.pentaho.platform.web.http.context.SolutionContextListener.context
Initialized(SolutionContextListener.java:131)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
216)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:74
0)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)

at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.jav
a:926)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.j
ava:889)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492
)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
)
at org.apache.catalina.core.StandardService.start(StandardService.java:4
48)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700
)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: java.lang.NoSuchMethodError: org.eclipse.birt.report.engine.api.Engin
eConfig.getLogFile()Ljava/lang/String;
at org.eclipse.birt.report.engine.api.impl.ReportEngine.intializeLogger(
ReportEngine.java:169)
at org.eclipse.birt.report.engine.api.impl.ReportEngine.<init>(ReportEng
ine.java:120)
at org.eclipse.birt.report.engine.api.impl.ReportEngineFactory.createRep
ortEngine(ReportEngineFactory.java:13)
at org.pentaho.platform.plugin.action.eclipsebirt.BirtSystemListener.cre
ateBIRTEngine(BirtSystemListener.java:205)
at org.pentaho.platform.plugin.action.eclipsebirt.BirtSystemListener.sta
rtup(BirtSystemListener.java:81)
at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemLis
tenersOfStartup(PentahoSystem.java:319)
... 27 more
21:07:29,281 ERROR [Logger] Error end:
Pentaho BI Plattform Server wurde nicht ordnungsgemõ▀ initialisert. Das System w
ird Anfragen nicht annehmen k÷nnen.
25.08.2009 21:07:29 org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
25.08.2009 21:07:29 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
25.08.2009 21:07:29 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/32 config=null
25.08.2009 21:07:29 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
25.08.2009 21:07:29 org.apache.catalina.startup.Catalina start
INFO: Server startup in 5812 ms
</pre>
 
Does anybody know that exception and could please help me? 
I tried some certain pentaho version (2.0, 3.0,3.5) but everytime I got the same exception. 
 
Thank you. 
 
Bye 
ManInBlack

Find more posts tagged with

Comments

mgrohmann

Hi, 
 
I had the same problem, but I'm not sure, which configuration-option solved it. Do you know this post (bottom): 
 
<a class='bbc_url' href='http://forums.pentaho.org/showthread.php?t=50290'>BIRT integration - Pentaho Community Forums</a> 
 
?

ManInBlack

Hi,

i could get it working.
I often tried the manuals and anytime it works.

But unfortunately pentaho can´t find the oda (open data access) driver.
I would like to open a new thread.

Bye
ManInBlack

mgrohmann

did you change something in any *.xml-file for configuration-reasons?

ManInBlack

No, I didn´t change any xml. 
 
I only did exact this tutorial: 
<a class='bbc_url' href='http://www.osbi.fr/?p=424'>osbi.fr (Open Source Business Intelligence) Blog Archive BIRT 2.3.1 dans Pentaho 2.0</a> 
 
You have to do every part, only than it will work. 
 
How about you, does it works?

sdecloix

Hi ManInBlack 
 
I'm Sylvain, <a class='bbc_url' href='http://www.osbi.fr'>osbi.fr (Open Source Business Intelligence)</a> is my blog ;-) 
 
If you use another version than Pentaho V2 (V3 for example), the procedure doesn't work because there are modifications in some Java classes in pentaho v3 
 
More comments by pentaho team about that here : 
<a class='bbc_url' href='http://jira.pentaho.com/browse/BISERVER-2711'>[#BISERVER-2711] Birt Reports do not work in 2.0 - Pentaho BI Platform Tracking</a>

ManInBlack

Hi Sylvain, 
 
ah ok, thank you for your block.

I like your videos, which helped me a lot, for example, how to create xaction-files. 
 
Your are right, the steps in this tutorial are also necessary to replicate: 
<a class='bbc_url' href='http://www.stratebi.es/Bugs/birt/Integrating BIRT in Pentaho 2.0.pdf'>http://www.stratebi.es/Bugs/birt/Integrating BIRT in Pentaho 2.0.pdf</a> 
 
Bye 
ManInBlack

sdecloix

Hi ManInBlack ! 
 
I'm happy my blog helps you 
 
You probably know that, there's a pentaho procedure to upgrade Pentaho 3.0 server for using BIRT 2.5 (or 2.3) 
 
Enjoy it in english on Pentaho site : 
<a class='bbc_url' href='http://wiki.pentaho.com/display/ServerDoc1x/Upgrading+the+BIRT+Report+Engine+in+Pentaho+3.0'>Upgrading the BIRT Report Engine in Pentaho 3.0 - Pentaho Wiki</a> 
 
Or in french on my blog (same procedure, with a DOS script to delete osbolete jars...) 
<a class='bbc_url' href='http://www.osbi.fr/?p=595'>osbi.fr (Open Source Business Intelligence) Blog Archive Birt 2.5 (ou 2.3) dans Pentaho 3.0 (maj de l’article du 7 sept)</a> 
 
Sylvain

mgrohmann

thats totally correct, I got Pentaho 2.0 Stable running with BIRT Engine 2.3

I would really appreciate if somebody could modify the tutorial for the current release of Pentaho (3.5 out now!) and BIRT (2.5).

Does anybody has the skills for this task or does anybody know a person with this skills?

mannaco

<a class='bbc_url' href='https://sourceforge.net/projects/birt25pentaho35/'>https://sourceforge.net/projects/birt25pentaho35/</a> 
 
I have uploaded here required changes in source codes and docs to configure BIRT2.5 with Pentaho 3.5 
 
- Manna

mgrohmann

Great work manna, I installed both components and it works!

But I still got one issue left:

When I'm executing a BIRT report via a defined xaction (e.g. execute a report and send it to a mail-address) it works correctly.

When I'm scheduling the same xaction, it won't work and throws an "ERROR_0007 could not execute xaction".

Any ideas?

mgrohmann

ok, the scheduling won't work correctly with BIRT reports.

are there any updates for the BIRT 2.5/Pentaho 3.5 solution (in reference to the release of Pentaho 3.5.2 stable)?