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