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

Question

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

Great

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

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.

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!

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???

chillychin · Answer

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

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

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

Anjum Ara · Answer

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

Antonija Mandić · Answer

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.