Skip to Content

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

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 ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 31, 2018 at 11:03 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 30, 2018 at 02:39 PM

    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
    Add comment
    10|10000 characters needed characters exceeded

  • Oct 30, 2018 at 03:46 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded