Sidebar

What does this error mean: Cannot create memory optimized tables. To create memory optimized tables...

0 votes
1.3K views
asked Aug 8, 2019 by rich-c-2789 (16,180 points)
retagged Aug 13, 2019 by rich-c-2789
I am using MSSQL Server.  I see this error in the logs and QIE fails to start:

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot create memory optimized tables. To create memory optimized tables, the database must have a MEMORY_OPTIMIZED_FILEGROUP that is online and has at least one container.

How can this be resolved?

1 Answer

0 votes

This only applies to Microsoft SQL Server instances of QIE.

This error is caused by running QIE in High Availability mode against either a Microsoft SQL Server database that is not supported for High Availability or the database has not been configured for High Availability.  High Availability requires Microsoft SQL Server 2016 or greater and needs to be configred with a filegroup for MEMORY_OPTIMIZED_DATA.  To configure the database via a script see this question: SQL Server script to create High Availability database for QIE

answered Aug 8, 2019 by rich-c-2789 (16,180 points)
edited Aug 13, 2019 by rich-c-2789
...