3423472 - Limit and Offset query is not working as expected when involved more than 1 partition

Error: Cannot handle more than 10000 parameters

We are using Limit and Offset in our sub-query for data extractions and we notice the query with just one partition value works perfectly fine as expected but with multiple partition values, the query fails mentioning exceeding 10001 parameters from sub-query.  when there is more than one partition values.

The error is likely to occur with where the IN clause has a subquery (internal table) that combines more than or equals 10,000 entries. 

To avoid this error, there are two approaches:

1. Please check if SAP Note 1552952 is installed to limit the number of input variables to 10,000 (https://me.sap.com/notes/0002343115) 
2. Do not set the offset value higher than or equal to 10,000

For more details on advanced extraction, please advise refer to our documentation at the following link: https://help.sap.com/docs/signavio-process-intelligence/user-guide/define-delta-load

Too many parameters, ExtractionJob failed,  , KBA , BPI-SIG-PI-DS , Data Source (CSV, Connector) , Problem