Migrate > Take the first steps after WebSphere Commerce migration

Host name change for e-mail template

If you have defined e-mail templates in WebSphere Commerce Version 5.6.1 or v6 and if you have changed the host name during the migration, manually modify the EMLMSG.JSPPATH column in the migrated database to reflect the newly defined host name.

Assume that the previous host name is oldhostname.mycompany.com, and the new host name is newhostname.mycompany.com.

To reflect the new host name, modify the EMLMSG.JSPPATH column from:

http://oldhostname.mycompany.com/webapp/wcs/stores/servlet/
  EmailTemplateFFSpecialsDisplayView

to:

http://newhostname.mycompany.com/webapp/wcs/stores/servlet/
  EmailTemplateFFSpecialsDisplayView

The following example SQL makes this update:

update EMLMSG 
  set JSPPATH = 'http://newhostname.mycompany.com/webapp/wcs/stores
                 /servlet/EmailTemplateFFSpecialsDisplayView'
 where JSPPATH = 'http://oldhostname.mycompany.com/webapp/wcs/stores
                 /servlet/EmailTemplateFFSpecialsDisplayView' 

+

Search Tips   |   Advanced Search