CMS Query Builder
Impressive way to retrive hidden info about CMS. Even using SDK restful Bi Admin platform nothing exceeds CMS query capabilities…..
A couple of my favourites links to work with (syntaxis is so complex as powerful 🙂
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
SAP BI 4.x System Copy
Backup and restore of filestore and CMS database of a BusinessObjects Enterprise BI 4.1 system (System Copy)
Resolution
Taking a backup on the Production machine
- From the Central Configuration Manager (CCM), stop the SIA
- Take a backup of the CMS database.
- Take a copy of the entire FileStore Input and Output folders (by default, under BOXI server installation folder)
- Restart the SIA
Note: On BI4.X you must know the cluster key at the time the backup was taken to be able to connect a CMS to the restored database.
Restoring the backup to the Test machine
- From the CCM, stop the SIA
- Rename the existing FileStore folder (e.g.: FileStore_Old)
- Copy the FileStore backup taken in step 3 into the BOXI server Test installation
- Restore the CMS database.
- Delete references to the original server as follows
WARNING: In this particular instance, the following command deletes the reference of the Business Objects Servers (parentid 16) in the database, as the production nodes/SIA (parentid 59) to avoid a system mixture. This should only be applied in a disaster recovery environment where the SIA and servers of production should not appear.
In the disaster recovery database, a delete command will remove the necessary references to the production
BOE XI 3.x | delete from cms_infoobjects6 where parentid=16 or parentid=59; |
BI 4.0/BI 4.1 | delete from cms_infoobjects7 where parentid=16 or parentid=59; |
- From the CCM, select “Add Server Intelligent Agent” or “Add Node”
- When details are requested, use the name and port number of the existing Test SIA (SIA port number is 6410 by default).
- For XI 3.x, 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”
- For BI 4.x, make sure to select “Recreate node”
- 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
- On BI 4.0 it will now ask for the cluster key – this is required to decode information from the restored database content
- DO NOT START THE SIA YET
- 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.
- Start the SIA
How to backup/restore the SubVersion Version Management System
How to backup/restore the SubVersion Version Management System
Cold backup/restore
Backup:
- Shutdown the SubVersion Server service.
- 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“ - 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” - Start the SubVersion Server service.
Restore:
- Shutdown the SubVersion Server service.
- 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“ - 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” - 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:
- 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” - 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 - 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:
- Shutdown the SubVersion Server service.
- Restore the folder structure for the SubVersion Repository from your backup location.
- 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” - Start the SubVersion Server service.
About the <Workspace Directory>
The <WorkSpace Directory> (i.e. Check_out folder) is used for:
- the preparation of content before it is uploaded to the Version Management Server repository.
- the preparation of content before it is imported into the SAP BusinessObjects Enterprise repository.
- 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
How to completely remove / uninstall SAP BO BI 4.0 from the system?
- Go to Start > All Programs > Control Panel > Add or Remove Programs and uninstall all the SAP BO patches in the reverse order.
- Select the base install of SAP BusinessObjects BI (SAP BusinessObjects BI platform 4.0), click on remove.
- Once it is finished, reboot the server once.
- Remove SAP BusinessObjects folder from <Install Directory>Program Files.
- Click on Start > Run > type regedit, which will open Windows registry window.
- Right click on My computer and take the backup entire registry by clicking on export.
- Clean the following location in the registry
- -HKEY_CURRENT_USER\Software\Business Objects
- -HKEY_CURRENT_USER\Software\SAP Business Objects
- -HKEY_LOCAL_MACHINE>Software>SAP Business Objects
- -HKEY_LOCAL_MACHINE\Software\Wow6432Node\SAP Business Objects
- Go to C:\documents and Settings\Administrator\Local Settings\Temp. The Local Settings folder may be hidden.
- Click on enable the option for “Show hidden files and folder” and uncheck the option for “Hide protected operating system files (Recommended)”
- Backup the Temp folder and delete all the files inside Temp. Don’t delete the Temp folder.
- Go to C:\WINDOWS.
- Search for “Installer” directory.
- Enable “Author” details.
- Delete all the files with “SAP Business Objects” as Author.
Recommendation:
*** TAKE BACKUP BEFORE DELETING ANY FOLDER OR REGISTRY ENTRIES***
Source: SAP Note 1691555