3530305 - Resolving Duplicates in the SNAP Table During System Conversion to SAP S/4HANA

During the Data Transfer Import (DT_IMP) phase of a system conversion to SAP S/4HANA, the following issue occurs:

• The phase is unable to create a unique index due to duplicate entries in the SNAP table.
• Despite deleting the existing duplicates, as stated in KBA 2262573 and 3465769, new entries are created continuously at a high rate .
• The SUM (Software Update Manager) tool fails to create the index due to the violation of the unique constraint on the SNAP table.

Error Message:

Task failed with error: (HDB) DbSlExecute failed for DDL statement 'ALTER TABLE "SNAP"
ADD CONSTRAINT "SNAP~0" PRIMARY KEY ( "DATUM" , "UZEIT" , "AHOST" , "UNAME" , "MANDT" , "MODNO" , "SEQNO" )'
(HDB) dbrc = 26 'unique constraint violated'

Read more...

SAP HANA, platform edition 2.0 ; SAP S/4HANA 1610 ; SAP S/4HANA 1709 ; SAP S/4HANA 1809 ; SAP S/4HANA 1909 ; SAP S/4HANA 2020 ; SAP S/4HANA 2021 ; SAP S/4HANA 2022 ; SAP S/4HANA 2023 ; SAP S/4HANA 2025 ; SAP S/4HANA 2027 ; SAP S/4HANA, on-premise edition 1511

SNAP table duplicates, Unique constraint violation, SUM tool error, SAP HANA duplicate keys, Truncate SNAP table, CRC check differences, System conversion, Data Transfer Import (DT_IMP), DMO , KBA , BC-UPG-TLS-TLA , Upgrade tools for ABAP , HAN-DB , SAP HANA Database , Problem