Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • 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

  • 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

  • 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