I log in with the user postgres. The Master of all 😊
> Gesendet: Donnerstag, 06. Mai 2021 um 17:41 Uhr > Von: "Gordon Luckett" <gordon.luck...@arrowgeomatics.com> > An: "MapGuide Users Mail List" <mapguide-users@lists.osgeo.org> > Betreff: Re: [mapguide-users] MapGuideOS - PostGIS FDO Problem > > I am curious if the user you are logging in with has access to all views, > tables, materialized views and objects in the database? That might cause > issues if it only has access to a sub-set. > > On Thu, May 6, 2021 at 4:31 PM <woo...@web.de> wrote: > > > I have also written the contents of the VM from the materialised view into > > a table. The errors have remained and the unstable connection to the > > MapGuide OS also. > > > > > > *Gesendet:* Donnerstag, 06. Mai 2021 um 17:02 Uhr > > *Von:* "Gordon Luckett" <gordon.luck...@arrowgeomatics.com> > > *An:* "MapGuide Users Mail List" <mapguide-users@lists.osgeo.org> > > *Betreff:* Re: [mapguide-users] MapGuideOS - PostGIS FDO Problem > > I have seen something similar if the database Schema changes. For > > example, if new tables or views appear. The schema definition is cached so > > it is no longer valid. > > > > > > > > On Thu, May 6, 2021 at 3:26 PM <woo...@web.de> wrote: > > > >> Hello, > >> > >> I have registered here to get rid of a problem or a few questions. > >> When I google through the net, I often only find old information about > >> tickets for MapGuideOS. Like here: > >> https://trac.osgeo.org/mapguide/report/1 > >> Maybe I'm looking in the wrong place. > >> My problem: I have an installation of MapGuideOS 3.1.2.9484 and a > >> PostgreSQL12.6 database. There I have a query (materialized view) running > >> over the ogr_fdw to a MSSQL database. This works fine, but the > >> MapGuide-PostGIS connection does not seem to be stable. Every morning I > >> have to retype the password of the feature source in the Meastro and save > >> the feature source so that the objects are displayed again. > >> At night, the MV is always called up via a > >> > >> REFRESH MATERIALIZED VIEW CONCURRENTLY mv_baugenehm; > >> > >> updated. Nothing more happens. > >> In the mapguideOS log I get the following messages, which also come in > >> throughout the day: > >> > >> <2021-05-06T07:41:02> 6860 Anonymous > >> Error: Failed to stylize layer: Po_V_BAUMASSN > >> An exception occurred in FDO component. > >> Error occurred in Feature Source > >> (Library://Verwaltung/ProsozBau/Prosozbau.FeatureSource): Class > >> 'public:v_baugenehm' not found (Cause: , Root Cause: Class > >> 'public:v_baugenehm' not found ) > >> StackTrace: > >> - MgMappingUtil.StylizeLayers() line 899 file > >> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\mapping\MappingUtil.cpp > >> > >> <2021-05-06T07:41:02> 5888 Anonymous > >> Error: Failed to stylize layer: Po_V_BAUMASSN > >> An exception occurred in FDO component. > >> Error occurred in Feature Source > >> (Library://Verwaltung/ProsozBau/Prosozbau.FeatureSource): Class > >> 'public:v_baugenehm' not found (Cause: , Root Cause: Class > >> 'public:v_baugenehm' not found ) > >> StackTrace: > >> - MgMappingUtil.StylizeLayers() line 899 file > >> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\mapping\MappingUtil.cpp > >> > >> Here I have also described the issue once (German only): > >> https://www.pg-forum.de/t/postgresql-postgis-und-mapguide-os/12208 > >> > >> Any Ideas? Thanks > >> > >> _______________________________________________ > >> mapguide-users mailing list > >> 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 > > _______________________________________________ > > mapguide-users mailing list > > 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 > _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users