4

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?

sarnold
  • 102,305
  • 22
  • 181
  • 238
jijesh
  • 41
  • 1
  • 2
  • 2
    If you click on "XML Source" in eclipse, and search for id="163", is the element your database connection? Do you have any parameters for specifying your database? Did you upload your jdbc driver to the plugins/org.eclipse.birt.report.data.oda.jdbc/driver folder in the birt viewer? – Adam Morris Jul 14 '11 at 12:56
  • @ruffp: please also remove "thanks" and the like when editing. Thanks! – sarnold Mar 27 '12 at 23:17
  • I have flagged this question for closure. The OP has not has not returned to provide information required (see comment) to answer the question. – James Jenkins Jan 07 '15 at 12:38

4 Answers4

0

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.

Esteve
  • 1,789
  • 18
  • 23
0

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.

ASIK RAJA A
  • 431
  • 4
  • 10
0

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.

Droj
  • 3,541
  • 3
  • 26
  • 19
0

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.

Adam Morris
  • 8,265
  • 12
  • 45
  • 68