[mapguide-users] MapGuideOS - PostGIS FDO Problem

[Gordon Luckett]

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