We have a calculation view with input parameters, we are calling this calculation views in other procedures/table functions. The input parameter is filled in the procedure through looking up a config table.
Everything is working fine perfectly until we upgraded from HANA2.0 Sp02 to SP03.
Now, in the procedure, if we assign a hard coded value, or use Dummy table to assign value to the variable, and then pass the variable to the calculation view input parameter, it is working fine.
But if we use a config table to assign the value to the variable, the calculation view input parameter won't take it. And throwing out some data casting error.
Does anyone experience this issue with Sp03 and have a solution for that?