FIX: Error 3624 occurs when you execute a query that contains multiple bulk insert statements in SQL Server 2014

Symptoms

Assume that you have tables that have clustered columnstore indexes in Microsoft SQL Server 2014. When you execute a query that contains multiple bulk insert statements on these tables, you receive the following error message:
Location: qquery.cpp:1617
Expression: NULL == pxteColumnStoreBulkInsert
SPID: 300
Process ID: 1704
Msg 3624, Level 20, State 1, Line 1
A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a Hotfix from Technical Support.

Resolution

Cumulative Update information

The issue was first fixed in the following cumulative update of SQL Server.

Recommendation: Install the latest cumulative update for SQL Server

Status

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

Article ID: 3048856 - Last Review: Jun 22, 2015 - Revision: 1

Feedback