<div dir="ltr">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.</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, May 6, 2021 at 4:31 PM <<a href="mailto:woody2@web.de">woody2@web.de</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div style="font-family:Verdana;font-size:12px"><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 0px 10px 10px;border-left:2px solid rgb(195,217,229)">
<div style="margin:0px 0px 10px"><b>Gesendet:</b> Donnerstag, 06. Mai 2021 um 17:02 Uhr<br>
<b>Von:</b> "Gordon Luckett" <<a href="mailto:gordon.luckett@arrowgeomatics.com" target="_blank">gordon.luckett@arrowgeomatics.com</a>><br>
<b>An:</b> "MapGuide Users Mail List" <<a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a>><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" target="_blank">woody2@web.de</a>> wrote:</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div style="font-family:Verdana;font-size:12px">
<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" 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 <a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a> <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></div>
_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/mapguide-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
</blockquote></div>