Business Intelligence – Oracle

Oracle BI EE 10.1.3.3/2 – Downgrading Repositories

Posted by Venkatakrishnan J on March 3, 2008

For those of you who have worked across multiple versions of BI EE, you would have noticed that the Repository files( .rpd 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. Look at the screenshot below,

      

I got the above 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. So, in order to downgrade in the later releases lets look at an approach today. Just remember this is not a supported approach and this assumes that you are not using any new features(in your rpd) that are specific to the newer version of the Admin tool. Ensure that you are taking a backup of all the repositories before trying this The below diagram explains the versions that i have in 2 different machines.

      

As shown above, 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:OracleOracleBIserverbinnqudmlgen -U Administrator -P Administrator -R bise1.rpd -O bise1.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 bise1.txt to Machine A. Open up the copied UDML file (bise1.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:oracleOracleBIserverBinnqudmlexec -U Administrator -P Administrator -I bise1.txt -O bise1_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.

      

About these ads

8 Responses to “Oracle BI EE 10.1.3.3/2 – Downgrading Repositories”

  1. Sofia.T said

    Hi Venkat

    Very nice blog…
    This is wat I was searching for the past few days.
    Thanks a lottt…

    Regards,
    Sofia.T

  2. Ankit said

    Hi,
    Its really nice Blog.

    One quick question. Can be downgrade RPD from Oracle BI 10.3.2.0 to Siebel Analytics 7.8.4 ?

    Regards
    Ankit

  3. kapil said

    hi venkat,

    very nice Blog, i have a question i am using oBIEE10.1.3.3, i have installed OBI apps (fusion 7.9.5), i encountered an error it is
    server version 183 can not read the newer version 184″

    can i apply Above solution to my problem, but i am not upgrading older version of OBIEE,just i installed inforamtica (8.1.1)(power center sp4) on that i installed OBI apps(fusion 7.9.5)

    please help me on this.

    thank u ,
    kapil.

  4. Rajesh Yadav .D said

    Hi Venkat,

    It is really nice,

    I have a question, i am using oBIEE10.1.3.3.0, i have installed OBI apps (fusion 7.9.5), i encountered an error it is
    [nQSError: 47037]Error happened when trying to validate Configauration.
    [nQSError:36010]Server version cannot read the newer version 184.

    when i installed Fusion7.9.5, it installed a repositroy file “OracleBIAnalyticsApps.rpd”, when i tried to open it with user :Administrator / password: , it is showing all the 3 layers of RPD empty.

    Can i use the same technique that u have explained above..

    Please help me on this..

    Best Regards,
    Rajesh.

  5. Desmond said

    Hi Venkat,

    I tried it but seems i get this error:
    C:\ORACLEBI\SERVER\BIN>nqudmlgen -U Administrator -P Administrator -R C:\ORACLEB
    I\SERVER\Metcash_Live.rpd -O Metcash_Live.txt
    The repository C:\ORACLEBI\SERVER\Metcash_Live.rpd cannot be opened

    REgards

    Desmond

  6. Sanket said

    hi venkat ,

    I am facing the same problem as reported by Desmond above.I am not using any of the new features of newer version of OracleBI Admin Tool.

    Thanks,
    Sanket

  7. Ken said

    Desmond/Sanket,

    You will see that message “Metcash_Live.rpd cannot be opened” if you use the nqUDMLGen.exe command from the older version of OBIEE against the newer version of the OBIEE repository file. Try running the same command on the newer version of OBIEE to generate the UDML text file.

    Ken

  8. Imran Ali said

    @ DESMOND: you are at using the command at the wrong path. In the command prompt, first go to the Installed directory of OBIEE where your repositories are present (e.g. as in my case it is “G:\OracleBI\server\Repository>”) and from there apply the command. So if I run this command on my system I’ll do like following in command prompt:

    “G:\OracleBI\server\Repository>G:\OracleBI\server\Bin\nQUDMLGen -U Administrator -P Administrator -R AnalyticsWeb26thOct09.rpd -O AnalyticsWeb26thOct09_1.txt”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 158 other followers

%d bloggers like this: