SAP Knowledge Base Article - Public

3242423 - Using on premises ETL connector to extract from S/4 HANA Order-to-Cash got error in Process Intelligence

Symptom

Using on premises ETL connector to extract from on premises S/4 HANA Order-to-Cash, ends with error as below. How can we fix this?

ExtractionJob failed | source-system: SAP exception: com.signavio.pi.etl.extractor.shared.exception.EtlException: Exception in Advanced Extractor occurred cause: com.signavio.pex.sap.exception.TransactionException: com.signavio.pex.sap.exception.ConnectorException: com.signavio.pex.sap.exception.ConnectorException: java.sql.SQLException: A table could not be found that matches CDPOS.]]>




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

Resolution

First, please check "Tables *" section in your connector configuration. If there is any table added in that field, the connector filters only to those tables to connect. Please remove "t001" if exists as a default and add all tables you want to connect.


Keywords

KBA , BPI-SIG-PI-DM , Data model / ETL for SAP Signavio Process Intelligence , How To

Product

SAP Signavio Process Intelligence all versions

Attachments

image2022-2-9_14-41-6.png