Scenario: Upgrading HyWorks Session host server from v3208928 (v3.2-SP2) to v3.3.0.11119


Issue: Upgrade fails with following error

---------------------------
Accops HyWorks Session Host - Error!
---------------------------
Setup Failed!
Error while configuring Database.
The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log or use the command-line sxstrace.exe tool for more detail. (Exception from HRESULT: 0x800736B1)
Unhandled Exception: System.Data.SqlServerCe.SqlCeException: Native components of SQL Server Compact engine are not loaded. Please reinstall Microsoft SQL Server Compact.
   at System.Data.SqlServerCe.NativeMethods.ThrowIfNativeLibraryNotLoaded()
   at System.Data.SqlServerCe.SqlCeEngine.Dispose(Boolean disposing)
   at System.Data.SqlServerCe.SqlCeEngine.Finalize()

ERROR! The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log or use the command-line sxstrace.exe tool for more detail. (Exception from HRESULT: 0x800736B1)
---------------------------
OK  
---------------------------


Workaround:

Download and install Microsoft® SQL Server® Compact 4.0 SP1 on server with problem. Initiate the upgrade again.

Download Link to download Microsoft® SQL Server® Compact 4.0 SP1 :  https://www.microsoft.com/en-in/download/details.aspx?id=30709