Skip to Content
avatar image
SHINY NICKITHA CHELLAM J

Error while adding two input parameters to a calculation sql scripted view

Sep 05, 2017 at 01:37 PM | 112 Views

Hello,

While using two input parameters to a scripted Calculation view, I get the below error.

Error: SAP DBTech JDBC: [2048]: column store error: search table error: [34023] Instantiation of calculation model failed;exception 306106: Undefined variable: $$d1$$. Variable is marked as required but not set in the query

If I execute the same script with only one input parameter, the query works fine. Issue raises when I use two input parameters.

Could someone please explain why do we face this error?

Thanks,

Shiny

SAP HANA
Add comment
10|10000 characters needed characters exceeded

  • Florian Pfeffer
    Sep 05, 2017 at 05:35 PM

    Please can you add some more details to your question (e.g. the parameter definitions for your scripted calculation view; the coding how you call the view, ...).

    Thx,
    Florian

  • Get RSS Feed

2 Answers

  • avatar image
    G B
    Sep 05, 2017 at 04:44 PM

    Hi

    From the error, it seems to me that you aren't passing a value to your parameter while executing the scripted calculation view.

    Please check.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Michael Healy
    Sep 07, 2017 at 08:40 PM

    What kind of parameters are you using? As far as I know this is a known issue with SAP at the moment.

    I would recommend opening an incident with SAP for further info.

    Add comment
    10|10000 characters needed characters exceeded