Skip to Content
0

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

Sep 05, 2017 at 01:37 PM

105

avatar image

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

10 |10000 characters needed characters left 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

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

G B Sep 05, 2017 at 04:44 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Gowthami,

I pass values to both parameters

0
Michael Healy
Sep 07, 2017 at 08:40 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded