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