FIX: Error when your stored procedure calls another stored procedure on a linked server in SQL Server 2014

Symptoms
Assume that you create a linked server to an instance of Microsoft SQL Server 2014 Service Pack 1 (SP1). When you run a stored procedure that calls another stored procedure on the linked server, and you pass a large object as the input parameter, the query fails. Additionally, you receive the following error message:
Error: 17065, Severity: 16, State: 1.
SQL Server Assertion: File:< tmpilb.cpp>, line = 3280 Failed Assertion = 'fFalse' Release. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.
Resolution

Hotfix information

This hotfix is included in the following cumulative update of SQL Server 2014 SP1:
About cumulative updates for SQL Server
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:

Hotfixes that are included in this package

Prerequisites

You must have SQL Server 2014 SP1 applied before you can install this hotfix.

Registry information

To use the hotfix in this package, you don't have to make any changes to the registry.

Restart requirement

You may have to restart the computer after you apply this hotfix.

Hotfix replacement information

This hotfix doesn't replace a previously released hotfix.
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 3097972 - Last Review: 05/06/2016 08:40:00 - Revision: 7.0

Microsoft SQL Server 2014 Service Pack 1

  • kbqfe kbfix kbsurveynew kbexpertiseadvanced KB3097972
Feedback