Downgrading RPD version in OBIEE 11g

Posted on June 13, 2012 by Paul McGarrick
Filed Under 11g Repository, Admin Tool, OBIEE 11g

OBIEE Administration ToolToday I encountered a problem when trying to deploy a later version repository into an earlier environment. In this case my changes were made in the 11.1.1.6 Administration Tool (v 318) and I needed to deploy the RPD to an 11.1.1.5 environment (v 308). Without downgrading the repository I was not able to start the BI Server component. Here’s how I got around it…

First I ran nqudmlgen.exe from the later (11.1.1.6) environment. This can be found in <BI_HOME>\bifoundation\server\bin

nqudmlgen.exe -N -P Admin123 -R C:\RPD\11116.rpd -O C:\RPD\udml.txt

Then I edited the file in a text editor to remove any instances of these lines:

'COMPRESS_COLUMNS' = 'No',
'ROWNUM_LIMIT_SUPPORTED' = 'Yes',
'ROWNUM_OFFSET_SUPPORTED' = 'Yes',
'NUMERIC_SUPPORTED' = 'No',
'ANCESTOR_DIMENSION_PROPERTY_SUPPORTED' = 'No',

Finally I used nqudmlexec.exe that comes with the earlier (11.1.1.5) environment and is bundled with the Client Tools installation.

nqudmlexec.exe -P Admin123 -I C:\RPD\udml.txt -O C:\RPD\11115.rpd

My new RPD could then be deployed via EM with no major complaints besides a few warnings in the nqserver.log file.

Comments

4 Responses to “Downgrading RPD version in OBIEE 11g”

  1. Michal Novy on June 14th, 2012 9:00 am

    Have you tried nqgenoldverrpd.exe (or without .exe at *NIX systems)? This is the right tool for this purpose. See more info from command line.

  2. Paul McGarrick on June 14th, 2012 10:28 am

    Hi Michal – I haven’t tried it but will do so when I get a minute. I knew there must be an easier way! Thanks for the tip! Paul

  3. Bakthi on August 23rd, 2012 10:49 am

    Excellent info. Can you tell me how can I downgrade the catalog from 11.1.1.6 to 11.1.1.5? I just copied the ATR files and folder from higher version to lower version but I am getting ENUM errors while trying to view analysis results..

  4. gotier on April 3rd, 2013 9:08 am

    Hi Bakthi – Have you find anything on your catalog downgrade issue between 11.1.1.6 and 11.1.1.5 ? We have actually the same issue and we don´t know how we can downgrade it..
    Thanks in advance !

Leave a Reply