[mapguide-users] Postgis views not selectable when using join
Hello, I am having following configuration: - MGOS 2.5.1 - Postgresql 9.3/Postgis 2.1 - Windows 2008 When creating a layer on a database view which is based on one table we can make a selection without any problems. If we make a view that is based on multiple tables (join) it is not possible anymore to select objects in the layer. Is this a known issue and are there any workarounds ? I know there is the possibility to override the schema, but I prefer not to do this as we would loose flexibility in this case (database changes). -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Postgis-views-not-selectable-when-using-join-tp5139362.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Unhandled exceptions in IIS web tier
I struggle with events related to mapguide because I don't really understand them. Several times a day we get logs like A process serving application pool 'MapGuide25AppPool' suffered a fatal communication error with the World Wide Web Publishing Service. The process id was '17544'. The data field contains the error number. with the source being W3SVC. W3svc.exe is the process related to the application pool in IIS that represents the website that holds mapguide. It's tricky for me to figure out what the cause of the errors are. It could be a memory leak in my own application (fairly likely,) so I can't blame mapguide for it off the bat. Basically, whenever my application pool fails, maps stop loading until I manually recycle the application pool. Without knowing the exact cause, the only workaround I've come up with is to configure my application pool to automatically recycle whenever it accumulates a certain amount of virtual memory. I've got it set to recycle at 800 megabytes, but I might decrease that number if problems persist. The hope is that frequent recycling will prevent errors. It's also important to note that my application does not use InProc session handling in web.config. That's the default setting and application pool recycling would reset any sessions (very bad.) Instead I use the StateServer setting. That way session aren't reset upon application pool resets. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Unhandled exceptions in IIS web tier
I think I recall having to set my recycle limits on the AppPool for stability from errors in Mapguide as well. Fiddle Fiddle Fiddle with different setting until things calm down. I think they could be set by memory size (as you've done) or after a certain time. I believe I set my Win2008R2 Server to recycle every 2 hours. On Fri, May 9, 2014 at 9:42 AM, Berg, James james.b...@stantec.com wrote: I struggle with events related to mapguide because I don't really understand them. Several times a day we get logs like A process serving application pool 'MapGuide25AppPool' suffered a fatal communication error with the World Wide Web Publishing Service. The process id was '17544'. The data field contains the error number. with the source being W3SVC. W3svc.exe is the process related to the application pool in IIS that represents the website that holds mapguide. It's tricky for me to figure out what the cause of the errors are. It could be a memory leak in my own application (fairly likely,) so I can't blame mapguide for it off the bat. Basically, whenever my application pool fails, maps stop loading until I manually recycle the application pool. Without knowing the exact cause, the only workaround I've come up with is to configure my application pool to automatically recycle whenever it accumulates a certain amount of virtual memory. I've got it set to recycle at 800 megabytes, but I might decrease that number if problems persist. The hope is that frequent recycling will prevent errors. It's also important to note that my application does not use InProc session handling in web.config. That's the default setting and application pool recycling would reset any sessions (very bad.) Instead I use the StateServer setting. That way session aren't reset upon application pool resets. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Unhandled exceptions in IIS web tier
Thanks for the responses. James, I also get the same error messages as the one you described. I think they may be related as I managed to create some of them by accident when attempting to catch and work with some of those unhandled exceptions within the mainframe.aspx. They are preceded by another error that looks like: “Faulting application name: w3wp.exe, version: 7.5.7601.17514, time stamp: 0x4ce7afa2….” I just noticed the following post in the Autodesk support site. It looks like this or a very similar issue is considered to be a known issue and will hopefully get patched up soon. http://knowledge.autodesk.com/support/infrastructure-map-server/troubleshooting/caas/sfdcarticles/sfdcarticles/Mapserver2014AppPool-Error.html From: northtron [via OSGeo.org] [mailto:ml-node+s1560n5139435...@n6.nabble.com] Sent: Friday, May 09, 2014 6:55 AM To: Galambos, John Subject: Re: Unhandled exceptions in IIS web tier I think I recall having to set my recycle limits on the AppPool for stability from errors in Mapguide as well. Fiddle Fiddle Fiddle with different setting until things calm down. I think they could be set by memory size (as you've done) or after a certain time. I believe I set my Win2008R2 Server to recycle every 2 hours. On Fri, May 9, 2014 at 9:42 AM, Berg, James [hidden email]/user/SendEmail.jtp?type=nodenode=5139435i=0 wrote: I struggle with events related to mapguide because I don't really understand them. Several times a day we get logs like A process serving application pool 'MapGuide25AppPool' suffered a fatal communication error with the World Wide Web Publishing Service. The process id was '17544'. The data field contains the error number. with the source being W3SVC. W3svc.exe is the process related to the application pool in IIS that represents the website that holds mapguide. It's tricky for me to figure out what the cause of the errors are. It could be a memory leak in my own application (fairly likely,) so I can't blame mapguide for it off the bat. Basically, whenever my application pool fails, maps stop loading until I manually recycle the application pool. Without knowing the exact cause, the only workaround I've come up with is to configure my application pool to automatically recycle whenever it accumulates a certain amount of virtual memory. I've got it set to recycle at 800 megabytes, but I might decrease that number if problems persist. The hope is that frequent recycling will prevent errors. It's also important to note that my application does not use InProc session handling in web.config. That's the default setting and application pool recycling would reset any sessions (very bad.) Instead I use the StateServer setting. That way session aren't reset upon application pool resets. ___ mapguide-users mailing list [hidden email]/user/SendEmail.jtp?type=nodenode=5139435i=1 http://lists.osgeo.org/mailman/listinfo/mapguide-users ___ mapguide-users mailing list [hidden email]/user/SendEmail.jtp?type=nodenode=5139435i=2 http://lists.osgeo.org/mailman/listinfo/mapguide-users If you reply to this email, your message will be added to the discussion below: http://osgeo-org.1560.x6.nabble.com/Unhandled-exceptions-in-IIS-web-tier-tp5139328p5139435.html To unsubscribe from Unhandled exceptions in IIS web tier, click herehttp://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=5139328code=am9obi5nYWxhbWJvc0B2YW5jb3V2ZXIuY2F8NTEzOTMyOHw4Nzc1NzM0MDA=. NAMLhttp://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Unhandled-exceptions-in-IIS-web-tier-tp5139328p5139466.html Sent from the MapGuide Users mailing list archive at Nabble.com.___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
