Symptoms

DB consolidation seems to go through almost all the way to the end, but there were errors when getting to the "Constraint, Proc, Index" step of the consolidation process.
 

Diagnoses

This was because there was a duplicate entry in the eK2SmartBroker].]SmartBroker].]ServiceInstance] table. After consolidation, we tried to add a unique index on the table, but because of the duplicate entry, this broke.
 

Resolution

After removing the duplicate entry from the hK2SmartBroker].rSmartBroker].rServiceInstance] table, the consolidation process went through without a problem.