Birt viewer cannot load the report query

When I am trying to run my BIRT viewer, the following error is displayed:

Can not load the report query: 163. Errors occurred when generating the report document for the report element with ID 163. (Element ID开发者_如何学C:163)

But the same module is successfully giving result in report design in Eclipse. I am using JDBC connection. How do I solve this?

Verify that your jdbc driver to the plugins/org.eclipse.birt.report.data.oda.jdbc/driver folder. That's usually what causes this.

It could also be a parameter that not getting set when you load the report.

I had the same error message and my problem was in the query:

My Scripted DataSet was returning a String value mapped to a Integer column.

If you want to log the SQL query text, set logging on the org.eclipse.birt.report.data.oda.jdbc.Statement , which is responsible for preparing the SQL queries.

In my case, the datasource for BIRT was not configured correctly. I needed to make sure the JNDI name matched what was in the config for my container.