DB Connection HANA

Hello, I am having the below error when trying to connect to a Hana view, it seems the view requires to define a variable, however, I don’t know how to do that in the SQL query inside the “DB Table Selector” node, does anybody know?

“ERROR DB Reader 3:21 Execute failed: SAP DBTech JDBC: [2048]: column store error: search table error: [34023] Instantiation of calculation model failed;exception 306106: Undefined variable: $$IP_RateType$$. Variable is marked as required but not set in the query”

Hi @Diego2609 ,

You may want to look into this node to potentially pass the $$IP_RateType$$ variable in before the read:

Please let me know if this helps.


you can use the DB SQL Executor node to create the variables before using it in a subsequent node. Have a look at this example workflow for more details: Working with user-defined database variables – KNIME Hub


It was by using:
‘PLACEHOLDER’ = (’$$IP_RateType$$’,‘M’))

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.