SAP Knowledge Base Article - Public

3449520 - Datasphere JCO_ERROR_CONVERSION error when previewing data on remote table

Symptom

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..."

Environment

SAP Datasphere

Reproducing the Issue

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

Resolution

Solution: Change in SAP ABAP adapter, change remote source configuration parameter RFC Serialization value to ‘rowbased’. 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

Keywords

KBA , DS-DI-CON , Connections , Problem

Product

SAP Datasphere all versions