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.
Please sign in to leave a comment.