Eclipse Community Forums: BIRT » BIRT 2.6 and Query Builder fails on deployment

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 17:50

Eclipse User

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.

Re: BIRT 2.6 and Query Builder fails on deployment [message #543599 is a reply to message #543588]

Tue, 29 June 2010 20:15

Eclipse User

>> 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

Re: BIRT 2.6 and Query Builder fails on deployment [message #543830 is a reply to message #543599]

Wed, 30 June 2010 13:29

Eclipse User

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.

Re: BIRT 2.6 and Query Builder fails on deployment [message #543845 is a reply to message #543830]

Wed, 30 June 2010 14:23

Eclipse User

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

Re: BIRT 2.6 and Query Builder fails on deployment [message #543859 is a reply to message #543845]

Wed, 30 June 2010 16:46

Eclipse User

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.

Re: BIRT 2.6 and Query Builder fails on deployment [message #543864 is a reply to message #543859]

Wed, 30 June 2010 17:37

Eclipse User

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

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:

-=] Back to Top [=-

Current Time: Sat Jul 12 00:11:24 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter