Hi, guys, fine.

I'm fighting here to make Birt and EGL work. Can anyone help us?

My settings are: RBD 9.5.0.1, Db2 v 9, BIRT 4.4.2 (OSGI), WAS 8.5. Client windows 7 and Server AIX - Power 740.

We were able to use BIRT within RBD from the Report Design perspective.

The problem is when I run EGL applications. Let's go to the details:
1) I developed a "BasicProgram" (attachment)
2) I developed a "Birthandler" (attachment)
3) when executing the "BasicProgram" I get the abend (attachment)
"Detail: org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:
Can not open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.dbprofile.
    Org.eclipse.datatools.connectivity.oda.OdaException;
    Java.lang.NoClassDefFoundError: org.eclipse.core.resources.ResourcesPlugin
At org.eclipse.birt.report.engine.executor.ExecutionContext.addException (ExecutionContext.java:1239)
..... "

I put the "jar" org.eclipse.birt.report.data.oda.jdbc.dbprofile, in various places and nothing ...
I changed the settings of my desktop variables by placing the "classpath" variable pointing to my birt_runtime.

Nothing to shoot ...

Can someone help us .. ??

Osvaldo Menezes

Hi Osvaldo,

what do you mean with "The problem is when I run EGL applications" ?

Do you run the application on the WAS 8.5 or in the RBD test environment?

Maybe you missed to add the support for BIRT reports to your project:

http://www.ibm.com/support/knowledgecenter/en/SSMQ79_9.5.1/com.ibm.egl.pg.doc/topics/pegl_brep_birt_support_tsk.html

1.

1. In the Project Explorer view, right-click your EGL project and then click Properties. The Properties window opens.
2. In the Properties window, click EGL Project Features.
3. Under EGL Project Features at the right side of the window, select the EGL with BIRT report support check box. If this check box is already selected, leave it selected.
4. Click OK.

2.

Setting the build descriptor option birtEngineHome

Before you can work with BIRT, you need to download BIRT runtime code and set the birtEngineHome build descriptor option, but only if you are working in a General project. Here are the steps:

Or maybe you are using the wrong birt version...

Note: EGL supports only the following versions of BIRT:

Table 1. EGL and BIRT version compatibility

EGL version	BIRT version
7.5	2.3.0
8.0	2.6.1

Kind Regards

Hello Marcel

Advance thank you for your commitment and return ..

Let the results ..
1) I was using the drive BIRT "birt-runtime-4_2_2-osgi"
With this version, I managed to at least progress in the execution .. See the attachments
In some explanations in the forum, this version was indicated so I used it.

2) Already in version "birt-runtime-2_3_0" I can not run the application. (see attached)

Something to add? Marcel. ???

Thank you

Osvaldo Menezes

Hi,

sorry but I don't know what's wrong. That's a litle bit strange at all.

I've tested it on my own. But I've got this error:

[09.01.17 10:19:01:445 CET] 000000a5 SystemOut O Can not load the report engine

How ever, we are using our own Java HTTP Servlet to create PDF and XLSX documents with birt.

Here is an example from Birt:

https://wiki.eclipse.org/Servlet_Example_(BIRT)_2.1

Kind Regards!

Hi Marcel..

I am analyzing your information .. even more you still have the same problems ..

I'll be posting the results ..

Thank you in advance for your commitment.

Thank you very much.

Osvaldo 

Our problem has been solved .. with Mark IBM support ..

In fact he discovered the problem that was in the lack of settings
Of the file "ServerProfiles.dat" created automatically by Birt when creating the dataSet of a ReportDesign. This file is located at:
<Your workspace> \. Metadata \ .plugins \ org.eclipse.datatools.connectivity \ ServerProfiles.dat.

But, in my view, it's a bug. This file should be created correctly and not altered as instructed.

Mark went further, it is raising the problem to see in the next releases if they resolve by definitive.

Attached here is how to change the settings for the "ServerProfiles.dat" file.

Available

Osvaldo Menezes