migrated from obiee to oas. weblogic user doesn't have access to catalog

User_27SWQ

BalagurunathanBagavathy-Oracle

@User_27SWQ Can you please check the application roles that are assigned to the Weblogic user? You can go to My Account > Application Roles tab.

viktyagi-Oracle

If the WebLogic user does not have access to the catalog, verify the permissions using Catalog Manager. Additionally, use the Admin Tool to review the live RPD configuration.

Gianni Ceresa

Hi @User_27SWQ ,

Welcome to the Oracle Analytics community.

It looks like your post content is gone missing somehow, and only a title has been posted. Could you provide some more details? What version of OBIEE you came from? What version of OAS have you migrated to? How was the migration performed?

Is the weblogic the only one you see as missing some privileges compared to OBIEE? Did you check if your security model has been correctly migrated and weblogic has the right application roles linked to it? (This is also what was mentioned above, just listing the most common things to check to start having a better vision of what your environment is like and what could be the cause of your issue.)

User_27SWQ

Thank you for the responses.

The original description should have included the following.

We are working with BAR file that has been migrated through a few iterations of software updates. It started with a catalog developed in OBIEE 5.4 that was eventually upgraded to OAS 2024. The process involved installing OAS first, then importing contents using BAR file. Along the way, what we saw was that weblogic (built-in admin account) did not have any access to catalog items that was brought in.

weblogic user is granted BISystemAmin account but it cannot take ownership of user contents.

Gianni Ceresa

Hi,

Technically having the BI Service Administrator application role doesn't automatically grant access to the catalog. I have worked on environments where weblogic was the system admin, but had no access to any content.

I assume this isn't the expected behaviour, or you wouldn't be posting the question.

Can you check in the Administration > Manage Privileges page to see if that application role is meant to have access to the catalog? You maybe have a missing inheritance in your application roles.

Or, if it comes from a number of upgrades, because there has been a rename of some application roles over time and the addition of new ones, it's worth to look if your security model is there fully and is what you expect, or some pieces have been lost.

Being based on an upgrade, it's difficult to know exactly what happened as it fully depends on your BAR (it does override everything, it doesn't add to the existing default settings).

I remember there are scripts you can run to recreate the default application roles with their policies that are new in OAS compared to OBIEE, I just don't have a document about it handy right now (but it's maybe not your issue anyway).