Having problems with the installation

[Former Member]

I followed the guide:

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_member184912]

Hi,

Based on the missing PAL algorithms it a likely that the afl installation wasn't done properly.

I would suggest you have a another look a Johns post on this subject - particular the first steps with downloading the afl, unpacking & running the installation : http://scn.sap.com/community/predictive-analysis/blog/2013/08/01/setting-up-hana-pal-for-use-with-sa...

Note that AFL must follow that patch level of your HANA system.

If you still have issues after re-installing please post the installation log.

Best regards,

Kurt

[Former Member]

Thanks for this information Kurt.

Can you - or someone else - help to explain the following:

As I wrote above the installation on the server reads:

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

What does the figure mean:

1.00.       = HANA version 1.0 right?

74.          = ?

05.          = ?

393829_   = ?

164096     = ?

The SAR-file is: IMDB_AFL100_74_5-10012328

What does these figures mean:

100_          = HANA version 1.0 right?

74_            = ?

5-               = ?

10012328    = ?

As we have >1 installation it could be that Basis provided me with the wrong file.