URT fails with the following: Mismatched or Missing Check Constraints KEYWORDCONDITION NVL(LENGTH(KEYWORDLIST),0) >= CHECKKEYWORDS

Products

• Data Loss Prevention Enforce

Issue/Introduction

Upgrade Readiness Tool returns 1 error before upgrading to DLP 15.5

Mismatched or Missing Check Constraints

Table Name      Master Check Constraint Definition

---------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

KEYWORDCONDITION      NVL(LENGTH(KEYWORDLIST),0) >= CHECKKEYWORDS

End  : Check Constraint Validation - elapsed .78s - FAILED (1 error)

Environment

Upgrading to DLP 15.5

Cause

Constraint missing for table KEYWORDCONDITION

Resolution

1. Log into SQLPlus with your Protect account.  Note, if the default username Protect isn't used, use the equivalent.

sqlplus /nolog
connect protect/password@protect;

2. Run these two SQL command lines:

          ALTER TABLE KEYWORDCONDITION DROP CONSTRAINT KEYWORDS_KEYWORDLIST_CHK1;

ALTER TABLE KEYWORDCONDITION add CONSTRAINT "KEYWORDS_KEYWORDLIST_CHK1" CHECK (NVL(length(keywordlist),0) >= checkKeywords) ENABLE;
COMMIT;

3. Rerun the Upgrade Readiness Tool.