Monday, July 30, 2012

New OBIEE Sample App Available (11.1.1.6.2) is Available on OTN

Hi Folks,

New OBIEE Sample App Available (11.1.1.6.2) is available for download on OTN.  Lets hope to see less bugs.

Links to download and explore are : http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html.


Thanks
Venkat

Monday, July 2, 2012

How to Downgrade RPD from 11.1.1.6 to 11.1.1.5 Version.


Issue:  Here I tried to open the 11.1.1.6 version of the Rpd using 11.1.1.5 version Admin tool. It shows the following error.

  
  
  Now we will try to downgrade 11.1.1.6 (V 318) to 11.1.1.5 (V 308)


There is  repository downgrade utility nqgenoldverrpd.exe file available for this purpose
It  is part of the OBIEE software.  This utility was present in the 10.1.3.2.1 version of OBIEE but was removed in the later releases. 

Note: 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




To understand how this utility works and what versions it can downgrade.

 Let us run the command

  1.   1)   Go to Run 
    2)    Type CMD
    3)  Point to the bin directory as shown below

     

    4) Now type nqgenoldverrpd.exe and hit enter. You will see the following screen
       
Important notes from the above screens shot.
  
1) Format you should type in the command prompt to downgrade the RPD:

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. 


  2) 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

 
Here I am downgrading to 308, which is 11.1.1.5 Version.

3)      Your command prompt will show “Done!!!” message as below.



4) Now my C drive has new Rpd as shown below which is of version 11.1.1.5. 








 


 You can now open this RPD using 11.1.1.5 Admin tool !!!!!.

Thanks
Venkat