If Hyper-Q reports the error message
DTM8031: Object not found or no permission, the SQL statement references a non-existing or inaccessible object.
Hyper-Q responds with this error code when there is either:
- A missing object definition.
- The user attempting to access the object does not have sufficient privileges.
- The statement uses a fully qualified name, or the database context is properly set.
- The user attempting to access the object has sufficient security and access levels.
To do this:
- Use the SHOW TABLE, SHOW VIEW, SHOW MACRO, or SHOW PROCEDURE commands on the source Teradata system to determine the object definition.
- If the object definition on the source Teradata system differs from that of the destination data warehouse, create the definition using Hyper-Q as well as any dependent objects that may be needed.
- If the object exists and is accessible, provide the error information and the complete SQL statement to your Datometry Customer Success representative.
Article is closed for comments.