SAP Knowledge Base Article - Preview

2481424 - Refresh SDA virtual table failed with error "SAP DBTech JDBC: [257]: sql syntax error"

Symptom

You want to refresh SDA virtual table's definition on HANA database after the source table is changed.

However, the SQL command "ALTER VIRTUAL TABLE [<schema>.]<virtual_table_name> REFRESH DEFINITION" failed with error:

Could not execute 'ALTER VIRTUAL TABLE [<schema>.]<virtual_table_name> REFRESH DEFINITION'
SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "REFRESH": line 1 col 50 (at pos 50)
 


Read more...

Environment

SAP HANA 2.0

Product

SAP HANA, platform edition 2.0

Keywords

SDA, virtual table, refresh, definition , 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.