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.
Thanks,
Zack
Hi,
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
Bye
Tobias
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.