FIX: "ADD PERIOD FOR SYSTEM_TIME failed" error when you add period columns to a memory-optimized table in SQL Server 2016
Symptoms
Assume that you use In-Memory OLTP in Microsoft SQL Server 2016. In this scenario, you use ALTER TABLE and ADD PERIOD FOR SYSTEM_TIME statements to add period columns that have appropriate default values together with corresponding system-time period to a memory-optimized table. If the table is not empty, you receive an error message that resembles the following:
Msg 13575, Level 16, State 0
ADD PERIOD FOR SYSTEM_TIME failed because table 'temporaltest.dbo.DrugMultiComponent' contains records where end of period is not equal to MAX date time.
Resolution
This fix is included in the following updates:
- Cumulative Update 2 for SQL Server 2016 Service Pack 1
- Cumulative Update 5 for SQL Server 2016
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 terminology Microsoft uses to describe software updates.
Article ID: 4013112 - Last Review: 20.3.2017 - Revision: 9
