Hello all,<div><br></div><div>MGOS 2.2 (Version 2.2.0.4829)</div><div>Win XP & IIS (VM XP Mode)</div><div>SQL Server 2008 on host</div><div><br></div><div>I'm seeing some weirdness with data coming from SQL Server which I think might be related to the Geography data type.</div>
<div>No data will show up at the initial map load zoom scale, but if I zoom in a bit it will show up.</div><div>There are no display ranges set, and this is a very simple data set.</div>
<div><br></div><div>The error in the log file is as follows:</div><div><div><br></div><div><2010-11-23T11:47:20> <span style="white-space:pre-wrap"> </span>372<span style="white-space:pre-wrap"> </span>Fusion Viewer<span style="white-space:pre-wrap"> </span>127.0.0.1<span style="white-space:pre-wrap"> </span>Anonymous</div>
<div> Error: Failed to stylize layer: My_Layer_Name</div><div> An exception occurred in FDO component.</div><div> RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]A .NET Framework error occurred during execution of user-defined routine or aggregate "geography": </div>
<div> System.FormatException: 24201: Latitude values must be between -90 and 90 degrees.</div><div> System.FormatException: </div><div> at Microsoft.SqlServer.Types.GeographyValidator.ValidatePoint(Double x, Double y, Nullable`1 z, Nullable`1 m)</div>
<div> at Microsoft.SqlServer.Types.Validator.BeginFigure(Double x, Double y, Nullable`1 z, Nullable`1 m)</div><div> at Microsoft.SqlServer.Types.For </div><div> StackTrace:</div><div> - MgMappingUtil.StylizeLayers() line 831 file c:\builds\mg22win32\mgdev\server\src\services\mapping\MappingUtil.cpp<span style="white-space:pre-wrap"> </span></div>
</div><div><span style="white-space:pre-wrap"><br></span></div><div>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</div>
<div><br></div><div>If the original SHP data is used there are no display issues, and I can view this data in a number of other viewers.</div><div><br></div><div>Any thoughts?</div><div><br>Warren M</div>