Hotfix rollup package for Sitecore Experience Commerce 9.3.0

• Run the SQL script 439942-stored-procedure-update.sql to update the engine Global and Shared databases.

Update and recompile the Commerce Engine

1. In the Sitecore.Commerce.Engine.SDK, open the Customer.Sample.Solution.
2. Open the Sitecore.Commerce.Engine project, and replace all references to Commerce plugin NuGet packages with the ones provided in the rollup package. A complete list of updated NuGet plugin packages is available at the end of this document.
3. Repeat the steps above for all custom plugins that have dependencies on Commerce NuGet packages.
4. Update the Startup.cs file. If you have not made any changes to your Startup.cs file, replace it with the file included in the rollup package.
   If you have customized your Startup.cs file, merge the changes to ensure that your customized Startup.cs file includes the latest updates.
   The following are some examples of changes contained in the Startup.cs:
   • New using statements.
   • Changes in the ConfigureServices(IServiceCollection services) method (around line 238), where Sitecore().Caching is configured.
   • New private method to the class private static void AddTransientFaultHandling(IServiceCollection services).
   • New call to the method in the ConfigureServices(IServiceCollection services) method.
5. Update the Global.json file by merging the changes from the sample Global.json files (OnPrem and Cloud versions) included in this package.
   • The new Sitecore.Commerce.Plugin.Content.DefaultContentPathsPolicy and EntityShardingPolicy were added to the Global.json file of Commerce Engine services bootstrap folder.
6. Update the PlugIn.Search.PolicySet-1.0.0.json file to add the following new SearchPolicy:

   {
   "$type": "Sitecore.Commerce.Plugin.Search.SearchPolicy, Sitecore.Commerce.Plugin.Search",
   "MaxNumberOfRows": 1000000,
   "IndexBatchSize": 1000,
   "DeleteBatchSize": 50,
   "ConcurrentIndexingOperations": 1
   }

7. Update the config.json file by merging the latest config.json with your customized config.json file. The Caching.Redis section contains the following new properties:

   IntervalBetweenConnectionAttemptsInSeconds": 60,
   "RedisConnectionPoolSize": 1,
   "RedisCompressionEnabled": true,

   Note: In systems under heavy load, the optimal value for RedisConnectionPoolSize = number of cores / 2.
   For example, for a 16-core machine, this would be set to: "RedisConnectionPoolSize": 8)
8. Rebuild and republish the solution.
9. In the build output, make sure the StackExchange.Redis.dll binary is downloaded with version 2.1.58.
10. In IIS Manager, restart the Commerce Engine services.
11. Bootstrap the environment.
12. Flush the Redis cache.
13. Synchronize content. In Postman, open the SitecoreCommerce_DevOps|3 Environment Initialize folder and run the Ensure\Sync default content paths with the following command arguments:
    • Replace {{ShopName}} with the name of your shop (for example, "Storefront" or "CommerceEngineDefaultStorefront")
    • Replace {{Environment}} with "GlobalEnvironment"
    Note: This command can only be executed once for each environment. If you need to re-synchronize content, run the "Sync content path" request to synchronize all content items.
    After completing the  steps above, the Commerce Control Panel items should be synchronized into [ContentEntities] and [ContentEntity] tables of both SitecoreCommerce9_Global and SitecoreCommerce9_SharedEnvironments databases.
14. Flush the Redis cache.
15. In IIS Manager, restart the Commerce Engine services.

1. In the hotfix rollup package, in the Binaries\Sitecore_CDCM\bin folder, copy the following binaries (.DLLs) to your CD and CM bin folder:
   • Sitecore.Commerce.Engine.Connect.dll
   • Sitecore.Commerce.ExperienceProfile.dll
   • Sitecore.Commerce.Connect.Core.dll
   • Sitecore.Commerce.XA.*.dll
   • Sitecore.framework.*.dll
   • Sitecore.Commerce.Engine.Connect.Caching.dll
2. The config_source_files/Sitecore/App_Config/Include/Y.Commerce.Engine folder contains a new version of the following files:
   • Sitecore.Commerce.Engine.Connectors.Inventory.config
   • Sitecore.Commerce.Engine.Connect.config
   The Sitecore.Commerce.Engine.Connect.config file contains the following changes:
   • Three new properties are added to the \configuration\sitecore\commerceCachingConfiguration\cachingSettings\redissection:
     • <intervalBetweenConnectionAttemptsInSeconds>60</intervalBetweenConnectionAttemptsInSeconds>
     • <redisConnectionPoolSize>1</redisConnectionPoolSize>
     • <redisCompressionEnabled>true</redisCompressionEnabled>
     Note: In systems under heavy load, the optimal value for RedisConnectionPoolSize= number of cores / 2. (For example, for a 16-core machine, "RedisConnectionPoolSize": 8)
   • A new property is added to the section:
     • <fullCacheRefreshThreshold>20</fullCacheRefreshThreshold> 
     Note: Change the default value to an appropriate value for your deployment.
   If you have not customized the files in your deployment, replace them with the new ones provided. Otherwise, compare your custom version of the file with the new version provided and merge the changes.
3. The config_source_files/Sitecore/App_Config/Include/Foundation/Commerce/ folder contains a new version of the Sitecore.Commerce.XA.Foundation.Connect.config file. If you have not customized this in your deployment, replace it with the new one provided. Otherwise, compare your custom version of the file with the new version provided and merge the changes.