[mapguide-users] MapGuideOS - PostGIS FDO Problem

[woody2 at web.de]

I log in with the user postgres. The Master of all 😊

> Gesendet: Donnerstag, 06. Mai 2021 um 17:41 Uhr
> Von: "Gordon Luckett" <gordon.luckett at arrowgeomatics.com>
> An: "MapGuide Users Mail List" <mapguide-users at 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 <woody2 at 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.luckett at arrowgeomatics.com>
> > *An:* "MapGuide Users Mail List" <mapguide-users at 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 <woody2 at 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 at lists.osgeo.org
> >> https://lists.osgeo.org/mailman/listinfo/mapguide-users
> >
> > _______________________________________________ mapguide-users mailing
> > list mapguide-users at lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/mapguide-users
> > _______________________________________________
> > mapguide-users mailing list
> > mapguide-users at lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/mapguide-users
> >
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapguide-users
>