Skip to Content

invalid number ERROR in HANA

Oct 13, 2017 at 12:18 PM


avatar image

Hi Community,

Am facing below error while calling a procedure.

SAP DBTech JDBC: [339]: invalid number: [339] invalid number: not a valid number string 'N' at function to_int() (please check lines: 5, 30, 79, 111, 164, 170, 224, 228, 279, 283, 314, 363)

I have tried all the below conversions for all the integer outputs.

  1. TO_NVARCHAR(Cloumn) AS Cloumn : tried to convert into string to check it
  2. CASE WHEN Cloumn='' THEN 0 ELSE Cloumn END AS PROJECT_NUMBER : did not work : throwing below error :invalid number: not a valid number string '' at function __constructor__()
  3. CASE WHEN Cloumn IS NULL THEN 0 ELSE Cloumn END AS Cloumn : no use.
10 |10000 characters needed characters left characters exceeded

"no use" is quite spot on... without the code that leads to the error, there is little anyone can say here.

Therefore, come back with the most minimal version of your code that still produces the error and we might have a chance to understand what's going on.

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

0 Answers