SAP DBTech JDBC: [423]: AFL error: [423] "SYS"."AFLLANG_WRAPPER_PROCEDURE_CREATE"

[Former Member]

Hi All,

While trying to leverage the SAP Automated Predictive Library(APL) in SAP HANA, we are receiving an error like below. Have created all the necessary table types and have also filled them. Pasted the code snippet for more information. Assume all the table types defined in the signature has already been created under the schema USER_APL.

Any idea on how to fix this would be really helpful.. Thanks in advance..

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

successfully executed in 204 ms 296 µs  (server processing time: 5 ms 1 µs) - Rows Affected: 0

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'.

Duration of 2 statements: 407 ms

[Former Member · Accepted solution]

Hi All,

The issue was the datatype provided in the MRI_FAULT_DATA_T where I have used something like SMALLINT, TINYINT etc., replaced them with INTEGER and its working fine.

[marc_daniau]

Were you able to run sucessfully a create and train using the insurance fraud sample scripts under

...\apl-2.3.0.10-linux_x64\samples\sql\apl_insurance_fraud ?

If yes then I would double check the table type mri_fault_data_t

Marc

[Former Member]

Hi Marc,

Thanks for the info. I didn't check the insurance fraud sample, but I did execute the attached sql script which is for another scenario from the same /samples/sql/ folder and here the generator worked fine.

apl_clustering_with_adult01.sql

Below given is the table type definition for the mri_fault_data_t. Let me know if I am missing anything here. Thanks.

Regards,
Raghav

[achab]

Hi,

What are the revisions of SAP HANA and version of APL you are using?

Thanks & regards

Antoine

[achab]

Also please check the rights are OK on the SAP HANA side (see screenshot from our user guide here)

[Former Member]

Hi Antoine,

Yes. I have granted those roles to the USER_APL and I am able to generate other procedures except this one. I guess this has something to do with table types.

The version details are below.

APL : apl-2.3.1.0-linux_x64

Regards,

Raghav