Hi,
I don't know if providing it it's going to actually help, but for sure
there is not enough context in your request. Please add:
- The OGC request you're making to GeoServer
- The SQL request GeoServer is issuing to the database (you can enable
"geotools developer logging" mode in the "global" panel and you'll find it
in the logs)
- The full stack trace of the error, that you can also get from the
GeoServer logs
That said, I don't have a SQL Server installation handy, but I tried to
validate the same geometry in PostGIS, and it thinks it is not valid:
> select st_isvalid(st_geomfromtext('POLYGON ((251729.71818420664
663642.27516417392, 251737.16999236215 663675.93147614226,
251736.05000000075 663671.05000000261, 251733.30000000075
663658.70000000112, 251729.71818420664 663642.27516417392,
251778.8949488923 663869.33735286258, 251784.39623646997
663897.91224282794, 251788.81305164937 663917.50764289685,
251789.26829153579 663919.79648787156, 251790.81104892213
663926.43540285528, 251797.14685532823 663951.088215299, 251797.717841235
663953.59133009054, 251797.91083160695 663954.20343570039,
251797.60439161211 663952.86850268207, 251798.1090213405
663954.83203207515, 251797.91083160695 663954.20343570039,
251810.35915837344 664009.93517630547, 251825.91792506818 664078.955976164,
251793.36404170096 664078.432479497, 251766.30091485195 664077.898934016,
251746.50783845782 664080.4618418254, 251735.20054437779 664076.799248796,
251735.1500000013 664076.80000000075, 251715.13197696209
664073.63398755714, 251659.19260758348 664058.6568582356, 251655.7016652422
664060.8038274385, 251645.70040612668 664066.90208183043, 251630.25
664076.00000000186, 251621.45000000112 664081.4000000041,
251611.60000000056 664087.44999999925, 251608.05000000075
664089.60000000149, 251609.20000000205 664094.90000000224,
251610.1500000013 664098.70000000112, 251611.4000000013 664103.30000000075,
251612.60000000056 664107.20000000112, 251613.34999999963
664109.15000000037, 251615.03654772323 664113.17183106579,
251615.80381457415 664112.69897260517, 251617.19722989947 664115.798085494,
251631.09840291645 664146.2993545942, 251611.09588468541 664154.3970366586,
251564.9977480676 664166.90345673636, 251543.29674725048
664177.30048061721, 251522.40376241971 664189.79690355249,
251414.5006477898 664268.10448824055, 251410.40000000224
664270.95000000112, 251449.59987289645 664328.397229623, 251480.12754900754
664446.69986129366, 251473.00000000093 664449.30000000075,
251470.60000000056 664450.200000003, 251466.9000000013 664451.94999999925,
251463.30000000075 664453.84999999963, 251459.20000000205
664456.30000000261, 251454.85000000056 664458.90000000037,
251451.76101656072 664461.08690432645, 251448.09927177616 664464.398299722,
251402.25 664528.80000000261, 251399.30000000168 664532.75,
251395.1500000013 664537.75, 251390.20245272573 664541.89611620083,
251384.70000000019 664548.85000000149, 251382.85000000149
664550.69999999925, 251376.95000000019 664556.30000000075,
251375.60000000056 664557.45000000112, 251371.14999999944
664561.19999999925, 251368.55000000075 664563.25000000186,
251365.40000000037 664565.45000000112, 251361.35000000056
664568.05000000261, 251354.85000000056 664572.15000000224,
251350.6500000013 664574.55000000075, 251348.45000000205
664575.59999999963, 251344.04999999981 664577.44999999925,
251340.35000000056 664578.84999999963, 251334.5 664580.80000000447,
251329.95000000019 664582.05000000075, 251328.50000000093
664582.40000000224, 251322.00000000093 664583.65000000037,
251318.1500000013 664584.30000000261, 251313.59999999963
664584.94999999925, 251306.75 664585.75000000373, 251301.4000000013
664586.30000000261, 251296.80000000075 664586.55000000261,
251292.95000000112 664586.50000000186, 251289.25000000093
664586.30000000261, 251287.1500000013 664586.09999999963, 251284.4000000013
664585.75000000373, 251282.34999999963 664585.35000000149,
251191.35000000149 664563.75, 251110.99994865805 664544.79528632388,
251158.40080493037 664724.10395974852, 251123.30157982092
664892.6957008671, 251086.89963505976 665053.0997856725, 251068.00195501465
665122.89980562776, 251069.99725980312 665128.4982031025, 251068.8017259445
665136.39594239555, 251129.3039843021 665135.09631441347, 251221.0962495422
665128.19828895293, 251241.7006572336 665125.79897574894,
251274.69739176054 665117.9012364503, 251340.09721641336
665140.40479487553, 251344.20325684082 665137.09574208036,
251449.30305069778 665116.20172293484, 251581.19929313287
665096.29742048122, 251635.1961982837 665081.30171295814,
251844.90108232945 665038.803877838, 251926.50245204661 665018.09980431385,
252000.09786743391 665001.60452603921, 252078.79697564431
664988.39830627851, 252128.10244102962 665088.89953809977,
252209.49768421985 665264.39930181764, 252278.59954130743
665430.60172686726, 252299.59971193131 665491.20437953994, 252319.80011163
665526.10438951291, 252361.80045288056 665592.29544252157,
252608.20410388429 665883.40211410448, 252600.99792048428
665899.99736376107, 252592.29938102141 665921.10132282041,
252586.99780673441 665928.59917658009, 252196.80029012263
666207.5993136242, 252155.44139252417 666293.11491403542,
252118.49694484659 666369.50296918117, 252107.49803333823
666398.10478199832, 252078.30227197893 666490.39836323448,
251923.79807200562 666531.89648452215, 251908.80030586291
666621.20092139579, 252038.0004133163 666975.89939001016,
252000.09786743391 666986.096471129, 251982.09889905155 666997.30326321907,
252084.19749066606 667313.60272344016, 251977.30027349014
667408.0956751164, 251967.10113290884 667580.69626870751,
251965.60053178761 667604.79936926626, 251956.70411085896
667755.59620412253, 252382.83868555632 667383.61591141671,
252628.08911191579 667186.11335567012, 252853.80631847773
667012.4847352393, 253157.65640423354 666806.3007484749, 253201.06355934311
666780.25645541213, 253250.98178771697 666771.57502439059,
253400.73647284135 666665.22749437578, 253457.1657744823 666615.309266001,
253570.02437776234 666552.36889109388, 253724.1197783947
666489.42851618864, 253834.80802392028 666478.57672740892,
253893.40768331755 666448.19171883725, 254123.46560539026
666413.46599474736, 254205.93920009583 666406.95492148027,
254245.00563969184 666415.63635250181, 254442.50819543563
666393.93277494982, 254762.63596435729 666346.18490432948,
254899.3685029475 666309.28882248513, 255051.29354582541
666255.02987860329, 255183.68536890484 666194.25986144878,
255303.05504545104 666118.29734001122, 255284.66294311918 665805.119392613,
255272.39548674226 665809.43715188466, 255279.32314546593
665768.5639654249, 255273.08825261518 665746.39545751177, 255248.841447087
665720.76312023588, 255178.87209398951 665690.281421857, 255052.09593936987
665650.79376713932, 254899.11014258396 665597.98961287923,
254888.0258886274 665597.98961287923, 254874.47846712545
665519.16825141571, 254848.61520789564 665453.89431145415,
254823.98353243712 665350.44127452932, 254842.303341059 665340.8965002913,
254739.77399196755 665090.577098459, 254658.48946295865 664789.45486599021,
254493.90937184915 664458.64061249979, 255592.19574239291
664223.42130024172, 256256.57055412605 664079.05604182, 256252.66129015759
664026.93252224661, 256264.10452565271 663982.7943281997,
256288.62574456912 663945.19512586109, 256318.05120726675
663904.3264276702, 256267.37402150873 663878.17046082579,
256151.30691864342 663806.24155200832, 256064.665278472 663734.31264318712,
255964.94565488491 663614.97604446486, 255893.01674606465
663544.68188357353, 255611.84010250028 663323.9909133371,
255521.92896647751 663261.87049208209, 255427.11358667072
663224.27128974907, 255299.60324831028 663184.32213726081,
255114.77456073277 663129.1493947003, 254960.37602468673
663080.99244533293, 254926.11443270184 663064.16816457734,
254833.45988535695 663002.70049683563, 254726.31209711637
662933.73180555366, 254593.30104964692 662849.98410899937,
254535.41661232244 662814.26817958429, 254479.99534254242
662789.63650412858, 254414.72140258085 662767.46799621545,
254355.60538148321 662756.38374226168, 254298.95252793096
662752.68899093941, 254239.83650683332 662756.38374226168,
254173.33098309673 662767.46799621545, 254106.82545936387
662788.40492035449, 254045.24627071898 662819.19451467507,
253991.05658471212 662857.37361163832, 253939.3300662525
662902.94221122935, 253874.05612629093 662973.14248628542,
253830.33490235359 663018.71108588018, 253785.99788652919
663053.19543152116, 253740.4292869335 663083.98502584174,
253678.85009828862 663117.23778770864, 253623.42882851046 663135.711544307,
253569.23914250359 663149.258965807, 253503.96520254202 663164.03797107935,
253468.24927312881 663171.42747371644, 253386.96474411897
663197.29073294625, 253324.15397170279 663225.61715972424,
253249.02736155596 663263.7962566819, 253198.5324268695 663288.42793214135,
253145.57432463393 663308.13327250257, 253110.47418710869 663320.449110236,
253040.27391205449 663338.92286682874, 252983.62105850224
663353.70187210292, 252936.82087513339 663373.40721246973,
252896.17861063033 663393.11255283467, 252855.53634612449
663417.74422829039, 252814.89408161957 663448.53382261656,
252769.32548202388 663489.17608711682, 252723.75688242633
663528.58676784858, 252692.96728810575 663553.218443308, 252637.54601832759
663588.93437271938, 252584.58791609202 663612.33446440659,
252542.71406781487 663627.11346968077, 252483.59804671723
663640.66089118272, 252425.71360939182 663645.58722627349,
252367.82917206828 663645.58722627349, 252298.86048078537
663635.73455609381, 252237.28129214328 663618.49238326959,
252139.98617408518 663585.2396214027, 251816.69543370605
663474.39708184637, 251708.40508367308 663435.41255583242,
251713.30166209396 663450.59849689528, 251710.10257838666
663459.59592141025, 251704.0012331726 663529.09602721408,
251729.71818420664 663642.27516417392))'));
NOTICE: Ring Self-intersection at or near point 251797.91083160695
663954.20343570039
st_isvalid
------------
f
(1 row)
Cheers
Andrea
On Sat, Nov 10, 2018 at 8:18 AM Yachtmaster <[email protected]> wrote:
> Hi all,
>
>
>
> I am getting the following error for some of the geometry in one of my
> layers:
>
>
>
> "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."
>
>
>
> I have checked that all the polygons in the SQL Server table are valid
> (indeed three separate people in three separate organisations have done
> this).
>
>
>
> An example Polygon that will display in GeoServer and an example polygon
> that will not display can be found here:
>
>
>
> https://drive.google.com/open?id=1ZaI2_JoPsqqpzrocdbduuCSrFHcoSVnw
>
>
>
> Best wishes,
>
> Mike
> _______________________________________________
> Geoserver-users mailing list
>
> Please make sure you read the following two resources before posting to
> this list:
> - Earning your support instead of buying it, but Ian Turton:
> http://www.ianturton.com/talks/foss4g.html#/
> - The GeoServer user list posting guidelines:
> http://geoserver.org/comm/userlist-guidelines.html
>
> If you want to request a feature or an improvement, also see this:
> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>
>
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
--
Regards, Andrea Aime == GeoServer Professional Services from the experts!
Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime
@geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054
Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339
8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it
------------------------------------------------------- *Con riferimento
alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 -
Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni
circostanza inerente alla presente email (il suo contenuto, gli eventuali
allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i
destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per
errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le
sarei comunque grato se potesse darmene notizia. This email is intended
only for the person or entity to which it is addressed and may contain
information that is privileged, confidential or otherwise protected from
disclosure. We remind that - as provided by European Regulation 2016/679
“GDPR” - copying, dissemination or use of this e-mail or the information
herein by anyone other than the intended recipient is prohibited. If you
have received this email by mistake, please notify us immediately by
telephone or e-mail.*
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
