Cumulative Update 1 for SQL Server 2014

An issue that affected Cumulative Update 1 for Microsoft SQL Server 2014 had previously caused us to remove the update from the download server. We have now resolved the issue, and the update is again available for download.

Summary

This article describes cumulative update package 1 (Build number: 12.0.2342.0) for Microsoft SQL Server 2014. This update contains hotfixes for issues that were fixed after the release of SQL Server 2014.

How to obtain this cumulative update package

Click "Hotfix Download Available" at the top of this article. If the "Hotfix Request" page doesn't appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.

Hotfixes that are included in this cumulative update package

VSTS bug numberKB article numberDescriptionFix area
18520842297709 FIX: An error message may occur when you run a "BULK INSERT" query on a database that uses the "BULK_LOGGED" or "SIMPLE" recovery model in SQL ServerSQL service
22053642723979 FIX: Access violation in SQL Server internal deadlock monitor when you run multiple applications together with Multiple Active Result Sets enabled in SQL ServerSQL service
20337642843619 Tablix column header sorting buttons are Section 508 noncompliant in a Reporting Services report in SQL Server 2012 or SQL Server 2014Reporting Services
20333352844210 FIX: The Remote Registry service crashes when an application tries to retrieve Performance Counter data from another computerReporting Services
20340682847735 FIX: "A PivotTable, cube function or slicer using connection <conn> had failed to refresh" error when you update data in an Excel workbook that is sourced from a perspective in SSAS 2012 or SSAS 2014 Analysis Services
20340932860446 FIX: Unexpected error in "XMCompressionAnalyzer::SelectBitPackCompression" function when you perform a Process command against a partitioned table in SSAS 2012 or SSAS 2014Analysis Services
22053672861456 FIX: Access violation in replication Distribution Agent in SQL Server Transactional ReplicationSQL service
20332242862241 FIX: Access violation when you trace an RPC event class by using SQL Server Profiler or XEvents in SQL Server 2012 or SQL Server 2014SQL service
20340992864111 FIX: It takes longer than expected to cancel an MDX query that contains many GROUP BY clauses in SSAS 2012 or SSAS 2014Analysis Services
19933172864930 FIX: You cannot write text that has more than 32,767 characters in Report Query Designer in SQL ServerAnalysis Services
20333402868348 FIX: Chart data cannot be updated when you use the Report Viewer Web Part to view the report in SSRSReporting Services
20341152872946 FIX: CPU spinning occurs when you use Power View to run a DAX query against a Multidimensional model in SSAS 2012 or SSAS 2014Analysis Services
20349052875949 FIX: VSS backup operations are not successful when the auto-recovery option is enabled in SQL ServerSQL service
20341282876882 FIX: "Internal error: An unexpected error occurred" when you run a "Process" command against the TFS SSAS cubeAnalysis Services
20349072878377 FIX: DecryptByKeyAutoAsymKey() function returns "NULL" value when you decrypt data that is encrypted by an asymmetric key in SQL ServerSQL security
20333932878968 FIX: Nonclustered index corruption may occur when you run a complex UPDATE statement together with a NOLOCK hint against a table in SQL ServerSQL performance
20332522879373 FIX: Threads are not scheduled evenly in SQL Server 2012 or SQL Server 2014 Standard EditionSQL service
20661692880071 FIX: Error messages when you perform a ProcessRecalc operation after a ProcessData operation on an SSAS 2012 or SSAS 2014 tabular modelAnalysis Services
20340812880094 FIX: Grand total or subtotal rows display incorrect results in a Power View report that runs against a multidimensional cube in SSAS 2012 or SSAS 2014Analysis Services
20332622881285 You cannot change the Run64BitRuntime property of an Integration Services project by using the SQL Server Data Tools in SQL Server 2012 or SQL Server 2014Integration Services
20332452881661 A memory leak occurs when a SQL Server Native Client OLE DB provider application calls the Prepare method in SQL Server 2012 or SQL Server 2014SQL connectivity
20341092884124 FIX: "Type mismatch" error when you run an MDX query that uses the Member.Name property against an SSAS 2012 or SSAS 2014 databaseAnalysis Services
20349082885565 FIX: Report Builder 3.0 may close unexpectedly when you search an attribute in Query Designer in SQL ServerReporting Services
20333242885671 Duplicated worksheets are opened when you use the SQL Server Master Data Services Add-in for Microsoft Excel in SQL Server 2012 or SQL Server 2014Data Quality Services (DQS)
20336582887888 FIX: Slow performance in SQL Server when you build an index on a spatial data type of a large table in a SQL Server 2012 or SQL Server 2014 instanceSQL service
20336632887899 FIX: Slow performance in SQL Server 2012 or SQL Server 2014 when you build an index on a spatial data type of a large tableSQL service
18520862888996 FIX: Data purity corruption in sys.sysbinobjs table in master database when you log on to SQL Server by using the SA account and then run DBCC CHECKDBSQL service
20333752889723 A series of errors occurs when you export a Reporting Services report as a PDF in SQL Server 2012 or SQL Server 2014Reporting Services
20333792890052 Integration Services catalog permissions don't work for Windows groups in SQL Server 2012 or SQL Server 2014Integration Services
20349092890095 FIX: Interrupted distributed query may return partial result set without any error in SQL ServerSQL service
20334062890415 Notification messages of data update failure are not sent when you use the PowerPivot for SharePoint 2013 add-in for SQL Server 2012 SP1 or SQL Server 2014Analysis Services
19933182890818 FIX: Incorrect value is returned when you run an UPDATE CUBE statement that uses the USE_WEIGHTED_INCREMENT allocation method in SSASAnalysis Services
20333182891083 FIX: Expressions for default values in parameters are run only one time in SSRS 2012 or SSRS 2014 in SharePoint Integrated modeReporting Services
20336042891088 FIX: Find option in Report Manager always takes you to the bottom of the page in SSRS 2012 or SSRS 2014Reporting Services
18520882891115 FIX: "The search text was not found" error when you search for numeric data that contains nonbreaking spaces in SSRSReporting Services
20337292891230 FIX: Error message when you select a report on the RSItemPicker.aspx page after you apply update 2791086 on a computer that is running SSRSReporting Services
18520902891489 FIX: Replication Log Reader Agent fails when you enable CDC and transactional replication for some columns in SQL ServerSQL service
20333082893842 FIX: Fewer results in the MDS subscription view after you apply SQL Server 2012 SP1 or SQL Server 2012 CU2 or in SQL Server 2014DQS
20333502894025 Mirror tables are dropped when you use "Change Data Capture for Oracle by Attunity" on a server that is running SQL Server 2012 or SQL Server 2014Integration Services
20336352894305 FIX: Suboptimal execution plan is generated when you run a query in SQL Server 2012 or SQL Server 2014SQL performance
20336392894326 An application cannot connect to a contained database when connection pooling is enabled in SQL Server 2012 or SQL Server 2014SQL security
20336752895494 Slow SQL Server performance and a memory leak after you apply Cumulative Update 3 for SQL Server 2012 Service Pack 1 or in SQL Server 2014SQL service
18521052895694 FIX: Query scope assignment works incorrectly after you run a ClearCache command in SSASAnalysis Services
20333302896720 FIX: Slow performance in SQL Server 2012 or SQL Server 2014 when you build an index on a spatial data type of a large table SQL performance
19933162896903 FIX: You cannot perform any administrator actions on databases when a data model corruption occurs in SSAS 2012 or SSAS 2014Analysis Services
20336442897221 Slow performance or error messages are logged when you have a transactional replication publisher server in SQL Server 2012 or SQL Server 2014SQL service
20337132897237 FIX: Transaction date format on an MDS website in SQL Server 2012 or SQL Server 2014 differs from the format that is defined on the computerDQS
20332732897263 "An error occurred when loading VertiPaq data" message after you load a database in SSAS 2012 or SSAS 2014Analysis Services
20336672897265 FIX: "Invalid column name" error when you run some MDX queries against ROLAP partitions in SSAS 2012 or SSAS 2014Analysis Services
20337212897282 FIX: Wrong date format will be returned when you run DateAdd or Day function in SSAS 2012 or SSAS 2014 on a non-US locale computerAnalysis Services
20336812897454 FIX: Insufficient system memory error occurs when you try to create an index in a char, varchar, or nvarchar type column in SQL Server 2012 or SQL Server 2014SQL performance
20337082897512 FIX: Newly added member disappears from the Master Data Explorer in SQL Server 2012 or SQL Server 2014 MDSDQS
20337362897539 FIX: IntelliSense feature does not work correctly after you type Transact-SQL statements in SSMS in SQL Server 2012 or SQL Server 2014Management Tools
20337422897633 FIX: You cannot start an audit by using an "ALTER" statement in SQL Server 2012 or SQL Server 2014SQL security
20349012899939 FIX: Error messages when you create a project level SMO connection manager together with a password for an SSIS 2012 or SSIS 2014 project Integration Services
20334112899945 FIX: "The report server cannot process the report" error when you view an SSRS 2012 or SSRS 2014 report on a SharePoint websiteReporting Services
20349042901757 FIX: Minute is overwritten by second in XML data after you migrate from SQL Server 2005 to SQL Server 2012 or SQL Server 2014XML
18521032904010 FIX: A small number of rows are sampled in SQL Server when table statistics are updated automatically or together with specified sampling rateSQL performance
20336172905275 FIX: Error messages when you run some MDX or DAX queries in SSAS 2012 or SSAS 2014Analysis Services
20333002905298 FIX: It takes much longer for a user without administrator permissions to run an MDX query than an administrator user in SSAS 2012 or SSAS 2014Analysis Services
18521072911385 FIX: Replication Queue Reader Agent crashes when you run transactional replication in SQL ServerSQL service
20349112912928 FIX: SQL Server 2012 or SQL Server 2014 PowerPivot for SharePoint 2010 cannot create databases when the SharePoint server name is FQDNAnalysis Services
18521132912949 FIX: SSAS crashes when more than one thread tries to access an SSAS cube at the same timeAnalysis Services
18521092913206 FIX: Cannot pass report parameters to reports in a SharePoint Document Library in SSRS by using HTML formsReporting Services
19933212915611 FIX: Left Arrow key does not work in Expression Editor of SSDT for Visual Studio 2012Reporting Services
19933222916827 FIX: "Invalid URI: The Uri string is too long" error when you render an SSRS 2012 or SSRS 2014 reportReporting Services
19933232916934 FIX: "Center map to show an embedded map element" option of the "Center and Zoom" tab for a map does not work in SSRS 2012 or SSRS 2014Reporting Services
19933252917636 FIX: SQL Server Agent cannot forward events to a different server in SQL Server 2012 or SQL Server 2014Management Tools
19933262919584 FIX: Incorrect result in a PDF file when you use expressions that contain a Lookup function in an SSRS 2012 or SSRS 2014 reportReporting Services
20768692920987 FIX: Poor performance when many table-valued parameters are used in SQL ServerSQL service
19933152921630 FIX: Incorrect result is returned when you run an MDX query that contains a DRILLTHROUGH statement in SSASAnalysis Services
22053452922935 FIX: Excel rendering extension produces corrupted files when you use nonprintable codes in SSRS 2012 or SSRS 2014Reporting Services
19933122923837 FIX: Merge Agent fails or you experience non-convergence when you use a custom stored procedure conflict resolver in SQL ServerSQL service
22053482924827 FIX: dtexec.exe cannot execute a package when one of the configuration files does not exist in SQL Server 2012 or SQL Server 2014Integration Services
22053582926217 FIX: Performance problems occur when database lock activity increases in SQL Server 2012 or SQL Server 2014 SQL service
22053592926223 FIX: Performance problems occur in NUMA environments during foreign page processing in SQL Server 2012 or SQL Server 2014SQL service
22053532927511 FIX: Access violation may occur when trigger query joins large dataset in deleted/inserted table and runs in parallel in SQL server 2012 or SQL Server 2014SQL performance
22053552927524 FIX: MDX query does not reuse cache after clear cache command on different Measure Group with Non-Admin login in SSAS 2012 or SSAS 2014Analysis Services
21013502927748 FIX: PowerPivot workbook cannot do data refresh in SharePoint 2013 after you apply SQL Server 2012 CU7 or in SQL Server 2014Analysis Services
22053562927779 FIX: Database shows "recovery pending" state when you use TDE with EKM provider in SQL Server 2012 or SQL Server 2014SQL security
22053572927844 FIX: Large DistinctCount become slower in tabular mode in SQL Server 2012 or SQL Server 2014Analysis Services
22053502929193 FIX: SQL Server 2012 or SQL Server 2014 instance shuts down when you join database as secondary replica during AlwaysOn Availability Groups configurationHigh Availability
22053472929832 FIX: Decimal precision is incorrect when you calculate based on size of scale in SQL Server 2012 or SQL Server 2014 MDSDQS
22053462929903 FIX: Merge agent fails when you apply snapshot in SQL Server 2012 or SQL Server 2014 instance if cross database dependencies are presentSQL service
22053632931001 FIX: Distribution Agent skips applying sp_MSins_, sp_MSupd_, sp_MSdel_ stored procedures on a Subscriber that is initialized with Backup in SQL Server 2012 or SQL Server 2014SQL service
22053652931241 FIX: Access violation occurs when you update a table that has an XML calculated column in SQL Server 2012 or SQL Server 2014SQL service
22053692932120 FIX: SQL Server takes long time to open the databases after the recovery phase when the number of databases or database files or both is large in SQL Server 2012 or SQL Server 2014SQL service
22053662932340 FIX: Errors when you add member in SQL Server 2012 or SQL Server 2014 MDSDQS
22053682932341 FIX: Content of member details window is locked when you add a new member to MDS Explorer in SQL Server 2012 or SQL Server 2014 MDSDQS
22053442933780 FIX: Message is not removed from transmission queue even though the ACK is received successfully in an AlwaysOn availability group in SQL Server 2012 or SQL Server 2014SQL service
22053702936004 FIX: Visual Studio 2012 crashes because of access violation when the data source binding is completed in Report Viewer 2012 UI in local modeReporting Services
20888452936896 FIX: Errors when you join memory-optimized table to memory-optimized table type at RCSI in SQL Server 2014In-Memory OLTP
20825342937574 FIX: Error when you open a Power View report that has any Bing Map in SQL Server 2014Reporting Services
20422462938460 FIX: An access violation occurs when you try to use datepart (weekday) in a natively compiled stored procedure in SQL Server 2014In-Memory OLTP
20329722938461 FIX: Incorrect message type when you restart a SQL Server 2014 instance that has Hekaton databasesIn-Memory OLTP
20329812938462 FIX: Missing or wrong information about missing indexes is returned when you query in SQL Server 2014In-Memory OLTP
20330102938463 FIX: No missing index recommendation is displayed when the index is not the correct type for the query in SQL Server 2014In-Memory OLTP
20329882938464 FIX: Cannot use showplan_xml for the query/procedure when you create a natively compiled stored procedure with a query that contains a large expression in SQL Server 2014In-Memory OLTP
21194892938555 FIX: Errors when you run an online index build/switch partition with the option ABORT_AFTER_WAIT=BLOCKERS and parallel queries at same time in SQL Server 2014SQL service
21296612940348 FIX: Worker time in the DMVs sys.dm_exec_procedure_stats and sys.dm_exec_query_stats for natively compiled stored procedures is reported incorrectly in SQL Server 2014In-Memory OLTP
21588352942895 FIX: Error 35377 when you build and rebuild clustered columnstore index with maxdop larger than 1 through MARS connection in SQL Server 2014SQL service
21595322943395 FIX: Error when you merge partitions with incremental statistics in SQL Server 2014SQL performance
21136822948180 FIX: Error when you restore full database backup from the secondary in SQL Server 2014SQL service
21579812949751 FIX: An access violation occurs when you run CHECKTABLE against the tables with clustered column store index in SQL Server 2014SQL service
21136182950069 FIX: Change the feature ID of deprecated feature Database compatibility level 110 to 275 in SQL Server 2014SQL service
22056972953592 FIX: The values of column query_hash and query_plan_hash are NULL for DMV sys.dm_exec_requests in SQL Server 2014SQL performance
22829532958050 FIX: Incorrect message 'Private Server build' is shown in the dumps and Dr. Watson is disabled when SQL Server 2014 generate dumpsSQL service
21041262958052 FIX: Access violation when you create an index on a no-partitioned table in SQL Server 2014SQL performance
21125552958054 FIX: SQL Cache Memory decreases and CPU usage increases when you rebuild an index for a table in SQL Server 2014SQL service
22789662958191 FIX: TRACK_CAUSALITY causes access violations for every batch or RPC completed event in SQL Server 2014SQL service
20768652922799 FIX: Unexpected exception is thrown when you convert writeback partition in SSASAnalysis Services
2034913957823 FIX: The clustered index table may take longer than you expect to be rebuilt when you use the ALTER INDEX REBUILD statement in SQL ServerSQL service
22053602926712 FIX: Performance decreases after an ALTER INDEX…ONLINE operation is aborted in SQL Server 2012 or SQL Server 2014SQL service
20349102907283 FIX: "Timeout expired" error when you use PowerShell to back up or restore a large database in SQL Server 2012 or SQL Server 2014Management Tools

Notes for this update

Cumulative update

  • We recommend that you test hotfixes before you deploy them in a production environment.
  • This cumulative package is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems.
  • This cumulative update contains all the hotfixes and all the updates that were included with the previous SQL Server 2014 update release.
  • We recommend that you upgrade your SQL Server installation to the next SQL Server 2014 service pack .

Hybrid environments deployment

When you deploy the hotfixes to a hybrid environment (Such as AlwaysOn, replication, cluster, and mirroring), we recommend that you refer to the following articles before you deploy them:
Language support
Components updated
Support for this update
How to uninstall this update

Cumulative update package information

Prerequisites

To apply this cumulative update package, you must be running SQL Server 2014 RTM.

Restart information

You may have to restart the computer after you apply this cumulative update package.

Registry information

To use one of the hotfixes in this package, you do not have to make any changes to the registry.
Cumulative update package file information
Properties

Article ID: 2931693 - Last Review: May 2, 2014 - Revision: 1

Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Web, Microsoft SQL Server 2014 Web, Microsoft SQL Server 2014 Web, Microsoft SQL Server 2014 Web

Feedback