Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Having problems with the installation

I followed the guide: Guide: Setting up HANA PAL for use with SAP Predictive Analysis

Everything was smooth sailing until the step:

Check if AFL__SYS_AFL_AFLPAL_EXECUTE has been granted to the user who will be running the predictive models:

As of this step everything seems as bit wrong.

I get an empty result set when executing:

SELECT * FROM
"SYS"."AFL_AREAS" WHERE SCHEMA_NAME = '_SYS_AFL' AND
AREA_NAME = 'AFLPAL';

SELECT * FROM
"SYS"."AFL_PACKAGES" WHERE SCHEMA_NAME = '_SYS_AFL' AND
AREA_NAME = 'AFLPAL';

SELECT * FROM
"SYS"."AFL_FUNCTIONS" WHERE SCHEMA_NAME = '_SYS_AFL' AND
AREA_NAME = 'AFLPAL';

Also, working with user SYSTEM I cannot see '_SYS_AFL' under 'Catalog', BUT when I go into 'Security'->'Users' and under 'Object Privileges' enter '_SYS_AFL' I see it appearing.

Also I see no role 'AFL__SYS_AFL_AFLPAL_EXECUTE' that I could assign.

BUT on the server the following has been created

/hana/shared/HDB/exe/linuxx86_64/plugins/afl_1.00.74.05.393829_1640963

and there I find the scripts:


afl_wrapper_generator.sql and

afl_wrapper_eraser.sql


Any ideas out there?

Former Member
Not what you were looking for? View more on this topic or Ask a question