Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

m_perreault
Contributor II

Qlik GeoAnalytics Connector QVX_SYNTAX_ERROR

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

Tags (1)
3 Replies
Employee
Employee

Re: Qlik GeoAnalytics Connector QVX_SYNTAX_ERROR

Hi Mark,

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

Thanks,

Patric

m_perreault
Contributor II

Re: Qlik GeoAnalytics Connector QVX_SYNTAX_ERROR

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

Employee
Employee

Re: Qlik GeoAnalytics Connector QVX_SYNTAX_ERROR

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

Community Browser