Error while running report created using custom oda-data-soursc

Rubbish

org.eclipse.birt.data.engine.core.DataException: Column binding "Scenario" has referred to a data set column "Scenario" which does not exist.
 at org.eclipse.birt.data.engine.impl.ResultIterator.validateManualBindingExpressions(ResultIterator.java:311)
 at org.eclipse.birt.data.engine.impl.ResultIterator.<init>(ResultIterator.java:148)
 at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:176)
 at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:92)
 at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:129)
 at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
 at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1755)
 at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77)


i know this message is posted several times and the general solution is to see the column bindings of table used in report.
i can see the binding is fine for the table and i have recreated the report several time dropping the dataset.

i am debugging my custom oda plugin and can see the that the metadata has the required information as well as resultset also have values in it.


Is there something i am missing while saving the datasetdesign for my custom oda-data-source as i have followed the instruction from extending the birt oda-extension guide.

please help me i am in deliema and will appriciate any help from heart....

Rubbish

Hi everyone,

I am very happy to inform that i have resolved the issue by my own.

After spending few more hours on the issue. i found the silly mistake i was doing.
i was creating resultset metadata after executeQuery method in my implementation of IQuery for custom-oda-datsource extension but we need to create the metadata before query execution.

i did the same bu making some changes in my code and it worked... Hurry i can connect to OLAP in birt and can render reports....

Thanks everyone for your help .