search cancel

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

book

Article ID: 174428

calendar_today

Updated On:

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)

Cause

Constraint missing for table KEYWORDCONDITION

Environment

Upgrading to DLP 15.5

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/[email protected];

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.