Error: upgrade failure adding period for SYSTEM_TIME and enabling SYSTEM_VERSIONING

Products

• Information Centric Analytics

Issue/Introduction

The following error messages are logged when attempting to upgrade Information Centric Analytics (ICA) to version 6.7 from 6.6, 6.6 MP1, or 6.6 MP2:

[1:ERROR] WpfLogger.<Log>b__0() Error    
    6.7.0.0 upgrade  ADD PERIOD FOR SYSTEM_TIME on table 'RiskFabric.dbo.LDW_DIMPolicies' failed because there are open records with start of period set to a value in the future.

IF COL_LENGTH(N'[dbo].[LDW_DIMPolicies]', N'RFModifiedBy') IS NULL
ALTER TABLE [dbo].[LDW_DIMPolicies] ADD[RFModifiedBy] [UNIQUEIDENTIFIER] NULL
IF COL_LENGTH(N'[dbo].[LDW_DIMPolicies]', N'SysStartTime') IS NULL AND COL_LENGTH(N'[dbo].[LDW_DIMPolicies]', N'SysEndTime') IS NULL
ALTER TABLE [dbo].[LDW_DIMPolicies] ADD
[SysStartTime] [DATETIME2] (0) GENERATED ALWAYS AS ROW START HIDDEN NOT NULL CONSTRAINT [DF_LDW_DIMPolicies_SysStartTime] DEFAULT (getdate()),
[SysEndTime] [DATETIME2] (0) GENERATED ALWAYS AS ROW END HIDDEN NOT NULL CONSTRAINT [DF_LDW_DIMPolicies_SysEndTime] DEFAULT (CONVERT([DATETIME],'9999-12-31 23:59:59',(0))),
PERIOD FOR SYSTEM_TIME ([SysStartTime], [SysEndTime])
    
[1:ERROR] WpfLogger.<Log>b__0() Error
    6.7.0.0 upgrade  Cannot set SYSTEM_VERSIONING to ON when SYSTEM_TIME period is not defined and the LEDGER=ON option is not specified.

Environment

Release : 6.7 (6.7.0.0)

Component : Installation Wizard

Resolution

The installation package for ICA 6.7 has been re-released with a modification to address this condition. Replace any installation package downloaded before August 3, 2025 with the latest version of the installation package.