Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

OBIEE 12c Upgrade - Bi Publisher Now Missing "Administration" Link??

Received Response
21
Views
3
Comments
chillychin
chillychin Rank 6 - Analytics Lead
in Oracle Business Intelligence Applications

So I am facing a very weird issue and am quite furious at the moment as I can not figure out what is going on.

I have successfully installed OBIEE 12c onto 4 of our servers.

The first 3 have gone as smooth as can be expected, except for the 4th and last one.

When installing on the 4th one, it looks like after importing the migration JAR file from our previous 11g enviroment, it seems to "delete" a few things - causing me to lose the "Administration" link in BI Publisher.

On my QA server I see the following

admin link here.png

Great

Now on my PROD server that I am installing the administration link goes missing

missing administration link.jpg

When I freshly installed OBIEE 12c on this server, everything was there and as expected.

It was only AFTER the migration process taking the JAR file from 11g to 12c does the administration link go missing.

I also tried to go to the following link

http://<servername>:9502/xmlpserver/servlet/admin

And I get hit with this error

Unauthorized Access: please contact the administrator.

I did some reading, and people say to confirm if my Application policies within EM are set correctly.

I check my QA enviroment and I see I have the following along with the application role.

QA EM.jpg

Great - So I try and go to my PROD EM and create a new role, and also add in the missing permissions.

No luck! As when I try to create the role and add the permissions, the permissions are not even there!

missing grants EM.jpg

So that explains why the admin link may be missing, but now I am stuck and am not sure how to find these missing permissions.

Does anyone have any advice at all on this???

Answers

  • Antonija Mandić
    Antonija Mandić Rank 3 - Community Apprentice

    Try to log in to OBIEE 12c with user that in OBIEE 11g had right to access the Administration. With that user you should see the Administration link.

    Now you sholud navigate to Administration -> Manage Privileges and edit Access to Administration and add weblogic user to the list of user that have access.

    Capture.PNG

  • Anjum Ara
    Anjum Ara Rank 4 - Community Specialist

    Hi

    I did face same issue when we upgraded OBIEE 11G to 12c.

    Kindly follow these steps:

    INSTALLATION DOCUMENTS BY RAVI: Administration link is missing obiee after upgrade

  • chillychin
    chillychin Rank 6 - Analytics Lead

    I was able to finally figure this out, while trouble shooting another issue.

    After logging into EM, I clicked on Weblogic Domain -> Security -> Application Policies

    pastedImage_0.png

    Here I selected OBI as the application stripe.

    I then checked the role BIAdministrator - This did not exist for me and I created a new role and proceeded to add in the missing permissions

    I selected [Resource Types] rather then [Permissions] and dug around and was finally able to find the missing permissions

    pastedImage_1.png

    I have no clue how this permission/role went missing, but after adding back the missing permissions and restarting the server everything worked again.

    Hope this helps someone if they come across this again