SAP DBTech JDBC: [423]: AFL error: [423]

[Former Member]

Hi All,

While executing the AFL generator for APL library in HANA system, we are getting this error message like below.

Have followed all the steps and have also created all the necessary table types in the signature in the system as per the SCN documents.

Has anyone had come across something like this, please let us know how you fixed it. Any guidance would be really helpful.

Could not execute 'call SYS.AFLLANG_WRAPPER_PROCEDURE_CREATE('APL_AREA', 'CREATE_MODEL_AND_TRAIN', 'USER_APL', ...' in 203 ms 324 µs .

SAP DBTech JDBC: [423]: AFL error:  [423] "SYS"."AFLLANG_WRAPPER_PROCEDURE_CREATE": line 156 col 5 (at pos 5073): [423] (range 3) AFL error exception: AFL error: Registration of AFLLANG wrapper procedure "USER_APL"."APLWRAPPER_CREATE_MODEL_AND_TRAIN" failed with error 'invalid parameter description'.

Code Executed:

-- Create the signature of the procedure

drop table CREATE_MODEL_AND_TRAIN_SIGNATURE;

create column table CREATE_MODEL_AND_TRAIN_SIGNATURE  like PROCEDURE_SIGNATURE_T;

insert into CREATE_MODEL_AND_TRAIN_SIGNATURE values (1, 'USER_APL','FUNCTION_HEADER_T', 'IN');

insert into CREATE_MODEL_AND_TRAIN_SIGNATURE values (2, 'USER_APL','OPERATION_CONFIG_T', 'IN');

insert into CREATE_MODEL_AND_TRAIN_SIGNATURE values (3, 'USER_APL','VARIABLE_DESC_T', 'IN');

insert into CREATE_MODEL_AND_TRAIN_SIGNATURE values (4, 'USER_APL','VARIABLE_ROLES_T', 'IN');

insert into CREATE_MODEL_AND_TRAIN_SIGNATURE values (5, 'USER_APL','MRI_FAULT_DATA_T', 'IN');

insert into CREATE_MODEL_AND_TRAIN_SIGNATURE values (6, 'USER_APL','MODEL_BIN_OID_T', 'OUT');

insert into CREATE_MODEL_AND_TRAIN_SIGNATURE values (7, 'USER_APL','OPERATION_LOG_T', 'OUT');

insert into CREATE_MODEL_AND_TRAIN_SIGNATURE values (8, 'USER_APL','SUMMARY_T', 'OUT');

insert into CREATE_MODEL_AND_TRAIN_SIGNATURE values (9, 'USER_APL','INDICATORS_T', 'OUT');

-- Generate the procedure

call SYS.AFLLANG_WRAPPER_PROCEDURE_DROP('USER_APL','APLWRAPPER_CREATE_MODEL_AND_TRAIN');

call SYS.AFLLANG_WRAPPER_PROCEDURE_CREATE('APL_AREA', 'CREATE_MODEL_AND_TRAIN', 'USER_APL', 'APLWRAPPER_CREATE_MODEL_AND_TRAIN', CREATE_MODEL_AND_TRAIN_SIGNATURE);

Regards,

Raghav

[achab]

Hi,

Could you please kindly flag this post as Answered, as I assume it is a duplicate to this one

Good to know your problem is resolved now 🙂

Thanks & regards

Antoine