SAP Knowledge Base Article - Public

3335189 - Error "LINK_INTEGRATION_TABLE_ALREADY_EXIST_IN_DATAMODEL" when linking multiple data sources to one pipeline in SAP Signavio Process Intelligence

Symptom

When linking multiple data sources to one process data pipeline, the following error message happens.  

Something went wrong
Error: LINK_INTEGRATION_TABLE_ALREADY_EXIST_IN_DATAMODEL

Error Id: <******************>
The given source data contain table(s) [XXX, ABC, XYZ] which already exists on the source data [***] connected the process data model [***]

* Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP Signavio Process Intelligence

Reproducing the Issue

  1. Process Intelligence 
  2. Click-on "Manage Data"
  3. In tab "Process data pipelines", open/create a pipeline
  4. Add source data with "Connection and source data" button
  5. Select a Connection type and next 
  6. Choose a Source Data and next 

Cause

When linking multiple source data to the process data pipeline, table names must be unique across all source data.

Resolution

The same table name in multiple Source Data can be unique by different table alias.
Please refer to the user guide Create a table name alias for details.

In Standard Extraction Mode:


In Advanced Extraction Mode, this can be done by "alias:<table-alias>"

See Also

Keywords

SAP Signavio, Process intelligence, process data pipelines, multiple source data, alias, table alias, LINK_INTEGRATION_TABLE_ALREADY_EXIST_IN_DATAMODEL , KBA , BPI-SIG-PI-DM , Data model / ETL for SAP Signavio Process Intelligence , BPI-SIG-PI-INT , Integration / Schedules / SQL Filter / Delta criteria , Problem

Product

SAP Signavio Process Intelligence 3.0