To overcome this issue, we need to downgrade the repository.
In OBIEE, we use nqgenoldverrpd.exe utility of the Admin Tool.
You can find this file on the following path,
If your are using default Admin Tool that comes with the OBIEE installation,
C:\Middleware\Oracle_BI1\bifoundation\server\bin
If you have installed BI Admin client saperately on your Windows machine,
C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client Tools\oraclebi\orahome\bifoundation\server\bin
For this purpose of practice, we are using BI Admin client path as my OBIEE server is on Linux environment.
The parameters that nqgenoldverrpd.exe uses are as follows,
-P: Repository password
-I: Repository name along with the full path that you want to downgrade.
-O: Repository path and new name of the rep you want to name for the downgraded version.
-V: Version you would like to downgrade.
Please make sure that the database types and call interface types in the repository are allowed in the specified version.
If not, change them to the nearest types before you run this utility. Otherwise, these types will be changed to the default type(ODBC 2.0) in the generated repository.
- Open command prompt and poing to the one of the above mentioned path, i.e.
cd C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client Tools\oraclebi\orahome\bifoundation\server\bin
- The downgrade command will be as follows,
nqgenoldverrpd.exe -P Admin123 -I D:\Sample\HandsOn.rpd -O D:\Sample\HandsOn_325.rpd -V 325
- Once you get Done!!! message,
In output path, there will be a newly created repository having your mention version (downgraded).
Also, you can find a log file of this process in a path mentioned in -O parameter of the command.
Now try to open that repository using your lower version of Admin Tool, surely you will be in..
Happy blogging.. :)
Happy blogging.. :)
Hello are using Wordpress for your blog platform? I'm new
ReplyDeleteto the blog world but I'm trying to get started and set up
my own. Do you need any html coding expertise to make your own blog?
Any help would be greatly appreciated!
Here is my webpage :: healthy diet
Hey,
ReplyDeleteI'm using Blogger as my blog platform. The blogger and wordpress are the two different and most popular domains for blogging.
And it is not mandatory to have a knowledge about HTML coding or any scripting language. All you need to know is just a knowledge about what you are going to write...... Happy stay.. ;-)
I am really thankful to the holder of this web page who has
ReplyDeleteshared this impressive post at at this place.
Take a look at my web page; free psychic reading
Hi there, after reading this remarkable post i am too delighted to
ReplyDeleteshare my know-how here with mates.
my blog dryers sold nowadays
I'm impressed, I must say. Rarely do I come across a blog that's both equally educative and amusing, and without a doubt, you've hit the nail on the head.
ReplyDeleteThe issue is something which too few folks are speaking intelligently about.
Now i'm very happy that I stumbled across this during my search
for something concerning this.
my web site :: Easydisplay UK ()
I am having the same error. when I tried the command, I got the error 'the following repository cannot be opened: ' any idea on this error? Thanks in advance.
ReplyDeleteI am also getting same error "Repository cannot be opened:" Can somone please help me on this?
ReplyDeleteThanks
Khalid
which repository version you are going to open? and which version of admin tool are you using?
ReplyDeleteadmin tool version 11.1.1.6.0, try to downgrade to 318 from 320
DeleteThis comment has been removed by the author.
ReplyDeletewhen i tried to do the same what you have explained in this post to downgrade from 320 to 318 version of RPD iam getting error: "cannot open C:\Users\Administrator\Desktop\opva.rpd"
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteHi Sagar,
ReplyDeletePFB are the details
Repository was developed under version: 11.1.1.7.1
I have installed 11.1.1.7.0
and while trying to downgrade the repository version getting this error
can anyone please tell me how to overcome this error "Repository cannot be opened".
ReplyDeleteI have tried all the steps mentioned but still not able to do it.
Hi guys.. sorry for the delay in reply..
DeleteAs I have mentioned in the post, you can only degrade a repository which is developed in same or lower version of OBIEE.
Say for example,
I have OBIEE 11.1.1.7.0 then I can only downgrade a repository developed in 11.1.1.7.0 or the lower version, and not in 11.1.1.17.1.
Hope this helps.
can anyone please tell me how to overcome this error "Repository cannot be opened".
ReplyDeleteI have tried all the steps mentioned but still not able to do it.
hi were you able to overcome this issue
DeleteHi, I was having this issue as well that "Repository cannot be opened". The issue was that I was trying to run the utility from the incorrect directory. Basically, I had two "new" versions of OBIEE client installed (in addition to the old version). Apparently I was using the incorrect version from one of the two new ones. Once, I switched directories and ran the nqgenoldverrpd utility from the appropriate new directory, it ran smoothly.
ReplyDeleteHope this helps someone.
I read this blog please update more content on hacking, further check it once at Tableau Online Training
ReplyDelete