Data Agregator no connecting Object "migration_status" already exists

Products

• CA Performance Management

Issue/Introduction

Caused by: com.vertica.support.exceptions.SyntaxErrorException: [Vertica][VJDBC](4213) ROLLBACK: Object "migration_status" already exists. In the exception.log. In the karaf.log I am getting this error

Added nodes to vertica cluster 

Add node Vertica cluster 

Data Aggregator hung 

NetOps Portal not connecting to Data Aggregator not 

Cause

Added node(s) to vertica cluster 

Resolution

1. Stop the Data Agregator 

2. Login to vsql on one of the vertica nodes and run: 

dauser>drop table dauser.migration_status cascade; 
dauser>commit; 

3 Then start the Data Agregator and it should re-generate the migration_status table and complete startup