SQL Server Floating Point Exception

Question

I'm trying to find the reason for a floating point exception that is thrown on a Microsoft SQL Server 2019 (RTM-GDR) (KB4517790) - 15.0.2070.41 (X64).

05/31/2021 21:23:00,spid66,Unknown,The Database Engine received a floating point exception from the operating system while processing a user request. Try the transaction again. If the problem persists<c/> contact your system administrator.

This floating point exception occurs a handful of times each day since we turned on Memory-Optimized TempDB Metadata.

How can I fix this?

Answer 1

Hi @Johannes Maly ,

Welcome to Microsoft Q&A!

SQL Server 2019 (RTM-GDR) (KB4517790) - 15.0.2070.41 (X64).

Could you please post the result of select @@VERSION? And is this your SQL Server build version? If yes, please install KB4536075, the issue has been solved by KB4536075. But we suggest you to install the latest Cumulative Update, it will fix the issue that you mentioned and also will fix other issues.

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Dear Carrin

Here the full output of @@VERSION:

Microsoft SQL Server 2019 (RTM-GDR) (KB4517790) - 15.0.2070.41 (X64) Oct 28 2019 19:56:59 Copyright (C) 2019 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)

Answer 3

Dear Carrin

Thank you for your support. Will try to get either the KB or even better the CU installed as you suggested.

Best Regards
Johannes

Answer 4

Ok let me apply CU 11 Thanks

here is the current @@version

Microsoft SQL Server 2019 (RTM-CU10) (KB5001090) - 15.0.4123.1 (X64) Mar 22 2021 18:10:24 Copyright (C) 2019 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2019 Datacenter 10.0 <X64> (Build 17763: ) (Hypervisor)

Answer 5

We Applied CU 11 but this is still occurring
Message
The Database Engine received a floating point exception from the operating system while processing a user request. Try the transaction again. If the problem persists, contact your system administrator.

This is from running full text query
example
SELECT TOP 10 * FROM FREETEXTTABLE

Microsoft SQL Server 2019 (RTM-CU11) (KB5003249) - 15.0.4138.2 (X64) May 27 2021 17:34:14 Copyright (C) 2019 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2019 Datacenter 10.0 <X64> (Build 17763: ) (Hypervisor)