cancel
Showing results for 
Search instead for 
Did you mean: 

System copy of Esourcing 5.1 / CLM 2.0

Former Member
0 Kudos

I need to do a system copy of esourcing 5.1 from my production system to create a new QA system. I have 2 seperate databases in my Production system -- one for netweaver java and one for Esourcing. Can I use sapinst to do an export / import copy for this system (like we do for a heterogenous system ) ? I would prefer to do it over backup restore because this is a java system.

If i do export import, would i also copy the contents of the esourcing database automatically and all the configuration ? Please shed some light on this.

Also, can anybody guide on post copy steps since this would be a QA system with a differetn SID and connecting to different KM, ERP and contract generation servers.


thanks a lot

BV

Accepted Solutions (1)

Accepted Solutions (1)

former_member89217
Contributor
0 Kudos

Typically, we just export the sourcing database and import into the new (in your case QA) environment. How you decide to build / copy the Netweaver infrastructure is up to you.  After the database is imported to the new enevironment, there will be some settings in sourcin that need to be updated with the new host information. (mainly system properties). Support has published a note that provides a bit more detail around this. Let vme know if you can't find that or have additional questions.

Regards,

Gary

Former Member
0 Kudos

thanks for your input gary. So, i will just copy the esourcing db using db copy methods. And then use export/import to create the netweaver/esourcing application part.

I cannot find the note that you mentioned. Can you please provide me the note # if possible ? thanks a lot

BV

former_member89217
Contributor
0 Kudos

Here is a copy of the content:

This note provides the basic steps that are required to take a SAP Sourcing database instance from one environment and apply it to a different environment. For example, taking a database instance for a production environment and utilizing it in a development environment. Some steps provided require specific SQL statements to be executed. Those specific statements are not provided here, but rather are described in concept here. This note also assumes that the backup procedures will backup only SAP Sourcing related tables (i.e., this procedure should not be used if the backup also includes NetWeaver related tables).

NOTE: The system that is being used as the Source system should have little to no activity on it.

1.      Take a database backup of the environment to be replaced (Target System).

This will allow for restoration in the event that the write-back is not successful. 

2.      In the application instance to be copied (Source System), perform the following:

a.  Confirm that the #automatically add services to cluster# setting is checked in the System Default Cluster configuration. If it is not checked, check it now and save the cluster, prior to the next steps.

b.  Confirm that there are no messages in the #queued messages#.  This ensures that when the database is copied to the new environment, no queued messages are sent.

3.      Ensure that no users are logged into the application instance of the Source System.

4.      Stop the Sourcing/CLM Application in the Source System.

5.      Take a database backup / Export the user/schema of the Source System.  The specific procedure to be determined and provided by the DBA.

NOTE: There should not be ANY errors, if there are they should be corrected / explained before proceeding.  This ensures that no errors are copied to the new Target system. 

6.      Shut down Target Application environment

7.      Create a NEW (empty) User/Schema per requirements in the Installation Guide. 

NOTE: This step is critical that the Target system is a new (empty) schema.

8.      Import the database into the User/Schema that was created in step 7.  The specific procedure to be determined and provided by the DBA.

9.      ***OPTIONAL*** Using SQL, overwrite all email addresses in the copied database with a valid email address (use of an invalid email address will result in downstream issues so should not be done). It is best to use a generic internal email account that can receive the email messages. This ensures that buyer and supplier users are not inadvertently informed of upcoming events in the system. Email addresses are stored in the User Account and Supplier Contact tables.

NOTE: If you choose not to do this step, it is strongly advised that you do NOT change the “delete” rule that you set in the Mail Configuration (step 2b) so that Suppliers in this new environment do NOT get mail.   

10.     Run the configure utility to reset the database connection information.

NOTE: If the application context is changed, or if additional custom jars are added, the .ear/.sca will need to be re-built and re-deployed. 

11.     Start up the environment with the database copy (Target System)   

a.  Check the application log to determine the application started.  Look for the following sequence in the logs:

Successful 5.X Startup contains a sequence like this:

Setting static content refresh time to 86400 seconds.

Servlet starting

IMBOFrameworkServlet starting

Setting default UI transaction timeout to 300000 milliseconds

AjaxServlet starting

CustomContentServlet starting

UtilServlet starting

runtime status: free/total = 2385313/3088384 kb, max = 3088384 kb, hitrate = 0.0 pgs/sec, active = 0 pgs, users = 0, ct = 0

Successful 7.X Startup contains a sequence like this:

#Info#/Applications/E-Sourcing/eso#

##sap.com/E-Sourcing-Server#000FFEE4D7BD001B000001A500001A3C#9337250000000011#sap.com/E-Sourcing-Server#E-Sourcing.eso.java.com.sap.odp.install.sysinfo.mbeans.MBeanRegistrationServlet.init#ume_dude#0##AD2A41401CED11E1807D000FFEE4D7BD#ad2a41401ced11e1807d000ffee4d7bd#ad2a41401ced11e1807d000ffee4d7bd#0#Application [5]#Plain##

Facility=local4;sessionid=system-7430;tenantid=\#system\#;username=system;registered SAP MBean: :SAP_J2EEApplicationPerNode=sap.com/E-Sourcing-Server,SAP_J2EECluster="",SAP_J2EEClusterNode="",j2eeType=SAP_ApplicationResourcePerNode,name=SAPCacheInfo#

#Info#/Applications/E-Sourcing/eso#

##sap.com/E-Sourcing-Server#000FFEE4D7BD001B000001A600001A3C#9337250000000011#sap.com/E-Sourcing-Server#E-Sourcing.eso.java.com.sap.odp.display.servlet.IMBOImageServlet.init#Guest#0##AD2A41401CED11E1807D000FFEE4D7BD#ad2a41401ced11e1807d000ffee4d7bd#ad2a41401ced11e1807d000ffee4d7bd#0#Application [5]#Plain##

Facility=local4;Setting static content refresh time to 86400 seconds.#

#Info#/Applications/E-Sourcing/eso#

##sap.com/E-Sourcing-Server#000FFEE4D7BD001B000001A700001A3C#9337250000000011#sap.com/E-Sourcing-Server#E-Sourcing.eso.java.com.sap.odp.display.servlet.IMBOImageServlet.init#Guest#0##AD2A41401CED11E1807D000FFEE4D7BD#ad2a41401ced11e1807d000ffee4d7bd#ad2a41401ced11e1807d000ffee4d7bd#0#Application [5]#Plain##

Facility=local4;Servlet starting#

#Info#/Applications/E-Sourcing/eso#

##sap.com/E-Sourcing-Server#000FFEE4D7BD001B000001A800001A3C#9337250000000011#sap.com/E-Sourcing-Server#E-Sourcing.eso.java.com.sap.odp.display.servlet.IMBOFrameworkServlet.init#Guest#0##AD2A41401CED11E1807D000FFEE4D7BD#ad2a41401ced11e1807d000ffee4d7bd#ad2a41401ced11e1807d000ffee4d7bd#0#Application [5]#Plain##

Facility=local4;IMBOFrameworkServlet starting#

#Info#/Applications/E-Sourcing/eso#

##sap.com/E-Sourcing-Server#000FFEE4D7BD001B000001A900001A3C#9337250000000011#sap.com/E-Sourcing-Server#E-Sourcing.eso.java.com.sap.odp.display.util.IMBOFrameworkProcessor.<clinit>#Guest#0##AD2A41401CED11E1807D000FFEE4D7BD#ad2a41401ced11e1807d000ffee4d7bd#ad2a41401ced11e1807d000ffee4d7bd#0#Application [5]#Plain##

Facility=local4;Setting default UI transaction timeout to 300000 milliseconds#

#Info#/Applications/E-Sourcing/eso#

##sap.com/E-Sourcing-Server#000FFEE4D7BD001B000001AA00001A3C#9337250000000011#sap.com/E-Sourcing-Server#E-Sourcing.eso.java.com.sap.odp.display.servlet.AjaxServlet.init#Guest#0##AD2A41401CED11E1807D000FFEE4D7BD#ad2a41401ced11e1807d000ffee4d7bd#ad2a41401ced11e1807d000ffee4d7bd#0#Application [5]#Plain##

Facility=local4;AjaxServlet starting#

#Info#/Applications/E-Sourcing/eso#

##sap.com/E-Sourcing-Server#000FFEE4D7BD001B000001AB00001A3C#9337250000000011#sap.com/E-Sourcing-Server#E-Sourcing.eso.java.com.sap.odp.display.servlet.CustomContentServlet.init#Guest#0##AD2A41401CED11E1807D000FFEE4D7BD#ad2a41401ced11e1807d000ffee4d7bd#ad2a41401ced11e1807d000ffee4d7bd#0#Application [5]#Plain##

Facility=local4;CustomContentServlet starting#

#Info#/Applications/E-Sourcing/eso#

##sap.com/E-Sourcing-Server#000FFEE4D7BD001B000001AC00001A3C#9337250000000011#sap.com/E-Sourcing-Server#E-Sourcing.eso.java.com.sap.odp.display.servlet.UtilServlet.init#Guest#0##AD2A41401CED11E1807D000FFEE4D7BD#ad2a41401ced11e1807d000ffee4d7bd#ad2a41401ced11e1807d000ffee4d7bd#0#Application [5]#Plain##

Facility=local4;UtilServlet starting#

....

#Info#/Applications/E-Sourcing/eso#

##sap.com/E-Sourcing-Server#000FFEE4D7BD00210000000000001A3C#9337250000000011#sap.com/E-Sourcing-Server#E-Sourcing.eso.java.com.sap.odp.display.util.SystemStatistics.computeAndLog#Guest#0##AD2A41401CED11E1807D000FFEE4D7BD#ad2a41401ced11e1807d000ffee4d7bd#ad2a41401ced11e1807d000ffee4d7bd#0#Thread[PageHitMonitorThread,5,ApplicationThreadGroup]#Plain##

Facility=local4;sessionid=system-862;tenantid=\#system\#;username=stats_monitor;runtime status: free/total = 860892/1223680 kb, max = 1224704 kb, hitrate = 0.0 pgs/sec, active = 0 pgs, users = 0, ct = 0#

12.     Login to the environment as the #system# user and check the following:

a.  System properties: Adjust system properties that refer to other systems/servers

System Level Properties

* contractgen     contractgen.km_search_webservice.url

* contractgen     contractgen.serviceurl

  j2ee            jndi.java.naming.provider.url

** messaging      messaging.smtp.mailhost

* optimization    optimization.jndi.java.naming.provider.url

  system          system.avscanner.hostname

* optional settings

** Mailhost can be set either as a system level or enterprise level property.

b.  Review the cluster configurations:

i.      In the “System Default” cluster, confirm the new service is shown and active and remove the service(s) that remain from the source system.  Save the cluster.

ii.      In the other cluster(s), add a new service member(s) using the add button on the cluster configuration UI. Then delete the service(s) that remain from the source system.  Update the hostname and port (if used). Save the cluster(s).  Make sure all cluster members added are set active and make sure the internal hostname is set correctly.

c.       (Version 7.x and up only) Update the directory configuration(s) to reflect that authentication method being used in the environment and if the host information is different, that should be updated as well.

  1. 13.  Login to the environment as the #enterprise# user and check the following:
  2. a. System properties: Adjust any system properties that refer to other systems/servers.

   1. Enterprise Level Properties

** messaging messaging.smtp.mailhost

** Mailhost can be set either as a system level or enterprise level property.

  1. b. Edit the Mail Configuration and set it to delete all email that is not going to the internal domain. 

For example:

We would like to send mail to sap.com and delete everything else.

In the company specific Mail Configuration,

Check the Use Global Rules checkbox.

Add the specific domain(s) to “send” mail

@sap.com=send;

Add the global all else delete rule.

@all=delete

Complete Rule:  @sap.com=send;@all=delete

There are other options like redirection. Consult the online SAP documentation for more information.

  1. c. (Version 5.x and earlier only) Update the directory configuration(s) to reflect that authentication method being used in the environment and if the host information is different, that should be updated as well.
  2. d. Integrated System Configurations: Ensure that any integrated system parameters are updated in the Integrated System Configuration.
  3. e. If using FTP/Scheduled imports, change all scheduled tasks to point to the proper file directories.
  4. f. Review log files for any errors
  5. g. ***Optional***Enable email via the daemon tab if required

  1. 14.  Test the updated environment
Former Member
0 Kudos

Thank you gary. I followed the steps but ran into an issue

1) first, we backed up the esourcing and nw database

2)  then on the brand new target system, we restored these databases using db tools

3) Then via sapinst, I created a distributed sap netweaver system using the "db backup method" and used the copy of source netweaver database.

4) then I installed e-sourcing on NW the system and ran configure utility to point to the newly copied esourcing database

5) redeployed fcsourcing.ear file

Now when I bring up the esourcing application page --- it shows a page that says "new user registration" and also it wouldnt allow me to login as system user with the password from the production system !!

any ideas ?? how can I check that it is pointing to right db ?

former_member89217
Contributor
0 Kudos


Have you reviewed the application logs to determine the application started properly?  Further, what URL are you using to access the application?  The only cluster that you should be able to hit after a copy is the system default cluster.  (Provided it was left unmodified in the system the copy was made from).

Former Member
0 Kudos

Gary,

I found the issue...I installed optimizer instead of main esourcing app and that is why I was getting the wrong login page !!!!

Anyways, all is good now and system copy is complete. One issue is witht he old email addresses. As per # 9 in your note above, I updated the email addresses in 5-6 tables but it still shows up for some vendor accounts if I add a contact for that vendor !! Any suggestions on what all tables I should be updating the email addresses in ?

Also, what is the note number that you pasted above

Thanks


BV

Former Member
0 Kudos

Hi Everyone:

We are planning to perform SAP Sourcing CLM 7.0 System Copy which is on SAP Netweaver Composite Environment SPS 11(Java Stack)  running
on Oracle 11g database and operating system is AIX 6.1. It has two databases, one is CLM database and other one is Netweaver Java database.

We are debating on which approach or procedure should we follow…!  Also in SMP, there is no such CLM 7.0 system copy guide to follow

  1. CLM 7.0 System Copy using SAPinst (export/import) with database specific Oracle Backup Restore Method.
  2. CLMP 7.0 System Copy using SAPinst(export/import) with database independent Method ( this does n’t involve DBA)
  3. CLM 7.0 System Copy using Writeback or Refresh Method (according to sap note SAP Note 1594214 ) - This is totally DB Specific Method.

Please advise which is the correct method?

Thanks,

Kumar

former_member89217
Contributor
0 Kudos

In terms of the Sourcing/CLM system, The SAPNote method is what we would suggest. How the NW infrastructure is copied may be served by the sapinst method. In any event, the changes to the sourcing system as outlined in the note would have to occur anyway. 

Answers (0)