TEIID30020 Processing exception 'Element "foo.bar" is not defined by any relevant group.

This is an error which occurs if the given object cannot be found. Typical causes and Solutions are:

  • Syntax error → correct the typo.
  • The object was only temporary, like temporary tables → Use the query in combination with a persistent table or check if you actually want to refer to the table “foo.bar” or maybe another one.
  • The object refers to a table which Data Virtuality shows as belonging to a data source → perform a metadata refresh of the data source to check if the object was removed or renamed at the other end Point.
  • The object refers to an element created by yourself and you are sure that there are no typos → Check the table SYSADMIN.ViewDefinitions, SYSADMIN.ProcDefinitions and SYS.Tables for any errors explaining why the object’s definition exists but it is not available.
1 Like