I have some script which read .JSON files through .NET and then inserts the data into a SQL Server database. The data's Geometry is of the type esriGeometryPolyline ; basically, they are floor plans for Buildings.
So my script parses the data, massages it a bit and then:
SqlGeometry.STMLineFromText(sc, 3857);do the above line, then inserts into a database table. So far so good: The polylines do look okay inside SQL Server and they do render fine in a Javascript web application. Problem is that, once the data is inside the database server, any ArcMAP document is unable to render them inside ArcGIS Desktop: I get error like:
Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0][SQL Server]A .NET Framework error occurred during execution of user-defined routine or aggregate "geometry": System.ArgumentException: 24144: This operation cannot be completed because the instance is not valid. Use MakeValid to convert the instance to a valid instance. Note that MakeValid may cause the points of a geometry instance to shift slightly.System.ArgumentException: But if I execute the MakeValid() on the data in the server then the geometry loses some values though looks okay inside ArcGIS Desktop for the most part; but still enough of a loss.
Why is ArcGIS Desktop behaving like this one since the ArcGIS Server has no problem rendering the geometry in queries? I could live without seeing the geometry inside ArcGIS Desktop for the Floor Plans though it doesn't 'look' good to the team.
What are my options? My script can't be that bad but maybe missing something?
Thanks!
أكثر...
So my script parses the data, massages it a bit and then:
SqlGeometry.STMLineFromText(sc, 3857);do the above line, then inserts into a database table. So far so good: The polylines do look okay inside SQL Server and they do render fine in a Javascript web application. Problem is that, once the data is inside the database server, any ArcMAP document is unable to render them inside ArcGIS Desktop: I get error like:
Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0][SQL Server]A .NET Framework error occurred during execution of user-defined routine or aggregate "geometry": System.ArgumentException: 24144: This operation cannot be completed because the instance is not valid. Use MakeValid to convert the instance to a valid instance. Note that MakeValid may cause the points of a geometry instance to shift slightly.System.ArgumentException: But if I execute the MakeValid() on the data in the server then the geometry loses some values though looks okay inside ArcGIS Desktop for the most part; but still enough of a loss.
Why is ArcGIS Desktop behaving like this one since the ArcGIS Server has no problem rendering the geometry in queries? I could live without seeing the geometry inside ArcGIS Desktop for the Floor Plans though it doesn't 'look' good to the team.
What are my options? My script can't be that bad but maybe missing something?
Thanks!
أكثر...