URT fails with the following: Mismatched or Missing Check Constraints KEYWORDCONDITION NVL(LENGTH(KEYWORDLIST),0) >= CHECKKEYWORDS
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)

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.

Powered by Wolken Software