Getting error "Incorrect syntax near keyword <fieldname>" when loading data from MS SQL Server/ Azure SQL databaseArticle Number: 000031563 | Last Modified: 2019/01/17
Error message shown in the data load progress dialog and document log is "Incorrect syntax near keyword <fieldname>" (sometime just "Connector reply error *** " without any further details), although Qlik Sense script editor does not prompt for any syntax error.
The issue is only observed when a number of specific words, such as "Function" or "References", are used as field names in the database.
A complete list of reserved keywords for for Microsoft SQL Server or Azure SQL can be found at https://msdn.microsoft.com/en-us/library/ms189822.aspx
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.