URT reports warnings on UPGRADE SCHEMA task as well as TABLE DEFINITION task

Products

• Data Loss Prevention Enterprise Suite

Issue/Introduction

After a successful run of URT, prior to upgrade from 15.8 to 16.x, the report has a warning on Upgrade Schema and Table Definitions.

Warnings from the URT:

   TASK_ID  BATCH_NUM ERROR_TYPE ERRANT_STMT                                      ERROR
---------- ---------- ---------- -------------------------------------------------------------------------------- ------------------------------
     6        1 WARNING     DROP TABLE DATAUSER_STG                              ORA-02449: unique/primary keys in table referenced by foreign keys
    16        1 WARNING     Obsolete Tables
                 ------------------------------
                 DATAUSER_STG

Environment

DLP 15.8

DLP 16.0.x

Cause

The attempt to drop the table, DATAUSER_STG, was made out-of-order. 

Resolution

The table, DATAUSER_STG, is no longer used by the product moving forward. Feel free to drop the table manually, or wait until the next upgrade where the table will be dropped again.