<br><font size=2 face="sans-serif">Hi Dave, </font>
<br>
<br><font size=2 face="sans-serif">I tried turning off the ODBC connection
pooling - this has no affect - still times out after about 1 minute with
that error message. I will experiment with the various timeouts
in mapguide and see if that helps. </font>
<br>
<br><font size=2 face="sans-serif">Meanwhile, I am using the SQL
Server ODBC driver, not the Native SQL Server driver - the latter cannot
be used because of a problem identified by someone else recently - the
Native driver has a problem reading SQL Server tables. I was thinking
that the Native driver may solve this issue, but it doesn't work at all.
Here's the error: </font>
<br>
<br><font size=2 face="sans-serif"><2007-07-06T16:37:40>
Administrator</font>
<br><font size=2 face="sans-serif"> Error: An exception occurred in
FDO component.</font>
<br><font size=2 face="sans-serif"> Invalid
length 0 for column type VARCHAR, must be &gt; 0 </font>
<br><font size=2 face="sans-serif"> StackTrace:</font>
<br><font size=2 face="sans-serif"> - MgFeatureServiceHandler.ProcessOperation
line 83 file c:\build_bond_area\mapguide_open_source_v1.2\build_18.1\mgdev\server\src\services\feature\FeatureServiceHandler.cpp</font>
<br><font size=2 face="sans-serif"> - MgOpDescribeSchemaAsXml.Execute
line 107 file c:\build_bond_area\mapguide_open_source_v1.2\build_18.1\mgdev\server\src\services\feature\OpDescribeSchemaAsXml.cpp</font>
<br><font size=2 face="sans-serif"> - MgServerDescribeSchema.DescribeSchema
line 500 file c:\build_bond_area\mapguide_open_source_v1.2\build_18.1\mgdev\server\src\services\feature\ServerDescribeSchema.cpp</font>
<br><font size=2 face="sans-serif"> - MgServerDescribeSchema.ExecuteDescribeSchema
line 173 file c:\build_bond_area\mapguide_open_source_v1.2\build_18.1\mgdev\server\src\services\feature\ServerDescribeSchema.cpp
An exception occurred in FDO component.</font>
<br><font size=2 face="sans-serif">Invalid length 0 for column type VARCHAR,
must be &gt; 0 </font>
<br>
<br><font size=2 face="sans-serif">This one does seem to be a mapguide
bug - there are no tables in our schema which have a varchar length less
than 10 - it seems not to be able to read the varchar type properly. </font>
<br>
<br><font size=2 face="sans-serif">Any ideas on this one? </font>
<br>
<br><font size=2 face="sans-serif">Thanks</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/06/2007 12:50 PM</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">By default there are a series
of timeouts that are set that could be affecting what you are seeing. Adjusting
the timeouts completely depends on the behavior of the users.</font>
<br><font size=2 color=#1f497d face="Calibri"> </font>
<br><font size=2 color=#1f497d face="Calibri">For example as a developer
working on a map you may want to significantly increase the timeout settings
to allow connections to last for 20 min or more whereas a user on the production
server may spend no more than 5 or 10 min querying a map so holding connections
for too long is a waste or can potentially not free up resources for other
users.</font>
<br><font size=2 color=#1f497d face="Calibri"> </font>
<br><font size=2 color=#1f497d face="Calibri">Most of the default settings
hold a session for about 20 min. So after you let your map sit for 20 min
you will have to refresh it. However below the main timeout settings there
is Connection Pooling taking place within FDO. These connections are held
for 10 min (600 seconds) and then released. You may want to try and up
this to 20 min to match the other timeouts. However in testing we have
never seen the link failure error that I am aware of.</font>
<br><font size=2 color=#1f497d face="Calibri"> </font>
<br><font size=2 color=#1f497d face="Calibri">A communication link failure
seems more like something external to FDO has dropped the connection rather
than FDO dropping the connection. FDO is trying to use a connection that
is no longer valid for some reason. Is there a proxy server or firewall
or router in between your MapGuide server and your database server that
could be dropping the connection? I’ve done some Google searches and one
possibility is that your DSN has connection pooling enabled and it may
be that the connection is dropped by SQLServer by the time you try to reuse
it. It’s not clear yet if it’s actually a MapGuide bug.</font>
<br><font size=2 color=#1f497d face="Calibri"> </font>
<br><font size=2 color=#1f497d face="Calibri">The Google searches weren’t
very informative. You might try to search msdn instead.</font>
<br><font size=2 color=#1f497d face="Calibri"> </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 11:05 AM<b><br>
To:</b> MapGuide Users Mail List<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>
Hi Dave, thanks for the responses... </font><font size=3 face="Times New Roman"><br>
</font><font size=2 face="Arial"><br>
I didn't know about the error log - there are indeed error messages like
the following: </font><font size=3 face="Times New Roman"><br>
</font><font size=2 face="Arial"><br>
<2007-07-05T13:54:45>
fac</font><font size=3 face="Times New Roman">
</font><font size=2 face="Arial"><br>
Error: Failed to stylize layer: Points</font><font size=3 face="Times New Roman">
</font><font size=2 face="Arial"><br>
An exception occurred in FDO component.</font><font size=3 face="Times New Roman">
</font><font size=2 face="Arial"><br>
RDBMS: [Microsoft][ODBC SQL Server Driver]Communication
link failure <br>
StackTrace:</font><font size=3 face="Times New Roman"> </font><font size=2 face="Arial"><br>
- 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><font size=3 face="Times New Roman">
</font><font size=2 face="Arial"><br>
An exception occurred in FDO component.</font><font size=3 face="Times New Roman">
</font><font size=2 face="Arial"><br>
RDBMS: [Microsoft][ODBC SQL Server Driver]Communication link failure </font><font size=3 face="Times New Roman"><br>
</font><font size=2 face="Arial"><br>
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><font size=3 face="Times New Roman">
<br>
</font><font size=2 face="Arial"><br>
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><font size=3 face="Times New Roman"><br>
</font><font size=2 face="Arial"><br>
Thanks for your help, </font><font size=3 face="Times New Roman"><br>
</font><font size=2 face="Arial"><br>
Ian Elsinga</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>"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/05/2007 11:36 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 color=#1f497d face="Calibri"><br>
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><font size=3 face="Times New Roman">
</font><font size=2 color=#1f497d face="Calibri"><br>
</font><font size=3 face="Times New Roman"> </font><font size=2 color=#1f497d face="Calibri"><br>
What coordinate system is your data in and what coordinate system is your
map in?</font><font size=3 face="Times New Roman"> </font><font size=2 color=#1f497d face="Calibri"><br>
</font><font size=3 face="Times New Roman"> </font><font size=2 color=#1f497d face="Calibri"><br>
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><font size=3 face="Times New Roman">
</font><font size=2 color=#1f497d face="Calibri"><br>
</font><font size=3 face="Times New Roman"> </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"> </font><font size=2 color=#1f497d face="Calibri"><br>
</font><font size=3 face="Times New Roman"> </font><font size=2 face="Tahoma"><b><br>
</b></font>
<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><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%><font size=3 face="Times New Roman"> </font>
<p>
<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"><br>
</font>
<p><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>
<p><font size=3 face="Times New Roman"><br>
<br>
</font><font size=2 color=#1f497d face="Calibri"><br>
<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"> </font><font size=2 color=#1f497d face="Calibri"><br>
<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">
</font><font size=2 color=#1f497d face="Calibri"><br>
<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"> </font><font size=2 face="Tahoma"><b><br>
<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">
</font><font size=2 face="Arial"><br>
<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_______________________________________________<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>
<p>