1750

Issue:
When SecureDoc Enterprise Console is making connection to SQL database and attempting to update SQL Database following error\warning is generated
we are unable to upgrade database .



Product version affected:
7.1sr4 , 7.1sr4 HF3

Environment (OS/hardware/software):

Server 2008/2013
SQL 2008/2012

Work Around:

We will need to apply a SQL script to remove the old Constraint

DECLARE @NeedsFolderCalculationCon NVARCHAR(MAX) = NULL;
select @NeedsFolderCalculationCon = d.name from sys.all_columns c
join sys.tables t on t.object_id = c.object_id
join sys.schemas s on s.schema_id = t.schema_id
join sys.default_constraints d on c.default_object_id = d.object_id
where t.name = 'Admins' and c.name = 'NeedsFolderCalculation'
IF @NeedsFolderCalculationCon IS NOT NULL
exec ('alter table Admins DROP CONSTRAINT ' + @NeedsFolderCalculationCon);

SQL Script is also attached in KB DefaultConstaint.sql

Ensure that correct Database is Selected


Fix Version

This will be added in 7.1sr5
SD-20801