ERROR: SAP DBTech JDBC: [339]: invalid number: not a valid number string

[former_member592144]

Good day.

I've got a problem in a calculation view.

I use a CUBE calculation view which has another Calculation view as data source.

Ive filtered 0CALMONTH through input parametrs (NVARCHAR, 6 ) in expression of my basis projection with calculation view.

Now when i try to make a Data Preview on this projection, I get this type of error:

Cannot get the data provider outline

SAP DBTech JDBC: [339]: invalid number: not a valid number string '' at function __typecast__()

When i open the calculation view, which is in projection ( which has the same filters and input parameters ) it works fine.

Any suggestions ?

[former_member592144 · Accepted solution]

The problem was solved. One of our developers used incorrect SQL statement in filter expression ( concatenated string statement with 01 instead of '01')

[KonradZaleski]

Firstly to make sure that this specific Input Parameter is the root cause of the error, try to remove it with the filter expression which is used for that IP.

If report works after removing it then:

• Check if 0CALMONTH column is also of VARCHAR(6) data type
• Make sure that filter expression is correct:
  for single value parameter it should be:

"0CALMONTH" ='$$IP_CALMONTH$$'

for multiple value parameter

in("0CALMONTH" ,  $$IP_CALMONTH$$)

If report still doesn't work after removing that IP, the root cause can be different:

• Check other input parameters which you are using (if its data type is consitent with column data type)
• Check definition of calculated columns - maybe there is some incorrect casting or operation

[former_member592144]

Thanks for the reply.

I removed the IP and the preview on the projection still doesn't work. And again if i open the calculation node that is used in this projection and make a data preview on it, it works fine.