Wednesday, April 27, 2016

SSH password less

http://www.golinuxhub.com/2014/01/how-to-create-password-less-ssh.html

Thursday, April 14, 2016

BI 4.1 Disaster Recovery in Windows Platform


Disaster Recovery for SAP Business Objects 4.1/SAP Crystal Enterprise 2013
Prerequisites:
1. File Store Input and Output folders
2. Back up of CMS Database
3. Cluster Key Information.

Restoring/Recovery steps:
1. From the CCM, stop the SIA
2. Rename the existing FileStore folder
3. Copy the file store folder to the server which we are restoring.
4. Delete references to the original server as follows.
Select * from cms_infoobjects7 where parentid=16 or parentid=59;
delete from cms_infoobjects7 where parentid=16 or parentid=59;
Business Objects Servers (parentid 16) in the database, as the production nodes/SIA (parentid 59)
5. From the CCM, select "Add Server Intelligent Agent" or "Add Node"
6. Add node with default servers.
7. Assign a port to the CMS (by default 6400) and select the restored CMS database. Enabling Auditing is optional at this stage and can be configured later
8. On BI 4.0 it will now ask for the cluster key - this is required to decode information from the restored database content
9. DO NOT START THE SIA YET
10. 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
11. Start the SIA

Deleting the Orphan SIA Agents in Central Configuration Manager

So, what needed to be done was to create a new node in the CCM with all servers, and then delete the old SIA by doing the following:

Launch Central Configuration manager (CCM).
Stop the Server Intelligence Agent (SIA) to be deleted.
Go to Windows Start > Run and type in "services.msc" without the quotes and press Enter key.
In the Services applet, find the SIA service to be deleted say Server Intelligent Agent (BI40).
Go to Properties of Server Intelligent Agent (BI40).
Under the General tab, copy the Service name BOEXI40SIABI40 to the clipboard.
Open DOS prompt and run following command:sc delete BOEXI40SIABI40
Navigate to "Install Directory\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64" directory and delete the following files for Server Intelligent Agent (BI40).
_boe_BI40.bootstrap
_boe_BI40.bootstrap.backup
_boe_BI40.bootstrap.original
_boe_BI40.dbinfo

Sonarqube Upgrade from 9.4.4 to 9.9.4 LTS

 Issue:  1) Java hasbeen upgraded from 11 to Open JDK 17. And Sonarqube is upgraded from 9.4 to 9.9.4. 2) After the upgrade sonarqube servic...