<br><font size=2 face="sans-serif">Hi Dave, thanks for the responses...
</font>
<br>
<br><font size=2 face="sans-serif">I didn't know about the error log -
there are indeed error messages like the following: </font>
<br>
<br><font size=2 face="sans-serif"><2007-07-05T13:54:45>
fac</font>
<br><font size=2 face="sans-serif"> Error: Failed to stylize layer:
Points</font>
<br><font size=2 face="sans-serif"> An exception
occurred in FDO component.</font>
<br><font size=2 face="sans-serif"> RDBMS: [Microsoft][ODBC
SQL Server Driver]Communication link failure </font>
<br><font size=2 face="sans-serif"> StackTrace:</font>
<br><font size=2 face="sans-serif"> - MgStylizationUtil.StylizeLayers
line 923 file c:\build_bond_area\mapguide_open_source_v1.2\build_18.1\mgdev\server\src\services\mapping\StylizationUtil.cpp
Failed to stylize layer: Points</font>
<br><font size=2 face="sans-serif">An exception occurred in FDO component.</font>
<br><font size=2 face="sans-serif">RDBMS: [Microsoft][ODBC SQL Server Driver]Communication
link failure </font>
<br>
<br><font size=2 face="sans-serif">Why would there be a Communications
link failure? We have lots of processes which communicate to that
particular database continually. It seems that something inside
the FDO provider times out and it thinks it can no longer access SQL Server.
</font>
<br>
<br><font size=2 face="sans-serif">If I restart the mapguide service and
re-open the site, it initially works. If I let it just sit there
for a few minutes, without doing any zooming or panning or clicking, then
when I try to zoom after that, the points disappear - and that error message
above is in the error log. So it seems that something in the FDO
provider is timing out - it is allowing the connection to timeout perhaps
and it doesn't re-establish it? </font>
<br>
<br><font size=2 face="sans-serif">Thanks for your help, </font>
<br>
<br><font size=2 face="sans-serif">Ian Elsinga<br>
</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>"Dave Wilson"
<dave.wilson@autodesk.com></b> </font>
<br><font size=1 face="sans-serif">Sent by: mapguide-users-bounces@lists.osgeo.org</font>
<p><font size=1 face="sans-serif">07/05/2007 11:36 AM</font>
<table border>
<tr valign=top>
<td bgcolor=white>
<div align=center><font size=1 face="sans-serif">Please respond to<br>
MapGuide Users Mail List <mapguide-users@lists.osgeo.org></font></div></table>
<br>
<td width=59%>
<table width=100%>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td valign=top><font size=1 face="sans-serif">"MapGuide Users Mail
List" <mapguide-users@lists.osgeo.org></font>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td valign=top>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td valign=top><font size=1 face="sans-serif">RE: [mapguide-users] ODBC
Point features failure</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br><font size=2 color=#1f497d face="Calibri">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.</font>
<br><font size=2 color=#1f497d face="Calibri"> </font>
<br><font size=2 color=#1f497d face="Calibri">What coordinate system is
your data in and what coordinate system is your map in?</font>
<br><font size=2 color=#1f497d face="Calibri"> </font>
<br><font size=2 color=#1f497d face="Calibri">Have you tried using the
DWF Viewer/Autodesk Design Review? I’m curious if it’s the data or something
in the viewer behavior.</font>
<br><font size=2 color=#1f497d face="Calibri"> </font>
<br><font size=2 color=#1f497d face="Calibri">Regards,</font>
<br><font size=2 color=#1f497d face="Calibri">Dave</font>
<br><font size=2 color=#1f497d face="Calibri"> </font>
<br><font size=2 face="Tahoma"><b>From:</b> mapguide-users-bounces@lists.osgeo.org
[mailto:mapguide-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>IElsinga@fac.bm<b><br>
Sent:</b> Thursday, July 05, 2007 6:25 AM<b><br>
To:</b> MapGuide Users Mail List<b><br>
Cc:</b> MapGuide Users Mail List; mapguide-users-bounces@lists.osgeo.org<b><br>
Subject:</b> RE: [mapguide-users] ODBC Point features failure</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 face="Arial"><br>
I noticed that when it stops working, there are no more SQL statements
being sent to the database. (Discovered by using SQL Profiler). </font><font size=3 face="Times New Roman">
<br>
</font><font size=2 face="Arial"><br>
Ian Elsinga<br>
Senior Client/Server Application Developer<br>
First Atlantic Commerce<br>
Bermuda<br>
<br>
mailto:ielsinga@fac.bm<br>
Phone : (441) 294-4640<br>
Primary Fax : (441) 295-6855 <br>
Secondary Fax : (441) 295-6708<br>
<br>
http://www.firstatlanticcommerce.com<br>
<br>
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>
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.</font><font size=3 face="Times New Roman"><br>
<br>
</font>
<p>
<table width=100%>
<tr valign=top>
<td width=47%><font size=1 face="Arial"><b>IElsinga@fac.bm</b> <br>
Sent by: mapguide-users-bounces@lists.osgeo.org</font><font size=3 face="Times New Roman">
</font>
<p><font size=1 face="Arial">07/05/2007 09:15 AM</font><font size=3 face="Times New Roman">
</font>
<p>
<br>
<table border=4 width=100%>
<tr valign=top>
<td width=100% bgcolor=white>
<div align=center><font size=1 face="Arial">Please respond to<br>
MapGuide Users Mail List <mapguide-users@lists.osgeo.org></font></div></table>
<br>
<td width=52%>
<br>
<table width=100%>
<tr>
<td width=12%>
<div align=right><font size=1 face="Arial">To</font></div>
<td width=87% valign=top><font size=1 face="Arial">MapGuide Users Mail
List <mapguide-users@lists.osgeo.org></font><font size=3 face="Times New Roman">
</font>
<tr>
<td>
<div align=right><font size=1 face="Arial">cc</font></div>
<td valign=top>
<tr>
<td>
<div align=right><font size=1 face="Arial">Subject</font></div>
<td valign=top><font size=1 face="Arial">RE: [mapguide-users] ODBC Point
features failure</font></table>
<br><font size=3 face="Times New Roman"> </font>
<p>
<br>
<table width=100%>
<tr valign=top>
<td width=50%>
<td width=49%></table>
<br></table>
<br><font size=3 face="Times New Roman"><br>
<br>
</font><font size=2 face="Arial"><br>
<br>
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. </font><font size=3 face="Times New Roman">
</font><font size=2 face="Arial"><br>
<br>
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. </font><font size=3 face="Times New Roman">
</font><font size=2 face="Arial"><br>
<br>
Is this a bug I should report somewhere? <br>
<br>
Thanks, <br>
<br>
Ian Elsinga<br>
Senior Client/Server Application Developer<br>
First Atlantic Commerce<br>
Bermuda<br>
<br>
mailto:ielsinga@fac.bm<br>
Phone : (441) 294-4640<br>
Primary Fax : (441) 295-6855 <br>
Secondary Fax : (441) 295-6708<br>
<br>
http://www.firstatlanticcommerce.com<br>
<br>
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>
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.</font><font size=3 face="Times New Roman"><br>
</font>
<p>
<table width=100%>
<tr valign=top>
<td width=47%><font size=1 face="Arial"><b>"Dave Wilson" <dave.wilson@autodesk.com></b>
<br>
Sent by: mapguide-users-bounces@lists.osgeo.org</font><font size=3 face="Times New Roman">
</font>
<p><font size=1 face="Arial">07/04/2007 06:47 PM</font><font size=3 face="Times New Roman">
</font>
<p>
<br>
<table border=4 width=100%>
<tr valign=top>
<td width=100% bgcolor=white>
<div align=center><font size=1 face="Arial">Please respond to<br>
MapGuide Users Mail List <mapguide-users@lists.osgeo.org></font></div></table>
<br>
<td width=52%>
<br>
<table width=100%>
<tr>
<td width=12%>
<div align=right><font size=1 face="Arial">To</font></div>
<td width=87% valign=top><font size=1 face="Arial">"MapGuide Users
Mail List" <mapguide-users@lists.osgeo.org></font><font size=3 face="Times New Roman">
</font>
<tr>
<td>
<div align=right><font size=1 face="Arial">cc</font></div>
<td valign=top>
<tr>
<td>
<div align=right><font size=1 face="Arial">Subject</font></div>
<td valign=top><font size=1 face="Arial">RE: [mapguide-users] ODBC Point
features failure</font></table>
<br><font size=3 face="Times New Roman"> </font>
<p>
<br>
<table width=100%>
<tr valign=top>
<td width=50%>
<td width=49%></table>
<br></table>
<br><font size=3 face="Times New Roman"><br>
<br>
</font><font size=2 color=#1f497d face="Calibri"><br>
<br>
In house testing with a feature source containing almost 10,000 features
appears to work fine.</font><font size=3 face="Times New Roman"> <br>
</font><font size=2 color=#1f497d face="Calibri"><br>
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?</font><font size=3 face="Times New Roman">
<br>
</font><font size=2 color=#1f497d face="Calibri"><br>
Regards,</font><font size=3 face="Times New Roman"> </font><font size=2 color=#1f497d face="Calibri"><br>
Dave</font><font size=3 face="Times New Roman"> <br>
</font><font size=2 face="Tahoma"><b><br>
From:</b> mapguide-users-bounces@lists.osgeo.org [mailto:mapguide-users-bounces@lists.osgeo.org]
<b>On Behalf Of </b>IElsinga@fac.bm<b><br>
Sent:</b> Wednesday, July 04, 2007 10:33 AM<b><br>
To:</b> mapguide-users@lists.osgeo.org<b><br>
Subject:</b> [mapguide-users] ODBC Point features failure</font><font size=3 face="Times New Roman">
<br>
</font><font size=2 face="Arial"><br>
<br>
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. </font><font size=3 face="Times New Roman">
</font><font size=2 face="Arial"><br>
<br>
I am bringing back 1000 points from a SQL Server database. This
behaviour was the same in 1.2 RC1. <br>
<br>
This will obviously make mapguide unusable for our purposes - is there
a problem with the ODBC FDO? </font><font size=3 face="Times New Roman">
</font><font size=2 face="Arial"><br>
<br>
I will be grateful for any assistance! </font><font size=3 face="Times New Roman">
</font><font size=2 face="Arial"><br>
<br>
<br>
Ian Elsinga</font><font size=2 face="Courier New">_______________________________________________<br>
mapguide-users mailing list<br>
mapguide-users@lists.osgeo.org<br>
http://lists.osgeo.org/mailman/listinfo/mapguide-users<br>
_______________________________________________<br>
mapguide-users mailing list<br>
mapguide-users@lists.osgeo.org<br>
http://lists.osgeo.org/mailman/listinfo/mapguide-users</font><font size=2><tt>_______________________________________________<br>
mapguide-users mailing list<br>
mapguide-users@lists.osgeo.org<br>
http://lists.osgeo.org/mailman/listinfo/mapguide-users<br>
</tt></font>
<br>