etlHealth failed during upgrade

Products

• DX NetOps
• CA Performance Management - Usage and Administration

Issue/Introduction

Fatal error, unable to create table attribute_instance_natural_key_dups
ERROR 3007: DDL statement interfered with this statement
Checking ETL health. failed .............................................[FAIL]

Could not enforce prerequisite compliance.
Data Repository Prerequisite Compliance Status on <drhostname> failed.

Environment

21.2.12

Cause

This is likely a timing issue with something locking the table. 

Make sure there are no data repository backups or copyclusters running.

Try re-running with the Data Aggregator stopped.

Resolution

Re-run the dr_validate.sh again. 

If the issue persists, please contact support.