M.App Enterprise Discussions

Discuss topics with other M.App Enterprise Product pioneers and experts to get the most out of it.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Occasional Contributor
Posts: 15
Registered: ‎01-12-2020

Error reading the input feature data: 42601: syntax error at or near "end"

Does anyone have any idea why I am encountering such an error

Capture.PNG

Highlighted
Technical Evangelist
Posts: 832
Registered: ‎11-12-2015

Re: Error reading the input feature data: 42601: syntax error at or near "end"

Hi Erezdan,

What is the version of M.App Enterprise you are using here? Is it the latest version 2019 Update 4?


Please open browser console (F12 most browsers) and monitor for any errors there during the data reading. You may also switch to the 'network' tab (re-try to load the feature) and inspect the request/response for any details.


Is your input feature coming from vector sets or some other source?
It could be that the input feature set includes some invalid geometries.

 

HTH 

 

Stephen

Highlighted
Occasional Contributor
Posts: 15
Registered: ‎01-12-2020

Re: Error reading the input feature data: 42601: syntax error at or near "end"

Thanks for the quick reply
If I understand correctly I am with the latest version

Capture.PNG

Capture.PNG

Highlighted
Technical Evangelist
Posts: 832
Registered: ‎11-12-2015

Re: Error reading the input feature data: 42601: syntax error at or near "end"

There is newer update 4 available at this time. 

 

You may upgrade and test there. This would be my first recommendation.

 

Perhaps you may also investigate the cancelled requests from Console Log. 

Are they indicating what may be going wrong with the input features?

 

Are you using vector set feature input data? If yes, there should be a call to the vector set made followed by a SQL Query against the specific dataset of the vector set. I am unable to discern this from your screenshot unfortunately.

 

Highlighted
Regular Contributor
Posts: 326
Registered: ‎11-16-2015

Re: Error reading the input feature data: 42601: syntax error at or near "end"

I have just had the same issue. It was because the column names had spaces which isn't good for Postgres! Removing the spaces (e.g. Old FID -> OldFID) did the trick. Hope this helps. Johnnie

Highlighted
Regular Contributor
Posts: 326
Registered: ‎11-16-2015

Re: Error reading the input feature data: 42601: syntax error at or near "end"

And, in further news, didn't like under_scores or dash-es or UpperCaseLetters in the column names either.