on 2019 Mar 05 10:43 AM
Hello All,
I'm trying to replicate the below(as per the link) scenario in HANA studio using the APL Procedures.
I have done the CREATE_MODEL_TRAIN successfully, but, when I'm trying to execute the APPLY_MODEL procedure I'm facing the below error.
Could not execute 'call APLWRAPPER_APPLY_MODEL( FUNC_HEADER, MODEL_TRAIN_BIN, APPLY_CONFIG, -- APL Inputs ...' in 548 ms 173 µs .
SAP DBTech JDBC: [423]: AFL error: search table error: _SYS_AFL.APL_AREA:APPLY_MODEL: [423] (range 3) AFL error exception: [APL error] Automated Analytics error (-2147024809): phase 'KxCPPInterf::IKxenModel::sendMode()' [[APLModel:New store already opened.][:Mapping Failed
Mapping Logical Variables to Physical Fields For data set ApplyOut (APL_ApplyOut)
The layout of an existing space does not match the expected one.
There are 1 unexpected fields that will be cleared.
Some mandatory variables have not been successfully mapped:KxIndex]]
Can anyone please advise?
Thanks,
Krishna.
Hello Khrisna, based on Marc's suggestion, can you please raise a support ticket with SAP support if not yet done?
Thanks & kind regards,
Antoine
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I would suggest you double check the input table that provides the trained model. Please contact the technical support if it still doesn't work.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes you can build a model with the apl wrapper create_and_train_model, and then apply the trained model with the apply_model procedure.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Marc,
Thanks for your response.
I remodeled the whole scenario using the proceduree method and got struck at the APPLY_MODEL step, where I'm facing the below error:
Could not execute 'call "SAP_PA_APL"."sap.pa.apl.base::APPLY_MODEL_AND_TEST"( FUNC_HEADER, MODEL_IN, CREATE_CONFIG, ...' in 387 ms 396 µs .
SAP DBTech JDBC: [423]: AFL error: search table error: "SAP_PA_APL"."sap.pa.apl.base::APPLY_MODEL_AND_TEST": line 37 col 4 (at pos 1859): [423] (range 3) AFL error exception: AFL error: search table error: _SYS_AFL.APL_AREA:APPLY_MODEL_AND_TEST: [423] (range 3) AFL error exception: [APL error] invalid/missing model format: empty model
Thanks,
Krishna.
Hi marc,
Thanks for your feedback. However, we have almost developed most of the model using the AFL Wrapper functions. Is there any way of calling only the APL function(APPLY_MODEL) using the stored procedures ?
Thanks.
Krishna.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It looks like your are using the APL wrapper method. I would suggest the APL procedure method that is simpler and less error prone.
See the classification sample scripts under: ...\samples\sql\procedure\apl_insurance_fraud
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
9 | |
8 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.