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