FIX: Internal error messages when you update a FILESTREAM tombstone system table in SQL Server

Si applica a: SQL Server 2014 DeveloperSQL Server 2014 EnterpriseSQL Server 2014 Enterprise Core

Symptoms


Assume that you have a FILESTREAM-enabled database in an instance of Microsoft SQL Server. When you start a transaction and use the SqlFileStream .NET API to open a Filestream file, the task may fail and throw an exception because of external factors.

If you open the file again by using SqlFileStream within the same transaction and commit, you may receive internal error messages that resemble the following:

If you run dbcc checktable ('sys.filestream_tombstone_2073058421'), you may receive the following error message:

Resolution


The fix for this issue is included in the following updates for SQL Server:

Cumulative Update 13 for SQL Server 2017         

Cumulative Update 1 for SQL Server 2014 Service Pack 3

Cumulative Update 15 for SQL Server 2014 Service Pack 2

Workaround


To work around this issue, rebuild the database index by using the DBCC CHECKTABLE command.

Status


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

References


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