Delta merges can fail with various errors, and the details are written to columns LAST_ERROR and ERROR_DESCRIPTION in monitoring view M_DELTA_MERGE_STATISTICS and its history HOST_DELTA_MERGE_STATISTICS.

You can check for the top error messages using SQL: "HANA_Tables_ColumnStore_Merges" .