'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:163)
But the same module is successfully giving result in report design in Eclipse. I am using JDBC connection. How do I solve this?
Solution 1:[1]
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.
Solution 2:[2]
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.
Solution 3:[3]
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.
Solution 4:[4]
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.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Adam Morris |
| Solution 2 | Esteve |
| Solution 3 | ASIK RAJA A |
| Solution 4 | Droj |