[mapguide-users] Fdo Provider PostGreSql 12

[Diego Ordonez]

Hi Gordon

No I'm trying to read a table, and permissions are OK because I use the postgres user

MapGuide Server is Centos 6 x64

System.Exception: The remote server returned an error: (559) MgFdoException.:
An exception occurred in FDO component.
Error occurred in Feature Source (Library://Ejemplo_Neiva/Data/postgres@200.116.160.53_10654 (12 Test).FeatureSource): RDBMS: [PGRES_FATAL_ERROR] ERROR:  column d.adsrc does not exist
LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as...
                                                             ^
 (Cause: RDBMS: [PGRES_FATAL_ERROR] ERROR:  column d.adsrc does not exist
LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as...
                                                             ^
, Root Cause: RDBMS: [PGRES_FATAL_ERROR] ERROR:  column d.adsrc does not exist
LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as...
                                                             ^
)

- MgFeatureServiceHandler.ProcessOperation() line 83 file FeatureServiceHandler.cpp
- MgOpDescribeSchemaAsXml.Execute() line 110 file OpDescribeSchemaAsXml.cpp
- MgServerFeatureService.DescribeSchemaAsXml() line 381 file ServerFeatureService.cpp
- MgServerDescribeSchema.DescribeSchemaAsXml() line 647 file ServerDescribeSchema.cpp
- MgServerDescribeSchema.DescribeSchema() line 583 file ServerDescribeSchema.cpp
- MgServerDescribeSchema.DescribeFdoSchema() line 217 file ServerDescribeSchema.cpp

 ---> System.Net.WebException: The remote server returned an error: (559) MgFdoException.
   at System.Net.HttpWebRequest.GetResponse()
   at OSGeo.MapGuide.MaestroAPI.HttpServerConnection.OpenRead(String req) in C:\projects\mapguide-maestro\OSGeo.MapGuide.MaestroAPI\Http\HttpServerConnection.cs:line 1405



________________________________
From: mapguide-users <mapguide-users-bounces at lists.osgeo.org> on behalf of Gordon Luckett <gordon.luckett at arrowgeomatics.com>
Sent: May 17, 2021 16:36
To: MapGuide Users Mail List <mapguide-users at lists.osgeo.org>
Subject: Re: [mapguide-users] Fdo Provider PostGreSql 12

Are you trying to look at a view?
It looks like one of the tables on the view is not accessable to the login user..

On Mon, May 17, 2021, 9:14 PM Diego Ordonez <diordonezr at hotmail.com<mailto:diordonezr at hotmail.com>> wrote:
Hello there

I have MapGUIDE 3.1.2 on Centos 6 x64

Everything seems to work properly, except connecting a layer to Postgresql 12

How do I set up FDO 4.1 properly ?


RDBMS: [PGRES_FATAL_ERROR] ERROR:  column d.adsrc does not exist
LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as...

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org<mailto:mapguide-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/mapguide-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20210517/efce045f/attachment.html>