GEOMETRY::STMPolyFromText makes SSMS crash in clr.dll

Question

GEOMETRY::STMPolyFromText makes SSMS crash in clr.dll

Martin Nielsen 0

I have a piece of SQL code where i create a geometry using GEOMETRY::STMPolyFromText

but when I select or click in the text GEOMETRY::STMPolyFromText SSMS crashes and generates the following error in the windows log:

Faulting application name Ssms.exe, version: 2023.190.2.56, time stamp: 0x654cf880

Faulting module name clr.dll, version: 4.8.9195.0, time stamp: 0x64e9259c

Exception code 0xc00000fd

Fault offset 0x000241ac

Faulting process id 0x35e8

Faulting application start time 0x01da1e9eac27e51d

Faulting application start time as time 2023-11-24 07:23:00

Faulting application path C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Ssms.exe

Faulting module path C:\Windows\Microsoft.NET\Framework\v4.0.30319\clr.dll

Report Id efa3832b-3814-4d98-a402-30e38521ef72

Faulting package full name NULL

SSMS is also periodically crashing (in clr.dll) when I'm not using the above code, but that is more random in nature, in fact I once came back to my pc, looked at the screen for a few seconds and then SSMS crashed (in clr.dll) without me ever touching the keyboard or mouse.

it seems the clr.dll module needs a serious overhaul

Erland Sommarskog 120.6K Reputation points MVP Moderator

2023-11-24T16:44:14.7733333+00:00
I ran:

DECLARE @g geometry; SET @g = geometry::STMPolyFromText('MULTIPOLYGON (((5 5, 10 5, 10 10, 5 5)), ((10 10, 100 10, 200 200, 30 30, 10 10)))', 0); SELECT @g

And my instance of SSMS survived the ordeal.

It seems unlikely that SSMS would be affected by which function you run. But possibly the returned spatial value could affect SSMS, as SSMS is trying to depict the spatial value. Do you have an example that leads to a crash?
Dave Oldham 0 Reputation points

2024-01-03T18:13:05.1433333+00:00

Mine is doing the exact same thing. Did you ever find the solution?

Faulting application name: Ssms.exe, version: 2023.190.2.56, Faulting module name: clr.dll, version: 4.8.9181.0,

Your answer

Erland Sommarskog 120.6K Reputation points MVP Moderator

2023-11-24T16:44:14.7733333+00:00

I ran:

DECLARE @g geometry; SET @g = geometry::STMPolyFromText('MULTIPOLYGON (((5 5, 10 5, 10 10, 5 5)), ((10 10, 100 10, 200 200, 30 30, 10 10)))', 0); SELECT @g

And my instance of SSMS survived the ordeal.

It seems unlikely that SSMS would be affected by which function you run. But possibly the returned spatial value could affect SSMS, as SSMS is trying to depict the spatial value. Do you have an example that leads to a crash?
Dave Oldham 0 Reputation points

2024-01-03T18:13:05.1433333+00:00

Mine is doing the exact same thing. Did you ever find the solution?

Faulting application name: Ssms.exe, version: 2023.190.2.56, Faulting module name: clr.dll, version: 4.8.9181.0,

Share via

GEOMETRY::STMPolyFromText makes SSMS crash in clr.dll

Your answer