Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need Clearer steps for moving FRS from old active server to new server

Hi Experts,

I am currently planning an upgrade for BusinessObjects XI 3.1 SP2 to SP3 FP 3.4. We had a new VM server built for development to replace the exiting VM Server (30 C drive and 40GB Data drive). We are running Windows 2003 64bit standard with SQL 2008. Once I complete the installs with FP 3.4, I will be moving the FRS from an existing database to a new environment. The part i would like to know in advanced is when I will need to disable/deactivate the current running CMS/SIA? Also, the webserver is running in this environment and i will be installing that on the new server. Basically, I'm looking for the best practice on doing a new install of BOBJ, moving the FRS, and replacing the existing BOBJ. I would like to decomission the existing Dev BOBJ Environment in a few weeks.

Any information or documentation you can provide would be appreciated.

The order in which i will be installing is as follows:

1. BusinessObjects XI 3.1 SP3 FP 3.4

2. Crystal Reports 2008 3.1 SP3 FP 3.4

3. Xcelsius Enterprise 2008 3.1 SP3 FP 3.4

4. SAP Integration kit 3.1 SP3 FP 3.1

5. Live office 3.1 SP3 FP 3.4

6. SAP BusinessObjects Client Tools 3.1 SP3 FP 3.4

7. Life cycle manager 1.0 SP3 FP 3.4

8. Data Federator SP3 FP 3.4

While doing the install in the order above, at which point will i have to turn off the existing CMS or SIA? Is this required prior to the steps where i move the frs to the new database? Below are my steps on how I will move the FRS from the older db to the newer db.

1. Go to the Central Management Console (CMC)

2. Change the file store directory paths in the CMC. These steps need to be executed for each input and output server process

a. Go to Servers  Input

1. InputFileRepository  properties  Change

2. Temporary Directory from old dev file path to new file path
db name\incoming\temp

3. File Store Directory from old dev file path to new file path
db name\incoming

b. Go to Servers  Output

1. In the properties, go to the Input Filestore Service section Change

2. Temporary Directory from old dev file path to new file path
db name\outgoing\temp

3. File Store Directory from old dev file path to new file path
db name\outgoing

3. Stop SIA on Apps in CCM

4. Backup the CMS and Auditing databases

5. Copy CMS and Auditing backups to new DB server

6. Restore backups to new database with the same name as the existing databases

7. Validate the SIA Agent is still stopped

8. Change ODBC settings

a. BUSOBJECTS_CMS

b. BUSOBJECTS_AUDIT

c. C:\windows\syswow64\odbcad32.exe

a. GO into the CCM

b. Change configuration properties on SIA (specify DB and password)

c. Start SIA on each server

d. Start the CMS service

9. Move Incoming and Outgoing shares onto new db server

10. Validate shared FRS drive is available on new server

11. Restart the SIA

12. Review FileStore for Incoming and Outgoing

13. Set security on file shares

Former Member
replied

1. BusinessObjects XI 3.1 SP3 FP 3.4

2. Crystal Reports 2008 3.1 SP3 FP 3.4

3. Xcelsius Enterprise 2008 3.1 SP3 FP 3.4

4. SAP Integration kit 3.1 SP3 FP 3.1

this has to be at the same patch lever as #1

5. Live office 3.1 SP3 FP 3.4

6. SAP BusinessObjects Client Tools 3.1 SP3 FP 3.4

not needed as client tools are part of default server install in #1

7. Life cycle manager 1.0 SP3 FP 3.4

8. Data Federator SP3 FP 3.4

As you're installing on new server, do a default installation with mysql and tomcat.

Once you have installed all of the above and all is working, then stop default newly installed SIA.

Stop SIA on your original server.

Copy FRS (it's not a DB, it's a file store) from original to the new server.

On new server create new SIA pointing to the same CMS DB as original server.

If FRS on old server was in the default location - simply start new SIA and you're operational.

If FRS on old server was in a non-default location - in CMC point new FRS servers to the right location.

Do update objects.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question