topic Re: Qlik GeoAnalytics Connector QVX_SYNTAX_ERROR in GeoAnalytics

Qlik GeoAnalytics Connector QVX_SYNTAX_ERROR

m_perreault — Mon, 12 Mar 2018 14:20:02 GMT

Hello,

I am using the Qlik GeoAnalytics Plus connector to read in several different ESRI Layers. All of the ESRI Layers are consistently loading successfully except for one. This one layer will sometimes load successfully and will sometimes fail with the error message

"ERROR: Connector reply error: QVX_SYNTAX_ERROR: *The column 'x' is not available in the requested result." does anyone know why this would be occurring and why it will only fail occasionally as opposed to all the time?

patricn‌ would you please be able to advise on this?

Thanks all

Mark

Re: Qlik GeoAnalytics Connector QVX_SYNTAX_ERROR

Patric_Nordstrom — Tue, 13 Mar 2018 14:24:53 GMT

Hi Mark,

That sounds strange, could you share the file or do a bug report?

Thanks,

Patric

Re: Qlik GeoAnalytics Connector QVX_SYNTAX_ERROR

m_perreault — Tue, 13 Mar 2018 15:37:54 GMT

Hi patricn‌ thank you for your response. I created an app which only has this problematic layer loaded into it and I have tasked it to reload upon successful completion of itself. It typically will successfully reload every two seconds for a few minutes then all of the sudden fail with this QVX error. I have attached the Reload Error File (I deleted the URL), please let me know if I could provide any more information. The version of Qlik GeoAnalytics Installed is November 2017

Re: Qlik GeoAnalytics Connector QVX_SYNTAX_ERROR

Patric_Nordstrom — Thu, 15 Mar 2018 15:09:28 GMT

Hi Mark,

Hard to tell without seeing the actual data.

Since it sometimes fail sounds like it might be the providing Esri server that gives the wrong input with a missing column.

Thanks,

Patric