Scheduling BIRT reports using batch files

Hi 
 
I am trying to schedule my BIRT reports using batch fiels.I created runRepoert batch file with following lines: 
 
C:\birt-runtime\birt-runtime-2_6_1\ReportEngine\genReport.bat -m runrender-o 
"c:\birt-runtime\birt-runtime-2_6_1\ReportEngine\samples\output.pdf" -f pdf 
"C:\birt-runtime\birt-runtime-2_6_1\ReportEngine\samples\hello_world.rptdesign" 
 
when i am trying to run the commands from command window : 
C:\birt-runtime\birt-runtime-2_6_1\ReportEngine>genReport.bat -m runrender-o 
 
following error is coming: 
 
 
 
C:\birt-runtime\birt-runtime-2_6_1\ReportEngine>ECHO off 
Exception in thread "main" java.lang.NoClassDefFoundError: org/eclipse/birt/repo 
rt/engine/api/ReportRunner 
Caused by: java.lang.ClassNotFoundException: org.eclipse.birt.report.engine.api. 
ReportRunner 
at java.net.URLClassLoader$1.run(Unknown Source) 
at java.security.AccessController.doPrivileged(Native Method) 
at java.net.URLClassLoader.findClass(Unknown Source) 
at java.lang.ClassLoader.loadClass(Unknown Source) 
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) 
at java.lang.ClassLoader.loadClass(Unknown Source) 
at java.lang.ClassLoader.loadClassInternal(Unknown Source) 
Could not find the main class: org.eclipse.birt.report.engine.api.ReportRunner. 
Program will exit. 
C:\birt-runtime\birt-runtime-2_6_1\ReportEngine> 
 
where to find to Report runner class .Pls help me.When I schedule this runreport batch file through windows scheduler nothing is created :no HTML nor PDF .I tried for both.pls help me. 
 
Thanks in advance 
chaiatnya.

Find more posts tagged with

Comments

mwilliams

Hi chaiatnya,

Are you sure that the BIRT runtime is in your classpath?

chaitanya1

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="71582" data-time="1292943325" data-date="21 December 2010 - 07:55 AM">
Hi chaiatnya, 
 
Are you sure that the BIRT runtime is in your classpath? </blockquote>
 
 
 
Hi williams, 
Thanks for ur reply. 
Actually I downloaded again the birt-runtime engine_2_6_1 freshly. 
Now I created the batch file as follows: 
 
Set BIRT_HOME=C:\birt-runtime\birt-runtime-2_6_1\ 
C:\birt-runtime\birt-runtime-2_6_1\ReportEngine\genReport.bat -m runrender-o 
"c:\birt-runtime\birt-runtime-2_6_1\ReportEngine\samples\output.pdf" -f pdf 
"C:\birt-runtime\birt-runtime-2_6_1\ReportEngine\samples\hello_world.rptdesign" 
 
 
When I am trying to run this batch file it is showing as follows and I am geeting one folder named workspace in the folder where runreport batch file is located. 
 
 
 
C:\birt-runtime\birt-runtime-2_6_1\ReportEngine>Set BIRT_HOME=C:\birt-runtime\bi 
rt-runtime-2_6_1\ 
 
C:\birt-runtime\birt-runtime-2_6_1\ReportEngine>C:\birt-runtime\birt-runtime-2_6 
_1\ReportEngine\genReport.bat -m runrender-o 
 
C:\birt-runtime\birt-runtime-2_6_1\ReportEngine>ECHO off 
Dec 28, 2010 12:14:53 PM org.eclipse.birt.report.engine.api.impl.ReportEngineHel 
per openReportDesign 
SEVERE: C:\birt-runtime\birt-runtime-2_6_1\ReportEngine\runrender-o not found! 
Dec 28, 2010 12:14:53 PM org.eclipse.birt.report.engine.api.ReportRunner runAndR 
enderReport 
SEVERE: The design file runrender-o can not be found. 
org.eclipse.birt.report.engine.api.EngineException: The design file runrender-o 
can not be found. 
at org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.openReport 
Design(ReportEngineHelper.java:113) 
at org.eclipse.birt.report.engine.api.impl.ReportEngine.openReportDesign 
(ReportEngine.java:295) 
at org.eclipse.birt.report.engine.api.ReportRunner.runAndRenderReport(Re 
portRunner.java:189) 
at org.eclipse.birt.report.engine.api.ReportRunner.execute(ReportRunner. 
java:162) 
at org.eclipse.birt.report.engine.api.ReportRunner.main(ReportRunner.jav 
a:121) 
 
 
I am totally confused with the process.Pls Pls help me out in this 
Thanks in advance 
Chaitanya

trivedi

Hi Chaitanya,

You are not specifying the *.rptdesign file name. BIRT is looking for it & throws an error.

Example:-

C:\birt-runtime\birt-runtime-2_6_1\ReportEngine\genReport.bat -f PDF samples\hello_world.rptdesign

this should run.

Basically problem is in paths and how you can make BIRT read your design file. Try deifferent combinations of path.

Good Luck.

Jitu

chaitanya1

<blockquote class='ipsBlockquote' data-author="'trivedi'" data-cid="71792" data-time="1293697424" data-date="30 December 2010 - 01:23 AM">
Hi Chaitanya, 
 
You are not specifying the *.rptdesign file name. BIRT is looking for it & throws an error. 
 
Example:- 
 
C:\birt-runtime\birt-runtime-2_6_1\ReportEngine\genReport.bat -f PDF samples\hello_world.rptdesign 
 
this should run. 
 
Basically problem is in paths and how you can make BIRT read your design file. Try deifferent combinations of path. 
 
Good Luck. 
 
Jitu </blockquote>
 
hiii 
 
Thank you very much Jitu 
Now I am getting both pdf and html formats of that sample report hello_world.rptdesign. 
But onething, 
when i am trying for my reports which is having jdbc connection,it is running but giving the following error : 
 
My batch file is : 
Set BIRT_HOME=C:\birt-runtime\birt-runtime-2_6_1\ 
C:\birt-runtime\birt-runtime-2_6_1\ReportEngine\genReport.bat -f HTML workspace\date_diff.rptdesign 
 
 
when i am trying for my reports which is having jdbc connection,it is running but giving the following error : 
I copied the required jar file for that jdbc connection in ReportEngine\plugins\jdbcfolder\jarfile. 
But still i ma getting this error. 
 
 
 
 
 
C:\birt-runtime\birt-runtime-2_6_1\ReportEngine>Set BIRT_HOME=C:\birt-runtime\bi 
rt-runtime-2_6_1\ 
 
C:\birt-runtime\birt-runtime-2_6_1\ReportEngine>C:\birt-runtime\birt-runtime-2_6 
_1\ReportEngine\genReport.bat -f HTML workspace\date_diff.rptdesign 
 
C:\birt-runtime\birt-runtime-2_6_1\ReportEngine>ECHO off 
Dec 31, 2010 5:34:10 PM org.eclipse.birt.data.engine.odaconsumer.Driver createNe 
wDriverHelper 
SEVERE: Cannot get ODA data source driver helper. 
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: Unabl 
e to load or instantiate the custom ODA driver class. (org.eclipse.birt.report.d 
ata.oda.jdbc.OdaJdbcDriver) ; 
java.lang.ClassNotFoundException: org.eclipse.birt.report.data.oda.jdbc.OdaJdbcD 
river 
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaDriver.load 
DriverInstance(OdaDriver.java:231) 
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaDriver.init 
(OdaDriver.java:177) 
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaDriver.<ini 
t>(OdaDriver.java:93) 
at org.eclipse.birt.data.engine.odaconsumer.Driver.createNewDriverHelper 
(Driver.java:97) 
at org.eclipse.birt.data.engine.odaconsumer.DriverManager.getDriverHelpe 
r(DriverManager.java:111) 
at org.eclipse.birt.data.engine.odaconsumer.DriverManager.getNewDriverHe 
lper(DriverManager.java:100) 
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnec 
tion(ConnectionManager.java:150) 
at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSo 
urce.java:222) 
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java 
:210) 
at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource 
(DataSourceRuntime.java:208) 
at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryE 
xecutor.java:406) 
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(Quer 
yExecutor.java:316) 
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQue 
ry.java:448) 
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQuer 
yResults(PreparedDataSourceQuery.java:190) 
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(Pre 
paredDataSourceQuery.java:178) 
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(Prepared 
OdaDSQuery.java:145) 
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.exec 
ute(DataRequestSessionImpl.java:617) 
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery( 
DteDataEngine.java:152) 
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(Ab 
stractDataEngine.java:265) 
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery 
(ExecutionContext.java:1876) 
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuer 
y(QueryItemExecutor.java:80) 
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(Tab 
leItemExecutor.java:62) 
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicat 
eItemExecutor.execute(SuppressDuplicateItemExecutor.java:43) 
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportIt 
emExecutor.execute(WrappedReportItemExecutor.java:46) 
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReport 
ItemExecutor.execute(LocalizedReportItemExecutor.java:34) 
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layout 
Nodes(HTMLBlockStackingLM.java:65) 
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPage 
LM.java:90) 
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.lay 
out(HTMLReportLayoutEngine.java:99) 
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAnd 
RenderTask.java:180) 
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRe 
nderTask.java:77) 
at org.eclipse.birt.report.engine.api.ReportRunner.runAndRenderReport(Re 
portRunner.java:222) 
at org.eclipse.birt.report.engine.api.ReportRunner.execute(ReportRunner. 
java:162) 
at org.eclipse.birt.report.engine.api.ReportRunner.main(ReportRunner.jav 
a:121) 
Caused by: java.lang.ClassNotFoundException: org.eclipse.birt.report.data.oda.jd 
bc.OdaJdbcDriver 
at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(Bundl 
eLoader.java:506) 
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader. 
java:422) 
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader. 
java:410) 
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(De 
faultClassLoader.java:107) 
at java.lang.ClassLoader.loadClass(Unknown Source) 
at org.eclipse.osgi.internal.loader.BundleLoader.loadClass(BundleLoader. 
java:338) 
at org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleH 
ost.java:232) 
at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadClass(Abs 
tractBundle.java:1197) 
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaDriver.load 
DriverInstance(OdaDriver.java:208) 
... 32 more 
 
 
Thank in advance 
 
Chaitanya

trivedi

Hi Chaitanya,

put your JDBC Driver in the following folder:-

<install path>/ReportEngine/plugins/org.eclipse.birt.report.data.oda.jdbc_2.5.1.v20090821/drivers/

this should solve the error !