[mapguide-users] SQL Server data visibility is intermittent

Warren Medernach wmedernach at gmail.com
Tue Nov 23 13:32:17 EST 2010


Hello all,

MGOS 2.2 (Version 2.2.0.4829)
Win XP & IIS (VM XP Mode)
SQL Server 2008 on host

I'm seeing some weirdness with data coming from SQL Server which I think
might be related to the Geography data type.
No data will show up at the initial map load zoom scale, but if I zoom in a
bit it will show up.
There are no display ranges set, and this is a very simple data set.

The error in the log file is as follows:

<2010-11-23T11:47:20> 372 Fusion Viewer 127.0.0.1 Anonymous
 Error: Failed to stylize layer: My_Layer_Name
        An exception occurred in FDO component.
        RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]A .NET
Framework error occurred during execution of user-defined routine or
aggregate "geography":
        System.FormatException: 24201: Latitude values must be between -90
and 90 degrees.
        System.FormatException:
           at
Microsoft.SqlServer.Types.GeographyValidator.ValidatePoint(Double x, Double
y, Nullable`1 z, Nullable`1 m)
           at Microsoft.SqlServer.Types.Validator.BeginFigure(Double x,
Double y, Nullable`1 z, Nullable`1 m)
           at Microsoft.SqlServer.Types.For
 StackTrace:
  - MgMappingUtil.StylizeLayers() line 831 file
c:\builds\mg22win32\mgdev\server\src\services\mapping\MappingUtil.cpp

There is no data outside -90 & 90, and when the table is viewed in the
SSMS Spatial Results view, the data resides between a bbox somewhere in the
neighborhood of: -160,-42 & 160, 70

If the original SHP data is used there are no display issues, and I can view
this data in a number of other viewers.

Any thoughts?

Warren M
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20101123/023f2c0c/attachment.html


More information about the mapguide-users mailing list