Publishing, There was an error publishing your object. Please ensure that all objects are fully qualified.
説明
Snapshot Error: There was an error publishing your object. Please ensure that all objects are fully qualified. Ensure the connection uses an IP address or host name and not 'localhost.': Error: execute command denied to user '<username>'@'%' for routine 'hub_information_schema.trunc' (Remembered answer: "OK". Enable)
View Error: There was an error publishing your object. Please ensure that all objects are fully qualified. Also ensure the connection uses an IP address or host name and not 'localhost.': Error: ERROR: line 1, column 25, ending line 1, column 25: Found '-': Expecting: end-of-input -or- ; -or- EXCEPT INTERSECT MINUS UNION -or- CLUSTER DISTRIBUTE FOR GROUP HAVING INTO LIMIT LOCK OFFSET ORDER PROCEDURE SORT UPDATE -or- WITH -or- WHERE -or- , CROSS FULL INNER JOIN LEFT NATURAL RIGHT STRAIGHT_JOIN -or- FORCE IGNORE USE -or- = AS identifier LATERAL TABLESAMPLE -or- . (Remembered answer: "OK". Enable)
Unable to resolve error when Publishing query to TIC as snapshot/view Getting two different errors when trying to publish the same code. One error is given when trying to publish as a View. The other error is given when trying to publish as a Snapshot.
対策
WORKAROUND:
None
STATUS:
Waiting for fix in a future version of Toad Data Point.
