Skip to Content
author's profile photo Former Member
Former Member

Could not execute CALL "SYS".AFLLANG_WRAPPER_PROCEDURE_CREATE

Hi,

I am trying to create a PAL procedure of KMEANS and I get this below error:

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 "OWNSCHEMA"."PAL_KMEANS_PROC" failed with error 'no matching overload found'

code:

CALL "SYS"."AFLLANG_WRAPPER_PROCEDURE_CREATE"('AFLPAL', 'KMEANS', 'OWNSCHEMA', 'PAL_KMEANS_PROC', "PAL_KMEANS_PDATA_TBL");

I have access to OWNSCHEMA and created the table types and the signature table mentioned in the call statement above.

Please help us to solve this error:'no matching overload found'.

Thanks in advance,

Shilpa.

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 01, 2017 at 02:25 AM

    Hi Shilpa,

    The error happens when the number of input and output tables doesn't match what PAL KMEANS requires. Please check the PAL manual and see if there is difference between the example and what you have in PAL_KMEANS_PDATA_TBL.

    Best regards,

    Xingtian

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 17, 2019 at 04:58 PM

    This may happen due to the incompatible changes between different HANA SPS versions. Please check the appropriate documentation for the version that you are using.

    To get the version, execute following sql:

    Select * from "SYS"."M_DATABASE";

    Then check if that procedure has same or different number of parameters.

    Use the example in that particular version of help documentation for:

    SAP HANA Predictive Analysis Library (PAL)

    Add comment
    10|10000 characters needed characters exceeded