<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>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.</div>
<div>
<div>
<div name="quote" style="margin:10px 5px 5px 10px; padding: 10px 0 10px 10px; border-left:2px solid #C3D9E5; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="margin:0 0 10px 0;"><b>Gesendet:</b> Donnerstag, 06. Mai 2021 um 17:02 Uhr<br/>
<b>Von:</b> "Gordon Luckett" <gordon.luckett@arrowgeomatics.com><br/>
<b>An:</b> "MapGuide Users Mail List" <mapguide-users@lists.osgeo.org><br/>
<b>Betreff:</b> Re: [mapguide-users] MapGuideOS - PostGIS FDO Problem</div>
<div name="quoted-content">
<div>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.
<div> </div>
</div>
<div> </div>
<div class="gmail_quote">
<div class="gmail_attr">On Thu, May 6, 2021 at 3:26 PM <<a href="mailto:woody2@web.de" onclick="parent.window.location.href='mailto:woody2@web.de'; return false;" target="_blank">woody2@web.de</a>> wrote:</div>
<blockquote class="gmail_quote" style="margin: 0.0px 0.0px 0.0px 0.8ex;border-left: 1.0px solid rgb(204,204,204);padding-left: 1.0ex;">
<div>
<div style="font-family: Verdana;font-size: 12.0px;">
<div>
<div>Hello,</div>
<div><br/>
I have registered here to get rid of a problem or a few questions.<br/>
When I google through the net, I often only find old information about tickets for MapGuideOS. Like here:<br/>
<a href="https://trac.osgeo.org/mapguide/report/1" target="_blank">https://trac.osgeo.org/mapguide/report/1</a><br/>
Maybe I'm looking in the wrong place.</div>
<div>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.<br/>
At night, the MV is always called up via a</div>
<div> </div>
<div>REFRESH MATERIALIZED VIEW CONCURRENTLY mv_baugenehm;</div>
<div> </div>
<div>updated. Nothing more happens.</div>
<div>In the mapguideOS log I get the following messages, which also come in throughout the day:</div>
<div> </div>
<div><2021-05-06T07:41:02> 6860 Anonymous<br/>
Error: Failed to stylize layer: Po_V_BAUMASSN<br/>
An exception occurred in FDO component.<br/>
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 )<br/>
StackTrace:<br/>
- MgMappingUtil.StylizeLayers() line 899 file c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\mapping\MappingUtil.cpp <br/>
<2021-05-06T07:41:02> 5888 Anonymous<br/>
Error: Failed to stylize layer: Po_V_BAUMASSN<br/>
An exception occurred in FDO component.<br/>
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 )<br/>
StackTrace:<br/>
- MgMappingUtil.StylizeLayers() line 899 file c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\mapping\MappingUtil.cpp</div>
<div> </div>
<div>Here I have also described the issue once (German only):</div>
<div><a href="https://www.pg-forum.de/t/postgresql-postgis-und-mapguide-os/12208" target="_blank">https://www.pg-forum.de/t/postgresql-postgis-und-mapguide-os/12208</a></div>
<div> </div>
<div>Any Ideas? Thanks</div>
<div> </div>
</div>
</div>
</div>
_______________________________________________<br/>
mapguide-users mailing list<br/>
<a href="mailto:mapguide-users@lists.osgeo.org" onclick="parent.window.location.href='mailto:mapguide-users@lists.osgeo.org'; return false;" target="_blank">mapguide-users@lists.osgeo.org</a><br/>
<a href="https://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/mapguide-users</a></blockquote>
</div>
_______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org <a href="https://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/mapguide-users</a></div>
</div>
</div>
</div></div></body></html>