Cannot find the ODA dataSource extension

Hello, 
 
I use BIRT Report Engine API 2.6.2 within a portlet. It works fine with the customers.rptdesign you can find in the BIRT tutorials. But it doesn't work with reports that use our database (via HibernateDataSource). Within the Eclipse preview our report is correct. Within the portlet it shows this error below the report header: 
 
<blockquote class='ipsBlockquote' >
The following items have errors: 
 
Table (id = 33): 
+ An exception occurred during processing. Please see the following message for details: 
Cannot find or process the org.jboss.tools.birt.oda driver's data source extension configuration. 
Cannot find the ODA dataSource extension (org.jboss.tools.birt.oda). 
Check the workspace log file for any problems with loading the extension bundle and its dependencies.</blockquote>
 
This is the logfile of the workspace: 
<a class='bbc_url' href='http://pastebin.com/UMzWJN7i'>http://pastebin.com/UMzWJN7i</a> 
 
The main error seems to be: 
 
<blockquote class='ipsBlockquote' >Resource is out of sync with the file system</blockquote>
 
What can I do about this? 
 
Regards 
Kloss

Find more posts tagged with

Comments

JasonW

Kloss

Do you have the oda runtime plugin copied to the deployed engine plugins directory?

Jason

Kloss

Hi Jason, 
 
I did not copy anything seperately. 
I have the following oda.jars in the ReportEngine/plugins folder: 
 
org.eclipse.birt.report.data.oda.xml_2.6.2.r262_v20110127.jar 
org.eclipse.birt.report.data.oda.jdbc.dbprofile_2.6.2.r262_v20110127.jar 
org.eclipse.datatools.connectivity.oda.consumer_3.2.3.v201102051100.jar 
org.eclipse.datatools.connectivity.oda.design_3.3.2.v201012150951.jar 
org.eclipse.datatools.connectivity.oda.flatfile_3.1.1.v201101261130.jar 
org.eclipse.datatools.connectivity.oda.profile_3.2.4.v201007150318.jar 
org.eclipse.datatools.connectivity.oda_3.3.1.v201102051100.jar 
org.eclipse.datatools.enablement.oda.ws_1.2.2.v201010151422.jar 
org.eclipse.datatools.enablement.oda.xml_1.2.1.v201010211755.jar 
 
There is also a folder named org.eclipse.birt.report.data.oda.jdbc_2.6.2.r262_v20110127 
containing oda-jdbc.jar 
 
I googled after a download link for oda-plugin, but could not find one (just a site with two broken links). 
 
I set the engineHome of BIRT to the ReportEngine folder, so the plugins are not deployed. 
<pre class='_prettyXprint _lang-auto _linenums:0'>config.setEngineHome(configProps.getProperty("engineHome"));</pre>
 
Regards 
Kloss

JasonW

Open of the plugins folder of your designer and look for plugins with:
org.jboss.tools.birt.oda
Copy it to the plugins folder of the report engine.
if it has a .ui in the name do not copy it.

Jason

Kloss

Thank you very much for helping. 
I copied org.jboss.tools.birt.oda_1.2.0.v20110123-0110-H12-CR1.jar to the plugins folder. 
Sadly i still get the same error for my report and there are no log entries for the current session in the workspace. 
 
Edit: I also downloaded the newest JBoss tools version, copied org.jboss.tools.birt.oda_1.2.0.v20110215-1225-H29-GA.jar to the plugins folder instead of the other one. It is still the same result. 
 
All I can provide is the Birt log: <a class='bbc_url' href='http://pastebin.com/am0jELnH'>http://pastebin.com/am0jELnH</a> 
<blockquote class='ipsBlockquote' >27.05.2011 11:21:01 org.eclipse.birt.data.engine.odaconsumer doGetDriverManifest 
SCHWERWIEGEND: Cannot find or process the ODA data source extension configuration. 
java.lang.IllegalArgumentException: Cannot find the ODA dataSource extension (org.jboss.tools.birt.oda). 
Check the workspace log file for any problems with loading the extension bundle and its dependencies. 
at org.eclipse.datatools.connectivity.oda.util.manifest.ManifestExplorer.getExtensionManifest(ManifestExplorer.java:200) 
at org.eclipse.birt.data.engine.odaconsumer.Driver.doGetDriverManifest(Driver.java:150)</blockquote>
But I guess this doesn't give any new information.

JasonW

Can you post the plugin jar file and the report design?

Jason

Kloss

Yes, of course. Thanks for your help.

JasonW

It all looks good. I am not certain what is happening. Can you try also adding the org.jboss.tools.birt.core plugin to the runtime? Also in your configuration directory clear everything but the config.ini in your runtime. You may need to setup a simple java project for a a command line to see if we can get the runtime to work and move to your webapp.

Jason

Kloss

<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="77847" data-time="1306945850" data-date="01 June 2011 - 09:30 AM">
Can you try also adding the org.jboss.tools.birt.core plugin to the runtime? Also in your configuration directory clear everything but the config.ini in your runtime.</blockquote>
I did that with the current project, it doesn't make a difference. 
 
Ok, I create a simple java project then.

Kloss

Here is my simple project. I let it print out the HTML of the report and it has the same error as the original project. I use HSQLDB this time.
I have never set up such a project before. Maybe I did something wrong with configuration in both projects which causes the error. I do some more tests with it.

JasonW

If you can get a report to run with your project that should be fine. I normally just create a java project add all the ReportEngine/lib jars to the build path and set the birt home to ReportEngine and then use a simple class like:

package REAPI;

import java.util.logging.Level;

import org.eclipse.birt.core.framework.Platform;
import org.eclipse.birt.report.engine.api.EXCELRenderOption;
import org.eclipse.birt.report.engine.api.EngineConfig;
import org.eclipse.birt.report.engine.api.EngineConstants;
import org.eclipse.birt.report.engine.api.EngineException;
import org.eclipse.birt.report.engine.api.HTMLRenderOption;
import org.eclipse.birt.report.engine.api.IReportEngine;
import org.eclipse.birt.report.engine.api.IReportEngineFactory;
import org.eclipse.birt.report.engine.api.IReportRunnable;
import org.eclipse.birt.report.engine.api.IRunAndRenderTask;
import org.eclipse.birt.report.engine.api.PDFRenderOption;

public class RunAndRenderTask {

public void runReport() throws EngineException
{

IRunAndRenderTask task=null;
IReportEngine engine=null;
EngineConfig config = null;

try{
//System.setProperty("java.io.tmpdir", "c:/temp/test/testsampledb");
config = new EngineConfig( );
config.setLogConfig("c:/dwn", Level.INFO);
config.getAppContext().put(EngineConstants.APPCONTEXT_CLASSLOADER_KEY, this.getClass().getClassLoader());

config.setBIRTHome("C:\\birt\\birt-runtime-2_6_2\\birt-runtime-2_6_2\\ReportEngine");

config.setLogConfig(null, Level.INFO);
Platform.startup( config );

IReportEngineFactory factory = (IReportEngineFactory) Platform
.createFactoryObject( IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY );
engine = factory.createReportEngine( config );

IReportRunnable design = null;
//Open the report design

design = engine.openReportDesign("Reports/dataseteventhandler.rptdesign");
task = engine.createRunAndRenderTask(design);
//task.setParameterValue("Top Count", (new Integer(5)));
task.validateParameters();

HTMLRenderOption options = new HTMLRenderOption();
options.setImageDirectory("./");
options.setOutputFileName("output/resample/eventhandlerjar.html");
options.setOutputFormat("html");

//PDFRenderOption options = new PDFRenderOption();
//options.setOutputFileName("output/resample/topn.pdf");
//options.setSupportedImageFormats("PNG;GIF;JPG;BMP;SWF;SVG");
//options.setOutputFormat("pdf");

//EXCELRenderOption options = new EXCELRenderOption();
//options.setOutputFormat("xls");
//options.setOutputFileName("output/resample/customers.xls");
//options.setWrappingText(true);

task.setRenderOption(options);
task.run();
task.close();
engine.destroy();
}catch( Exception ex){
ex.printStackTrace();
}
finally
{
if ( !task.getErrors( ).isEmpty( ) )

{

for ( Object e : task.getErrors( ) )

{

( (Exception) e ).printStackTrace( );

}

}
Platform.shutdown( );
System.out.println("Finished");
}

}

/**
* @param args
*/
public static void main(String[] args) {
try
{

RunAndRenderTask ex = new RunAndRenderTask( );
ex.runReport();
System.exit(0);

}
catch ( Exception e )
{
e.printStackTrace();
}
}
}

Are you still getting resource out of sync errors or just the oda error? Look at you birt home and you should have a plugins directory and a configuration directory. Look in the configuration directory. Do you have any logs in it? If so please post. If not clear the configuration directory of everything but the config.ini and then retry.

Jason

Kloss

<blockquote class='ipsBlockquote' >Are you still getting resource out of sync errors or just the oda error?</blockquote>
Just the oda error. 
 
<blockquote class='ipsBlockquote' >Look at you birt home and you should have a plugins directory and a configuration directory. Look in the configuration directory. Do you have any logs in it? If so please post. If not clear the configuration directory of everything but the config.ini and then retry.</blockquote>
There are still no logs in it. 
There is also no log file in the workspace. 
 
Regards 
 
Kloss 
 
 
Edit: I made a test and copied everything from eclipse plugins folder to the BIRT plugins folder. Afterwards a different error occured: 
<blockquote class='ipsBlockquote' >06.06.2011 14:44:29 org.eclipse.birt.report.engine.api.impl.RunAndRenderTask doRun 
SCHWERWIEGEND: An error happened while running the report. Cause: 
java.lang.NullPointerException 
at org.jboss.tools.birt.oda.impl.ConsoleConfigurationOdaFactory.getSessionFactory(ConsoleConfigurationOdaFactory.java:54) 
at org.jboss.tools.birt.oda.impl.ConsoleConfigurationOdaFactory.<init>(ConsoleConfigurationOdaFactory.java:34) 
at org.jboss.tools.birt.oda.impl.HibernateConnection.open(HibernateConnection.java:47) 
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250) 
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165) 
at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224) 
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212) 
at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:208) 
at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:406) 
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:316) 
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455) </blockquote>
That seems like the oda driver could be found in this case. I just don't know which of the copied files is responsible for this and why this new error is thrown. 
 
This is the code in the oda driver that causes the NullPointerException (last line): 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>public SessionFactory getSessionFactory(Properties properties) throws OdaException {
String configurationName = properties.getProperty(CONFIGURATION);
ConsoleConfiguration[] configurations = KnownConfigurations.getInstance().getConfigurations();
for (int i = 0; i < configurations.length; i++) {
if (configurations[i].getName().equals(configurationName)) {
consoleConfiguration=configurations[i];
break;
}
}
if (!isOpen()) {
try {
sessionFactory = consoleConfiguration.getSessionFactory();</pre>
 
Regards 
Kloss

JasonW

Kloss,

Which line in line number 54? BTW have you posted this on the JBoss forums as well?

Jason

Kloss

<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="78013" data-time="1307368836" data-date="06 June 2011 - 07:00 AM">
Which line in line number 54? </blockquote>
The last line of the code I gave is line 54: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>sessionFactory = consoleConfiguration.getSessionFactory();</pre>
 
<blockquote class='ipsBlockquote' >BTW have you posted this on the JBoss forums as well?</blockquote>
No. Shall I?

JasonW

It looks to me that maybe the hibernate jars are not in your classpath. In the viewer they should be in the WEB-INF/lib directory I believe. You may want to post on the Jboss forums or try using there deployment method and look at what is put in the WEB-INF/lib and the plugins folder of the web app.
http://docs.jboss.org/tools/3.1.0.M2/en/jboss_birt_plugin_ref_guide/html_single/index.html

Jason

Kloss

Ok, thank you. I found this http://www.eclipse.org/forums/index.php?t=tree&th=154708&#page_top and did everything listed, but the NullPointerException is still there.
I ask for this in the JBoss community.

JasonW

If this is the error you are getting, this does look like the Hibernate jars are not found. Do you know what jar this org.hibernate.Session class is in?

Where do you have this jar in your runtime?

Jason

Kloss

<blockquote class='ipsBlockquote' >Do you know what jar this org.hibernate.Session class is in?</blockquote>
It is in the hibernate-3.2.6.ga.jar 
 
<blockquote class='ipsBlockquote' >Where do you have this jar in your runtime?</blockquote>
In the lib folder where maven puts the jars in.

JasonW

Is this in the web-inf/lib directory of the viewer?

Jason

Kloss

I don't use the viewer. I made my own tag to show the produced html in the portlet.

At the moment I use the scripted datasource as interim solution. That works fine, but is more extensive than necessary.

mbaxley

I was having a similar issue, when using the Hibernate Datasource, receiving an exception like: 
The following items have errors: 
 
Table (id = 9): 
+ An exception occurred during processing. Please see the following message for details: 
Cannot find or process the org.jboss.tools.birt.oda driver's data source extension configuration. 
Cannot find the ODA dataSource extension (org.jboss.tools.birt.oda). 
Check the workspace log file for any problems with loading the extension bundle and its dependencies. 
 
I received some help over at community.jboss.org to resolve this: 
<a class='bbc_url' href='http://community.jboss.org/message/610705'>BIRT Integration-Cannot find the ODA dataSource extension (org.jboss.tools.birt.oda)</a>

bmario

Hello there;

I'm a newbie in this whole BIRT world and I'm also having trouble with the ODA datasource. Initially eclipse didn't show me the Hibernate Datasource, but after following the instructions given by Snjezana Peco in this thread http://209.132.182.49/thread/168170?tstart=0#620187 I was able to choose that option, however I cant configure anything of it. If I choose the hibernate datasource then the only thing I can do is click "finish" instead of next and when I try to edit the created data source it shows an empty window with no configuration form at all. The only thing I wasn't able to do was to delete all the files in the "WEB-INF/platform/configuration" but the config.ini because I could't find that folder, nor in the oda's .jar nor in my eclipse's plugin folder.

Like I said, I'm a newbie using BIRT so I'm still not too familiar with the configuration folders and urls, so any help will be really appreciated.