Operational Defect Database
BugZero found this defect 1317 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 13288075
KB4531386 - FIX: Assertion occurs when sys.sp_cdc_enable_table is used to enable CDC on column set table in SQL Server 2016 and 2017 - Microsoft Support
Last update date:
9/15/2021
Affected products:
SQL Server 2017 Developer on Windows
SQL Server 2017 Enterprise Core on Windows
SQL Server 2017 Enterprise on Windows
SQL Server 2017 Standard on Windows
SQL Server 2016
SQL Server 2016 Service Pack 3 - duplicate (do not use)
Affected releases:
build lower than 14.0.3281.6
Fixed releases:
14.0.3281.6
Description:
Symptoms
When you use the sys.sp_cdc_enable_table stored procedure to enable Change Data Capture (CDC) on a column set table in Microsoft SQL Server 2017 or 2016, the following assertion error is logged in the error log: Location: FilePath\FileName:LineNumber Expression: m_REColId == m_imedIndexColumn->GetColumnId()
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Resolution
Cumulative update information This problem is fixed in the following cumulative update for SQL Server: Cumulative Update 19 for SQL Server 2017 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: Latest cumulative update for SQL Server 2017 Service pack information for SQL Server 2016 This problem is fixed in the following service pack for SQL Server: Service Pack 3 for SQL Server 2016 About service packs for SQL Server: Service packs are cumulative. Each new service pack contains all the fixes that are in previous service packs, together with any new fixes. We recommend that you apply the latest service pack and the latest cumulative update for that service pack. You do not have to install a previous service pack before you install the latest service pack. Use Table 1 in the following article to find more information about the latest service pack and latest cumulative update. Determine the version, edition, and update level of SQL Server and its components
References
Learn about the terminology that Microsoft uses to describe software updates.
