Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1762

Exception when using Teiid with BIRT Report Designer

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • 7.5
    • None
    • None

      Hi,

      I've been trying to use the Birt report Designer tool in eclipse to talk to teiid in order to look at designing some reports on top of it.

      I can add the datasource fine but when I go to create a data set, I notice the following error getting spammed to the eclipse log

      Sep 26, 2011 12:00:39 PM org.eclipse.birt.report.data.oda.jdbc.ui.model.SchemaNode refetchChildren
      WARNING: Column name "TABLE_NAME" does not exist.
      org.teiid.jdbc.TeiidSQLException: Column name "TABLE_NAME" does not exist.
      	at org.teiid.jdbc.ResultSetImpl.findColumnIndex(ResultSetImpl.java:1227)
      	at org.teiid.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1214)
      	at org.teiid.jdbc.ResultSetImpl.getString(ResultSetImpl.java:826)
      	at org.eclipse.birt.report.data.oda.jdbc.ui.model.SchemaNode.refetchChildren(SchemaNode.java:71)
      	at org.eclipse.birt.report.data.oda.jdbc.ui.model.RootNode.refetchChildren(RootNode.java:106)
      	at org.eclipse.birt.report.data.oda.jdbc.ui.model.ChildrenAllowedNode$1TempThread.run(ChildrenAllowedNode.java:35)
      Sep 26, 2011 12:00:54 PM org.eclipse.birt.report.data.oda.jdbc.ui.model.SchemaNode refetchChildren
      WARNING: Column name "TABLE_NAME" does not exist.
      org.teiid.jdbc.TeiidSQLException: Column name "TABLE_NAME" does not exist.
      	at org.teiid.jdbc.ResultSetImpl.findColumnIndex(ResultSetImpl.java:1227)
      	at org.teiid.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1214)
      	at org.teiid.jdbc.ResultSetImpl.getString(ResultSetImpl.java:826)
      	at org.eclipse.birt.report.data.oda.jdbc.ui.model.SchemaNode.refetchChildren(SchemaNode.java:71)
      	at org.eclipse.birt.report.data.oda.jdbc.ui.model.RootNode.refetchChildren(RootNode.java:106)
      	at org.eclipse.birt.report.data.oda.jdbc.ui.model.ChildrenAllowedNode$1TempThread.run(ChildrenAllowedNode.java:35)
      

      We have also noticed the problem when using other reporting engines like http://datavision.sourceforge.net/ which throw the same error.

      Is it possible to have the column added to whatever table is needed (I assume the SYS model) in order for these errors to not occur?

      Thanks,

      Graeem

              rhn-engineering-shawkins Steven Hawkins
              graeme.gillies Graeme Gillies (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: