Bi Publisher: "Unauthorized Access: Either you do not have the privilege, or you have not signed in — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Bi Publisher: "Unauthorized Access: Either you do not have the privilege, or you have not signed in

Received Response
423
Views
5
Comments
User_4NU9S
User_4NU9S Rank 6 - Analytics Lead
edited Aug 13, 2024 5:56PM in Oracle Analytics Cloud and Server

HI All ..

Obiee ver. 11.1.1.7.x

This is a brand new Obiee set-up . The rpd and webcatalog were deployed from lower env.

Can login to Analytics / EM/ and Console

But in BI Publisher , getting this error when trying to login through weblogic user

"Unauthorized Access: Either you do not have the privilege, or you have not signed in

I know there is a doc.. but does this applies here?

Navigating to BI Publisher from OBIEE 11g Fails With Error: "Unauthorized Access: Either you do not have the privilege, or you have not signed in" (Doc ID 1942564.1)

In Analytics I can login with weblogic user but the permission option is disabled..

pastedImage_3.png

Thanks for having this ..

Regards

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    819624 wrote: The rpd and webcatalog were deployed from lower env.

    So looks like the security is messed up with regards to the privileges.

    I.e. either the privileges themseves are messed up or the app roles are messed up etc

  • User_4NU9S
    User_4NU9S Rank 6 - Analytics Lead

    Thanks Chris.. what the solution?

    I have these in mind what I read from other blogs

    Option 1:

    delete the  users folder  and users.atr and then restart the BI services to see if it fix the problem.

    Option2:

    Open the catalog in Offline mode in Catalog Manager and then give the weblogic user Full permission .

    option 3:

    Again do the rpd and catalog deployment

    and then refresh GUIDs.

    Thanks

  • Gianni Ceresa
    Gianni Ceresa Mod

    Not wanting to annoy going back to something we discussed yesterday .... but isn't it worth to include security in your migration? (yes, you said you didn't want to look at that now, but ... you see that you have issues with permissions).

    What's the context of your operation? Is that a one-shot move or you are setting up your process and will do that kind of deployments frequently?

  • User_4NU9S
    User_4NU9S Rank 6 - Analytics Lead

    Thanks .. this is one and last shot move ..

    let me explain things ..

    the source env is single node and we decided to move to brand new env which is  active-active set-up - 2 servers and each has all the obiee components running .

    rpd and catalog locations are on a shared path accessible to both.

    there are only 3 users..BIsystemuser  weblogic and OracleSystemuser

    pastedImage_0.png

    I just have deployed the rpd and coped the catalog on the shared path and then refreshed the guids .

    Since this has 2 bi servers , I updated the guids like this

    update the NQSConfig.ini file on both server.

    update the instanceconfig.xml on only node 1 server. (not node 2 server)

    start the biserver on both nodes and the ps server on node 1 .

    wait for biserver to stop .

    the stop the ps server

    revert those changes and start all the services again.

    I am able to login to weblogic console , analytics , em with weblogic user  but not to BI publiser for which I am getting this error;

    pastedImage_1.png

    in analytics I can see the shared folder and reports in there but cannot access them

    pastedImage_2.png

    that's all..

    regards

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    GUID refresh first.

    User folder purge second.

    CatMan....well not really because even in CatMan you can't change the right on /users directories