e-sourcing system copy - sap e-sourcing...e-sourcing system copy [system refresh from production to...

29
SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com © 2010 SAP AG 1 E-Sourcing System Copy [System refresh from Production to existing Development] Applies to: SAP Netweaver 7.0 and E-Sourcing 5.1/CLM 2.0 Summary This document discusses about the steps to do an E-Sourcing system copy. Author: Thilip Kumar Company: Cognizant Technology Solutions Created on: 2 February 2, 2011 Author Bio I am Thilip Kumar R.B. I am working as BASIS Consultant in Cognizant Technology Solutions and I have around 5 years of experience in Netweaver Administration.

Upload: others

Post on 10-Mar-2020

12 views

Category:

Documents


1 download

TRANSCRIPT

Page 1: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 1

E-Sourcing System Copy [System

refresh from Production to existing

Development]

Applies to:

SAP Netweaver 7.0 and E-Sourcing 5.1/CLM 2.0

Summary

This document discusses about the steps to do an E-Sourcing system copy.

Author: Thilip Kumar

Company: Cognizant Technology Solutions

Created on: 2 February 2, 2011

Author Bio

I am Thilip Kumar R.B. I am working as BASIS Consultant in Cognizant Technology Solutions and I have around 5 years of experience in Netweaver Administration.

Page 2: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 2

Table of Contents

Environment ........................................................................................................................................................ 3

Pre-requisite........................................................................................................................................................ 3

Procedure ........................................................................................................................................................... 3

System Copy Export ....................................................................................................................................... 3

System Copy Import ...................................................................................................................................... 10

Restore ESD_CLM database ........................................................................................................................ 21

Configure E-Sourcing application ................................................................................................................. 23

Post-Installation Steps for Netweaver ........................................................................................................... 25

Post-Installation steps for E-Sourcing system .............................................................................................. 25

Issues faced .................................................................................................................................................. 26

Resolution ..................................................................................................................................................... 26

Related Content ................................................................................................................................................ 28

Disclaimer and Liability Notice .......................................................................................................................... 29

Page 3: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 3

Environment

OS – AIX 6.1

DB – DB2 9.1.5

System copy method – Homogeneous system copy

Pre-requisite

1) Download brdb6brt tool from the service market place. 2) Turn off the e-mail functionality of the source system.

3) Take a database and file system copy of the existing development system

Procedure

Drop the Netweaver AS Java database ( in this case ESD)

Command - db2 drop database <database name>

Now drop the E-Sourcing database (in this case ESD_CLM)

Drop the existing ESD_CLM database

System Copy Export

Install the latest brdb6brt tool according to SAP Note 511323

Run the command mentioned below to export the databases to the path specified.

The option BOTH means to export both the database and create scr file in the mentioned path.

Export both ESD and ESD_CLM databases

Page 4: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 4

Run the same command to export Netweaver database

Page 5: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 5

Now we need to export the Netweaver Application to the backup directory

Run sapinst in the E-Sourcing Production server

Navigate to ‘System CopyIBM DB2 for Linux, UNIX and Windows Source System ExportCentral SystemBased on AS JAVADatabase and Central Instance’

Page 6: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 6

Page 7: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 7

Page 8: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 8

Check the option to use Database specific tools

Page 9: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 9

Page 10: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 10

Now start the E-Sourcing source system

Turn on the e-mails

System Copy Import

Copy the database export from Production to development server

Edit the ESP_NODE000.scr

Page 11: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 11

Change the <SID> and the path according to the source system database structure

You should only edit the content contained between S################ and E#############

Save the scr file

Check the modified ESP_NODE0000.scr file for any errors

Page 12: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 12

Confirms that the file does not contain any errors

Run sapinst on development server to start the import

Page 13: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 13

Page 14: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 14

Page 15: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 15

Page 16: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 16

Page 17: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 17

Page 18: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 18

Now we need to import the database. Leave the dialog box as it is.. Do not click on ‘Ok’ or ‘Cancel’

Execute the command mentioned below that will create the database on the target server

The restore is completed successfully for ESD database

Page 19: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 19

Now click ‘Ok’ on the dialog box to continue the import

Page 20: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 20

Page 21: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 21

Restore ESD_CLM database

Modify the ESP_CLM_NODE0000.scr file so that it matches the target database ESD_CLM and its structure

Check the ESP_CLM_NODE0000.scr file for any errors

Page 22: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 22

Restore the ESD_CLM

ESD_CLM is restored successfully

Page 23: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 23

Configure E-Sourcing application

Run the configure utility in E-Sourcing to configure the E-Sourcing application to the newly imported database

Page 24: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 24

After this, deploy the fcsourcing.ear file in the visual administrator

Copy the fcisystem.properties and password.properties file from the E-Sourcing production to the development server.

Login to E-Sourcing with the password of production server.

Page 25: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 25

Post-Installation Steps for Netweaver

Install new licenses for Netweaver.

Delete the old certificate in Visual Administrator and create a new certificate

Post-Installation steps for E-Sourcing system

Install new license

Change the hostname and port number in Cluster configuration

Page 26: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 26

Make relevant changes to System Information

Enable all the e-mails in the development.

Issues faced

E-Sourcing system clocks indefinitely.

Error – Class definition error

Resolution

Set the class path mentioned below for Instance node in Config tool

./bin/boot/boot.jar;./bin/boot/jaas.jar;./bin/system/bytecode.jar;./usr/sap/ESD_CLM/lib/endorsed/xalan.jar;/usr/sap/ESD_CLM/lib/endorsed/xercesImpl.jar;/usr/sap/ESD_CLM/lib/endorsed/xml-apis.jar;/usr/sap/ESD_CLM/lib/jcschart.jar;

Look out for parameter java.awt.headless, if it is defined for both the dispatcher as well as server node.

Page 27: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 27

For some reason this parameter was not reflecting in server node. Just interchange the position of this parameter in configtool. Restart the instance.

Check the parameter definition in http://<server name:<port>

Page 28: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 28

Related Content

http://www.sdn.sap.com/irj/scn/events?rid=/library/uuid/743fd6e5-0d01-0010-a2b5-e85339108ee9

Page 29: E-Sourcing System Copy - SAP E-Sourcing...E-Sourcing System Copy [System refresh from Production to existing ... DB – DB2 9.1.5 System copy method – Homogeneous system copy

E-Sourcing System Copy [System refresh from Production to existing Development]

SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com

© 2010 SAP AG 29

Disclaimer and Liability Notice

This document may discuss sample coding or other information that does not include SAP official interfaces and therefore is not supported by SAP. Changes made based on this information are not supported and can be overwritten during an upgrade.

SAP will not be held liable for any damages caused by using or misusing the information, code or methods suggested in this document, and anyone using these methods does so at his/her own risk.

SAP offers no guarantees and assumes no responsibility or liability of any type with respect to the content of this technical article or code sample, including any liability resulting from incompatibility between the content within this document and the materials and services offered by SAP. You agree that you will not hold, or seek to hold, SAP responsible or liable with respect to the content of this document.