[mapguide-users] ODBC Point features failure

Dave Wilson dave.wilson at autodesk.com
Thu Jul 5 10:36:31 EDT 2007


Are there any errors logged in the server error log? It seems to me
something is causing the provider to die? Usually there is at least 1
error logged before something like this can happen.

 

What coordinate system is your data in and what coordinate system is
your map in?

 

Have you tried using the DWF Viewer/Autodesk Design Review? I'm curious
if it's the data or something in the viewer behavior.

 

Regards,

Dave

 

From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of
IElsinga at fac.bm
Sent: Thursday, July 05, 2007 6:25 AM
To: MapGuide Users Mail List
Cc: MapGuide Users Mail List; mapguide-users-bounces at lists.osgeo.org
Subject: RE: [mapguide-users] ODBC Point features failure

 


I noticed that when it stops working, there are no more SQL statements
being sent to the database.  (Discovered by using SQL Profiler).   

Ian Elsinga
Senior Client/Server Application Developer
First Atlantic Commerce
Bermuda

mailto:ielsinga at fac.bm
Phone : (441) 294-4640
Primary Fax : (441) 295-6855 
Secondary Fax : (441) 295-6708

http://www.firstatlanticcommerce.com

------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
---------------
The information in this Internet e-mail, including attachments, contains
information that is confidential and may be protected by attorney client
privileges. This email, including attachments, constitutes non-public
information intended only for the use of the designated recipient(s) to
which it is addressed and may contain legal or financial information
which is privileged, confidential or subject to copyright. Access by any
other person to this Internet e-mail is not authorized. If you are not
the intended recipient, please delete this Internet e-mail, including
attachments, immediately and notify the sender by return email. Any
disclosure of this Internet e-mail, including attachments, or of the
parties to it, or copying, distribution or any action taken or omitted
to be taken in reliance on it is prohibited, and may be unlawful.




IElsinga at fac.bm 
Sent by: mapguide-users-bounces at lists.osgeo.org 

07/05/2007 09:15 AM 

Please respond to
MapGuide Users Mail List <mapguide-users at lists.osgeo.org>

To

MapGuide Users Mail List <mapguide-users at lists.osgeo.org> 

cc

	
Subject

RE: [mapguide-users] ODBC Point features failure

 

		





Thanks for the response - there is 4GB of RAM on the mapguide server
which is running Windows Server 2003.  There are no properties selected
and there are only two layers.   It is pulling data via ODBC from SQL
Server on another server which is configured similarly.   

I can use the map for a few minutes, zooming, panning, clicking on
points, etc., but then the points disappear for no reason and the only
way I can get them back is to restart the mapguide service.   

Is this a bug I should report somewhere? 

Thanks, 

Ian Elsinga
Senior Client/Server Application Developer
First Atlantic Commerce
Bermuda

mailto:ielsinga at fac.bm
Phone : (441) 294-4640
Primary Fax : (441) 295-6855 
Secondary Fax : (441) 295-6708

http://www.firstatlanticcommerce.com

------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
---------------
The information in this Internet e-mail, including attachments, contains
information that is confidential and may be protected by attorney client
privileges. This email, including attachments, constitutes non-public
information intended only for the use of the designated recipient(s) to
which it is addressed and may contain legal or financial information
which is privileged, confidential or subject to copyright. Access by any
other person to this Internet e-mail is not authorized. If you are not
the intended recipient, please delete this Internet e-mail, including
attachments, immediately and notify the sender by return email. Any
disclosure of this Internet e-mail, including attachments, or of the
parties to it, or copying, distribution or any action taken or omitted
to be taken in reliance on it is prohibited, and may be unlawful.



"Dave Wilson" <dave.wilson at autodesk.com> 
Sent by: mapguide-users-bounces at lists.osgeo.org 

07/04/2007 06:47 PM 

Please respond to
MapGuide Users Mail List <mapguide-users at lists.osgeo.org>

To

"MapGuide Users Mail List" <mapguide-users at lists.osgeo.org> 

cc

	
Subject

RE: [mapguide-users] ODBC Point features failure

 

		





In house testing with a feature source containing almost 10,000 features
appears to work fine. 
 
How much memory on your system? What is the OS? Do you have properties
selected on your layer? How many other layers are in your map? 
 
Regards, 
Dave 
 
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of
IElsinga at fac.bm
Sent: Wednesday, July 04, 2007 10:33 AM
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] ODBC Point features failure 
 

I am using MGOS 1.2 RC2 and am experiencing a problem with an ODBC
connected to SQL Server point source.    Points are displayed initially,
but then eventually they are not displayed any longer.  Opening a new
web browser does not help.  The only way I can get them to come back is
to restart the MapGuide windows service - then the points will come back
- for a few minutes of interaction.   

I am bringing back 1000 points from a SQL Server database.    This
behaviour was the same in 1.2 RC1. 

This will obviously make mapguide unusable for our purposes - is there a
problem with the ODBC FDO?   

I will be grateful for any assistance!   


Ian Elsinga_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20070705/669c77d1/attachment.html


More information about the mapguide-users mailing list