Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » BIRT 2.6 and Query Builder fails on deployment(Getting errors using connection for Query Builder)
BIRT 2.6 and Query Builder fails on deployment [message #543588] Tue, 29 June 2010 21:50 Go to next message
Byron Palmer is currently offline Byron PalmerFriend
Messages: 14
Registered: July 2009
Junior Member
I am trying the new 2.6 version and I have created a very simple report using the connection for Query Builder. It works find inside of Eclipse but it fails when I deploy it to my stand-alone report runner. It generates an error


Cannot find or process the org.eclipse.birt.report.data.oda.jdbc.dbprofile driver's data source extension configuration.
Cannot find the ODA dataSource extension (org.eclipse.birt.report.data.oda.jdbc.dbprofile).

In the report log it says (and a lot more)

SEVERE: Cannot find or process the ODA data source extension configuration.
java.lang.IllegalArgumentException: Cannot find the ODA dataSource extension (org.eclipse.birt.report.data.oda.jdbc.dbprofile).
Check the workspace log file for any problems with loading the extension bundle and its dependencies.

If I switch this back to a simple JDBC connection it works find except that I can't use the query builder.

This seems to be an error but I can't find anything in the bugs. Has anyone a solution to this? I would love to give my users the ability to create reports using Query Builder but I can't unless I can actually deploy them.

Report message to a moderator

Re: BIRT 2.6 and Query Builder fails on deployment [message #543599 is a reply to message #543588] Wed, 30 June 2010 00:15 Go to previous messageGo to next message
Linda ChanFriend
Messages: 845
Registered: July 2009
Senior Member
>> Check the workspace log file for any problems with loading the extension bundle and its dependencies.

Any related info from the Eclipse workspace log file in your deployment environment?
Basically, the message indicates the related bundle is not loaded, either because the bundle jar file is missing or its dependencies cannot be resolved.
The birt runtime package includes the bundle jar file named org.eclipse.birt.report.data.oda.jdbc.dbprofile_*.jar . Check that it is in your WEB-INF\platform\plugins/ folder.

Linda

Report message to a moderator

Re: BIRT 2.6 and Query Builder fails on deployment [message #543830 is a reply to message #543599] Wed, 30 June 2010 17:29 Go to previous messageGo to next message
Byron Palmer is currently offline Byron PalmerFriend
Messages: 14
Registered: July 2009
Junior Member
The bundle jar is located in the ReportEngine directory in plugins.

The error message generated is

[org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:
Failed to find out data source of data set "Conn"., org.eclipse.birt.report.engine.api.EngineException: Failed to find out data source of data set "Conn".]

at org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.prepare(DataRequestSessionImpl.java:656)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.d oPrepareQuery(AbstractDataEngine.java:216)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doPrep areQuery(DteDataEngine.java:253)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.p repare(AbstractDataEngine.java:180)
at org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:124)
at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportExecutor.execute(WrappedReportExecutor.java:60)
at org.eclipse.birt.report.engine.internal.executor.dup.Suppres sDuplciateReportExecutor.execute(SuppressDuplciateReportExec utor.java:42)
at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportExecutor.execute(WrappedReportExecutor.java:60)
at org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportExecutor.execute(LocalizedReportExecutor.java:61)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doR un(RunAndRenderTask.java:170)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:75)
at org.trimet.obss.reportviewer.ReportManager.runReport(ReportM anager.java:205)
at org.trimet.obss.reportviewer.ViewerFrame.runReport(ViewerFra me.java:507)
at org.trimet.obss.reportviewer.ViewerFrame.access$3(ViewerFram e.java:459)
at org.trimet.obss.reportviewer.ViewerFrame$3.run(ViewerFrame.j ava:544)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:498 )
at org.eclipse.jface.action.ActionContributionItem.handleWidget Selection(ActionContributionItem.java:584)
at org.eclipse.jface.action.ActionContributionItem.access$2(Act ionContributionItem.java:501)
at org.eclipse.jface.action.ActionContributionItem$6.handleEven t(ActionContributionItem.java:452)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java :84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.ja va:3880)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :3473)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:825 )
at org.eclipse.jface.window.Window.open(Window.java:801)
at org.trimet.obss.reportviewer.ViewerMain.main(ViewerMain.java :102)
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: Failed to find out data source of data set "Conn".
at org.eclipse.birt.report.data.adapter.internal.adapter.DataAd apterUtil.adaptBaseDataSet(DataAdapterUtil.java:78)
at org.eclipse.birt.report.data.adapter.internal.adapter.OdaDat aSetAdapter. <init>(OdaDataSetAdapter.java:55)
at org.eclipse.birt.report.data.adapter.impl.ModelAdapter.adapt DataSet(ModelAdapter.java:133)
at org.eclipse.birt.report.data.adapter.impl.DefineDataSourceSe tUtil.defineDataSourceAndDataSet(DefineDataSourceSetUtil.jav a:120)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.defineDataSourceDataSet(DataRequestSessionImpl.java:166 2)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.prepare(DataRequestSessionImpl.java:447)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.prepare(DataRequestSessionImpl.java:639)
... 25 more

Here are the birt jar files in the plugin directory:
org.eclipse.birt.api_1.0.0.jar
org.eclipse.birt.chart.device.extension_2.6.0.v20100521.jar
org.eclipse.birt.chart.device.svg_2.6.0.v20100527.jar
org.eclipse.birt.chart.engine.extension_2.6.0.v20100601.jar
org.eclipse.birt.chart.engine_2.6.0.v20100607.jar
org.eclipse.birt.chart.examples.core_2.6.0.v20100607.jar
org.eclipse.birt.chart.reportitem_2.6.0.v20100604.jar
org.eclipse.birt.core.script.function_2.6.0.v20100524.jar
org.eclipse.birt.core_2.6.0.v20100526.jar
org.eclipse.birt.data.aggregation_2.6.0.v20100524.jar
org.eclipse.birt.data_2.6.0.v20100524.jar
org.eclipse.birt.report.data.adapter_2.6.0.v20100525.jar
org.eclipse.birt.report.data.bidi.utils_2.6.0.v20100524.jar
org.eclipse.birt.report.data.oda.jdbc.dbprofile.sampledb_2.6 .0.v20100524.jar
org.eclipse.birt.report.data.oda.jdbc.dbprofile_2.6.0.v20100 524.jar
org.eclipse.birt.report.data.oda.xml_2.6.0.v20100524.jar
org.eclipse.birt.report.engine.dataextraction.csv_2.5.2.v201 00115.jar
org.eclipse.birt.report.engine.dataextraction_2.5.2.v2010011 5.jar
org.eclipse.birt.report.engine.emitter.config_2.6.0.v2010030 4.jar
org.eclipse.birt.report.engine.emitter.excel.config_2.6.0.v2 0100527.jar
org.eclipse.birt.report.engine.emitter.html.config_2.6.0.v20 100304.jar
org.eclipse.birt.report.engine.emitter.html_2.6.0.v20100603. jar
org.eclipse.birt.report.engine.emitter.pdf.config_2.6.0.v201 00512.jar
org.eclipse.birt.report.engine.emitter.pdf_2.6.0.v20100513.j ar
org.eclipse.birt.report.engine.emitter.postscript.config_2.6 .0.v20100512.jar
org.eclipse.birt.report.engine.emitter.postscript_2.6.0.v201 00526.jar
org.eclipse.birt.report.engine.emitter.ppt.config_2.6.0.v201 00512.jar
org.eclipse.birt.report.engine.emitter.ppt_2.6.0.v20100429.j ar
org.eclipse.birt.report.engine.emitter.prototype.excel_2.6.0 .v20100601.jar
org.eclipse.birt.report.engine.emitter.wpml.config_2.6.0.v20 100512.jar
org.eclipse.birt.report.engine.emitter.wpml_2.6.0.v20100520. jar
org.eclipse.birt.report.engine.script.javascript_2.6.0.v2010 0408.jar
org.eclipse.birt.report.engine_2.6.0.v20100609.jar
org.eclipse.birt.report.item.crosstab.core_2.6.0.v20100531.j ar
org.eclipse.birt.report.model.adapter.oda_2.6.0.v20100528.ja r
org.eclipse.birt.report.model_2.6.0.v20100603.jar

There are no messages when the report engine starts up, and if I change the data source to the older style it works, although I can no longer edit the data set.

I agree that something is missing as it runs in the designer. However what that library or configuration that is missing is not apparent. I tried putting some of the plugin files from eclipse into the report engine but that didn't help.

Report message to a moderator

Re: BIRT 2.6 and Query Builder fails on deployment [message #543845 is a reply to message #543830] Wed, 30 June 2010 18:23 Go to previous messageGo to next message
Linda ChanFriend
Messages: 845
Registered: July 2009
Senior Member
The Eclipse workspace log file is different from the report engine's log file that shows the stack trace. Look for the .metadata/.log file name.

In any case, it looks like the birt-runtime 2.6 package is missing the org.eclipse.datatools.modelbase.sql.query_*.jar bundle jar file, which is one of the dependencies required by the org.eclipse.birt.report.data.oda.jdbc.dbprofile data source type.

Try manually copy the missing bundle jar file from the BIRT designer package (in its eclipse/plugins/ folder) to your deployment environment (into the WEB-INF/platform/plugins/ folder).

Let us know if that works, so it will get fixed in BIRT 2.6.1 runtime packaging.

Linda

Report message to a moderator

Re: BIRT 2.6 and Query Builder fails on deployment [message #543859 is a reply to message #543845] Wed, 30 June 2010 20:46 Go to previous messageGo to next message
Byron Palmer is currently offline Byron PalmerFriend
Messages: 14
Registered: July 2009
Junior Member
That seems to work. Without it the report fails. But with it in place it seems to work. I will test some more.

Thanks for figuring out what is needed. I tried a number of different things and ended up adding all the bundles and it worked, but it is nicer this way.

Report message to a moderator

Re: BIRT 2.6 and Query Builder fails on deployment [message #543864 is a reply to message #543859] Wed, 30 June 2010 21:37 Go to previous message
Linda ChanFriend
Messages: 845
Registered: July 2009
Senior Member
Thanks for letting us know. I'd submitted Bugzilla #318524 (https://bugs.eclipse.org/bugs/show_bug.cgi?id=318524) to have it fixed in the 2.6.1 birt-runtime packaging.

Linda

Report message to a moderator

Previous Topic:How to show rptdesign page in ie or any other browser insetead of birt viewer
Next Topic:Content Overflow in pdf
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 06:25:05 GMT 2024

Powered by FUDForum. Page generated in 0.02194 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly