SAP Knowledge Base Article - Preview

2886811 - CamelJDBCAdapter creates malformed SQL when including schema name in virtual table name - SAP HANA Smart Data Integration

Symptom

  • Could not execute 'SELECT TOP 1000 "DAY_DAY_ID", "DAY_DAY" FROM "EDW"."ORACLE_DW_DATAMARTS.DIM_TIME"'
  • Error: (dberror) 403 - SQL error, server error code: 403. internal error: Remote execution error Camel execution failed. for query "SELECT "ORACLE_DW_DATAMARTS.DIM_TIME"."DAY_DAY_ID", "ORACLE_DW_DATAMARTS.DIM_TIME"."DAY_DAY" FROM "DW_DATAMARTS.DIM_TIME" "ORACLE_DW_DATAMARTS.DIM_TIME" "
  • Virtual table name here is ORACLE_DW_DATAMARTS.DIM_TIME


Read more...

Environment

  • SAP HANA Smart Data Integration
  • CameJdbcAdapter

Product

SAP HANA smart data integration all versions

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

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