3742185 - Error: “unrecognized column <COL_NAME> in query for table <TABLE_NAME>” during PDM Source Data extraction in SAP Signavio Process Intelligence

During data extraction in Process Data Management (PDM) for a Source Data entity, the extraction fails with the following error message:

“unrecognized column <COL_NAME> in query for table <TABLE_NAME>”

The affected table does not extract successfully and remains in an error state.

This issue is caused by a mismatch between the structure of the source system and the internal schema maintained for the Source Data entity in SAP Signavio Process Intelligence.
Specifically, one or more columns present in the source system are not expected by the existing internal schema, or required columns defined in the internal schema no longer exist in the source. This inconsistency prevents the extraction logic from successfully aligning the source data with the stored schema.

To resolve this issue, the internal schema must be reset by re‑extracting the affected table(s) after removing the unrecognised column from the source definition. Perform the following steps for each affected table:

1. In Source Data, ensure that the unrecognised columns have been removed from the table definition.
2. Delete the previously extracted data without deleting the table itself:
   • Open the table in Source Data.
   • Select Delete extracted data.
   • Choose Delete only extracted data and keep the table.
   • Enable the following options:
     • Keep partition strategy
     • Keep SQL filter and variables
   • Click Delete.
3. (Optional) Preview the table to verify the structure.
4. Run the extraction again to re‑extract the table data.

Additional reference:
SAP Help – Data Deletion (Standard Extraction)
https://help.sap.com/docs/signavio-process-intelligence/user-guide/data-deletion-standard-extraction

soe, SAP Signavio Process Intelligence, Process Data Management, PDM, Source Data, data extraction error, unrecognized column, schema mismatch, source system changes, table extraction failure, reset extraction, delete extracted data, re-extract table, internal schema, data consistency