[mapguide-users] MapGuideOS - PostGIS FDO Problem

[woody2]

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