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