Can not insert data from temp table

[Former Member]

Hi all,

in HANA Studio i am trying to execute a procedure by calling the procedure with overview in order to fill a predefined column table with the procedure result.

Now when executing the procedure I get below error message in Log:

SAP DBTech JDBC: [1301]: numeric or value error: [1301] BIAPPL.CE_SQL_TEST2: line 15 col 2 (at pos 452): SQLException1301 exception

When i execute the same procedure call without passing the table name but NULL it will write it in a temp table where i can read then the data from.

Does anyone else already faced this issue?

BR,

Bastian

[Former Member]

Hi Bastian,

Just FYI I'm facing the same error (SQLException 1301 - numeric or value error). Haven't had any luck narrowing down the source - it's in the middle of lots of SQLScript, and when I start whittling down my script (not touching the problematic code) the error magically disappears... will let you know if I find anything out.

Cheers

Jody

(Lars, if I can simplify the code and reproduce the error I'll post it - you tend to see right through these things )

[Former Member]

Not sure exactly what the source was, seems HANA was being finicky about storing data in a temp variable. All I did was create a temporary table and store the data there, solved the problem.

[lbreddemann]

Well I also tried just laying my hands on - but this never worked

Without the source code for the failing procedures, I really can't do anything.

[Former Member]

Well the source code is quite involved and the bug was quite obscure so I figured I'd wait to post it. Workaround above seems to be working, but if that changes I may post some snippets. Thanks, Lars.

[Former Member]

I got something like this, but the same script works fine if I use it with subset of the data-sets I am trying to process. Looks like it ran out of memory? I am going to increase memory and try it out, in the meanwhile if anyone had any idea?

Could not execute 'CALL _SYS_AFL.PAL_DT(V_DT_DATA, DT_PARAMS, DT_MODEL_JSON, DT_MODEL_TREEMODEL) WITH OVERVIEW' in 162 ms 515 µs .

SAP DBTech JDBC: [2048]: column store error: search table error:  [2620] executor: plan operation failed;Can not insert data from temp table "SYSTEM:P3_550A04985809171AE1000000AC1F001B (-1)" into table ""TITANIC"."DT_MODEL_JSON""