KNOWLEDGE BASE

Error "Syntax error or access violation" Using Published Data Source Based on SAP HANA


Published: 03 Aug 2015
Last Modified Date: 16 Sep 2015

Issue

When using a published data source connected to a calculation view in SAP HANA, the following error might occur:

[SAP AG][LIBODBCHDB32 DLL][HDBODBC32] Syntax error or access violation;257 sql syntax error: line 1 col 29 (at pos 29)

Environment

  • Tableau Server 9.0
  • SAP HANA

Resolution

Option 1

Upgrade Tableau Server to 9.0.5 or a later version. For more information, see Upgrading Tableau Server.

Option 2

Use an embedded connection to SAP HANA, rather than a data source published to Tableau Server.

Cause

This behavior is related to a known issue which has been corrected in more recent versions.
Did this article resolve the issue?