Downgrading Version of Repositories in OBIEE

Courtesy: Mamta Dayama

Repository Files are not backward compatible. (but they are a upward compatible) i.e. One cannot use a rpd file created with a higher version of the Admin tool in a lower version of the Admin tool. But the vice versa is possible.
I got the below error, after trying to open a repository that was created with 10.1.3.3.0 of the Admin tool from 10.1.3.3.2 version of the Admin tool.









Now, how do we downgrade the repository to a lower version. In earlier releases of BI EE and Siebel Analytics, there was a tool called as nqgenoldverrpd.exe which would automatically downgrade the repositories. But in the current releases we do not have this tool.
This approach will not work if you are using any new features that are specific to newer version of Admin tool.



I have 10.1.3.3.0 version of the Admin tool in Machine A and 10.1.3.3.2 version of the Admin tool in Machine B. Our aim is to make the repository created with the Admin tool in Machine B, work with the Admin tool in Machine A. In order to achieve this, go to machine B and open up a command prompt. Type in the following command.

D:\Oracle\OracleBI\server\bin\nqudmlgen -U Administrator -P Administrator -R Paint.rpd -O Paint.txt



So, what we are basically doing is we are creating the UDML of the repository using the nqudmlgen.exe utility. Once this done, copy the Paint.txt to Machine A. Open up the copied UDML file (Paint.txt) in a text editor. One the top of this text file you would basically see something like the one below



DECLARE REPOSITORY PROPERTIES (‘CustomPresentationLayer’ = ‘01′,‘PersistedNextUpgradeID’ = ‘BA500000′);VERSION 1.1.185;



We got the above mentioned error because of the VERSION 1.1.185. Now, edit this line and change it to 180 (for 10.1.3.3.0 version. This number varies for each version of BI EE release).


DECLARE REPOSITORY PROPERTIES (‘CustomPresentationLayer’ = ‘01′,‘PersistedNextUpgradeID’ = ‘BA500000′);VERSION 1.1.180;



Save this file in Machine A and then in Machine A open up a command prompt and enter the below command.

D:\oracle\OracleBI\server\Bin\nqudmlexec -U Administrator -P Administrator -I Paint.txt -O Paint_new.rpd

Again, we are basically using the nqudmlexec.exe utility to recreate the repository from the UDML text file. But now we should be able to open the repository in the lower version of the Admin tool.

Popular posts from this blog

Image
If you had gone through my blog entry here, i would have talked about using UDML as a way for automating migration from dev to test/prod environments. But the major problem with UDML is that one cannot update the passwords of Connection Pools, Users etc since the UDML expects them to be encoded. In such a case, for updating passwords alone we can use an undocumented command line switch option for the AdminTool. For example, look at the screenshot below. If you had gone through my blog entry here, i would have talked about using UDML as a way for automating migration from dev to test/prod environments. But the major problem with UDML is that one cannot update the passwords of Connection Pools, Users etc since the UDML expects them to be encoded. In such a case, for updating passwords alone we can use an undocumented command line switch option for the AdminTool. For example, look at the screenshot below. Open Dev_Machine.rpd Administrator Administrator SetProperty "Connecti...
Read more

How To Unlock Bootloaders on your Xperia Arc S

UPDATE : Before you proceed, please visit  this link  to check if your phone’s boot loader can be unlocked or not? NOTE:  If the light above the USB port on your phone doesn’t turn blue when you connect your phone using the USB cable to your PC while holding the “MENU” button (on Xperia Arc. For Xperia Play – “SEARCH” button), then it means that you cannot connect to fastboot, and hence you cannot unlock the boot loader. Here’s a Step by Step guide (w/ video) on how to unlock bootloaders on your Xperia Arc, Play, Neo & Pro. [info]Although this guide is made using Xperia arc, I can assure that it would work perfectly with Xperia Play, Neo & Pro too. NOTE : Xperia Play users should press the “ Search ” button instead of “ Menu ” button in Step 8th of this tutorial.[/info] [warning]The methods and procedures discussed here are considered risky and you should not attempt if you don’t know completely what it is. If any damage occurs to you or your device, w...
Read more

Inherited Colour Vision Deficiency

Image
Red/green colour blindness is a common hereditary condition which means it is usually passed down from your parents. Colour blindness is usually passed from mother to son on the 23rd chromosome, which is the sex chromosome. Chromosomes are structures which contain genes – these contain the instructions for the development of cells, tissues and organs. If you are colour blind it means the instructions for the development of your cone cells are wrong and the cone cells might be missing, or less sensitive to light or it may be that the pathway from your cone cells to your brain has not developed correctly. The X chromosome is the sex chromosome: males have an X chromosome and a Y chromosome and females have two X chromosomes. For a male to be colour blind the faulty colour blindness gene only has to appear on his X chromosome. For a female to be colour blind it must be present on both of her X chromosomes. This is why red/green colour blindness is far more common in men than women. Bl...
Read more