cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member242922
Participant
0 Kudos

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

pfefferf
Active Contributor
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member183326
Active Contributor
0 Kudos

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.

former_member208449
Active Participant
0 Kudos

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.

former_member242922
Participant
0 Kudos

Hi Gowthami,

I pass values to both parameters