https://community.qlik.com/t5/Official-Support-Articles/Incorrect-syntax-near-keyword-lt-fieldname-gt-when-loading-data/ta-p/1715735 <P>Loading data from Microsoft SQL Server or Azure SQL databases to Qlik Sense fails at one or more specific fields. Upon excluding these fields, the reload works normally.&nbsp;<BR /><BR />Error message shown in the data load progress dialogue and document log is &nbsp;<I><SPAN style="font-family: courier new,courier,monospace;">Incorrect syntax near keyword &lt;fieldname&gt; </SPAN></I>or&nbsp;<SPAN style="font-family: courier new,courier,monospace;"><I>Connector reply error ***</I></SPAN>, although Qlik Sense script editor does not prompt for any syntax error.<BR /><BR />The issue is only observed when a number of specific words, such as "Function" or "References", are used as field names in the database.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="data load progress.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/55083iC0F718F37BBB4888/image-size/large?v=v2&amp;px=999" role="button" title="data load progress.png" alt="data load progress.png" /></span></P> <P> </P> <P>&nbsp;</P> <P class="qlik-migrated-tkb-headings">Resolution:</P> <P>Tables/ columns named with reserved keywords should be quoted with double quotes or square brackets in order for the containing SQL query to work.</P> <P>&nbsp;</P> <P class="qlik-migrated-tkb-headings">Cause:</P> <P>Words like "Function", "References" are reserved keywords for Microsoft SQL Server or Azure SQL databases, which cannot be used directly as object names in SQL queries.<BR />A complete list of reserved keywords for&nbsp;for Microsoft SQL Server or Azure SQL can be found at&nbsp;<A href="https://msdn.microsoft.com/en-us/library/ms189822.aspx" target="_blank" rel="noopener">https://msdn.microsoft.com/en-us/library/ms189822.aspx</A></P> Mon, 17 May 2021 07:23:42 GMT Sonja_Bauernfeind 2021-05-17T07:23:42Z https://community.qlik.com/t5/Official-Support-Articles/Incorrect-syntax-near-keyword-lt-fieldname-gt-when-loading-data/ta-p/1715735 <P>Loading data from Microsoft SQL Server or Azure SQL databases to Qlik Sense fails at one or more specific fields. Upon excluding these fields, the reload works normally.&nbsp;<BR /><BR />Error message shown in the data load progress dialogue and document log is &nbsp;<I><SPAN style="font-family: courier new,courier,monospace;">Incorrect syntax near keyword &lt;fieldname&gt; </SPAN></I>or&nbsp;<SPAN style="font-family: courier new,courier,monospace;"><I>Connector reply error ***</I></SPAN>, although Qlik Sense script editor does not prompt for any syntax error.<BR /><BR />The issue is only observed when a number of specific words, such as "Function" or "References", are used as field names in the database.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="data load progress.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/55083iC0F718F37BBB4888/image-size/large?v=v2&amp;px=999" role="button" title="data load progress.png" alt="data load progress.png" /></span></P> <P> </P> <P>&nbsp;</P> <P class="qlik-migrated-tkb-headings">Resolution:</P> <P>Tables/ columns named with reserved keywords should be quoted with double quotes or square brackets in order for the containing SQL query to work.</P> <P>&nbsp;</P> <P class="qlik-migrated-tkb-headings">Cause:</P> <P>Words like "Function", "References" are reserved keywords for Microsoft SQL Server or Azure SQL databases, which cannot be used directly as object names in SQL queries.<BR />A complete list of reserved keywords for&nbsp;for Microsoft SQL Server or Azure SQL can be found at&nbsp;<A href="https://msdn.microsoft.com/en-us/library/ms189822.aspx" target="_blank" rel="noopener">https://msdn.microsoft.com/en-us/library/ms189822.aspx</A></P> Mon, 17 May 2021 07:23:42 GMT https://community.qlik.com/t5/Official-Support-Articles/Incorrect-syntax-near-keyword-lt-fieldname-gt-when-loading-data/ta-p/1715735 Sonja_Bauernfeind 2021-05-17T07:23:42Z