3639256 - Receiving an error message during an extraction in Process Intelligence that suggests to use the Z_Custom_Read_Table function

When carrying out an extraction in Process Intelligence that uses an On-Premise Extractor, you receive the following error message:

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.

This error occurs due to the rows that are attempting to be extracted, include more data than the 512 bytes limit that is the default with the SAP RFC_Read_Table function which our On-Premise Extractor uses.

Please know that there is no need to download the Z_Custom_Read_Table function that is included in the error message. All you need to do is install the following SNOTE on your SAP source system and re-run the extraction:

2246160 

If you still face this or any related errors during your next extraction, please feel free to reach out to Signavio Support via the SAP for Me platform and reference this Knowledge Article.

soe, process, intelligence, z_custom_read_table, z, custom, read, table, error, extract, 512, byte, limit , KBA , BPI-SIG-PI-DM , Data model / ETL for SAP Signavio Process Intelligence , Known Error