Unable to call into C compiler when creating memory optimized table in SQL Server 2014

Question

I am trying to create my first memory optimized table using SQL Server 2014. I first created the necessary file group and file without issue. But when I try to create a simple table using

CREATE TABLE [dbo].[tblSessionDevices_Optimized](
[SessionInfo_Id] [int] IDENTITY NOT NULL PRIMARY KEY NONCLUSTERED ,
[Device_Id] INT NOT NULL INDEX IX_SessionInfoOptimize_DeviceID  
) 
WITH (Memory_Optimized = ON)

I get the error:

Msg 41312, Level 16, State 4, Line 0 Unable to call into the C compiler. GetLastError = 1392.

I'm guessing that the SQL Server account calling the compiler does not have access to the directory where the compiler resides, but just can't put my finger on it.

1392 is ERROR_FILE_CORRUPT. This is not the kind of error you'd expect over a simple access issue. Check the event viewer and/or the SQL Server error log for possible disk problems. This could also be caused by a file system filter interfering (antivirus/malware). You could use Process Monitor to dig into the exact call that's failing, if necessary. — Jeroen Mostert
– Jeroen Mostert, Commented Sep 19, 2016 at 14:32

TheGameiswar · Accepted Answer · 2016-09-19 14:26:36Z

0

I did some search and below is what i found..

SQLServr.exe looks for CL.EXE under C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\Xtp\VC\bin folder

So this error can happen when..

1.No access to SQLServer account on that folder
2.Bin folder name changed unintentionally..

answered Sep 19, 2016 at 14:26

TheGameiswar

29k9 gold badges67 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

andrew.fox · Accepted Answer · 2020-02-26 07:18:07Z

0

In my case it was due to heavy load on SQL Server and low memory.

answered Feb 26, 2020 at 7:18

andrew.fox

8,0696 gold badges56 silver badges83 bronze badges

Collectives™ on Stack Overflow

Unable to call into C compiler when creating memory optimized table in SQL Server 2014

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related