Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Microsoft.SqlServer.Types.SqlGeometry.MakeValid() method cause out of memory exception

Unanswered Microsoft.SqlServer.Types.SqlGeometry.MakeValid() method cause out of memory exception

  • Wednesday, February 20, 2013 3:00 AM
     
      Has Code
    Sign In to Vote
    0

    Hi,

    I'm using the Microsoft.SqlServer.Types in C#, but when I try to use the MakeValid method, the memory goes up to several giga bytes and crashed. Here is my code to test

    SqlGeometry.STGeomFromWKB(new SqlBytes(wellKnownBinary), 0).MakeValid()

    The Base64String of the wellKnownBinary is 

    "AQIAAAC/AgAAO0xdbn+gNsD2KFyPwjUZQNBpA502oDbAi0YCvnk1GUAGW7AFW6A2wPYoXI/CNRlAO0xdbn+gNsD2KFyPwjUZQEGnDXTaoDbAN9BpA502GUCsiWdFI6E2wOJZ0UjANxlAF2zBFmyhNsBkqOwwdTkZQBdswRZsoTbA+cWSXyw5GUDhehSuR6E2wCMB37yaOBlArIlnRSOhNsDiWdFIwDcZQDtMXW5/oDbA9ihcj8I1GUA7TF1uf6A2wGELtmALNhlAoNMGOm2gNsD2KFyPwjUZQAZbsAVboDbA9ihcj8I1GUCg0wY6baA2wPYoXI/CNRlA1sSzopGgNsD2KFyPwjUZQAZbsAVboDbA9ihcj8I1GUBr4lnRSKA2wItGAr55NRlABluwBVugNsD2KFyPwjUZQGviWdFIoDbA9ihcj8I1GUCbeFY0EqA2wItGAr55NRlAimdFIwGfNsATz4pGAj4ZQOQ4juM4njbAorLD1OU2GUDpkz7pk542wEqf9EmfNBlAVHaYutyeNsBKn/RJnzQZQIpnRSMBnzbASp/0SZ80GUC5/UGGyp42wEqf9EmfNBlA7+7u7u6eNsC1gU4b6DQZQFR2mLrcnjbAtYFOG+g0GUDv7u7u7p42wEqf9EmfNBlAimdFIwGfNsBKn/RJnzQZQLn9QYbKnjbASp/0SZ80GUAfhetRuJ42wEqf9EmfNBlAVHaYutyeNsD2KFyPwjUZQGWHqcvtnzbAjuM4juM4GUAqO0xdbp82wCBkqOwwNRlAeVY0EvCdNsCLRgK+eTUZQKjsMHW5nTbAzO0PMlQ2GUDe3d3d3Z02wPYoXI/CNRlAGSo7TF2eNsC1gU4b6DQZQH6x5BdLnjbAtYFOG+g0GUCEDJUdpp42wEqf9EmfNBlAH4XrUbieNsBKn/RJnzQZQCTgm1cTnzbASp/0SZ80GUAk4JtXE582wEqf9EmfNBlAhAyVHaaeNsBKn/RJnzQZQBkqO0xdnjbAtYFOG+g0GUDkOI7jOJ42wLWBThvoNBlAuf1BhsqeNsBKn/RJnzQZQE8b6LSBnjbASp/0SZ80GUCEDJUdpp42wEqf9EmfNBlAJOCbVxOfNsBKn/RJnzQZQI/C9ShcnzbAtYFOG+g0GUDFs6KRgJ82wCBkqOwwNRlAyw5Tl9ufNsD2KFyPwjUZQDXxrGgkoDbAorLD1OU2GUCg0wY6baA2wI7jOI7jOBlAm3hWNBKgNsA30GkDnTYZQFrRSMA3nzbAtYFOG+g0GUAk4JtXE582wEqf9EmfNBlAKjtMXW6fNsC1gU4b6DQZQMWzopGAnzbAIGSo7DA1GUAqO0xdbp82wLWBThvoNBlAZYepy+2fNsBhC7ZgCzYZQNBpA502oDbADZUdpi43GUAAAAAAAKA2wMztDzJUNhlAMJb8YsmfNsD2KFyPwjUZQNBpA502oDbADZUdpi43GUCg0wY6baA2wCMB37yaOBlA1sSzopGgNsClT/qkTzoZQAZbsAVboDbAuB6F61E4GUA18axoJKA2wKKyw9TlNhlAa+JZ0UigNsDiWdFIwDcZQKDTBjptoDbAIwHfvJo4GUDWxLOikaA2wCeeFY0EPBlA1sSzopGgNsDm9gcZKjsZQNbEs6KRoDbApU/6pE86GUA7TF1uf6A2wD0K16NwPRlAj8L1KFyfNsBYE8+KRkIZQBkqO0xdnjbAWBPPikZCGUAqO0xdbp82wO0wdbn9QRlAZYepy+2fNsDWxLOikUAZQGWHqcvtnzbArIlnRSNBGUCg0wY6baA2wBPPikYCPhlA1sSzopGgNsB7FK5H4ToZQGviWdFIoDbA4lnRSMA3GUBlh6nL7Z82wPYoXI/CNRlAAAAAAACgNsDM7Q8yVDYZQNBpA502oDbAorLD1OU2GUAGW7AFW6A2wE08KxoJOBlABluwBVugNsBNPCsaCTgZQKDTBjptoDbAIwHfvJo4GUCg0wY6baA2wLgehetROBlA0GkDnTagNsANlR2mLjcZQAAAAAAAoDbAzO0PMlQ2GUCbeFY0EqA2wMztDzJUNhlANfGsaCSgNsA30GkDnTYZQMsOU5fbnzbA9ihcj8I1GUAAAAAAAKA2wMztDzJUNhlA0GkDnTagNsCissPU5TYZQGWHqcvtnzbAYQu2YAs2GUBr4lnRSKA2wHd3d3d3NxlAoNMGOm2gNsAjAd+8mjgZQDXxrGgkoDbAorLD1OU2GUA18axoJKA2wDfQaQOdNhlA0GkDnTagNsCissPU5TYZQGWHqcvtnzbAYQu2YAs2GUBlh6nL7Z82wPYoXI/CNRlA+qRP+qSfNsAgZKjsMDUZQGWHqcvtnzbA9ihcj8I1GUBr4lnRSKA2wA2VHaYuNxlAAAAAAACgNsBhC7ZgCzYZQDCW/GLJnzbAi0YCvnk1GUAwlvxiyZ82wItGAr55NRlAAAAAAACgNsBhC7ZgCzYZQAAAAAAAoDbAYQu2YAs2GUAAAAAAAKA2wGELtmALNhlAyw5Tl9ufNsD2KFyPwjUZQDXxrGgkoDbAN9BpA502GUA7TF1uf6A2wCMB37yaOBlABluwBVugNsDiWdFIwDcZQNBpA502oDbAorLD1OU2GUCg0wY6baA2wE08KxoJOBlAO0xdbn+gNsAjAd+8mjgZQNbEs6KRoDbAOm2g0wY6GUDWxLOikaA2wGhFIwHfPBlAO0xdbn+gNsATz4pGAj4ZQJt4VjQSoDbAQacNdNpAGUCVHaYut582wIJOG+i0QRlAm3hWNBKgNsBBpw102kAZQGviWdFIoDbAAAAAAABAGUCg0wY6baA2wFR2mLrcPhlAO0xdbn+gNsATz4pGAj4ZQHE9CtejoDbAUdlh6nI7GUBxPQrXo6A2wLy7u7u7OxlAcT0K16OgNsCSgG9eTTwZQDtMXW5/oDbAfrHkF0s+GUCg0wY6baA2wFR2mLrcPhlA0GkDnTagNsBr4lnRSEAZQNBpA502oDbAa+JZ0UhAGUAGW7AFW6A2wJUdpi63PxlA0GkDnTagNsBr4lnRSEAZQNBpA502oDbAa+JZ0UhAGUDQaQOdNqA2wGviWdFIQBlANfGsaCSgNsDWxLOikUAZQJt4VjQSoDbAQacNdNpAGUA18axoJKA2wEGnDXTaQBlANfGsaCSgNsDWxLOikUAZQJUdpi63nzbA7TB1uf1BGUBa0UjAN582wMP1KFyPQhlAv1jyiyWfNsDD9Shcj0IZQFR2mLrcnjbALtiCLdhCGUC5/UGGyp42wC7Ygi3YQhlAJOCbVxOfNsAu2IIt2EIZQFR2mLrcnjbALtiCLdhCGUBa0UjAN582wMP1KFyPQhlAj8L1KFyfNsBYE8+KRkIZQDXxrGgkoDbA1sSzopFAGUDWxLOikaA2wGhFIwHfPBlA1sSzopGgNsA6baDTBjoZQNbEs6KRoDbAZKjsMHU5GUBxPQrXo6A2wHsUrkfhOhlA1sSzopGgNsCo7DB1uT0ZQJt4VjQSoDbAQacNdNpAGUD6pE/6pJ82wO0wdbn9QRlAxbOikYCfNsBYE8+KRkIZQMsOU5fbnzbAF2zBFmxBGUBlh6nL7Z82wBdswRZsQRlA1sSzopGgNsCo7DB1uT0ZQDtMXW5/oDbAIwHfvJo4GUAGW7AFW6A2wE08KxoJOBlA1sSzopGgNsA6baDTBjoZQDtMXW5/oDbAjuM4juM4GUBxPQrXo6A2wGhFIwHfPBlA+qRP+qSfNsDtMHW5/UEZQOQ4juM4njbAWBPPikZCGUDe3d3d3Z02wBdswRZsQRlAScA3ryaeNsDtMHW5/UEZQLSikYBvnjbAWBPPikZCGUDv7u7u7p42wMP1KFyPQhlAcT0K16OgNsDm9gcZKjsZQDtMXW5/oDbAIwHfvJo4GUA7TF1uf6A2wCMB37yaOBlAoNMGOm2gNsAjAd+8mjgZQHE9CtejoDbA5vYHGSo7GUCbeFY0EqA2wNbEs6KRQBlAfrHkF0ueNsBYE8+KRkIZQN7d3d3dnTbAF2zBFmxBGUDe3d3d3Z02wBdswRZsQRlArkfhehSeNsCCThvotEEZQIQMlR2mnjbAWBPPikZCGUDLDlOX2582wJUdpi63PxlAcT0K16OgNsDm9gcZKjsZQAZbsAVboDbA4lnRSMA3GUBr4lnRSKA2wOJZ0UjANxlABluwBVugNsDiWdFIwDcZQNbEs6KRoDbAOm2g0wY6GUDWxLOikaA2wP1iyS+WPBlANfGsaCSgNsDWxLOikUAZQH6x5BdLnjbAWBPPikZCGUA9CtejcJ02wCo7TF1uPxlAeVY0EvCdNsCsiWdFI0EZQCTgm1cTnzbArIlnRSNBGUAGW7AFW6A2wKjsMHW5PRlABluwBVugNsBNPCsaCTgZQJt4VjQSoDbAzO0PMlQ2GUDLDlOX2582wPYoXI/CNRlAMJb8YsmfNsCLRgK+eTUZQPqkT/qknzbAIGSo7DA1GUCVHaYut582wItGAr55NRlAMJb8YsmfNsD2KFyPwjUZQNBpA502oDbAorLD1OU2GUBlh6nL7Z82wGELtmALNhlAZYepy+2fNsBhC7ZgCzYZQMsOU5fbnzbA9ihcj8I1GUAAAAAAAKA2wGELtmALNhlAMJb8YsmfNsCLRgK+eTUZQDCW/GLJnzbAi0YCvnk1GUA18axoJKA2wDfQaQOdNhlA0GkDnTagNsCissPU5TYZQKDTBjptoDbAuB6F61E4GUA7TF1uf6A2wI7jOI7jOBlAcT0K16OgNsBR2WHqcjsZQGviWdFIoDbAlR2mLrc/GUDLDlOX2582wBdswRZsQRlAj8L1KFyfNsBYE8+KRkIZQDCW/GLJnzbAF2zBFmxBGUCbeFY0EqA2wGviWdFIQBlA1sSzopGgNsAnnhWNBDwZQDtMXW5/oDbAIwHfvJo4GUDWxLOikaA2wM+KRgK+ORlA1sSzopGgNsClT/qkTzoZQHE9CtejoDbAvLu7u7s7GUCg0wY6baA2wFR2mLrcPhlANfGsaCSgNsBr4lnRSEAZQDCW/GLJnzbAF2zBFmxBGUAk4JtXE582wMP1KFyPQhlA7+7u7u6eNsDD9Shcj0IZQO/u7u7unjbAw/UoXI9CGUDpkz7pk542wMP1KFyPQhlAVHaYutyeNsDD9Shcj0IZQGAs+cWSnzbA7TB1uf1BGUDFs6KRgJ82wO0wdbn9QRlAv1jyiyWfNsDD9Shcj0IZQPVJn/RJnzbAWBPPikZCGUCKZ0UjAZ82wFgTz4pGQhlAScA3ryaeNsDtMHW5/UEZQKjsMHW5nTbAQacNdNpAGUDv7u7u7p42wMP1KFyPQhlAH4XrUbieNsDD9Shcj0IZQH6x5BdLnjbAWBPPikZCGUDe3d3d3Z02wKyJZ0UjQRlAQ2WHqcudNsBBpw102kAZQENlh6nLnTbAQacNdNpAGUAZKjtMXZ42wEGnDXTaQBlA2IIt2IKdNsAAAAAAAEAZQAgZKjtMnTbAqOwwdbk9GUCo7DB1uZ02wNInfdInPRlAtKKRgG+eNsC/WPKLJT8ZQIQMlR2mnjbArIlnRSNBGUD1SZ/0SZ82wKyJZ0UjQRlAKjtMXW6fNsAXbMEWbEEZQPVJn/RJnzbAWBPPikZCGUB+seQXS542wFgTz4pGQhlAfrHkF0ueNsBYE8+KRkIZQENlh6nLnTbAQacNdNpAGUDe3d3d3Z02wJUdpi63PxlATxvotIGeNsCVHaYutz8ZQLSikYBvnjbA1sSzopFAGUBJwDevJp42wJUdpi63PxlAE8+KRgKeNsCsiWdFI0EZQHlWNBLwnTbArIlnRSNBGUBz+4MMlZ02wGviWdFIQBlAGSo7TF2eNsBYE8+KRkIZQFrRSMA3nzbA7TB1uf1BGUBJwDevJp42wO0wdbn9QRlAQ2WHqcudNsCsiWdFI0EZQKjsMHW5nTbAlR2mLrc/GUDpkz7pk542wKjsMHW5PRlAYCz5xZKfNsAjAd+8mjgZQCo7TF1unzbAi0YCvnk1GUD1SZ/0SZ82wLWBThvoNBlAj8L1KFyfNsDM7Q8yVDYZQCo7TF1unzbA9ihcj8I1GUDv7u7u7p42wItGAr55NRlAv1jyiyWfNsDM7Q8yVDYZQPVJn/RJnzbA+cWSXyw5GUC/WPKLJZ82wBAyVHaYOhlAxbOikYCfNsCSgG9eTTwZQGWHqcvtnzbA6ZM+6ZM+GUBlh6nL7Z82wKjsMHW5PRlANfGsaCSgNsAjAd+8mjgZQJUdpi63nzbAzO0PMlQ2GUBlh6nL7Z82wGELtmALNhlAYCz5xZKfNsCLRgK+eTUZQDCW/GLJnzbAorLD1OU2GUA18axoJKA2wGSo7DB1ORlABluwBVugNsC8u7u7uzsZQJt4VjQSoDbAKjtMXW4/GUCVHaYut582wGviWdFIQBlA+qRP+qSfNsCsiWdFI0EZQCo7TF1unzbAgk4b6LRBGUCbeFY0EqA2wKjsMHW5PRlANfGsaCSgNsANlR2mLjcZQMWzopGAnzbAIGSo7DA1GUBgLPnFkp82wItGAr55NRlA+qRP+qSfNsD2KFyPwjUZQGAs+cWSnzbAi0YCvnk1GUCbeFY0EqA2wA2VHaYuNxlAm3hWNBKgNsDiWdFIwDcZQFrRSMA3nzbAWBPPikZCGUAZKjtMXZ42wFgTz4pGQhlAQ2WHqcudNsBBpw102kAZQENlh6nLnTbA1sSzopFAGUBJwDevJp42wOmTPumTPhlAQ2WHqcudNsA9CtejcD0ZQKjsMHW5nTbAVHaYutw+GUDe3d3d3Z02wCo7TF1uPxlA3t3d3d2dNsB+seQXSz4ZQKjsMHW5nTbAv1jyiyU/GUB+seQXS542wO0wdbn9QRlAv1jyiyWfNsBYE8+KRkIZQPVJn/RJnzbAWBPPikZCGUD1SZ/0SZ82wO0wdbn9QRlAKjtMXW6fNsDtMHW5/UEZQCTgm1cTnzbAWBPPikZCGUBJwDevJp42wBPPikYCPhlAc/uDDJWdNsC4HoXrUTgZQD0K16NwnTbA4lnRSMA3GUDYgi3Ygp02wOJZ0UjANxlADnTaQKedNsDiWdFIwDcZQD0K16NwnTbATTwrGgk4GUAIGSo7TJ02wPnFkl8sORlACBkqO0ydNsAjAd+8mjgZQNiCLdiCnTbAd3d3d3c3GUATz4pGAp42wItGAr55NRlAGSo7TF2eNsC1gU4b6DQZQE8b6LSBnjbASp/0SZ80GUCEDJUdpp42wEqf9EmfNBlAuf1BhsqeNsBKn/RJnzQZQFR2mLrcnjbASp/0SZ80GUDv7u7u7p42wEqf9EmfNBlA7+7u7u6eNsBKn/RJnzQZQO/u7u7unjbA37yaeFY0GUCKZ0UjAZ82wN+8mnhWNBlAWtFIwDefNsBKn/RJnzQZQPVJn/RJnzbASp/0SZ80GUBa0UjAN582wEqf9EmfNBlAj8L1KFyfNsC1gU4b6DQZQL9Y8oslnzbASp/0SZ80GUBa0UjAN582wEqf9EmfNBlAWtFIwDefNsBKn/RJnzQZQCTgm1cTnzbASp/0SZ80GUCPwvUoXJ82wEqf9EmfNBlAYCz5xZKfNsAgZKjsMDUZQDCW/GLJnzbAi0YCvnk1GUCVHaYut582wItGAr55NRlAlR2mLrefNsCLRgK+eTUZQGWHqcvtnzbAYQu2YAs2GUDQaQOdNqA2wKKyw9TlNhlABluwBVugNsDiWdFIwDcZQNbEs6KRoDbAz4pGAr45GUDWxLOikaA2wGhFIwHfPBlAO0xdbn+gNsCo7DB1uT0ZQNbEs6KRoDbAaEUjAd88GUDWxLOikaA2wP1iyS+WPBlA1sSzopGgNsDm9gcZKjsZQNbEs6KRoDbAOm2g0wY6GUBxPQrXo6A2wHsUrkfhOhlA1sSzopGgNsBoRSMB3zwZQKDTBjptoDbAv1jyiyU/GUAwlvxiyZ82wIJOG+i0QRlA9Umf9EmfNsDD9Shcj0IZQI/C9ShcnzbAWBPPikZCGUD1SZ/0SZ82wMP1KFyPQhlA7+7u7u6eNsAu2IIt2EIZQO/u7u7unjbALtiCLdhCGUAk4JtXE582wMP1KFyPQhlAJOCbVxOfNsDD9Shcj0IZQPVJn/RJnzbAWBPPikZCGUD1SZ/0SZ82wMP1KFyPQhlAWtFIwDefNsDD9Shcj0IZQFrRSMA3nzbAw/UoXI9CGUC5/UGGyp42wMP1KFyPQhlAv1jyiyWfNsDD9Shcj0IZQFrRSMA3nzbAw/UoXI9CGUDv7u7u7p42wC7Ygi3YQhlAimdFIwGfNsDD9Shcj0IZQFR2mLrcnjbALtiCLdhCGUAk4JtXE582wMP1KFyPQhlAJOCbVxOfNsDD9Shcj0IZQFR2mLrcnjbALtiCLdhCGUBPG+i0gZ42wMP1KFyPQhlAfrHkF0ueNsBYE8+KRkIZQLSikYBvnjbAw/UoXI9CGUAZKjtMXZ42wFgTz4pGQhlArkfhehSeNsDtMHW5/UEZQK5H4XoUnjbA7TB1uf1BGUDkOI7jOJ42wFgTz4pGQhlArkfhehSeNsDtMHW5/UEZQLSikYBvnjbAw/UoXI9CGUB+seQXS542wFgTz4pGQhlAGSo7TF2eNsBYE8+KRkIZQLSikYBvnjbAw/UoXI9CGUBPG+i0gZ42wMP1KFyPQhlAfrHkF0ueNsBYE8+KRkIZQEnAN68mnjbA7TB1uf1BGUB5VjQS8J02wIJOG+i0QRlA3t3d3d2dNsAXbMEWbEEZQHlWNBLwnTbAgk4b6LRBGUB5VjQS8J02wIJOG+i0QRlAE8+KRgKeNsCCThvotEEZQH6x5BdLnjbAWBPPikZCGUAZKjtMXZ42wFgTz4pGQhlAfrHkF0ueNsBYE8+KRkIZQOQ4juM4njbA7TB1uf1BGUB+seQXS542wFgTz4pGQhlA6ZM+6ZOeNsDD9Shcj0IZQE8b6LSBnjbAWBPPikZCGUAZKjtMXZ42wFgTz4pGQhlAfrHkF0ueNsBYE8+KRkIZQK5H4XoUnjbA7TB1uf1BGUB5VjQS8J02wIJOG+i0QRlAE8+KRgKeNsCCThvotEEZQN7d3d3dnTbArIlnRSNBGUBz+4MMlZ02wGviWdFIQBlAqOwwdbmdNsBBpw102kAZQENlh6nLnTbAQacNdNpAGUDYgi3Ygp02wJUdpi63PxlAo5GAb16dNsBUdpi63D4ZQAgZKjtMnTbAPQrXo3A9GUCjkYBvXp02wH6x5BdLPhlADnTaQKedNsBr4lnRSEAZQBPPikYCnjbAgk4b6LRBGUBJwDevJp42wIJOG+i0QRlA6ZM+6ZOeNsDD9Shcj0IZQCo7TF1unzbA7TB1uf1BGUBUdpi63J42wMP1KFyPQhlAScA3ryaeNsDWxLOikUAZQD0K16NwnTbAJ54VjQQ8GUBJwDevJp42wCBkqOwwNRlAv1jyiyWfNsBKn/RJnzQZQMWzopGAnzbAtYFOG+g0GUCVHaYut582wItGAr55NRlAlR2mLrefNsAgZKjsMDUZQGAs+cWSnzbAIGSo7DA1GUBlh6nL7Z82wGELtmALNhlAMJb8YsmfNsCLRgK+eTUZQGWHqcvtnzbAYQu2YAs2GUA18axoJKA2wDfQaQOdNhlAlR2mLrefNsCLRgK+eTUZQPqkT/qknzbAIGSo7DA1GUAwlvxiyZ82wItGAr55NRlAAAAAAACgNsDM7Q8yVDYZQGviWdFIoDbA4lnRSMA3GUCg0wY6baA2wI7jOI7jOBlAO0xdbn+gNsDPikYCvjkZQHE9CtejoDbAUdlh6nI7GUAGW7AFW6A2wCo7TF1uPxlAj8L1KFyfNsBYE8+KRkIZQE8b6LSBnjbAw/UoXI9CGUBPG+i0gZ42wMP1KFyPQhlA7+7u7u6eNsDD9Shcj0IZQL9Y8oslnzbAw/UoXI9CGUCPwvUoXJ82wFgTz4pGQhlAZYepy+2fNsCsiWdFI0EZQGWHqcvtnzbArIlnRSNBGUCbeFY0EqA2wNbEs6KRQBlAa+JZ0UigNsAqO0xdbj8ZQJt4VjQSoDbA1sSzopFAGUAwlvxiyZ82wBdswRZsQRlAxbOikYCfNsDtMHW5/UEZQFR2mLrcnjbAw/UoXI9CGUBPG+i0gZ42wMP1KFyPQhlA6ZM+6ZOeNsDD9Shcj0IZQFR2mLrcnjbAw/UoXI9CGUD1SZ/0SZ82wFgTz4pGQhlAYCz5xZKfNsDtMHW5/UEZQMsOU5fbnzbAF2zBFmxBGUCbeFY0EqA2wEGnDXTaQBlA0GkDnTagNsBr4lnRSEAZQIpnRSMBnzbAw/UoXI9CGUBUdpi63J42wMP1KFyPQhlA6ZM+6ZOeNsDD9Shcj0IZQH6x5BdLnjbAWBPPikZCGUC0opGAb542wMP1KFyPQhlAtKKRgG+eNsDD9Shcj0IZQIQMlR2mnjbAw/UoXI9CGUC5/UGGyp42wMP1KFyPQhlA9Umf9EmfNsDD9Shcj0IZQMWzopGAnzbAWBPPikZCGUBgLPnFkp82wO0wdbn9QRlAYCz5xZKfNsDtMHW5/UEZQPVJn/RJnzbAw/UoXI9CGUC5/UGGyp42wMP1KFyPQhlAScA3ryaeNsBYE8+KRkIZQEnAN68mnjbAWBPPikZCGUAZKjtMXZ42wMP1KFyPQhlAtKKRgG+eNsDD9Shcj0IZQBkqO0xdnjbAw/UoXI9CGUDpkz7pk542wC7Ygi3YQhlAuf1BhsqeNsAu2IIt2EIZQFR2mLrcnjbAw/UoXI9CGUBa0UjAN582wMP1KFyPQhlAJOCbVxOfNsDD9Shcj0IZQLSikYBvnjbAWBPPikZCGUATz4pGAp42wIJOG+i0QRlAeVY0EvCdNsCCThvotEEZQHlWNBLwnTbAgk4b6LRBGUB5VjQS8J02wIJOG+i0QRlArkfhehSeNsDtMHW5/UEZQEnAN68mnjbAWBPPikZCGUDkOI7jOJ42wFgTz4pGQhlAtKKRgG+eNsDD9Shcj0IZQOQ4juM4njbA7TB1uf1BGUBJwDevJp42wIJOG+i0QRlAE8+KRgKeNsAXbMEWbEEZQBPPikYCnjbAgk4b6LRBGUATz4pGAp42wIJOG+i0QRlAqOwwdbmdNsBBpw102kAZQA502kCnnTbAQacNdNpAGUBDZYepy502wKyJZ0UjQRlAimdFIwGfNsDD9Shcj0IZQK5H4XoUnjbA7TB1uf1BGUCo7DB1uZ02wEGnDXTaQBlAScA3ryaeNsCsiWdFI0EZQMWzopGAnzbAfrHkF0s+GUBxPQrXo6A2wLy7u7u7OxlAO0xdbn+gNsB+seQXSz4ZQMWzopGAnzbA7TB1uf1BGUC0opGAb542wFgTz4pGQhlAqOwwdbmdNsBBpw102kAZQHP7gwyVnTbA1sSzopFAGUBz+4MMlZ02wNbEs6KRQBlAQ2WHqcudNsCsiWdFI0EZQHlWNBLwnTbAF2zBFmxBGUCo7DB1uZ02wEGnDXTaQBlA3t3d3d2dNsCsiWdFI0EZQPqkT/qknzbAAAAAAABAGUA7TF1uf6A2wJKAb15NPBlANfGsaCSgNsCissPU5TYZQPqkT/qknzbAi0YCvnk1GUDFs6KRgJ82wCBkqOwwNRlAj8L1KFyfNsC1gU4b6DQZQMWzopGAnzbAIGSo7DA1GUD6pE/6pJ82wGELtmALNhlAoNMGOm2gNsCO4ziO4zgZQDtMXW5/oDbAE8+KRgI+GUDFs6KRgJ82wFgTz4pGQhlAH4XrUbieNsDD9Shcj0IZQJt4VjQSoDbA0id90ic9GUBr4lnRSKA2wHd3d3d3NxlAa+JZ0UigNsB3d3d3dzcZQAZbsAVboDbA4lnRSMA3GUCbeFY0EqA2wKKyw9TlNhlAm3hWNBKgNsCissPU5TYZQJt4VjQSoDbAorLD1OU2GUCg0wY6baA2wPnFkl8sORlAoNMGOm2gNsB+seQXSz4ZQIpnRSMBnzbAw/UoXI9CGUC5/UGGyp42wIJOG+i0QRlAAAAAAACgNsBUdpi63D4ZQAZbsAVboDbAjuM4juM4GUBgLPnFkp82wCBkqOwwNRlAj8L1KFyfNsBKn/RJnzQZQPVJn/RJnzbAtYFOG+g0GUCPwvUoXJ82wLWBThvoNBlAxbOikYCfNsC1gU4b6DQZQPqkT/qknzbAIGSo7DA1GUD6pE/6pJ82wCBkqOwwNRlAyw5Tl9ufNsD2KFyPwjUZQNBpA502oDbA4lnRSMA3GUAGW7AFW6A2wCMB37yaOBlAoNMGOm2gNsAjAd+8mjgZQNbEs6KRoDbAOm2g0wY6GUBr4lnRSKA2wHd3d3d3NxlAZYepy+2fNsBhC7ZgCzYZQGWHqcvtnzbAYQu2YAs2GUDQaQOdNqA2wA2VHaYuNxlAO0xdbn+gNsBkqOwwdTkZQDtMXW5/oDbA+cWSXyw5GUCg0wY6baA2wM+KRgK+ORlA1sSzopGgNsBR2WHqcjsZQAZbsAVboDbAv1jyiyU/GUBa0UjAN582wMP1KFyPQhlAWtFIwDefNsBYE8+KRkIZQPqkT/qknzbArIlnRSNBGUDFs6KRgJ82wO0wdbn9QRlAyw5Tl9ufNsDWxLOikUAZQDXxrGgkoDbAa+JZ0UhAGUAAAAAAAKA2wNbEs6KRQBlANfGsaCSgNsBr4lnRSEAZQJt4VjQSoDbA1sSzopFAGUAwlvxiyZ82wIJOG+i0QRlA9Umf9EmfNsBYE8+KRkIZQCTgm1cTnzbAw/UoXI9CGUCKZ0UjAZ82wMP1KFyPQhlAuf1BhsqeNsDD9Shcj0IZQIQMlR2mnjbAWBPPikZCGUBPG+i0gZ42wEGnDXTaQBlAimdFIwGfNsBUdpi63D4ZQJUdpi63nzbAKjtMXW4/GUA7TF1uf6A2wNInfdInPRlAAAAAAACgNsBBpw102kAZQIQMlR2mnjbAw/UoXI9CGUAAAAAAAKA2wEGnDXTaQBlAm3hWNBKgNsDWxLOikUAZQMsOU5fbnzbAF2zBFmxBGUDQaQOdNqA2wAAAAAAAQBlAa+JZ0UigNsCVHaYutz8ZQJt4VjQSoDbAa+JZ0UhAGUAGW7AFW6A2wOmTPumTPhlA+qRP+qSfNsDpkz7pkz4ZQMWzopGAnzbA/WLJL5Y8GUAwlvxiyZ82wOb2BxkqOxlAZYepy+2fNsClT/qkTzoZQMWzopGAnzbA0id90ic9GUAfhetRuJ42wEGnDXTaQBlA9Umf9EmfNsBYE8+KRkIZQMsOU5fbnzbArIlnRSNBGUBUdpi63J42wMP1KFyPQhlAJOCbVxOfNsDD9Shcj0IZQDCW/GLJnzbAF2zBFmxBGUBlh6nL7Z82wEGnDXTaQBlAm3hWNBKgNsAAAAAAAEAZQNBpA502oDbAlR2mLrc/GUCbeFY0EqA2wGviWdFIQBlAj8L1KFyfNsDtMHW5/UEZQFR2mLrcnjbAw/UoXI9CGUD6pE/6pJ82wIJOG+i0QRlAYCz5xZKfNsCCThvotEEZQI/C9ShcnzbAWBPPikZCGUD6pE/6pJ82wIJOG+i0QRlA+qRP+qSfNsAXbMEWbEEZQPVJn/RJnzbA7TB1uf1BGUBa0UjAN582wFgTz4pGQhlAv1jyiyWfNsDtMHW5/UEZQH6x5BdLnjbAlR2mLrc/GUDYgi3Ygp02wLy7u7u7OxlACBkqO0ydNsCO4ziO4zgZQHP7gwyVnTbAorLD1OU2GUCo7DB1uZ02wMztDzJUNhlACBkqO0ydNsAjAd+8mjgZQNInfdInnTbAEDJUdpg6GUCjkYBvXp02wDptoNMGOhlAPQrXo3CdNsC4HoXrUTgZQHP7gwyVnTbAd3d3d3c3GUBDZYepy502wKKyw9TlNhlA3t3d3d2dNsDM7Q8yVDYZQBPPikYCnjbAi0YCvnk1GUDe3d3d3Z02wGELtmALNhlArkfhehSeNsCLRgK+eTUZQE8b6LSBnjbAtYFOG+g0GUBPG+i0gZ42wEqf9EmfNBlAv1jyiyWfNsBKn/RJnzQZQL9Y8oslnzbASp/0SZ80GUCKZ0UjAZ82wEqf9EmfNBlAYCz5xZKfNsAgZKjsMDUZQPqkT/qknzbAIGSo7DA1GUBgLPnFkp82wCBkqOwwNRlA+qRP+qSfNsAgZKjsMDUZQDCW/GLJnzbAi0YCvnk1GUD6pE/6pJ82wCBkqOwwNRlAMJb8YsmfNsCLRgK+eTUZQMsOU5fbnzbA9ihcj8I1GUA18axoJKA2wDfQaQOdNhlANfGsaCSgNsA30GkDnTYZQDXxrGgkoDbAN9BpA502GUDQaQOdNqA2wA2VHaYuNxlAAAAAAACgNsDM7Q8yVDYZQMsOU5fbnzbA9ihcj8I1GUDLDlOX2582wPYoXI/CNRlAYCz5xZKfNsAgZKjsMDUZQJUdpi63nzbAi0YCvnk1GUAwlvxiyZ82wPYoXI/CNRlAAAAAAACgNsDM7Q8yVDYZQGWHqcvtnzbAYQu2YAs2GUDLDlOX2582wPYoXI/CNRlAyw5Tl9ufNsD2KFyPwjUZQGWHqcvtnzbAYQu2YAs2GUCbeFY0EqA2wDfQaQOdNhlAAAAAAACgNsDM7Q8yVDYZQGWHqcvtnzbAYQu2YAs2GUBgLPnFkp82wCBkqOwwNRlAyw5Tl9ufNsD2KFyPwjUZQDXxrGgkoDbAorLD1OU2GUBr4lnRSKA2wHd3d3d3NxlAa+JZ0UigNsANlR2mLjcZQAAAAAAAoDbAYQu2YAs2GUBlh6nL7Z82wGELtmALNhlANfGsaCSgNsCissPU5TYZQAZbsAVboDbATTwrGgk4GUAGW7AFW6A2wOJZ0UjANxlA1sSzopGgNsClT/qkTzoZQAZbsAVboDbAVHaYutw+GUAGW7AFW6A2wL9Y8oslPxlAZYepy+2fNsCsiWdFI0EZQAAAAAAAoDbAa+JZ0UhAGUBr4lnRSKA2wJUdpi63PxlA0GkDnTagNsAAAAAAAEAZQGviWdFIoDbAKjtMXW4/GUA7TF1uf6A2wBPPikYCPhlA1sSzopGgNsBoRSMB3zwZQA=="

    Is this a bug in SqlServer Types?

    Regards,

    Edgar

     

All Replies

  • Thursday, February 21, 2013 6:40 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Edgar,

    I want to confirm whether SQL Server crashed or the application which calls MakeValid() method crashed. I suggest debugging the codes to make sure you pass a valid value to the method, additionally, please run the application from another computer and check the result again. There is a similar question on the following link, you can also refer to it:

    http://social.technet.microsoft.com/Forums/ms/sqlspatial/thread/6b73e701-be81-424b-a052-29b5efa0d5e9

    Allen Li
    TechNet Community Support

     
  • Thursday, February 21, 2013 8:05 AM
     
     
    Sign In to Vote
    0

        Hi Allen,

     I get same result than Edgar just by using the Microsoft.SqlServer.Types library from a windows form application (without SQL at all). MakeValid method start eating memory until application crash.

     It's quite simple to test, just try to MakeValid the geometry Edgar posted and you will se the effect.

     By the way CanMakeValid returns true. But then Microsoft.SqlServer.Types gets crazy when trying to make the geometry valid. If we knew the reason, maybe we could check manually the invalid geometry before calling MakeValid.

     Regards,

    Carlos 

     
  • Thursday, February 21, 2013 8:47 AM
     
      Has Code
    Sign In to Vote
    0

    Hi Allen,

    Thanks for your reply, as Carlos said, we're using the Microsoft.SqlServer.Types 11.0 library, you can just create a console application and write this code and run, you'll see the memory rise up to giga bytes and then the exception occurs.

    SqlGeometry.STGeomFromWKB(new SqlBytes(Convert.FromBase64String(Base64String)), 0).MakeValid()

    Thanks,

    Edgar

     
  • Wednesday, February 27, 2013 7:09 AM
     
     
    Sign In to Vote
    0

       Hi Allen,

    Did you have a chance to run the code an recreate the issue?

     
  • Friday, March 01, 2013 8:22 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi, from your description,

    I get same result than Edgar just by using the Microsoft.SqlServer.Types library from a windows form application (without SQL at all). MakeValid method start eating memory until application crash.

    This issue can occur due to SqlGeometry.MakeValid Method self since there is no SQL Server. I would recommend to submit a feedback to the Microsoft Connect at this link https://connect.microsoft.com/SQLServer/Feedback. This connect site will serve as a connecting point between you and Microsoft, and ultimately the large community for you and Microsoft to interact with. Your feedback enables Microsoft to offer the best software and deliver superior services, meanwhile you can learn more about and contribute to the exciting projects on Microsoft Connect.

    Allen Li
    TechNet Community Support

     
  • Friday, March 01, 2013 6:46 PM
     
     
    Sign In to Vote
    0

       Thanks Allen,

    I filled the feedback: https://connect.microsoft.com/SQLServer/feedback/details/780448/outofmemory-exception-on-microsoft-sqlserver-types-with-sqlgeometry-stgeomfromwkb-new-sqlbytes-wellknownbinary-0-makevalid

    Carlos

     
  • Thursday, March 07, 2013 5:44 PM
     
     
    Sign In to Vote
    0

        Hi Again Allen,

      Do you know how long use to take roughly until Microsoft respond the the feedback posted on Microsoft Connect?

     
  • Friday, March 15, 2013 6:57 AM
     
     
    Sign In to Vote
    0

    Hi Allen,

    There is still no reply at the Connect page, do you have any idea with this?

    Edgar