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-boun...@lists.osgeo.org> on behalf of 
Gordon Luckett <gordon.luck...@arrowgeomatics.com>
Sent: May 17, 2021 16:36
To: MapGuide Users Mail List <mapguide-users@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 
<diordon...@hotmail.com<mailto:diordon...@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@lists.osgeo.org<mailto:mapguide-users@lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users

Reply via email to