on 05-26-2015 9:10 AM
Hello, We are trying to use predictive Analytics for the first time.
We granted the following authorizations:
Now when we try to run a simple predictive we can see that HANA tryies to run the following statement:
CREATE PROCEDURE "TEST_PREDICT_MODEL_PAS2_3" (IN input1 "APR_MODEL_PAS2_3",IN input2 "APR_TYPE_PAS2_3", OUT result "COMP_APRMODEL_STORE_TYPE_PAS2_3") LANGUAGE RLANG READS SQL DATA AS BEGIN attach(input1);attach(input2);library(arules);model_char1
Could not execute 'CREATE PROCEDURE "TEST_PREDICT_MODEL_PAS2_3"(IN input1 "APR_MODEL_PAS2_3",IN input2 ...'
SAP DBTech JDBC: [258]: insufficient privilege: Not authorized
Which authorizations are missing? What did we miss?
Thanks,
Amir
Hi Amir,
Just to check that this is not an PAL configuration problem.
Please do the following PAL check with following commands:
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';
You can also do the same to test your APL (Automated Predictive Libraries):
select * from "SYS"."AFL_AREAS";
select * from "SYS"."AFL_PACKAGES";
select * from "SYS"."AFL_FUNCTIONS" where AREA_NAME='APL_AREA';
select * from "SYS"."AFL_FUNCTION_PARAMETERS" where AREA_NAME='APL_AREA';
None of the result tables should be empty if PAL & APL is configured correctly.
As for autorizations you can refer to the SAP HANA PAL guide:
For each AFL area, there is a role. You must be assigned this role to execute the functions in the library. The role for the PAL library is automatically created when the Application Function Library (AFL) is installed.
The role name is:
AFL__SYS_AFL_AFLPAL_EXECUTE
To generate or drop PAL procedures, you also need the following role, which is created when SAP HANA is installed:
AFLPM_CREATOR_ERASER_EXECUTE
From the document "SAP HANA Predictive Analysis Library (PAL)" - based on SAP HANA Platform SPS 09, Document Version: 1.1 – 2015-02-16
Try it out and please share your results.
Best regards,
Kurt Holst
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
We get result for everything but the last 2 SQLs:
select * from "SYS"."AFL_FUNCTIONS" where AREA_NAME='APL_AREA';
select * from "SYS"."AFL_FUNCTION_PARAMETERS" where AREA_NAME='APL_AREA';
As you can see from my original message all of the roles from the guide are assigned.
We are using HANA revision 84
Thanks,
Amir
Hi Amir,
Thanks for the quick feedback.
Well the missing results on the APL functions is not the problem as this is unrelated to the HANA ABC Analytics (PAL).
I see that you have a RLANG call in your scripts. If you want to use the R language then you also need to provide that priviliges to your user. "Create R Script" as shown below:
May I suggest that you take a look at this article - in the appendix you find an end-to-end scenarios where HANA Script is used with the PAL:
http://scn.sap.com/docs/DOC-50803
Best regards, Kurt
Hi,
Just as an information, the official documentation for R integration into HANA can be found here: http://help.sap.com/hana/SAP_HANA_R_Integration_Guide_en.pdf
SAP HANA Platform SPS 09 Document Version: 1.1 – 2015-02-16
Security aspects (detailed by Kurt) are on pages 6/7.
Best regards
Antoine
Hi Amir,
Can you please precise what client you are using? Automated Analytics or Expert Analytics? Also are you triggering specific HANA predictive library (APL? PAL?)
Thanks & regards
Antoine
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.