Created On:  18 November 2010

Problem:

When running an SQL in BIRT, why do I receive the following error?



Note: The SQL can run fine when being run in SilkCentral Test Manager and in Oracle.

Resolution:

This error can occur in your BIRT DataSet if you do not include the instance name when referencing your tables in your SQL query.

For example, 

SELECT *

FROM instance.tablename

See example below from a BIRT DataSet:

Incident #2477320