SQL runs in SQL editor and gets results back in around a minute. Attempting to publish the same SQL to TIC generates different errors regarding syntax, objects, etc.
In Toad 3.8, can publish the file as a dataset, or as a snapshot without a schedule.
Trying a view, try adding a schedule to a snapshot), or try a refresh dataset step in Automation returns an error about using ‘(PARTITION BY’.
Upgrading to 4.0 returns different results. Publishes the data as a snapshot (with schedule) once, but attempting to force refresh throws error.
Other times, fails to publish and returning an error referring to an object,
There was an error publishing your object.:
Error:The name <name_of_object> already exists
There was an error publishing your object.: Error: Object reference not set to an instance of an object.
and/or
Information tab
Last refresh status
Error. 1064. You have an error in your SQL syntax; check the manual that corresponds to your mySQL server version for the right syntax to use near ‘(PARTITION BY <user>)
and/or
Alter Refresh snapshot - <name_snapshot>
Database Error
Data Service Database Error
You have an error in your SQL syntax; check the manual that corresponds to your Data Service server version for the right syntax to use near ‘(PARTITION BY <user>) AS COUNT_OF_DOCS_PER_USER’ at line xxx.
