Update Readiness Tool Reports Failure on Import: ORA-39375: Statistics failed to import.

Products

• Data Loss Prevention Enterprise Suite

Issue/Introduction

URT reports failure on full import but does not mark the upgrade test as failed.

Environment

Release : 16.0

Cause

Import: Release 19.0.0.0.0 - Production on Tue Oct 17 18:47:05 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Master table "PROTECTURT"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "PROTECTURT"."SYS_IMPORT_FULL_01":  "protecturt/********@protectdb" dumpfile=sandbox_result.dmp remap_schema=protect:protecturtdirectory=data_pump_dir logfile=imp_sandbox_result.log TABLE_EXISTS_ACTION=REPLACE 
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "PROTECTURT"."DSH_PRECHECK_SUMMARY"        6.546 KB       1 rows
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
ORA-39375: Statistics failed to import. Failing error is 
ORA-04088: error during execution of trigger 'DB_ADMIN.TIMEZONE_CHECK'
ORA-00604: error occurred at recursive SQL level 3
ORA-20001: This table has timezone columns.   T1  Please contact Primary DBA for Adding more columns

Resolution

If the sandbox upgrade has completed with non-fatal errors, then these errors on statistics import can be ignored.