"Downgrading OBIEE RPD from 11.1.1.6 to 11.1.1.5 Version"
- Repository downgrade utility nqgenoldverrpd.exe is used to downgrade OBIEE RPD versions.
- This utility was present in the 10.1.3.2.1 version of OBIEE but was removed in the later releases.
- Using this Utility you cannot downgrade the RPD from 11g to 10g version. You can downgrade from one version to another 11g Versions.
Physical location of the nqgenoldverrpd.exe file will be
1 ) If you are using Admin tool on your system , the directory path will be
<BI_HOME>\bifoundation\server\bin
2) If you are using Admin client, the directory path will be
C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client11.1.1.6\oraclebi\orahome\bifoundation\server\bin
Downgrading:
1. Goto>StartMenu>All Programs>Oracle Business Intelligence Enterprise Edition
2. Select BI Command Prompt
3. Syntax for Downgrading
nqgenoldverrpd [-P repository_password] -I input_repository_pathname –O
output_repository_pathname -V version
-P: your RPD password
-I: Repository path and name
-O: Repository path and new name of the rep you want to name for the downgraded version
-V: To which version you want to downgrade.
You can only generate repository of version 302 to 318 [ 318 being 11.1.1.6 Version].
Downgrading Process:
1. Copy the 11.1.1.6 RPD to a location you want to ( Here I copied the file to C drive)
2. Now go to Run > Cmd and type the downgrade command as follows and hit enter
3. After hitting Enter on successful downgrade completion you will get the below screen.
Hope It Helps!!
Thanks,
Shanmugha Bharathy G B
