SAP Knowledge Base Article - Preview

3118509 - Error: "invalid remote object name: Exception occurred during execution on the exchange'" when creating Virtual Table through CamelJDBCAdapter connection

Symptom

  • Create virtual table failed through CamelJDBCAdapter remote source that connect to "Apache Solr"
        "Could not execute 'CREATE VIRTUAL TABLE "<schema_name>"."<virtual_tablename>" AT "<remotesource_name>"."***"."NULL"."***"' in *** ms *** µs . SAP DBTech JDBC: [476]: invalid remote object name: Exception occurred during execution on the exchange: Exchange[***]"
  • Error from framework.trc file.
        "Pipeline | PipelineHelper.continueProcessing [] - Message exchange has failed: so breaking out of pipeline for exchange: Exchange[***] Exception: com.sap.hana.dp.adapter.sdk.AdapterException: Failed to import metadata due to exception.while trying to invoke the method java.sql.ResultSet.next() of a null object loaded from local variable 'rsColumns' Context: java.lang.NullPointerException: while trying to invoke the method java.sql.ResultSet.next() of a null object loaded from local variable 'rsColumns'"


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration 2.0

Keywords

JDBC, camelJDBCAdapter, test, remote source , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , 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.