installation

How to install Sitecore Commerce 9 Update 2 on the machine has an existing XC 9.0.X

Actually, you will not be able to install Sitecore XC 9 Update 2 (aka XC 9.0.2) by using its default settings if there is a Sitecore XC 9 Update 1 (aka XC 9.0.1) instance on your machine. You need to modify the appropriate ones in many places manually before installing it. Another way is to uninstall everything of XC 9.0.1 before installing XC 9.0.2 and making it work properly.

You want to keep the current 9.0.X (X = 0, 1, 2) instance and install another XC 9.0.2 instance(s) as well on your own machine? You’d love to give my way a shot.

Personally, it’s a good chance for me to have a deep dive into the operation by learning and modifying some configurations and modules of the installation package in order to make it fit with my needs.

Assumptions

  • having XC 9.0.2 instance along with other XC 9.0.X instances are available on the same machine
  • all XC 9.0.2 stuff should have unique identifier rather than default one by:
    • adding the instance suffix to all site name / all application pool (all physical path as well) + all indexing name + all database name
    • adding service port suffix to all service port
  • assuming that instance suffix is Sc902 and service port suffix is 2, you will see something like these ones after installing it successfully
    • This slideshow requires JavaScript.

 

Setup Prerequisites

Step-by-step guide

  1. install the ones below if not yet 😀
  2. rebuild the Link databases for the master and core databases if not yet:
    • on the Sitecore Launchpad, click Control Panel, and in the Database section, click Rebuild Link Databases
    •  select the master and core databases and then click Rebuild
    • sc9com_1
  3. rebuild the search indexes if not yet:
    • on the Sitecore Launchpad, click Control Panel, and in the Indexing section, click Indexing manager
    •  in the Indexing Manager dialog box, click Select all, and then click Rebuild
    • sxc902_7
  4. DO NOT stop the xConnect site sc902com.xconnect.local
    • from the installation guide with love (Page 9)
    • sxc902_6
  5. create a new folder D:\sc902_com_install
  6. create a certificate for the Sitecore Commerce Engine Connect to authenticate with the Sitecore XC Engine:
    • launch PowerShell as an administrator
    • create the certificate by running the following cmdlet:
      • New-SelfSignedCertificate -certstorelocation cert:\localmachine\my -dnsname “storefront902.local”
    • export the certificate to a file by running the following cmdlet:
      • Export-Certificate -Cert cert:\localMachine\my\<Thumbprint-of-cert> -FilePath D:\sc902_com_install\storefront902.local.cer
    • for example:
    • sc9com_3
  7. download MSBuild Microsoft Visual Studio Web targets (available from Nuget) then extract the Web targets package, copy the \tools\VSToolsPath\Web\Microsoft.Web.XmlTransform.dll file into D:\sc902_com_install
  8. download Sitecore Experience Accelerator 1.7.1 (Note: must log into https://dev.sitecore.net/ before downloading) and put it into D:\sc902_com_install
  9. download Sitecore Powershell Extensions 4.7.2 then put it into D:\sc902_com_install
  10. download and unzip Packages for On Premises 2018.07-2.2.126 (Note: must log into https://dev.sitecore.net/ before downloading)
  11. unzip D:\sc902_com_install\SIF.Sitecore.Commerce.1.2.14.zip and then rename D:\sc902_com_install\SIF.Sitecore.Commerce.1.2.14 to D:\sc902_com_install\SIF for a better practice
  12. unzip the D:\sc902_com_install\Sitecore.BizFX.1.2.19.zip
  13. unzip the D:\sc902_com_install\Sitecore.Commerce.Engine.SDK.2.2.72.zip file then copy the D:\sc902_com_install\Sitecore.Commerce.Engine.SDK.2.2.72\Sitecore.Commerce.Engine.DB.dacpac file into D:\sc902_com_install
  14. download sc902_com_install.ps1 and then put it into D:\sc902_com_install\SIF then open it to correct 11 parameters below:
    1. $InstanceSuffix
    2. $ServicePortSuffix
    3. $SitePrefix
    4. $ScInstallDirectory
    5. $SiteHostHeaderName
    6. $SqlServer
    7. $SqlDbPrefix
    8. $CommerceEngineCertificatePath
    9. $SolrUrl
    10. $SolrRoot
    11. $SolrService
  15. copy / paste Master_SingleServer.json to the one in D:\sc902_com_install\SIF\Configuration\Commerce so that we have a chance to inject our Service Port Suffix to every single configuration + inject SitecoreBizFxName as well (Note: the name SitecoreBizFx is hardcoded by default)
    • xc902a_11
  16. copy / paste SitecoreBizFx.json to the one in D:\sc902_com_install\SIF\Configuration\Commerce\SitecoreBizFx so that we have a chance to use our Service Port Suffix and make SitecoreBizFx‘s name configurable
    • xc902a_12.png
  17. copy / paste SitecoreIdentityServer.json to the one in D:\sc902_com_install\SIF\Configuration\Commerce\SitecoreIdentityServer so that we have a chance to use our Service Port Suffix
    • xc902a_13.png
  18. copy / paste CommerceEngine.Deploy.json to the one in D:\sc902_com_install\SIF\Configuration\Commerce\CommerceEngine so that we have a chance to use our Service Port Suffix + add Site Host Header Name to deploy tasks so we are able to correct some misconfigurations by default while deploying the commerce content
    • xc902a_14.png
  19. copy / paste DeployCommerceContent.psm1 to the one in D:\sc902_com_install\SIF\Modules\DeployCommerceContent so that we append our Service Port Suffix to appropriate places and correct some misconfigurations of the default one as well
    • xc902a_15.png
  20. (optional): you can specify any local account (note: it will be created automatically if non-existent) to be set up for the various application pools that are created as part of the deployment in sc902_com_install.ps1
    • for example:
    • sxc902_1
  21. (optional): if you play with SQL Server 2017, you will have to download DeployCommerceDatabase.psm1 then overwrite D:\sc902_com_install\SIF\Modules\DeployCommerceDatabase\DeployCommerceDatabase.psm1
  22. (optional): you may get timeout exceptions (some tasks’ execution timeout is only 12 minutes by default and the remote query timeout of SQL Server is only 10 minutes by default) so I suggest:
    • download SitecoreUtilityTasks.psm1 then overwrite D:\sc902_com_install\SIF\Modules\SitecoreUtilityTasks\SitecoreUtilityTasks.psm1in order to increase the execution timeout
    • download PerformanceTweak.config then put it into  \sc902com.local\App_Config\Environment in order to turn all Sitecore jobs off and disable xDB for a better installation (you know, it’s a super long operation :D)
    • configure the remote query timeout option of SQL Server:
      1. using SQL Server Management Studio
      2. in Object Explorer, right-click a server and select Properties
      3. under Remote server connections, in the Remote query timeout box, type or select a value from 0 through 2,147,483,647 to set the maximum number seconds for SQL Server to wait before timing out
    • consider to put $global:ProgressPreference = ‘silentlyContinue’ into the sc902_com_install.ps1 in order to speed up the operation
  23. launch PowerShell as an administrator
    • xc902a_21
    • hopefully there is nothing can stop the installation process now
    • sxc902_10.png
  24. open a browser then navigate to storefront902.local/, you would see the default page of Sitecore webiste. That’s because we don’t use the default host name sxa.storefront.com so we need to correct it inside Sitecore
    • log into sc902com.local/sitecore/
    • access /sitecore/content/Sitecore/Storefront/Settings/Site Grouping/Storefront
    • update Host Name to storefront902.local and then publish it
    • access /sitecore/content/Sitecore/Storefront/Presentation/Page Designs
    • update Theme field to Storefont Branded and then publish it
    • refresh storefront902.local/, you would see something like this
    • sxc902_9.png
  25. DO NOT forget to perform Post-Installation Steps

 

How to uninstall it?

  • download sc902_com_uninstall.ps1 and put it into D:\sc902_com_install then open it to correct 07 parameters below:
    1. $InstanceSuffix
    2. $Prefix
    3. $SolrService
    4. $PathToSolr
    5. $SqlServer
    6. $SqlAccount
    7. $SqlPassword
  • launch PowerShell as an administrator
    • sc9com_15.png
  • hopefully, it runs well and cleans everything up

 

Note: some known issues

  1. Business Tools link is still the default one instead of the new one in Sitecore Launchpad
    • xc902a_19
    • it’s in Sitecore.Commerce.Engine.Connect.2.2.86.update file and I’ve not figured out the way to append Service Port Suffix yet 😀
    • xc902a_18.png
    • in the meantime, I have to correct it manually
    • switch to core database
    • access /sitecore/client/Applications/Launchpad/PageSettings/Buttons/Commerce/BusinessTools
    • correct Link field and then save it
    • xc902a_20.png
  2. The service cannot accept control messages at this time
    • sc9com_16.png
    • access IIS, start sc902com.local site and sc902com.local application pool manually (note: you may need to do it several times) if they’re in STOP status, somehow IIS cannot restart those ones after stopping them
  3. The wait operation timed out: [SqlException (0x80131904): Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and
    respond; Or it could have timed out while attempting to create multiple active connections.

    • sc9com_17.png
    • open D:\sc902_com_install\SIF\Configuration\Commerce\Master_SingleServer.json to remove the tasks completed
    • for instance, I would remove all the completed tasks before InstallSXAFrameworkModule then re-do Step 24 again
    • sc9com_18.png
  4. Request timed out:  Exception Details: System.Web.HttpException: Request timed out.
    • sc9com_19.png
    • my suggestions:
      1. open D:\sc902_com_install\SIF\Configuration\Commerce\Master_SingleServer.json to remove the tasks completed
        • for instance, I would remove all the completed tasks before PublishExtensions then re-do Step 23 again
      2. consider to perform Step 22 as well if solution #1 does not work as expected then re-do Step 23 again
  5. Something went wrong restarting SQL server again: Cannot validate argument on parameter ‘InputObject’. The argument is null or empty. Provide an argument that is not null or empty, and then try the command again.
    • sc9com_22
    • somehow SQL Server window service cannot restart after stopping, ensure SQL Server window service is running

 

Got issues?

Please send your issues (with screenshots if possible) to viet.hoang.sitecore@gmail.com so that I have a chance to understand your problem and be able to suggest the solution.

Happy Sitecore Installation!

 

 

5 thoughts on “How to install Sitecore Commerce 9 Update 2 on the machine has an existing XC 9.0.X

    1. Hi Bhavesh,

      As I know so far, it’s a known issue of SXA 1.7.1 (both “sitecore_sxa_master_index” and “sitecore_sxa_web_index” are NOT created automatically via the installation process). You should create them manually.

      Don’t forget to reconfigure SXA indexing in case you want to use the new ones rather than the default ones https://doc.sitecore.net/sitecore_experience_accelerator/setting_up_and_configuring/configuring/configure_sxa_indexing

      Like

  1. I am getting an error
    Install-SitecoreConfiguration : A parameter cannot be found that matches parameter name ‘ServicePortSuffix’. This error might have
    setting $PSDefaultParameterValues[“Disabled”] to be $true, and then trying again. The following default parameters were successfull
    At C:\Program Files\WindowsPowerShell\Modules\SitecoreInstallFramework\1.1.0\Public\Install-SitecoreConfiguration.ps1:253 char:21
    Any idea?

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.