Symptom
Why are so many rows missing from my table data extraction in Signavio Process Intelligence when I use the Automatic Pagination partition strategy? The issue does not occur when I use the other partitioning options.
Cause
Although the USE_ET_DATA_4_RETURN parameter removes duplicate rows in your extracted data, this sorts your data in an order that is not using Primary Keys. However, Automatic Pagination relies on Primary Keys to extract data, leading to the extractor to skip rows.
Resolution
Please ensure that if you include the 'RFCReadTableOptions=USE_ET_DATA_4_RETURN' Extra Connection Argument in your Connection setup in Process Intelligence, that you also include 'GET_SORTED'.
Your argument should look like this:
RFCReadTableOptions=USE_ET_DATA_4_RETURN,GET_SORTED;
Keywords
process, intelligence, soe, extract, row, record, less, missing, automatic, pagination , KBA , BPI-SIG-PI-DM , Data model / ETL for SAP Signavio Process Intelligence , Known Error
SAP Knowledge Base Article - Public