Hi,
I had to edit my post, because of new findings.
I'm running a HANA Procedure that calls a FlowGraph among other things. Running this HANA Procedure give me this error message:
invalid number: <Composite Exception ID 139624857098176 start> <Part 1>: [339]: invalid number: "_SYS_BIC"."XXX.XXX::PR_101_PARAMETER_AUSWAHL_FUER_RF_2": line 168 col 2 (at pos 9238): [6930] attribute value is not a number;exception 700
I was able to identify the root cause of the error and it was not the line mentioned in the error. The procedure runs fine with this exact line, if I disable the call of the FlowGraph (PAL_XXX_BETRAG_TRAIN_1).
The FlowGraph has one Input table (with valid data), a Random Forest (Train) Module and a data sink (database table) "T_XXX_TRAINED_MODEL_1" that writes into a table, which is truncated by the HANA procedure before the call of the FlowGraph.
The Procedure and FlowGraph were running fine on HANA 1.00.122.27.1568902538, now we upgraded to HANA 2.00.044.00.1571081837 and are facing this issue. If recreate the FlowGraph with a temp table as target, the Flowgraph runs fine.
Thanks in Advance!
The Code before the call looks like this (Error occurs at "CALL "XXX::PAL_XXX_BETRAG_TRAIN_1"();:")
/* ################## Anzahl der Trennvariablen werden ermittelt */ SELECT CURRENT_TIMESTAMP INTO START_TIME FROM DUMMY; COMMIT; WHILE (:TRY_NUM_START<=:TRY_NUM_END) DO UPDATE "XXXX::PAL_XXX_TRAIN_1.RANDOMFORESTTRAIN_PARAMS" SET INTARGS=:TRY_NUM_START WHERE NAME =:PARAM_NAME_XXX_TRENNVARIABLE; TRUNCATE TABLE "XXX::T_40858_TRAINED_MODEL_1"; TRUNCATE TABLE "XXX::T_40860_FIT_RESULT_XXX_4" ; TRUNCATE TABLE "XXX::T_40859_FIT_RESULT_TEST_2"; CALL "XXX::PAL_XXX_BETRAG_TRAIN_1"(); CALL "XXX::PAL_XXX_BETRAG_TEST_2"(); CALL "XXX::PAL_XXX_BETRAG_XXX_2"();