Regresar
-
Título
Publish, View, There was an error publishing your object., Error. 1064., You have an error in your SQL syntax; -
Descripción
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.
Debe iniciar sesión
Tiene que estar conectado y contar con un contrato de mantenimiento vigente para ver los artículos de conocimiento premium.