BO recovery on different machine

[Former Member]

Hello,

we try to restore BO to a new host (different IP and hostname). We have a CMS database backup and a FRS file share backup from the old host.

Our recovery steps are:

1) Installing BO with a new empty CMS database

2) Creating new SIA with different port (6401) an pointing it to the restored CMS database

3) Pointing the FRS in the new SIA to the restored FileStore directory

The new SIA starts successfully. When we try to log in to the new SIA via CCM we retrieve an error saying that a connection to the the old hostname is not possible.

We changed CMS hostname and cluster name in properties of the SIA from old to new value, but that did not help.

Did we choose the correct recovery steps and are there any configuration changes we kept not in mind?

[Former Member · Accepted solution]

Hi,

Please check this KBA for further help in restoring BOE:

http://service.sap.com/sap/support/notes/1275068

Did you delete the restored services from the previous BOE system?

Thanks & Regards,

Insaf

[Former Member · Accepted solution]

Hi Insaf,

Thank you very much!

With that KBA i was able to restore and access our BOE on the new host

Unfortunately in the CMC i could only find the CMS server, all other servers are missing.

How can i restore the missing servers and their configuration settings?

Thanks & Regards,

Kai

[Former Member · Accepted solution]

Hi Kai,

Do you mean that you can only see the CMS under the newly created SIA? If so, during creating this SIA, did you select "Create default servers on the new node"?

Thanks & regards,

Insaf

[Former Member · Accepted solution]

Hi Insaf,

Yes, exactly. I can only see CMS under the newly created SIA or in the CMC.

I added the new SIA as described in KBA 1275068:

10. From the CCM, select "Add Server Intelligent Agent"

• When details are requested, use the name and port number of the existing Test SIA (SIA port number is 6410 by default). Make sure to select "Create default servers on the new node" and "Recreate Server Intelligence Agent on the local host, if it already exists in the CMS system database"
• Assign a port to the CMS (by default 6400) and select the restored CMS database of point 7. Enabling Auditing is optional at this stage and can be configured later.
• DO NOT START THE SIA YET

11. When the SIA is created, go to SIA > Properties > Configuration and modify the ClusterName of the restored environment to be different from the production environment.

12. Start the SIA

In the CMC i can see that the universes, users, folders and reports are restored correctly but in the servers area, all the job and processing server are missing except the CMS server.

Thanks & Regards,

Kai

[Former Member · Accepted solution]

Dear Kai,

Didn't you try to create a new node with different name and different ports? Please make sure to select "Create default servers on the new node"...

If this is not helpful, please open a ticket for the SAP Support for further analysis.

Thanks & Regards,

Insaf

[Former Member · Accepted solution]

Hi Insaf,

Yes i did, but i think the problem is caused by the fact, that BO installation path and machine name in the destination environment are different.

Can you please check if these steps are correct to restore a BO XI 3.1 CMS database backup and FRS directories backup to a new BO XI 3.1 environment:

1) Create a new SIA with default servers, different name and port.

2) Copy the CMS database with "Copy data from another Data Source"

3) Replacing the directories of the FRS with the backup

4) Change the Cluster name in SIA configuration

5) Start the SIA and Update Objects

In Step 5) i can now see all servers, but they have their old names and they are stopped and could not be started. When i Update Objects, i receive an error that FRS needs to run. However it says "Adding objects..." now (since 50 minutes).

Are these steps correct?

Do i have to run the delete SQL statement from KBA 1275068, and if yes in which step?

Regards,

Kai

[Former Member · Accepted solution]

Dear Kai,

To restore correctly the BOE environment into another server, you just need to do this:

- Install the BOE product in the new server (you an use different hostname & diffferet path).

- Restore the CMS database from the backup or use the Copy option to copy the CMS DB from the source environment.

- Restore the FRS folder.

- Create a new SIA in the destination environment because the old sia won't be working.

- Later on if the server is working fine, you can delete the old SIA from the destination server and change the cluster name.

I hope this help.

Thanks & Regards,

Insaf