KNOWLEDGE BASE

SAP HANA Input Parameters not Passed in Queries During Extract Refresh


Published: 16 Jun 2020
Last Modified Date: 10 Jul 2020

Issue

Published extracts that require input parameters are failing to refresh. The most common failure messages are:

[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;2048 column store error: search table error: [34023] Instantiation of calculation model failed;exception 306106: Undefined variable: $$IP_DATE_FROM$$. Variable is marked as required but not set in the query

or 

Connectionless Failure (status code = 10000, SAP DBTech JDBC: [2048]: column store error: search table error: [3023] Instantiation of calculation model failed;exception 306106: Undefined variable [input_param]. Variable is marked as required but not set in the query )

Environment

  • Tableau Server 2020.2.1
  • SAP HANA

Resolution

Workaround 1
Hard coding the input parameters as Custom SQL in the data source may resolve the issue, but may cause performance issues. Make sure you test it in a test environment.

Workaround 2
Downgrade Tableau Server to 2020.2 or older 

 

Cause

This is a known issue currently being investigated by Tableau development team.
Did this article resolve the issue?