Skip to main content
  • EN

Hello,

I have a SQLExecutor connecting to my SDE on a SQL database. I am using the Microsoft SQL Server Non-Spatial Format with an embedded Connection.

My SQL Statement is:

FME_SQL_DELIMITER ;

 

GO

 

DISABLE TRIGGER gisowner.SEGME_MSLINK_COUNTER ON gisowner.ra10];

 

GO

I get the following errors:

Query failed, possibly due to a malformed statement.

Provider error `(-2147217900) Incorrect syntax near the keyword 'TRIGGER'.'

A fatal error has occurred. Check the logfile above for details

Failed to read features from dataset 'AHS_GIS' using the 'MSSQL_ADO' reader

Hello @juliarozema

The cause of the error is the GO statement. The GO is not a true T-SQL statement, but is used with SQLcmd or OSQL utilities(such as SQL Server Management Studio). More information can be found here: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/sql-server-utilities-statements-go?view=sql-server-2017

 

 

As such if you alter your statement to the following:

 

 

FME_SQL_DELIMITER ; DISABLE TRIGGER gisowner.SEGME_MSLINK_COUNTER ON gisowner.a10;

 I tried the above with my own syntax and it worked correctly. I hope that helps!

Hello @juliarozema

The cause of the error is the GO statement. The GO is not a true T-SQL statement, but is used with SQLcmd or OSQL utilities(such as SQL Server Management Studio). More information can be found here: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/sql-server-utilities-statements-go?view=sql-server-2017

 

 

As such if you alter your statement to the following:

 

 

FME_SQL_DELIMITER ; DISABLE TRIGGER gisowner.SEGME_MSLINK_COUNTER ON gisowner.a10;

 I tried the above with my own syntax and it worked correctly. I hope that helps!

Thank you so much!!

 

 

Were you able to replace "GO" with something else to make this statement run?

Reply


Community Stats

30,607
Posts
115,974
Replies
38,245
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.