Symptom
When attempting to perform a Process Intelligence Extraction, using the Order-to-Cash template, the following message is received.
Error: ExtractionJob failed
cause: Exception in Advanced Extractor occurred by com.signavio.pex.sap.exception.ConnectorException
java.sql.SQLException
You have selected to return 757 bytes worth of data per row.
However, SAP only allows 512 bytes to be returned.
Select fewer columns to avoid this error.
If you need to select more than 512 bytes of data, you can install the Z_CUSTOM_READ_TABLE function to SAP and update the connection to refer to it
It should be noted that this template accesses the SAP table CDPOS.
Cause
There are limitations in the SAP default RFC_READ_TABLE function.
This function is used by Process Insights to access SAP tables.
Resolution
Please implement the solution in SAP Note 2246160 - Enhancement RFC_READ_TABLE (7.40+) - SAP for Me
The RFC_READ_TABLE function needs to be enhanced so it can handle more than 512 bytes of data.
Additonal
If you are getting this error, then you may also need to apply other SAP Notes.
Please review: Required and Use Case Specific SAP Notes | SAP Help Portal to see if any additional SAP Notes need to be applied to your Process Insights implementation.
Keywords
KBA , BPI-SIG-PI-DS , Data Source (CSV, Connector) , Problem
SAP Knowledge Base Article - Public