CHECK CONSTRAINT [CK_DATAFORMFIELDCHARACTERISTIC_VALIDFIELDID] is violated by data after the update to 4.0

When applying constraints to the database after updating, a couple of specs seem to violate the check constraint.
Download and install the latest patch which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch.

Steps to Duplicate

select * from DATAFORMFIELDCHARACTERISTIC 
where not ([dbo].[UFN_DATAFORM_ISINSTANCEFORMFIELDIDVALID]([DATAFORMINSTANCEID],[FIELDID])=(1))
 
select * from DATAFORMFIELDCHARACTERISTIC where dataforminstanceID IN (
'80DC7A4A-8120-4D91-8972-C6A2AD14DFE3',
'C92C0609-4724-40FE-B43C-E810B6884F19')

Environment

 Blackbaud CRM
 4.0
 4.0
 Service Pack 3

Was this article helpful?