8.1.1.2

Description

Prevents from the Cannot insert duplicate key in object 'dbo.SessionState' exception when there are simultaneous requests to the same server with the same session cookie

Compatibility - .NET Framework

The release was built for the following target framework version:

• 4.5 (Sitecore: 7.0, 7.1, 7.2, 7.5, 8.0, 8.1)

Compatibility - Sitecore

The release was tested with the following Sitecore products in bare condition (no hotfixes, patches or other customizations, unless explicitly specified):

• Sitecore CMS 8.1 rev. 151207 (Update-1)

Contents

• bin/Sitecore.Support.96296.98800.dll

Installation

For all Sitecore instances in the solution:

1. Uninstall previous version of the patch (if installed).

2. Make a backup of the files mentioned in Contents section and listed in the installation instruction (if any).

3. Copy the contents of the Website folder from the archive to the Website folder of your Sitecore solution, overwrite existing files if any conflicts occur.

4. In the Web.config file, update the <sessionState> node:

   <sessionState mode="Custom" customProvider="mssql" cookieless="false" timeout="20">
     <providers>
       <add name="mssql"
                 type="Sitecore.Support.SessionProvider.Sql.SqlSessionStateProvider,Sitecore.Support.96296.98800"
                 connectionStringName="sessions.private"  
                 pollingInterval="60"
                 compression="true" 
                 sessionType="private"/>
     </providers>
   </sessionState>

5. In the \App_Config\Include\Sitecore.Analytics.Tracking.config file, update the <sharedSessionState> node:

   <sharedSessionState defaultProvider="mssql">
     <providers>
      <clear/>
        <add name="mssql" 
                  type="Sitecore.Support.SessionProvider.Sql.SqlSessionStateProvider,Sitecore.Support.96296.98800"
                  connectionStringName="sessions.shared" 
                  pollingInterval="60" 
                  compression="true" 
                  sessionType="shared"/>
     </providers>
     ...
   </sharedSessionState>

Important Notes

• The patch should be installed only if recommended by Sitecore Support.
• Any related issues and other feedback should be reported via support portal, check KB 654910 for details.
• Check KB 077333 to find more information about Sitecore Patches.