Qlik GeoAnalytics Plus ESRI Layer Showing Sporadic Syntax Error with Qlik Sense Tasks
Article Number: 000048513 | Last Modified: 2018/11/21
Qlik GeoAnalytics Version number: November 2017
Qlik Sense Version number: September 2017 11.14.3
When loading an ESRI Layer using GeoAnalytics Plus with Qlik Sense it will successfully connect, however, sporadically fail with a QVX_SYNTAX_ERROR.
Adjusting the parameters in the GeoAnalytics Plus Wizard including adding a Key Field and changing the Expected Geometry Type did not solve the issue.
An example of the Error Message seen in the logs is:
"QVX_SYNTAX_ERROR: *The column ObjectID is not available in the requested result"
The error occurs when the layer being updated has no data. Setting the errormode=0 will ignore if the layer is empty.
Set errormode=0 in Qlik so when this layer is either empty or being updated it will just be ignored.
More information about the ErrorMode can be found in the following Help Section of the Qlik Site.https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/ErrorVariables/ErrorMode.htm