SAP Knowledge Base Article - Public

3643418 - Why are so many rows missing from my table data extraction in Signavio Process Intelligence when I use the Automatic Pagination partition strategy?

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

Product

SAP Signavio Process Intelligence 3.0