Return
-
Title
Publish, View, There was an error publishing your object., Error. 1064., You have an error in your SQL syntax; -
Description
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 existsThere was an error publishing your object.: Error: Object reference not set to an instance of an object.and/orInformation tabLast refresh statusError. 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/orAlter Refresh snapshot - <name_snapshot>Database ErrorData Service Database ErrorYou 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. -
Resolution
WORKAROUND
None.
STATUS
Waiting for fix. -
Defect ID
TIC-6183