Discussion Board for collaboration regarding Qlik GeoAnalytics.
I have a Qlik Sense App that uses Qlik GeoAnalytics Connector to plot utility consumption by location (uses Lat/Long).
It has been working fine until now and now the reload task is giving errors. This is happening in both DEV and PROD instances. The error message in the document script log is as follows:
2019-05-21 12:00:36 0741 LIB CONNECT TO 'UD Location Geo Data'2019-05-21 12:00:36 Connected.2019-05-21 12:00:36 0744 [GeoData_newark]:2019-05-21 12:00:36 0745 SQL SELECT [UD_Build_1] as [^BldgKey], [Geometry] FROM Load(dataset='Dataset')2019-05-21 12:00:36 0746 DATASOURCE Dataset GEOFILE url='file:///E:/Qlik/Group Connections/FACILITIES/Common_Data/UDEL_GEO_DATA/Newark/UD_Buildings.zip', keyField='UD_Build_1', type='shape', expectedGeomType='polygon', encoding='', crs='EPSG:3857'2019-05-21 12:00:37 Error: Connector reply error: QVX_SYNTAX_ERROR: *null2019-05-21 12:00:37 Execution Failed2019-05-21 12:00:37 Execution finished.
Any idea why this would happen? To my knowledge there are no changes to the DEV and PROD Qlik Sense environments.
Go to Solution.
View solution in original post
usually errors in the script , means you have some problem with the geometry
if you have a line with null value in geometry or ID it'll cause an error
Thanks for the reply. The geometry has not changed and the reload task has been running successfully until 2 days ago.
Thank you, Patric.
The issue is resolved now.