SAP Knowledge Base Article - Preview

3566022 - [CamelJDBCAdapter] "DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC" when previewing Remote Table from DB2 in Datasphere - SAP HANA Smart Data Integration

Symptom

  • Using the CamelJDBCAdapter in Datasphere to connect to a DB2 database via the Data Provisioning Agent.
  • Doing a Snapshot replication is successful.
  • When using the Data Viewer for a preview of the data in the Data Builder, an error message is thrown in the DPAgent framework traces:
    • [ERROR] [] DPFramework | AsyncHandler.processStreamingExecuteStatement [] - AH(): Exception while processing request "SDA Response for CamelJdbcAdapter of type SUCCESS_MSG responding to FEDERATION_GET_NEXT"
      [ERROR] [] DPFramework | AsyncHandler.processStreamingExecuteStatement [] - AH(): com.sap.hana.dp.adapter.sdk.AdapterException: Camel execution failed. Reason: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=1000 [...] <sql command>, DRIVER=<driver version> Context: org.apache.camel.CamelExecutionException: Exception occurred during execution on the exchange: Exchange[]


Read more...

Environment

SAP HANA smart data integration 2.0

Product

SAP HANA smart data integration 2.0

Keywords

SAP Datasphere, Remote Table, DB2, Data Viewer, sqlerror -104, LIMIT, FETCH FIRST clause, DPAgent, sdi, smart data integration, data preview, top, limit , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , HAN-DP-SDI-DS , SAP Datasphere specific SDI issues , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.