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

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)

 
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

SAP HANA, platform edition 2.0

SDA, virtual table, refresh, definition, SDA , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , Problem

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

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