3542792 - Create SAP HANA Virtual Table Failed With Error "Cannot retrieve why the ODBC API has failed"

Symptom

Below error occurs when attempting to create virtual tables in the SAP HANA Database with SDA connection to postgresql remote source"

Could not execute 'CREATE VIRTUAL TABLE <table_name> AT ...'. SAP DBTech JDBC: [476]: invalid remote object name: Cannot retrieve why the ODBC API has failed

Environment

SAP HANA 2.0

Product

SAP HANA, platform edition 2.0

Keywords

Error 476, Invalid Remote Object Name, CREATE VIRTUAL TABLE, Postgresql, ODBC API , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , 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.