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

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

Search for additional results

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