Skip to Content
avatar image
Former Member

Issue when using HCP.HCP_AFL_WRAPPER_GENERATOR

Hello,

I'm trying to get clustering working on HCP but when executing PAL creation procedure I'm always getting the following error:

(generate PAL procedure)

Statement: 'CALL HCP.HCP_AFL_WRAPPER_GENERATOR ('TWEETERS_CLUSTER', 'AFLPAL', 'KMEANS', PAL_SIGNATURE)'.Error calling procedure: transaction rolled back by an internal error: [129] "HCP"."HCP_AFL_WRAPPER_GENERATOR": line 31 col 5 (at pos 1742): [129] (range 3): transaction rolled back by an internal error: invalid name of function or procedure: AFL_WRAPPER_GENERATOR: line 1 col 13 (at pos 12)

(drop PAL procedure)

Statement: 'CALL HCP.HCP_AFL_WRAPPER_ERASER ('TWEETERS_CLUSTER')'.Error calling procedure: invalid name of function or procedure: [328] "HCP"."HCP_AFL_WRAPPER_ERASER": line 18 col 5 (at pos 1073): [328] (range 3) invalid name of function or procedure exception: invalid name of function or procedure: AFL_WRAPPER_ERASER: line 1 col 13 (at pos 12)

It looks like the AFL functions are missing. So I checked the following:

1) SELECT * FROM SYS.AFL_FUNCTIONS WHERE PACKAGE_NAME='PAL' and AREA_NAME = 'AFLPAL' and function_name = 'KMEANS';

This returns 1 line (146121,_SYS_AFL,AFLPAL,PAL,KMEANS,26.10.2015 09:25:02.818,2,2,LFunc,UNKNOWN,)

2) select * from "SYS"."SCHEMAS" WHERE SCHEMA_NAME = '_SYS_AFL';

This returns 1 line (_SYS_AFL,_SYS_AFL,FALSE,)

Any ideas what I'm missing ?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 03, 2015 at 11:32 AM

    Hi Erik,

    Are you using an HCP Trial version ?

    Best,

    Christoforos

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 10, 2015 at 11:31 PM

    Hi Erik,

    I'm having the exact same issue...

    It's strange that the code is calling:

         HCP_AFL_WRAPPER_GENERATOR

    But in the log, it says can not find:

         AFL_WRAPPER_GENERATOR


    It's omitting the "HCP_" part!

    and if I'm calling any other procedure, the log will not get the procedure name wrong...


    anyway, hope someone can help out...

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 11, 2015 at 12:57 PM

    Hi All,

    can someone retry and let me know if this works now?

    Regards

    Ganesh Vattamwar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I found solution that worked for me. I reviewed again blog post on PAL - Using Predictive Analysis Library (PAL) in SAP HANA Cloud Platform and merged two 'CALL's together in one execution process. The one that activates objects and the other one, which really fires created function (see image below). I used SAP HANA Cloud Platform with SAP HANA version '1.00.85 and trial user access. You need to navigate inside SAP HANA Web-based Development Workbench's 'Catalog' view select two 'CALL's and run them (or type F8). I don't discuss previous steps (table creations, types and rights, they should be the same).

      2016-01-12-PAL.png (14.8 kB)
  • Feb 05, 2016 at 09:50 AM

    Hi Erik,

    please check the DB type you try to connect to on HCP.

    Among others there is a HANA (<shared>) and a HANA XS (<shared>) flavour.

    Only the later will provide you with an HCP schema with the corresponding HCP_AFL* procedures.

    good luck

    Markus

    Add comment
    10|10000 characters needed characters exceeded