OAS Import/Export Bar — Oracle Analytics

Oracle Analytics Cloud and Server

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

OAS Import/Export Bar

Accepted answer
853
Views
3
Comments
Temoryian
Temoryian Rank 4 - Community Specialist

Hello,

I've recently completed an out of place upgrade from 12.2.1.4 OBIEE to OAS 7.0/2023 on Windows Server 2019 using SQL Server 2019 for the database schemas. When following the out of place upgrade documentation, I don't have access to Snapshot when logged in to DV and viewing path Navigator/Console. I only see section Configuration and Administration with a tile of Monitor Deliveries. I have used the command line importarchive.cmd to import the previously OBIEE exported bar file without issue but am curious to know why I can't see the Snapshot when logged into DV as shown here: https://docs.oracle.com/en/middleware/bi/analytics-server/migrate-upgrade-oas/migrating-oracle-business-intelligence-12c-or-previous-release-oracle-analytics-server.html#GUID-4BDBF84B-9B5C-4607-989F-96B97B2D9DC7. I'm logged in with an administrator account that has the BI Service Administrator role and have verified that when logged in to the classic home. Any idea on why I am unable to see the snapshot page?

The reason I want to import again is because I have tried to archive our catalog from OBIEE and unarchive into OAS. It starts and appears to be working but fails and I'm unsure why. I've looked through some BI_Server logs, but don't see why the unarchive process fails and maybe I'm looking in the incorrect log. Is it possible to unarchive the catalog from OBIEE into OAS or should I always use the bar file? We still have development going in OBIEE and I want to bring over the full catalog when we turn it off and are ready to only run OAS.

Thanks in advance for your help!

Best Answer

  • There are different policies needed in OAS that didn't exist in OBIEE. Depending how you did move the content over in your upgrade, if you took with you the security model (application roles), you probably did override the default OAS application role with the one from OBIEE, and you lost the application policies that were there.

    That could easily explain why you are missing some pieces that you can't see. Ideally you should merge the security model you migrate with the new defaults of OAS.

    I believe there is a script in the <domain>/tools/bin that will restore the default or whatever are missing (never looked into what the script does because I generally prepare the merge of security model by script.

    You can't really unarchive the whole archive in OAS because the archive is not on disk anymore and therefore you don't have offline access. And working online you will have the security enforced and therefore you will not be allowed to write everything of your catalog.

    There are ways to do things, but unsupported. The only supported way is through the BAR file.

    You don't really need that import snapshot page anyway: you can do the same exact thing by command line, both the import and export with all the same settings as the web page.

Answers

  • Temoryian
    Temoryian Rank 4 - Community Specialist

    Thank you Gianni. I'll use the command line. Much appreciated.

  • Temoryian
    Temoryian Rank 4 - Community Specialist

    Just wanted to follow up in case anyone runs into the same problem(s) I have. Turns out that there is a bug for doing an out of place migration from OBIEE to OAS. The solution given encounters another error for windows users so you need to go into two scripts and change the delimiter from a comma to a colon. To solve:

    1. On Windows Machine Grant Or Revoke Permission Assignments Scripts Are Not Parsing Comma Separated Permission Sets Correctly (Doc ID 2777665.1)
    2. After Out-of-Place Migration From OBI 12c To Oracle Analytics Server, BIServiceAdministrator Role Permission Sets Are Missing Preventing Administration In Analytics Console (Doc ID 2656979.1)

    Navigate to domain_home\bitools\bin> and execute:

    grantPermissionSetsToBIRole.cmd -r BIServiceAdministrator -p actio.admin:bip.administrator:bisecurity.GBUAdmin:bisecurity.admin:customScripts.admin:dataReplication.access:infer.administrator:obips.administrator:obis.administrator:obisch.administrator:oracle.bi.dss.CustomKnowledge.admin:oracle.bi.dss.SystemKnowledge.admin:majel.administrator:pod.admin:rdc.admin:rdc.monitor:sac.advanced.approle.administrator:sac.approle.administrator:sac.snapshot.administrator:va.admin

    Thanks, Mitch