Dataservice upgrade from 4.2 sp4 to 4.2 sp7

2324793 - Release Notes for SAP Data Services 4.2 Support Pack 7 Patch 1 (14.2.7.1237)

compare the version : 

version needed : 

• SAP BusinessObjects Information Platform Services (IPS) 4.1 SP7 or 4.2 SP2 or its higher compatible patches 

current version : 

Check IPS version 

[dsadm@ssx3h1dts01 bin]$ cd /usr/sap/DS/sap_bobj/enterprise_xi40/linux_x64/

[dsadm@ssx3h1dts01 linux_x64]$  strings boe_cmsd | grep BOBJVERSION

@(#)BOBJVERSION: 14.1.5.1501 boe_cmsd release 14/11/10 linux_x64 vcvmlnx215

which means IPS version is 4.1 sp5

Check DS version 

[dsadm@ssx3h1dts01 bin]$ ./al_jobserver -version 

SAP Data Services Engine Version 14.2.4

[dsadm@ssx3h1dts01 bin]$ ./al_engine -version 

SAP Data Services Engine Version 14.2.4

which means DS version is 4.2 sp4 

--------------

Upgrade step for  upgrade DS from 4.2 sp4 to 4.2 sp7 

STEP 1. upgrade IPS from 4.1 sp5 to 4.1 sp7  ----> way1(upgrade patch ) or way2 (fresh install )  -----> seems not upgrade there is no problem  . ignore this step first  .

STEP 2.upgrade DS from 4.2 sp4 to 4.2sp7 --->(upgrade )

STEP 3.upgrade repository manager from 4.2 sp4 to 4.2 sp7 

STEP 4.upgrade local and central repository  from 4.2sp4 to 4.2 sp7 

STEP 5.upgrade finished . 

STEP 1. upgrade IPS from 4.1 sp5 to 4.1 sp7  ----> way1(upgrade patch ) or way2 (fresh install )

Way1 : So upgrade the IPS version from 4.1 sp4 to 4.1 sp7 

1.upgrade file under folder : 

[root@ssx3h1dts01 IPS4.1SP7]# ll /SRC_SAP/Data_Services/IPS_4.1_sp7/IPS4107P_1-20010908.TGZ 

2.create install path 

[root@ssx3h1dts01 IPS4.1SP7]# mkdir /usr/sap/SOURCES/IPS4.1SP7/

3.cp install file 

cp /SRC_SAP/Data_Services/IPS_4.1_sp7/IPS4107P_1-20010908.TGZ    /usr/sap/SOURCES/IPS4.1SP7/

4.unzip 

cd  /usr/sap/SOURCES/IPS4.1SP7/

tar -xvf  /SRC_SAP/Data_Services/IPS_4.1_sp7/IPS4107P_1-20010908.TGZ  

5. install IPS 4.1 SP7 

[dsadm@ssx3h1dts01 IPS_lnx]$ ./setup.sh 

6.choose destination folder : 

Configure Destination Folder

Enter the full destination path where the product will be installed.

Destination Folder:

[/usr/sap/DS/                                                ]

-------------------

Way 2 : fresh install IPS 4.1 sp7 

1.[dsadm@ssx3h1dts01 ~]$ cd /usr/sap/SOURCES/IPS4.1SP7_INSTALL/DATA_UNITS/IPS_lnx/

[dsadm@ssx3h1dts01 IPS_lnx]$ ./InstallIPS 

2.lan ----> choose english 

3.enter destination foler 

Configure Destination Folder

Enter the full destination path where the product will be installed.

Destination Folder:

[/usr/sap/DS/                                                ]

4.product key ---->keep default 

Product Key:

[D5205-N000000-NTMWP04-UDDETFV-3R                            ]

5.install type ----> full 

Select Install Type

Select the type of installation.

 1  -   Full

 2  -   Custom / Expand

 3  -   Web Tier

6. database  --->  Configure and install a Sybase SQL Anywhere database

Select Default or Existing Database

Select whether to configure and install Sybase SQL Anywhere or use an existing database to store data for the Information platform services.

 1  -   Configure and install a Sybase SQL Anywhere database

 2  -   Configure an existing database

7.Select a Java Web Application Server solution. --->    choose 1 

Select Java Web Application Server

Select a Java Web Application Server solution.

 1  -   Install the default Tomcat Java Web Application Server and automatically deploy web applications

 2  -   Manually deploy web applications to a supported Java Web Application Server after the installation

 3  -   Install the Web Application Container Server and automatically deploy web applications

8. choose 1 

Select Version Management

Select whether to install the default version control system or use an exising system for version management.

 1  -   Configure and install Subversion

 2  -   Do not configure a version control system at this time

9.SIA config 

Configure Server Intelligence Agent (SIA)

Enter a name and port number for the SIA node.

Node Name:

[ssx3h1dts01                                                 ]

SIA Port:

[6410  ]

10 . CMS port 6400 

Configure Central Management Server (CMS)

Enter a port number for the CMS.

CMS Port:

[6400  ]

11.enter password ---> all Decathlon1 

Configure CMS Account

Enter the administrator account password and cluster key for the CMS. The cluster key is used to connect multiple CMS servers together.

Administrator Account Password:

[**********                                                  ]

Confirm Password:

[**********                                                  ]

CMS Cluster Key:

[**********                                                  ]

Confirm Cluster Key:

[**********                                                  ]

12.sql anywhere ---> Decathlon1 

Configure Sybase SQL Anywhere

Enter the server port and administrator password for the Sybase SQL Anywhere database.

Sybase SQL Anywhere Port:

[2638  ]

"dba" Account Password:

[**********                                                  ]

Confirm Password:

[**********                                                  ]

13. port default 

Configure Tomcat

Enter the port information for Tomcat.

Connection Port:

[8080  ]

Shutdown Port:

[8005  ]

Redirect Port:

[8443  ]

14. ---> Decathlon1

Configure Subversion

Enter the port and user name for the Subversion version control system.

Subversion Port:

[3690  ]

Repository User Account Password:

[**********                                                  ]

Confirm Password:

[**********                                                  ]

15.SMD ---> choose 1 not config 

Select Connectivity for Solution Manager Diagnostics (SMD) Agent

Select connectivity to SMD Agent to provide server profiling and diagnostics.

 1  -   Do not configure connectivity to SMD Agent

 2  -   Configure connectivity to SMD Agent

16. Introscope Enterprise Manager not config 

Select Connectivity to Introscope Enterprise Manager

Select connectivity to Introscope Enterprise Manager to configure server profiling.

 1  -   Do not configure connectivity to Introscope Enterprise Manager

 2  -   Configure connectivity to Introscope Enterprise Manager

17. install ----- > finished 

18 .set auto start ---> root#  /usr/sap/DS/sap_bobj/init/setupinit.sh

19 . config db connection ---> vi /usr/sap/DS/sap_bobj/enterprise_xi40/odbc.ini 

[ODBC Data Sources]

BI4_CMS_DSN_1479800710=SQLAnywhere 12.0

BI4_Audit_DSN_1479800710=SQLAnywhere 12.0

HANADB=HANA 1.00.122

[BI4_CMS_DSN_1479800710]

UID=dba

DatabaseName=BI4_CMS

ServerName=BI4_1479800710

Host=localhost:2638

Driver=/usr/sap/DS/sqlanywhere/lib64/libdbodbc12.so

[BI4_Audit_DSN_1479800710]

UID=dba

DatabaseName=BI4_Audit

ServerName=BI4_1479800710

Host=localhost:2638

Driver=/usr/sap/DS/sqlanywhere/lib64/libdbodbc12.so

[HANADB]

SERVERNODE=192.168.84.229:30015

20. export ODBCINI=/usr/sap/DS/sap_bobj/enterprise_xi40/odbc.ini 

21. test odbc ---> 

[dsadm@ssx3h1dts01 hdbclient]$ ./odbcreg 192.168.84.229:30015 S22 IPSADMIN Decathlon2

ODBC Driver test.

Connect string: 'SERVERNODE=192.168.84.229:30015;SERVERDB=S22;UID=IPSADMIN;PWD=Decathlon2;'.

retcode: 0

outString(75): SERVERNODE={192.168.84.229:30015};SERVERDB=S22;UID=IPSADMIN;PWD=Decathlon2;

Driver version 01.00.0097 (2015-06-11).

Select now(): 2016-11-22 09:11:02.365000000 (29)

22.copy lib to IPS 

[dsadm@ssx3h1dts01 hdbclient]$ cp libodbcHDB.so  /usr/sap/DS/sap_bobj/enterprise_xi40/linux_x64/

23.setup cms db 

[dsadm@ssx3h1dts01 sap_bobj]$ pwd

/usr/sap/DS/sap_bobj

[dsadm@ssx3h1dts01 sap_bobj]$ ./cmsdbsetup.sh 

24.choose yes 

----------------------------------------------------------

           SAP BusinessObjects

The node will be stopped. Do you want to continue?

[yes(3)/no(2)/back(1)/quit(0)] 

----------------------------------------------------------

[yes]

STEP 2.upgrade DS from 4.2 sp4 to 4.2sp7 --->(upgrade )

1.upgrade filde under folder : 

[dsadm@ssx3h1dts01 bin]$  ll /SRC_SAP/Data_Services/Dataservice_4.2_sp7_p1/

total 2543252

-rwxr-xr-x 0 root root 2604288000 Nov 20 14:56 Dataservice_4.2SP7_P1.tar.gz

2.copy and uncompress file 

[dsadm@ssx3h1dts01 bin]$ cp /SRC_SAP/Data_Services/Dataservice_4.2_sp7_p1/Dataservice_4.2SP7_P1.tar.gz /usr/sap/SOURCES/Dataservice_4.2SP7_P1/

[dsadm@ssx3h1dts01 bin]$ cd /usr/sap/SOURCES/Dataservice_4.2SP7_P1/

[dsadm@ssx3h1dts01 Dataservice_4.2SP7_P1]$ tar -zxvf Dataservice_4.2SP7_P1.tar.gz

3.Upgrade dataservice 

[dsadm@ssx3h1dts01 bin]$ cd /usr/sap/SOURCES/Dataservice_4.2SP7_P1/DATA_UNITS/DS_42_LNX64

[dsadm@ssx3h1dts01 DS_42_LNX64]$ ls

Collaterals  Documentation  dunit  langs  modifyOrRemoveProducts.sh  PRODLABEL  ProductId.txt  response.ini  script  setup.core.sh  setup.engine  setup.env.sh  setupexe  setup.ini  setup.sh  SIGNATURE.SMF

4.run Install command  ---> run ./setup.sh InstallDir=/usr/sap/DS

[dsadm@ssx3h1dts01 DS_42_LNX64]$ ./setup.sh  InstallDir=/usr/sap/DS/

5.enter destination folder  --->enter /usr/sap/DS

Configure Destination Folder

Enter the full destination path where the product will be installed.

Destination Folder:

[/usr/sap/DS/                                                ]

6.select language  ---> keep default 

Select all additional Language Packages that the users will interact with in the product.

[X]  English

[ ]  Czech

[ ]  Turkish

[ ]  German

[ ]  Hungarian

[ ]  Japanese

[ ]  Russian

[X]  French

7.enter cms pwd   ---> pwd of administrator of CMS

8.install start 

Undeploying web applications

     17% [********                                          ]

8.install finished  

9.stop/start server 

[dsadm@ssx3h1dts01 DS_42_LNX64]$ cd /usr/sap/DS/sap_bobj/

[dsadm@ssx3h1dts01 sap_bobj]$ ./stopservers &&./tomcatshutdown.sh  && ./startservers && ./tomcatstartup.sh 

10.login to the CMC : http://sapsx3.subsidia.org/BOE/CMC  then go to the dataservice tab check the version of the repository (should be 14.2.7 ----> means 4.2 sp7 ) and each repository should be inactive (it is normal because we didn't upgrade the repository yet )

P.S if the version of the repository is not 14.2.7 please run the command on the server to upgrade . 

[dsadm@ssx3h1dts01 sap_bobj]$ cd /usr/sap/DS/dataservices/bin   

[dsadm@ssx3h1dts01 bin]$ ./DSXI40UpgradeMgr.sh -RU -CCssx3h1dts01 -CUAdministrator -CPDecathlon1 -CA secEnterprise

STEP 3.upgrade repository manager from 4.2 sp4 to 4.2 sp7 

the repository manager install package is on the F:/51050995_5.ZIP on admna0sap06  . 

Install the new repository manager to the new version 4.2 sp7  . 

1.  go to the path : F:\51050995_5\BD_SAP_DATA_SERVICES_4.2_SP7_MULTI_64B_\DATA_UNITS\DS_CLIENT_42_WIN64

2.run setup.exe 

3.follow the screenshot  : 

5.install finished .

STEP 4.upgrade local and central repository  from 4.2sp4 to 4.2 sp7 

1.open the repository manager on the TSE (sapgate01 ----> admna0sap06 )

2.get version from the repository (one central and two local repository ) (before upgrade it should be 14.2.4 ---> mean 4.2 sp4 )

3.press upgrade (need to upgrade three repository , one central and two local ) ----> finish the upgrade (after upgrade , it should be 14.2.7 )

4.back to CMC console , http://sapsx3.subsidia.org/BOE/CMC , and then go to the dataservice tab  , all the repository should be active . 

STEP 5.upgrade finished . 

reference upgrade guide see the attachement .