Archive | Administration RSS for this section

Troubleshooting for Promotion Management

Superb set of links that provide useful guides to solve any kind of issue related with Promotion Management (LCM)

http://wiki.scn.sap.com/wiki/display/BOBJ/Promotion+Management+Problems

Using End to End trace to isolate scanning of override issues

Using End to End trace for Promotion Management

Identify problematic overrides with Razor SQL and fix or reset database

How to backup/restore the SubVersion Version Management System

How to backup/restore the SubVersion Version Management System

Cold backup/restore

Backup:

  1. Shutdown the SubVersion Server service.
  2. Since SubVersion is a file based repository, simply backup the folder structure that makes up the repository.
    For XI 3: the default location of the SubVersion Repository on Windows is “C:\LCM_repository\svn_repository
    For BI 4: the default location of the SubVersion Repository on Windows is “<install_dir>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\LCM_repository\svn_repository
  3. It is important to also backup the <Workspace Directory> folder structure at the same time
    For XI 3: the default location of the <Workspace Directory> is “C:\Check_out”
    For BI 4: the default location of the <Workspace Directory> is “<install_dir>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\CheckOut”
  4. Start the SubVersion Server service.

Restore:

  1. Shutdown the SubVersion Server service.
  2. Since SubVersion is a file based repository, simply restore the folder structure that makes up the repository.
    For XI 3: the default location of the SubVersion Repository on Windows is “C:\LCM_repository\svn_repository
    For BI 4: the default location of the SubVersion Repository on Windows is “<install_dir>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\LCM_repository\svn_repository
  3. It is important to also restore the <Workspace Directory> folder structure at the same time
    For XI 3: the default location of the <Workspace Directory> is “C:\Check_out”
    For BI 4: the default location of the <Workspace Directory> is “<install_dir>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\CheckOut”
  4. Start the SubVersion Server service.

‘Hot backup/restore’

Backing up the files via a recursive copy is not necessarily safe or valid whilst SubVersion is running. Invalid backups are possible when the repository is being updated at the time the files are ‘backed-up’ or when files are backed-up in the wrong order.

Backup:

  1. Launch the command prompt and change directories to “\subversion\bin
    For XI 3: cd “C:\Program Files\Subversion\bin”
    For BI 4: cd “C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\subversion”
  2. Run the hotcopy command “svnadmin hotcopy repository_location new_repository_location ”
    For XI 3: snvadmin hotcopy C:\LCM_repository\svn_repository C:\svn_copy
    For BI 4:svnadmin hotcopy “C:\Program Files (x86)\SAPBusinessObjects\SAPBusinessObjects Enterprise XI 4.0\LCM_repository\svn_repository” C:\svn_copy
  3. It is important to also backup the <Workspace Directory> folder structure at the same time
    For XI 3: the default location of the <Workspace Directory> is “C:\Check_out”
    For BI 4: the default location of the <Workspace Directory> is “<install_dir>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\CheckOut”

Restore:

  1. Shutdown the SubVersion Server service.
  2. Restore the folder structure for the SubVersion Repository from your backup location.
  3. It is important to also restore the <Workspace Directory> folder structure at the same time
    For XI 3: the default location of the <Workspace Directory> is “C:\Check_out”
    For BI 4: the default location of the <Workspace Directory> is “<install_dir>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\CheckOut”
  4. Start the SubVersion Server service.

About the <Workspace Directory>

The <WorkSpace Directory> (i.e. Check_out folder) is used for:

  1. the preparation of content before it is uploaded to the Version Management Server repository.
  2. the preparation of content before it is imported into the SAP BusinessObjects Enterprise repository.
  3. the identification of which ‘version’ (revision number) was last imported into the SAP BusinessObjects Enterprise repository and users will see this as the ‘CMS Version’, within the Version Management User Interface.

and it is organized so there is a folder for each ‘system’ and a folder for each object, identified by its CUID

For XI 3: The <Workspace Directory> is defined within LifeCycle Management Console – Administration Options – VMS Settings – SubVersion – SubVersion Settings and by default is ‘C:/Check_out/‘ for Windows.
For BI 4: The <Workspace Directory> is defined within Central Management Console – Applications – Version Management – VMS Settings – SubVersion – SubVersion Settings and by default is ‘<install_dir>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\CheckOut‘ for Windows