Eclipse Community Forums: BIRT » Integrated BIRT Report giving OCL errors

Home » Archived » BIRT » Integrated BIRT Report giving OCL errors(Errors while integrating BIRT report design to Java)

Integrated BIRT Report giving OCL errors [message #916375]

Tue, 18 September 2012 20:16

Eclipse User

We have a BIRT report design that I am trying to integrate into a Java application so we can push a button and produce the report. The errors I am getting follow. We are using the OCL expression "self" with EMF Ecore Models in order to get at the meta model itself (like class and attribute information). See attached for the Java app.

Any help from the BIRT experts here would be greatly appreciated.

Thanks,
Randy

Sep 18, 2012 5:50:44 PM org.eclipse.birt.data.engine.odaconsumer.Connection prepareOdaQuery
SEVERE: Failed to prepare the following query for the data set type (org.eclipse.emf.oda.ecore.dataSet).
[self]
org.eclipse.datatools.connectivity.oda.OdaException ;
java.lang.NullPointerException
at org.eclipse.emf.oda.ecore.impl.Query.prepare(Query.java:155)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.doPrepare(OdaQuery.java:229)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.prepare(OdaQuery.java:186)
at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareOdaQuery(Connection.java:290)
at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareStatement(Connection.java:197)
at org.eclipse.birt.data.engine.executor.DataSource.prepareStatement(DataSource.java:302)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:281)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:442)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:341)
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:159)
at org.eclipse.birt.data.engine.impl.PreparedJointDataSourceQuery.populatePreparedQuery(PreparedJointDataSourceQuery.java:555)
at org.eclipse.birt.data.engine.impl.PreparedJointDataSourceQuery.populatePreparedQuery(PreparedJointDataSourceQuery.java:492)
at org.eclipse.birt.data.engine.impl.PreparedJointDataSourceQuery.access$2(PreparedJointDataSourceQuery.java:490)
at org.eclipse.birt.data.engine.impl.PreparedJointDataSourceQuery$JointDataSetQueryExecutor.createOdiQuery(PreparedJointDataSourceQuery.java:587)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:325)
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:159)
at org.eclipse.birt.data.engine.impl.PreparedJointDataSourceQuery.populatePreparedQuery(PreparedJointDataSourceQuery.java:555)
at org.eclipse.birt.data.engine.impl.PreparedJointDataSourceQuery.populatePreparedQuery(PreparedJointDataSourceQuery.java:492)
at org.eclipse.birt.data.engine.impl.PreparedJointDataSourceQuery.access$2(PreparedJointDataSourceQuery.java:490)
at org.eclipse.birt.data.engine.impl.PreparedJointDataSourceQuery$JointDataSetQueryExecutor.createOdiQuery(PreparedJointDataSourceQuery.java:587)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:325)
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:624)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
at com.lmco.osf.col.birt.BIRTReportRunner.runReport(BIRTReportRunner.java:87)
at com.lmco.osf.col.birt.RunBirtReport$4.widgetSelected(RunBirtReport.java:179)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)
at com.lmco.osf.col.birt.RunBirtReport.runEventLoop(RunBirtReport.java:192)
at com.lmco.osf.col.birt.RunBirtReport.main(RunBirtReport.java:203)
Caused by: java.lang.NullPointerException
at org.eclipse.emf.oda.ecore.impl.Query.prepare(Query.java:147)
... 53 more
Report succeded.

==================================================================================
The output.html file contains:

The following items have errors:

Table (id = 14):
+ An exception occurred during processing. Please see the following message for details:
Failed to prepare the query execution for the data set: Class Data Set
Failed to prepare the following query for the data set type (org.eclipse.emf.oda.ecore.dataSet).
[self]
org.eclipse.datatools.connectivity.oda.OdaException ;
java.lang.NullPointerException (Element ID:14)

Attachment: BIRTReportRunner.java
(Size: 3.59KB, Downloaded 359 times)

Re: Integrated BIRT Report giving OCL errors [message #916934 is a reply to message #916375]

Wed, 19 September 2012 12:55

Eclipse User

Does the report work in the designer?

Jason

Re: Integrated BIRT Report giving OCL errors [message #917218 is a reply to message #916934]

Wed, 19 September 2012 19:12

Eclipse User

Yes, it is fine.

Randy

Re: Integrated BIRT Report giving OCL errors [message #917941 is a reply to message #917218]

Thu, 20 September 2012 11:25

Eclipse User

Did you copy the emf oda runtime plugin to your deploy environment?

Jason

Re: Integrated BIRT Report giving OCL errors [message #917976 is a reply to message #917941]

Thu, 20 September 2012 11:59

Eclipse User

Jason,

Yes, I included org.eclipse.emf.oda.ecore in the list of dependencies for the package (among a bunch of others). I am guessing it has something to do with OCL being not supported somehow but I don't really know. I sure appreciate help. I am stuck on this now.

Thank you!
Randy

Re: Integrated BIRT Report giving OCL errors [message #919021 is a reply to message #917976]

Fri, 21 September 2012 11:56

Eclipse User

Is your app an RCP app? What version of BIRT are you using and which emf oda did you download.

Jason

Re: Integrated BIRT Report giving OCL errors [message #919032 is a reply to message #919021]

Fri, 21 September 2012 12:07

Eclipse User

Jason,

The application is an SWT app, so it's short. There are two classes, one for the UI getting the input/output and data source file names plus the output format, and the other class which is what I posted, the BirtReportRunner. I have the DOC, HTML, XLS, and PDF emitters working correctly I believe, but the OCL query error is stopping the results.

I am using Juno. I attached a screen shot of the software installed. Looks like 4.2 of BIRT, and 1.1.0 of EMF ODA driver.

Thanks for your time,
Randy

Attachment: InstalledSoftware.PNG
(Size: 164.55KB, Downloaded 282 times)

Re: Integrated BIRT Report giving OCL errors [message #919095 is a reply to message #919032]

Fri, 21 September 2012 13:21

Eclipse User

I am not very familiar with the emf ecore oda. Is this the method you used to install:
http://wiki.eclipse.org/Ecore_ODA_Driver
Any chance you can open a bugzilla entry on the DTP Project?

Jason

Re: Integrated BIRT Report giving OCL errors [message #919106 is a reply to message #919095]

Fri, 21 September 2012 13:34

Eclipse User

Jason,

No, I used to integrated Install Software method since the driver is now integrated with Eclipse.

I don't know how to open a bugzilla entry on the DTP Project. How does that work?

Thanks,
Randy

Re: Integrated BIRT Report giving OCL errors [message #919116 is a reply to message #919106]

Fri, 21 September 2012 13:44

Eclipse User

You can log a bug on data tools here:
https://bugs.eclipse.org/bugs/enter_bug.cgi?classification=DataTools
I am trying to locate the source for the oda you are using. Do you know where it is?

Jason

Re: Integrated BIRT Report giving OCL errors [message #919133 is a reply to message #919116]

Fri, 21 September 2012 14:06

Eclipse User

BTW this error should not be reported to the DataTools project but the EMF project.

Jason

Re: Integrated BIRT Report giving OCL errors [message #919157 is a reply to message #919133]

Fri, 21 September 2012 14:40

Eclipse User

Hi Jason,

I created: https://bugs.eclipse.org/bugs/show_bug.cgi?id=390120

Hopefully they can help. Please add any comments to it you think are necessary.

Thanks again for your time,
Randy

Re: Integrated BIRT Report giving OCL errors [message #929640 is a reply to message #919157]

Mon, 01 October 2012 12:23

Eclipse User

That bug was marked invalid because I didn't include a reproducible example, so I put together an example and created another bug:

https://bugs.eclipse.org/bugs/show_bug.cgi?id=390581

Thanks,
Randy

Re: Integrated BIRT Report giving OCL errors [message #931998 is a reply to message #929640]

Wed, 03 October 2012 14:31

Eclipse User

The solution was:

QueryDelegate.Factory.Registry.INSTANCE.put("http://www.eclipse.org/emf/2002/Ecore/OCL", new OCLQueryDelegateFactory.Global());

Works now!

Randy

Re: Integrated BIRT Report giving OCL errors [message #932084 is a reply to message #931998]

Wed, 03 October 2012 16:25

Eclipse User

Thanks for updating.

Jason

Previous Topic:	How to show Average in Cross Tab?
Next Topic:	Birt Web Viewer Internationalization

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 22 14:30:17 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter