3514643 - I receive OPTION_NOT_VALID Extraction error when using delta load in Process Intelligence

Symptom

I receive OPTION_NOT_VALID Extraction error when using delta load

Error: ExtractionJob failed | source-system: SAP | cause: Exception in Advanced Extractor occurred by com.signavio.pex.sap.exception.ConnectorException java.sql.SQLException OPTION_NOT_VALID

Reproducing the Issue

error using delta load for VAL of I2P for ECC systems

Resolution

If you are using a nested SELECT (Sub query), which have a query limit of 10,000 entries (see here), please check and ensure that the sub query does not return more than 10,000 entries.

Keywords

Extraction Error, OPTION_NOT_VALID, delta load, sub-query , KBA , BPI-SIG-PI-DS , Data Source (CSV, Connector) , Problem

Product

SAP Signavio Process Manager all versions