Skip to Content
avatar image
Former Member

Unable to Find the Data After BOBJ 4.1 System Restore

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

Add comment
10|10000 characters needed 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.

  • Get RSS Feed

5 Answers

  • May 11, 2017 at 01:59 PM

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

    Add comment
    10|10000 characters needed characters exceeded

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

    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

    Add comment
    10|10000 characters needed 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.

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 12, 2017 at 09:30 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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?

  • Jun 05, 2017 at 07:38 PM

    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

    Add comment
    10|10000 characters needed characters exceeded