Skip to Content
0

Unable to Find the Data After BOBJ 4.1 System Restore

May 11, 2017 at 10:23 AM

157

avatar image
Former Member

Hi Team,

We are unable to find the data after Restored Completed by Database Team.

Due to Datacenter Migration We have done Backup & Restore.

After Restore we are unable to find the Data in Bobj.Request to assist me on this.

Regards

Sai Naveen

10 |10000 characters needed characters left characters exceeded

Hello Naveen,

How can we provide any assistance since you haven't provided any details ?
No version, no actual error, no workflow, no details on what was backed up and what restored exactly....

If I had to guess - you didn't move your file repository.

0
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Jawahar Konduru May 11, 2017 at 01:59 PM
0

can you access BO repository? check if the all the tables have data or not? While restoring it, probably, tables have missing data.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Jawar,

not able to access BO Repsoitory.As procedure stated below.

Do we have any other procedure to navigate to BO Repository.

Regards

Sai Naveen

0
avatar image
Former Member May 12, 2017 at 05:10 AM
0

Hi Jawahar,

Thanks for your answer.Let me how to access the Repository.

[‎5/‎12/‎2017 10:33 AM]

Tools to browse CMS repository

There is tools to view the virtual tables called Query builder

Query Builder

Query Builder is a UI that lets you enter queries and send to the CMS. It returns the results in a UI table format. To use the feature, run "http://localhost:8080/AdminTools/" on a web browser.

The query is like ordinary sql query, see the following example:
Select SI_ID, SI_NAME from CI_INFOOBJECTS where SI_KIND='Webi'
i will check above process & update you accordingly.

Regards

Sai Naveen

Show 1 Share
10 |10000 characters needed characters left characters exceeded

What ever the DB you have, you can use those tools to connect to BO repository. If BO repository is in oracle, use PL/SQL developer or Toad, If you have SQL server, use SQL server management studio etc. Check with your DBA, which tools they use to connect to DB.

0
avatar image
Former Member May 12, 2017 at 05:22 AM
0

Hi Denis,

Thanks for your Reply.

Please find the Below Information.

==========================

Source System

RHEL 5

Database: Oracle 11.2

Applicaton BO 4.1 SP6 Patch 4

==========================

Target System

OS Solaris Sparck 11.2

Database : Oracle RAC 11.2.0.4

Applicaton : To be installed as same BO 4.1 SP6 Patch 4 as Source

=============================

Task:Due to Datacenter Migration We are using BACKUP/RESTORE Method.

After Restoring Backup into Target System we are unable to find the Data.

The issue may be appearing because you have migrated the database first and then installed the SAP BI pointing to it, so the data has been deleted during the installation/Build time.

I Suspect We need to follow Below Steps

Take a Full Backup of Working BO System As well File System SNAP.

Where in Target System After performing Vanilla Installtion ( BO Same Version as Source).

We Need to Restore after vanilla Installtion on Bo System.

Request to assist me on this.

Regards

Sai Naveen

Share
10 |10000 characters needed characters left characters exceeded
Tanveer Mujawar May 12, 2017 at 09:30 AM
0

Hi Naveen,

To know how to do a backup and restore of CMS database and filestore in BI 4.x kindly refer the below video KBA,

1275068 - Backup and restore of filestore and CMS database of a BusinessObjects Enterprise XI 3.x/BI 4.0/BI 4.1 system

The above KBA has the required steps.

Regards,

Tanveer

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Tanveer,

Thanks for your Reply & Note.

We have Referred that Note.This note refers to standerd Procedures before to perform the task.

We have already completed by using backup/Restore Method In Oracle.But note able to fetch the data.

Moreover We are not able to navigate to CMS Repository also.

We have source is in lower Version & Target is in Higher Version

source is at BO 4.1 SPS 4 & Target is BO 4.1 SPS7.

Regards

Sai Naveen

0

How are you navigating into the CMS repository?

What data you are not able to fetch?

Are you not able configure the System Database in the SIA>Properties>Configuration tab>

If yes, what is the error you get?

0
Denis Konovalov
Jun 05, 2017 at 07:38 PM
0

What does it mean - "After Restoring Backup into Target System we are unable to find the Data" ?
If your new system is higher version than original system - then backup/restore method will not work.

Sounds like you need to review Promotion management Patter book, from here

https://wiki.scn.sap.com/wiki/display/BOBJ/Business+Intelligence+Platform+-+Pattern+Books+Index

Share
10 |10000 characters needed characters left characters exceeded