Some users may be experiencing issues when trying to access customer resources like the Case Portal or the Product Licensing Center. Our team is aware of the issue and is working to resolve it. Click here for more information.
When FNMS is working with Microsoft Server SQL Server 2019 version, they might receive the follow error message:
System.InvalidOperationException: Memory optimized tables and natively compiled modules cannot be accessed from within SQLCLR stored procedures.
SQL Server 2019 (15.x) introduces a new feature that's part of the in-memory database feature family: memory-optimized tempdb metadata. When this feature is enabled, the system tables involved in managing temporary table metadata can be moved into latch-free, non-durable, memory-optimized tables. However any memory optimized tables and natively compiled modules cannot be accessed from within SQL CLR stored procedure, and therefore causing compatible issue with FNMS.
User may see the error message listed above during some data activities such as during data warehouse export process.
--Option 1:
ALTER SERVER CONFIGURATION SET MEMORY_OPTIMIZED TEMPDB_METADATA = OFF GO
--Option 2: EXEC sp_configure 'tempdb metadata memory-optimized', 0 GO RECONFIGURE GO
Feb 07, 2021 05:54 AM
Hi mfranz,
For the details of CU5, please find the document from Microsoft:
I didn't test on each revision but I believe the memory optimized tempdb has to be switch off no matter which revision of SQL Server 2019 is.
Regards,
Cemson