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 [K2SmartBroker].[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 [K2SmartBroker].[SmartBroker].[ServiceInstance] table, the consolidation process went through without a problem.