Issue

An error appears at the last part of database consolidation: Constraint, Proc, Index.

"Database consolidation was cancelled or failed. See log for more information."

Image

Symptoms

The installer log generated by the tool shows the error "Could not re-encrypt."

It points to a particular entry in the [CustomUM].[User] table inside the K2SQLUM database where UserID=0 fails to get decrypted.

Troubleshooting Steps

Prior to running the consolidation tool, remove the entry on the table which fails to get decrypted:

DELETE FROM [K2SQLUM].[CustomUM].[User] WHERE [UserID] = 0


If this does not help, please ensure that the connection string (VariableValue) points to the SQL server instance where the single K2 database will be hosted:
SELECT [VariableToken], [VariableValue] FROM [K2HostServer].[HostServer].[Configuration]
WHERE VariableToken LIKE '%CONNECTIONSTRING%'


Should there be a need to update a connection string, kindly log a K2 Support Ticket as direct manipulation of data stored inside the K2 database without the supervision of a K2 personnel could put you in an unsupported state.