Increase size of column "FAILURE_REASON" in table MERGE_RESULT

Summary

As of now, if a merge fails, the reason will be stored in the table MERGE_RESULT, column FAILURE_REASON.

The column is defined as varchar(4000), but if the reason of failure exceeds 4000 chars, storing this information will fail. The build result behind this merge can potentially be innaccessible, and a DB corruption needs to be manually fixed.

Worakround

If this happens, remove the build result to clean the database corruption

Accepted solution 1

Increase the size of this column.

Accepted solution 2.

Trim the merge failure message to avoid corruption