We are attempting to upgrade our Business Objects repository from 6.0 to 6.5.1 in Oracle 9.2.0.6. First we did a scan & repair in Supervisor 6.0, then created a new BO main key using Supervisor 6.5.1. We then attempted to upgrade the repository in Supervisor 6.5.1 and received the following error messages:
Preparing to update version number, add or remove some tables if required
create table OBJ_M_USRATTR (M_UATT_N_ACTORID NUMBER(10) not null, M_UATT_N_ATTRTYPE NUMBER(10) not null, M_UATT_C_ATTRVALUE VARCHAR2(254) not null)
MasterRepository() function fail:
SQL.MASTER.Create.Table.UserAttribute
N/A:ORA-00955: name is already used by an existing object
Error during update. (ADM0169)
Is this the correct process?? Am I missing something here? Thanks!!
First how to upgrade a repository has to be determined first. You can check the pdf files for more detailed information.
How are you planning a GRADUAL or SPLIT method…?
a) How would you like to upgrade your Universes and Reports to 6.5?
b) How many universes and reports do you have to upgrade?
c) How would you upgrade your users to 6.5?
d) Is this upgrade related to FC only, WEBI or both?
6.5 repository has 6 additional tables … totals to 56
You might be doing an INPLACE upgrade, that is you are upgrading the existing repository itself, did you make a copy of your current repository, before upgrading it, and how do you compare that your BO upgrade was successful.
I did two upgrades to 6.5.1 from lower versions. A neat and clean process would be to, Create a new repository in a new Schema, Export the users, Export the Universes, and reports one by one. I hope this should not take much time.
Additional Universe domains and Document domains can also be created at the same time if required.
And after upgrading the Users, Universes and Reports, Compare with the old version.
Backup current repository.
Restore a copy into a new table space for 6.5
Leave the ‘old’ repository version running in case of backout situations.
Create new ODBC/… connections to Repository65
Log on to Supervisor 6.5.2
Use admin / run a safe recovery using new connection details - it updates the tables for 6.5
All your original userid’s, universes and reports will still be there, but run a few tests to confirm.
Copy bomain to necessary locData folders etc on server.
For Reports:
Backup all your 6.1 reports, keep it in a different directory.
Open the 6.1 report in 6.5 reporter
Save it, it will be upgraded to 6.5, Compare the functionality… with the 6.1