Oracle Analytics and AI

Temoryian

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!

Gianni Ceresa

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.