Having issue with opening RPD file after you've downloaded a snapshot?

... well, I certainly did. As usual I was taking the shortcut. Once snapshot was created, I downloaded the .BAR file, renamed it to .ZIP, extracted it, found the .RPD file in extracted folder structure and ultimately opened it. It worked for me so far, but I learnt my lesson a couple of days ago. I don't know, maybe I wasn't paying attention, but the case was: "Invalid password".

Basically I found a solution quick at Oracle Support under this very link, however, let's take a look at the whole process.

When snapshot is created, one would usually download the snapshot in the form of the .BAR file.

After the snapshot password is provided, download can begin. In my old habit I then simply renamed .BAR file into .ZIP file which is then extracted.

In the extracted folder, .RPD file is located in the \datamodel\rpd subfolder (in the screen below, I copied default.rpd file to Desktop folder). 

And if you try to open the .RPD file this way from Model Administration Tool (hey, I didn't see that rename change either !!!), it will return Logon failed error.

The reason is simple. I didn't follow the right steps, as I simply unzipped .BAR file. This used to work in the past, but not any more.

So what needs to be done then? There are a couple of steps required.

Step 1: copy .BAR file to a selected folder

Step 2: navigate to the \domains\bi folder in your Oracle Analytics client home.

Enter the following command:

set DOMAIN_HOME= <your home path>\domains\bi

Step 3: navigate to the \bi\modules\oracle.bi.metadatalcm\scripts folder in your Oracle Analytics client home.

Step 4: run the expandarchive.cmd command

expandarchive.cmd <path to .BAR file> <path to target folder> encryptionpassword=<password that you provided during download>

.BAR file is now expanded in provided folder:

And you can now go and open your .RPD file in offline mode from the standard folder ...

... using your favourite Model Administration Tool.

That's it. Hope it helps.


Popular posts from this blog

Oracle Analytics 5.9: Using Web Map Service (WMS) and Tiled Maps (XYZ)

OBI 12c Series: Connecting OBI with Hyperion Planning