On Thu, Jun 14, 2012 at 6:23 PM, Ultrabyte <ultrab...@gmail.com> wrote: > Hi, Everybody! > > Operating system: Windows Server 2008 R2 - 64-bit > Java version: Oracle Java 7 update 3 > Database engine: Microsoft SQL Server 2008 R2 Enterprise > Web container: JBoss 7.1.0.Final > GeoServer version: 2.1.4 > Microsoft SQL Server JDBC driver version 4 > > > We want to add a new layer from a SQL Server 2008 datastore (with the > geometry datatype). However, when we try to calculate from the native > frame, we get the following stack trace:
The database is already telling you what the problem is and how to solve it): > Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 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. Cheers Andrea -- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 mob: +39 339 8844549 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users