KB4338960 - FIX: "PAGE_FAULT_IN_NONPAGED_AREA" Stop error when enumerating contents in a SQL Server FileTable directory

Applies to: SQL Server 2017 DeveloperSQL Server 2017 EnterpriseSQL Server 2017 Enterprise Core

Symptoms


Assume that you use the FileTables feature in Microsoft SQL Server 2016 and 2017. When the contents of a directory that is managed by FileTables is enumerated, and then a cancellation is issued, you may receive the following Stop error code message:

Resolution


Workaround


This problem is reported to affect SMB clients most frequently. To work around this problem, change the time-out value in the registry on all client computers that use FileTable, as follows:

Subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters
Type: REG_DWORD
Name: SessTimeout
Value: 600 (Decimal)

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


FileTables (SQL Server)

Learn about the standard terminology Microsoft uses to describe software updates.