SAP Knowledge Base Article - Public

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

Symptom

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.

Resolution

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

Keywords

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

Product

SAP Signavio Process Manager all versions