3449520 - Datasphere JCO_ERROR_CONVERSION error when previewing data on remote table

Data extraction operation in SAP Datasphere (for example data preview on remote table) throws below error.

• internal error: Error opening the cursor for the remote database <remote_database_name> com.sap.conn.jco.ConversionException: (122) JCO_ERROR_CONVERSION: Cannot convert a value from type int to type CHAR field PARAMCLASS in record RFC_FUNINT , Code: 403, SQL State: HY000

Below error messages can also be found in framework trace.

ABAPAdapter | ABAPAdapter.executeDelta [] - SAPI.0CUSTOMER_ATTR: com.sap.conn.jco.ConversionException: (122) JCO_ERROR_CONVERSION: Cannot convert a value from type int to type CHAR field PARAMCLASS in record RFC_FUNINT
                               at com.sap.hana.dp.abapadapter.TableLoaderExtractor.checkForPointer(TableLoaderExtractor.java:543)
                               at com.sap.hana.dp.abapadapter.ABAPAdapter.executeDelta(ABAPAdapter.java:2307)
                               at com.sap.hana.dp.abapadapter.ABAPAdapter.poll(ABAPAdapter.java:2274)
                               at com.sap.hana.dp.adapter.sdk.adapterbase.BaseAdapterClass$Poller.run(BaseAdapterClass.java:1542)
                               Caused by: com.sap.conn.jco.JCoException: (108) JCO_ERROR_INTERNAL: com.sap.conn.jco.ConversionException: (122) JCO_ERROR_CONVERSION: Cannot convert a value from type int to type CHAR field PARAMCLASS in record RFC_FUNI..."

SAP Datasphere

Data extraction operation in SAP Datasphere (for example data preview on remote table).

Solution: Change in SAP ABAP adapter, change remote source configuration parameter RFC Serialization value to ‘rowbased’ and then refresh the adapter. It needs to upgrade DP Agent to at least version 2.7.3.

SAP Note 3438494 - [ABAPAdapter] Support row-based serialization for remote sources

Since currently the RFC Serialization parameter is not exposed in connection dialog UI,  a manual change of this parameter value to ‘rowbased’ needs to be done by SAP support to resolve this completely.

Workaround: Upgrade Kernel patch level as per SAP Note 2418683.

SAP Note 2418683 - Fast Serialization Release Information

KBA , HAN-DP-SDI-DS , SAP Datasphere specific SDI issues , DS-DI-RT , Remote Tables , Problem