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

Error: Insufficient privilege

Hi, I'm using Predictive Analysis with HANA online. In my prediction, I'm using algorithm: HANA Apriori. When i click in execute, it appears an error that says: insufficient privilege: Not authorized action. Did anyone ever had this problem? Why it's happening?

Regards,

Jürgen Mollo

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

16 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 24, 2014 at 07:56 AM

    I had faced a similar issue. In that case I went to HANA System Privileges, and assigned “Create R Script” permission granted. I stopped getting the above error after that.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2014 at 08:09 PM

    Hi Kevin, I have acces to the SYSTEM logon and when I use the PA, I work with the system login, so in this case I need to assign this privileges to the SYSTEM?

    I also tryied to open your JAM link, but it says that my email (ID) wasn't registered in the system, so then I can't access the page.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2014 at 07:47 PM

    Hi Bimal and Kevin, thank you all for your good intention in helping me. But unfortunately I don't know exactly how to work with HANA, so I'm not sure how to check or add the privileges you sended before. In my HANA Studio, I already executed WRAPPER GENERATOR (wasn't installed in my Studio, so a friend of mine sended me, and than I executed).

    Can anyone please write me some steps, teaching how to check or install the privileges?

    Regards!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2014 at 09:06 PM

    Thank you again for your help. I'm having some problems when I try to save the changes in privileges that I have done before. It appears an error that says I can't modify the SYSTEM becaus grantor and grantee are identical. So I'll try to modify this privileges with another logon. So then, I'll ask some tomorrow morning to do this for me in my Studio, or send me the login and password, so than I can do this changes.

    I also tryied to logon at the PA with another user name and password, but it gives an error that says I can't connect to the server. I think it happens because that user don't have permission to do that.

    When I finish doing the changes at privileges, I must click on DEPLOY, or just save and close?

    I have just tryied running my analysis again, and the error of privileges persist.

    I'll talk with someone here in the office tomorrow morning, so than I'll ask him to check the privileges.

    And then I'll post here my results.

    Regards!

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      FYI, Since you are able to log in as the SYSTEM user, you can create yourself another user very easily:

      Give yourself a username (a schema matching your username will be created automatically), enter the password you want to use twice and then press save icon or the green right arrow / deploy icon.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2014 at 12:19 PM

    Hi Kevin, I've created a new user, with all the permissions from SYSTEM and following the steps that you and Bimal told me. Then I executed the algorithm and it worked!

    But after executing, I've changed to the results, but unfortunately it didn't show any results!

    Do anyone know why it's happening?

    In my data, I have the purchase number, and the products that are on this purchase.

    For example:

    Purchase Number Products

    1 Bread

    1 Milk

    1 Coke

    1 Bread

    2 Cheese

    2 Water

    2 Beer

    As you could see, there is repeated products in the same purchase. For example in Purchase 1, we have 2 lines that contains Bread.

    Maybe this could be the problem? Repeated products in the same purchase?

    I've configurated the algorithm this way: in the transaction ID, I've used the Purchase Number. and in Item Collumn, I've used the list of Products. But this product are numbers, and not products name. For example, Bread is 1234, milk is 4321....

    I need to change this numbers to names?

    Regards and thanks again for your help!


    Sem título.png (50.4 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Jugren,

      It is happening because you cannot have two records against same transaction to run Apriori algorithm.

      Purchase number 1 cannot have bread twice. You will have to delete the duplicates and than it will work.

      Regards,

      Bimal

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2014 at 12:45 PM

    Hi Bimal, does exist and easy way to delete the duplicates? Because I have almost 30 million lines in my database...

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      You can do it using the below R script. You will have to create a custom R component with below code:

      packagerunner <- function (mydata)

      {

      #Remove duplicates for Apriori Analysis.

      output <-unique(mydata)

      return(list(out=output))

      }

      See the tutorials here on how to create a custom R component.

      Use the output of above to run the Apriori algorithm.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2014 at 06:15 PM

    Hi Bimal, I've tried to configure a new R component, but it gives an error. I'm sending step by step what I've done.

    And the error after executing the algorithm:

    Does anyone know why it's happening this error?

    Regards


    1.png (63.6 kB)
    2.png (72.0 kB)
    3.png (69.7 kB)
    erro.png (55.7 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      All your steps are correct.

      That error occurs because you are executing the R component on HANA server in online mode

      To execute R Script on HANA server you need the R server (RServe) installed and integrated with HANA server

      See details here:

      help.sap.com/hana/SAP_HANA_R_Integration_Guide_en.pdf


      Guide: Setting up HANA integration with R for use with SAP Predictive Analysis


      In case you don't have a separate server to install R-Serve you can do the below ( a bit painful) work around:


      1. I would say work in offline mode. Get the data in SAP PA. Run the algorithm in SAP PA. Save the data with duplicates removed to an excel file.

      2. Load this excel file to your HANA table.

      3. Connect in online mode. Run the APRIORI on the new data from step 2.

      The size of this thread in increasing. As your original query has been resolved, I would recommend closing this thread and start a new one in case you have any other issue. This will help newcomers in future also.

      Thanks

  • author's profile photo Former Member
    Former Member
    Posted on Feb 03, 2014 at 12:22 PM

    Hi Bimal, I tried to run the algorithm OFFLINE on HANA. It got a long time to download, and then I tried to execute the component, but it gives and error that says something like: the result of the principal component is invalid or there is an error in the processing of the result of the current component.

    I checked the component several times, but I don't know what is wrong.

    I'm sending how I configure the component, and the error.

    Do you know what might had happened?

    Regards


    1.png (63.6 kB)
    2.png (72.0 kB)
    3.png (69.7 kB)
    erro1.png (71.3 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 03, 2014 at 12:43 PM

    Hi, the error persists, at the R configuration that you sended me, I needed to change anything for the real name of the collumns that I'm using?

    I've exported 3 collumns from the HANA, but in this analysis I'm using only 2, might this be the problem?


    Regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Please samplee some data and save the data in CSV and send it to me with the details of what exactly you are trying to do. I will run it from my side and come back to you on this.

      Send me a Personal Message and I will send you my email id there where you can mail me the file and scenario you are trying to cover.

      Connect with me by following me. I sent you a request already.

  • author's profile photo Former Member
    Former Member
    Posted on Feb 05, 2014 at 06:04 PM

    Hi Bimal, I donwloaded the table, and tried to execute it again, but it gives the same error. Than i've reduced the number of lines, and it worked, but when I runned the APRIORI, it didn't show any results. I've also created a fake table with 1.500 lines, and it worked perfectly, the component that remove duplicates and the APRIORI.

    Do you know what might be?

    I'm sending you the CSV file with the data, I'm using column number 4 (named column_3) as the purchase ID. And column number 5 (named column 4) as the products inside it purchase.

    I'm sending it to your email.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello, If Apriori does not return any results, it can help to change the Apriori configuration.

      The default values for Support (0.1) and Confidence (0.8) might be too high for your data. The support for instance means it will only produce rules that apply to at least 10% of your shopping baskets (if that's your use case). If no such combination is found, then no data will be returned.

      You could try with 0.1 / 0.1. If there are still no results reduce the values further.

      To avoid the duplicate records it would be nice to use HANA for this. Can you create an analytical view or calculation view that aggregates the duplicates?

      Greetings

      Andreas

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.