SAP Knowledge Base Article - Public

3161449 - Extracting from CDPOS table failed after many hours using on premise ETL Connector

Symptom

I would like to extract CDPOS table from an SAP System using the on-premise ETL extractor, running into this error below after many hours.

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: java.sql.SQLException: CPIC-CALL: CMRCV on convId:########

ERROR Return codes ( function=STIAsRcvFromGw / CPIC-RC=CM_DEALLOCATED_ABEND / SAP-RC=GW_SHUTDOWN )


Resolution

If you are using CHANGENR in WHERE clause to filter results, please try to add CHANGENR as parameters and apply a page size 100000 to see if it works.


Keywords

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

Product

SAP Signavio Process Intelligence all versions