SAP Knowledge Base Article - Public

3339624 - Duplicates during extraction even though DISTINCT is used in sql block

Symptom

Duplicates during extraction even though DISTINCT is used in sql block.

Resolution

As we have just 40 records, it looks like issue with customer's Primary key configuration. Check whether they have done NON NULL as the primary key configuration.

And to avoid actual data duplication issue in future kindly ask customers to

  • Install SAP NOTE 2246160
  • And set below parameters as "Extra Connection Arguments"
    RFCReadTableOptions=USE_ET_DATA_4_RETURN,GET_SORTED;Pagesize=20000 

Keywords

KBA , BPI-SIG-PI-DTT , Data Transformation Templates , Problem

Product

SAP Signavio Process Manager all versions