SAP Knowledge Base Article - Public

3594093 - Facing error 'Primary keys from request do not match the schema primary keys' during extraction

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

  1. Firstly, please ensure you have updated to the latest version of the On-Premise Extractor.
  2. 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