[mapguide-users] MapGuideOS - PostGIS FDO Problem

[Gordon Luckett]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20210506/1d175f90/attachment.html>