DLP 16.0 URT Error ORA-32417 DROP MATERIALIZED VIEW LOG

Products

• Data Loss Prevention Network Discover

Issue/Introduction

You want to upgrade to DLP 16.0 and are running the Upgrade Readiness Tool.  You notice from the URT log output an error for  "ORA-32417: must use DROP MATERIALIZED VIEW LOG.

 

Environment

Release : 15.7, 15.8.

Cause

Log on the to Protect database in oracle and run the following sql command,

SELECT owner, mview_name, container_name, query FROM all_mviews;
SELECT log_owner, master, log_table FROM all_mview_logs;

From this output you will see that a materialize table view was added to the WalkReport table.  And, is still tracking changes for that table.  DLP doesn't use materialized views. 

Due to this customization to the DLP database schema the URT fails to run clean without error.

 

Resolution

When this situation happens customer's must rely on their Oracle DBA's to remove the materialize table view before proceeding with running the URT.

Additional Information

Our product doesn't use materialized views so either the customer's DBA added a materialized view to our schema (which would not be supported) OR there is a materialized view left over from a online redefinition that didn't get properly cleaned up when it was finished.

Either way the Materialized View needs to be dropped before we can support this database