11-21-2018 08:59 AM - last edited on 11-25-2018 11:12 PM by fcaelen
I am using MAE 16.5, and I built a workflow desktop application but whenever I try to open a workflow form or list, it gives me the following error message
The field 'geom' has type 'public.geometry', which is currently unknown to Npgsql. You can retrieve it as a string by marking it as unknown, please see the FAQ.
Note: I originally built the workflow on MAE 16.1.4 then migrated it into 16.5.
I am using database postgres 9.6 with postgis 2.5.0.
Solved! Go to Solution.
11-22-2018 02:09 AM
I cannot replicate your issue. I've loaded your table and your workflow (removing only references to additional tables) and I can successfully capture data and load lists and forms.
Is there anything else in your workflow definition that can cause problems?
11-24-2018 11:36 PM - edited 11-25-2018 01:54 AM
Now I get in the error log another error as follows:
c:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\workflows\d4a0faa0\5c7ee588\App_Web_listheadertemplate.cshtml.5e279d63.zdb5velh.0.cs(65): error CS0103: The name 'nameof' does not exist in the current context
Although I did not change anything.
I also tried another sample shapefile from https://www.mapbox.com/help/data/stations.zip but the same error of the NPGSQL, I investigated the error and it appears that the npgsql.dll 184.108.40.206 which is used in MAE 16.5 does no longer support the types of POSTGIS itself, but there a specialized spatial library 'NetTopologySuite' should be used as stated in https://www.npgsql.org/doc/types/nts.html. I hope this note would help.
11-26-2018 12:09 PM
I'm not quite sure I've got your point. The way it is implemented keeps compatibility with the past, so you don't have to take care of any change.
As I said we are not able to replicate this issue, we have tested several environments including a Postgres 9.6 server with PostGIS 2.5.
I guess there is something wrong on your server installation.
12-15-2020 05:24 AM
I am facing the very same issue.
Within the form a sql-query is used for a table. As soon as the geometry is called within this lov-SQL, the error 'public.geometry currently unknown to Npgsql' occurs.
I have reinstalled ME - no change.
You got some hints on it? Otherwise I will open a supporticket.