Would someone please share the steps involved with moving the
BusinessObjects repository (security, document and universe domains) to
another server? Using 4.1, Oracle 7.3. I’ve never (yet!) needed to recreate
the BOMAIN.key or run a safe recovery. We have about 40+ universes - will
each of these have to be individually re-exported to the new server? Thanks
in advance!
Kathy wrote:
Would someone please share the steps involved with moving the
BusinessObjects repository (security, document and universe domains) to
another server? Using 4.1, Oracle 7.3. I’ve never (yet!) needed to recreate
the BOMAIN.key or run a safe recovery. We have about 40+ universes - will
each of these have to be individually re-exported to the new server? Thanks
in advance!
We found this to be a VERY PAINFUL experience, but here is what we had to do:
Import all Universes from current repos. to a network server or your hard drive.
Retrieve all Reports from current repos. to a network server or your hard drive.
Create new database on New Server and Create new BOMAIN.key.
Sign on as General Supervisor to NEW repos. and Create from scratch
a. Domains
b. Connections
c. Groups/Users (and Security)
Export your Universes that you saved in step 1 to the new repos.
Also need to Import Universes again (from NEW repos) for running reports.
Refresh reports that you saved in step 2 and send these to the NEW repos.
Retrieve reports from step 7 and re-run to make sure they work!
If you use DAS, also send reports to DAS and make sure they run in DAS.
Would someone please share the steps involved with moving the
BusinessObjects repository (security, document and universe domains) to
another server? Using 4.1, Oracle 7.3. I’ve never (yet!) needed to
recreate
the BOMAIN.key or run a safe recovery. We have about 40+ universes - will
each of these have to be individually re-exported to the new server?
Thanks
in advance!
We moved our BO4.1.2 repository (ORACLE 7.3) from one server to another. The
task would have been not so painful if we would have known that there is a
bug in the version 4.1.2 which prevents you from changing the database
connection inside the Supervisor to the new database instance for the
security and universe domain. So I strongly advise to upgrade to BO4.1.4
before moving the repository!
What we did is the following:
we created a new repository on the new database (from scratch) and created
a new BOMAIN.KEY.
afterwards we exported the ORACLE-user which owns all BO repository tables
and imported the user into the new database.
if you use BO4.1.4 then you simply start the SUPERVISOR and change in the
“Tools”–>“Repository” window the connections to the domains.
In case you are still using BO4.1.2 and you are not able to upgrade before
you are moving the repository you can contact me directly and I can give you
advise how to get around the bug in BO4.1.2 (however it’s a tricky and risky
task).
Best regards,
Andrea Halbherr
Novartis Crop Protection
Switzerland
andrea.halbherr@cp.novartis.com
To all interested: if you use ORACLE database, there is a way to move all your
repositories to any other machines as long as you do not change the middleware
connection name. This is supported by oracle and a customer of ours already did this a
few times.
It involves the following steps:
disable logins to database and move all tables to other database (probably on
different machine)
2. let your connection name point to the new machine.
The only thing you need in this case is a centralized connection management.
That’s it.
No re-reation of BOmain keys, or whatever…
hope this helps.
Walter.
Alice Harper wrote:
Kathy wrote:
Would someone please share the steps involved with moving the
BusinessObjects repository (security, document and universe domains) to
another server? Using 4.1, Oracle 7.3. I’ve never (yet!) needed to recreate
the BOMAIN.key or run a safe recovery. We have about 40+ universes - will
each of these have to be individually re-exported to the new server? Thanks
in advance!
We found this to be a VERY PAINFUL experience, but here is what we had to do:
Import all Universes from current repos. to a network server or your hard drive.
Retrieve all Reports from current repos. to a network server or your hard drive.
Create new database on New Server and Create new BOMAIN.key.
Sign on as General Supervisor to NEW repos. and Create from scratch
a. Domains
b. Connections
c. Groups/Users (and Security)
Export your Universes that you saved in step 1 to the new repos.
Also need to Import Universes again (from NEW repos) for running reports.
Refresh reports that you saved in step 2 and send these to the NEW repos.
Retrieve reports from step 7 and re-run to make sure they work!
If you use DAS, also send reports to DAS and make sure they run in DAS.
–
DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria
Tel: +43-1-8151456, Fax: +43-1-8151456-21
e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at
Dear adridabbi, if you’ll notice, this topic is over 7 years old – it’s probably for version 3.x or 4.x of BusinessObjects. You don’t even say which version of BusinessObjects you are using, the process might be quite different.
