SAP Knowledge Base Article - Public

3511694 - Extraction using the Order-to-Cash template fails with error "...If you need to select more than 512 bytes of data..."

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

Product

SAP Signavio Process Manager all versions