iHub Report runtime error.

Hi,
 
I recently created a report that queries the results from an ODA data set (connecting to a MySQL data source) to do some pre-processing in the beforeFactory phase. Using the results, I create a new dataset at run-time use it to create a Table on the report at runtime.
 
I was able to *successfully* run the report and get results on my BIRT Designer PRO, although, when I try to publish the report on iHub and run it, I get an error :
 
Caused by: java.lang.NoClassDefFoundError: org/eclipse/birt/data/engine/impl/IQueryContextVisitor
 at java.lang.Class.getDeclaredMethods0(Native Method)
 at java.lang.Class.privateGetDeclaredMethods(Class.java:2531)
 at java.lang.Class.privateGetPublicMethods(Class.java:2651)
 at java.lang.Class.privateGetPublicMethods(Class.java:2667)
 at java.lang.Class.privateGetPublicMethods(Class.java:2667)
 at java.lang.Class.getMethods(Class.java:1467)
 at org.mozilla.javascript.JavaMembers.discoverAccessibleMethods(JavaMembers.java:380)
 at org.mozilla.javascript.JavaMembers.discoverAccessibleMethods(JavaMembers.java:335)
 at org.mozilla.javascript.JavaMembers.reflect(JavaMembers.java:450)
 at org.mozilla.javascript.JavaMembers.<init>(JavaMembers.java:76)
 at org.mozilla.javascript.JavaMembers.lookupClass(JavaMembers.java:838)
 at org.mozilla.javascript.NativeJavaObject.initMembers(NativeJavaObject.java:90)
 at org.mozilla.javascript.NativeJavaObject.<init>(NativeJavaObject.java:80)
 at org.mozilla.javascript.NativeJavaObject.<init>(NativeJavaObject.java:70)
 at org.mozilla.javascript.WrapFactory.wrapAsJavaObject(WrapFactory.java:149)
 at org.mozilla.javascript.WrapFactory.wrap(WrapFactory.java:105)
 at org.eclipse.birt.report.engine.javascript.JavascriptEngine$2.wrap(JavascriptEngine.java:160)
 at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:258)
 at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66)
 at org.mozilla.javascript.gen.c76096._c2(/report/method[@name="beforeFactory"]:158)
 at org.mozilla.javascript.gen.c76096.call(/report/method[@name="beforeFactory"])
 at org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97)
 at org.mozilla.javascript.gen.c76096._c0(/report/method[@name="beforeFactory"]:2)
 at org.mozilla.javascript.gen.c76096.call(/report/method[@name="beforeFactory"])
 at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:398)
 at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3065)
 at org.mozilla.javascript.gen.c76096.call(/report/method[@name="beforeFactory"])
 at org.mozilla.javascript.gen.c76096.exec(/report/method[@name="beforeFactory"])
 at org.eclipse.birt.report.engine.javascript.JavascriptEngine.evaluate(JavascriptEngine.java:290)
 ... 15 more
Caused by: java.lang.ClassNotFoundException: org.eclipse.birt.data.engine.impl.IQueryContextVisitor
 at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
 at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
 at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
 at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
 at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
 ... 44 more
 
I presume that this class (IQueryContextVisitor) is available within the following jar with the iHub install, and it is getting included at runtime:
./jar/BIRT/platform/plugins/org.eclipse.birt.data_4.2.3.v20131216-0430.jar
 
Can you tell me if Iâ€™m missing any required reference on the report design? If not, how would I go about debugging this issue?

Find more posts tagged with

Comments

micajblock

What does your code look like?

tejusdas

Thanks for the response, Mica. This is what the code in the beforeFactory() method looks like:
<pre class="_prettyXprint _lang-js">
if(!reportContext.getDesignHandle().findElement("MyReportTable")){ //If table doesn't already exist

var reportDesignHandle = reportContext.getDesignHandle(); //ReportDesignHandle
var elementFactory = reportDesignHandle.getElementFactory(); //ElementFactory

var odaDataSet = elementFactory.newOdaDataSet("DataSet", "org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" ); //OdaDataSetHandle
odaDataSet.setDataSource("Data Source"); //Existing mysql Data source
odaDataSet.setQueryText("select * from MySchema.MyTable"); //Specifies the static query text
reportDesignHandle.getDataSets( ).add( odaDataSet ); //SlotHandle - Add report item to the slot with the given element handle

QueryDataSet("DataSet"); //Call fuction with API code to query new data set. //See ResultLogic funciton for table build.
}

function ResultLogic(ri) {

importPackage(Packages.org.eclipse.birt.report.model.api); //Tool-writer's interface for the BIRT design model (also known as the "Design Engine.")
importPackage(Packages.org.eclipse.birt.report.model.api.elements);
importPackage(Packages.org.eclipse.birt.report.model.elements.interfaces);

//Create report table
rptTable = elementFactory.newTableItem("MyReportTable", 0, 1, 1, 0); //TableHandle - (java.lang.String name, int columnNum, int headerRow, int detailRow, int footerRow)
rptTable.setProperty(IReportItemModel.DATA_SET_PROP, "DataSet"); //Bind data set to table
rptTable.setProperty(IStyleModel.TEXT_ALIGN_PROP,DesignChoiceConstants.TEXT_ALIGN_CENTER); //Set to center align
rptTable.setWidth("100%"); //Set table width
reportContext.getReportRunnable().designHandle.getBody().add(rptTable); //Add table element to report body

//reportContext.getReportRunnable().designHandle.getStyles().add("HideStyle");
//var ssh = elementFactory.newStyle("HideStyle");
//ssh.setDisplay("none");

rptTable.setThemeName("ThemesReportItems3.Modern Table"); //Set table theme

var rsmd = ri.getResultMetaData(); //IResultMetaData - IBaseResultIterator (Get metadata handle)
var cc = rsmd.getColumnCount(); //int - IBaseResultMetaData (Get column count)

//Get all column header names and create table column bindings
for (var i=1;i<=cc;i++){ //Loop through each column in the row. *Note: i starts with 1 for getColumnName looping
var currentColumnName = rsmd.getColumnLabel(i); //Get current column name

//Create table column bindings
var col = StructureFactory.createComputedColumn(); //Create an empty computed column structure
col.setName(currentColumnName); //Set the column name
col.setExpression("dataSetRow[\"" + currentColumnName + "\"]"); //Set the expression

rptTable.getColumnBindings().addItem(col); //Add column binding to table
rptTable.insertColumn(i, 1); //Add new column to table at pos i, 1=after column i (-1=before col i)

//Set Header Row
var label = elementFactory.newLabel(null); //Create new label
label.setText(currentColumnName); //Set label text with column name
var tcell = rptTable.getHeader().get(0).getCells().get(i-1); //Get table cell (-1 to accomidate for getColumName loop)
tcell.getContent().add(label); //Add label to tabel cell

//Set Detail Row
var data = elementFactory.newDataItem(null); //Create new data item
data.setResultSetColumn(currentColumnName); //Set value
var tcell = rptTable.getDetail().get(0).getCells().get(i-1); //Get table cell (-1 to accomidate for getColumName loop)
tcell.getContent().add(data); //Add data item to table cell
}
}

function QueryDataSet(dataSetName) {

//Gather Data Source Info
var dataSourceName = reportContext.getDesignHandle().findDataSet(dataSetName).getDataSourceName(); //String - DataSetHandle (Get DataSource Name for dataSetName)

//Import Classes
importClass(org.eclipse.birt.data.engine.api.querydefn.QueryDefinition); //Default implementation of the IQueryDefinition interface.
importClass(org.eclipse.birt.report.data.adapter.api.DataRequestSession); //Main entry point to Data Engine functionalities.
importClass(org.eclipse.birt.report.data.adapter.api.DataSessionContext); //Context information used to initialize a DataRequestSession.

//Prepare preQuery
var engineConfig = reportContext.getReportRunnable().getReportEngine().getConfig(); //EngineConfig - IReportEngine (Get report engine configurations)
var dataSourceHandle = reportContext.getDesignHandle().findDataSource(dataSourceName); //DataSourceHandle - ModuleHandleImpl (Get DataSource handle)
var dataSetHandle = reportContext.getDesignHandle().findDataSet(dataSetName); //DataSetHandle - ModuleHandleImpl (Get DataSet handle)

var iScriptContext = _jsContext.getScriptContext(); //IScriptContext - ScriptContext (org.eclipse.birt.core.script.ScriptContext)
var dataSessionContext = new DataSessionContext(DataSessionContext.MODE_DIRECT_PRESENTATION, reportContext.getDesignHandle(), iScriptContext, null); //Creates a DataEngine context in the provided mode, using the provided top level scope. Also sets the handle of the report design being executed. (int mode, ModuleHandle moduleHandle, ScriptContext scriptContext, ClassLoader classLoader)
var dataRequestSession = DataRequestSession.newSession(engineConfig, dataSessionContext); //DataRequestSession - DataRequestSession (PlatformConfig, DataSessionContext)

var DataModelAdapter = dataRequestSession.getModelAdaptor(); //IModelAdapter - DataRequestSession (Get DataModelAdapter)
var odaDataSourceAdapter = DataModelAdapter.adaptDataSource(dataSourceHandle); //BaseDataSourceDesign - IModelAdapter (Get OdaDataSourceAdapter)
var odaDataSetAdapter = DataModelAdapter.adaptDataSet(dataSetHandle); //BaseDataSetDesign - IModelAdapter (Get OdaDataSetAdapter)

odaDataSetAdapter.setDataSource(dataSourceName); //void - BaseDataSetDesign
dataRequestSession.defineDataSource( odaDataSourceAdapter ); //void - DataRequestSession
dataRequestSession.defineDataSet( odaDataSetAdapter ); //void - DataRequestSession

//Is this an iHub3 engine
try {iQueryDefinition = new QueryDefinition(true);} //iHub3 compatable (autoBinding)
catch(err) {
java.util.logging.Logger.getLogger("birt.report.logger").warning ("Not iHub3? (See error below)\n" + err + "\nTrying another way..."); //(OFF, SEVERE, WARNING, INFO, CONFIG, FINE, FINER, FINEST and ALL)
iQueryDefinition = new QueryDefinition( ); //Pre iHub3 compatable
iQueryDefinition.setAutoBinding(true); //void - QueryDefinition (Set autoBinding)
}
iQueryDefinition.setDataSetName( odaDataSetAdapter.getName() ); //Set the dataSetName Name of data set used by this query.

//Run Query
var iPreparedQuery = dataRequestSession.prepare( iQueryDefinition ); //IPreparedQuery - DataRequestSession
var iQueryResults = iPreparedQuery.execute( null ); //IQueryResults - IPreparedQuery
var iResultIterator = iQueryResults.getResultIterator( ); //IResultIterator - IQueryResults

ResultLogic(iResultIterator); //Pass iResultIterator to ResultLogic function for custom user logic.

//Close up
iResultIterator.close( ); //void - IBaseResultIterator
iQueryResults.close( ); //void - IBaseQueryResults
dataRequestSession.shutdown( ); //void - DataRequestSession
}
</pre>

micajblock

Sorry, not sure. I would suggest you open a case with support.

tejusdas

Thanks Mica. I have an open ticket with support as well. I was just curious to see if someone else has seen this issue before.