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