Symptom
You are facing the following error in Process Intelligence when extracting a table individually or during an ETL run:
ExtractionJob failed | source-system: SAP | cause: Primary keys from request do not match the schema primary keys
Cause
The Primary Keys defined in your Process Intelligence Source Data for the table that is throwing this error do not match the ones defined in your source system.
Resolution
- Firstly, please ensure you have updated to the latest version of the On-Premise Extractor.
- If this does not resolve the issue, please ensure that the Primary Keys defined for this table in your source system match the ones defined in your Process Intelligence Source Data.
The error message will include details on which Primary Keys are defined in each system:
"Primary keys from request do not match the schema primary keys. Missing keys: <missingKeys>. Extra keys: <extraKeys>."
Keywords
process, intelligence, source, data, extract, error, failed, primary, key, match, schema , KBA , BPI-SIG-PI-DS , Data Source (CSV, Connector) , Problem
Product
SAP Signavio Process Intelligence 3.0