We are having problem with a customer project, where I see some strange behavior on my local installation.
So we tried to install a standard DynamicWeb 10 version following the guide at Installation | Dynamicweb 10 Developer Documentation
Seing simmilary problems on this "out-of-the-box" project I provide you the details on what I have been doing to get here:
I go through the setup, asking it to create files.
In setup database I create a new DB, the provides details for "Configure administrator".
In setup database I create a new DB, the provides details for "Configure administrator".
I get to this point:
Going on I install the trial license:
So thinking all is good. But no.
Going to Settings->Repositories. Pressing the + and provides a name I am redirected to the "Monitoring Dashboard".
I see this in Dynamicweb.Host.Suite\wwwroot\Files\System\Log\AddInManager:
TypeLoadErrors looking like:
[2025-12-10 11:02:27.685] C:\dev\DynamicWeb\DW10_Projects\Dynamicweb.Host.Suite\bin\Debug\net8.0\runtimes\win\lib\net6.0\Microsoft.Data.SqlClient.dll System.Reflection.ReflectionTypeLoadException Unable to load one or more of the requested types.Could not load type 'SqlGuidCaster' from assembly 'Microsoft.Data.SqlClient, Version=5.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5' because it contains an object field at offset 0 that is incorrectly aligned or overlapped by a non-object field.
[2025-12-10 11:02:27.698] C:\dev\DynamicWeb\DW10_Projects\Dynamicweb.Host.Suite\bin\Debug\net8.0\runtimes\win\lib\netcoreapp2.1\System.Data.SqlClient.dll System.Reflection.ReflectionTypeLoadException Unable to load one or more of the requested types.Could not load type 'SqlGuidCaster' from assembly 'System.Data.SqlClient, Version=4.6.1.6, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' because it contains an object field at offset 0 that is incorrectly aligned or overlapped by a non-object field.
[2025-12-10 11:02:27.698] C:\dev\DynamicWeb\DW10_Projects\Dynamicweb.Host.Suite\bin\Debug\net8.0\runtimes\win\lib\netcoreapp2.1\System.Data.SqlClient.dll System.Reflection.ReflectionTypeLoadException Unable to load one or more of the requested types.Could not load type 'SqlGuidCaster' from assembly 'System.Data.SqlClient, Version=4.6.1.6, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' because it contains an object field at offset 0 that is incorrectly aligned or overlapped by a non-object field.
Going to Settings->Repositories does not show my new repository - it fails creating it.
On Insights->EventViewer->Errors this is shown:
2025-12-10 11:18:24.8123: Update failed: 2361309f-5bad-49ae-b3a9-6704ae94801b Dynamicweb.Ecommerce.Updates.EcommerceUpdateProvider. System.Data.SqlClient.SqlException (0x80131904): 'PK_EcomPrices' is not a constraint. Could not drop constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Dynamicweb.Data.Database.ExecuteNonQuery(IDbCommand command) at Dynamicweb.Data.Database.ExecuteNonQuery(String sql, IDbConnection connection, IDbTransaction transaction, Boolean useTransaction, Int32 commandTimeout, Dictionary`2 sqlParams) at Dynamicweb.Data.Database.ExecuteNonQuery(String sql, Int32 commandTimeout, Boolean useTransaction, IDbConnection connection, IDbTransaction transaction, Dictionary`2 sqlParams) at Dynamicweb.Updates.SqlUpdate.Execute(UpdateContext context) at Dynamicweb.Updates.UpdateManager.ExecuteUpdates() ClientConnectionId:ab7d51d9-3fc7-44ac-bb2a-54ca1a066128 Error Number:3728,State:1,Class:16 2025-12-10 11:18:24.8193: Request headers: [ "Accept", "Host", "User-Agent", "Accept-Encoding", "Accept-Language", "Authorization", "Cache-Control", "Cookie", "Referer", "Upgrade-Insecure-Requests", "sec-fetch-site", "sec-fetch-mode", "sec-fetch-user", "sec-fetch-dest", "sec-ch-ua", "sec-ch-ua-mobile", "sec-ch-ua-platform", "priority" ] 2025-12-10 11:18:24.8200: Request item keys: [ "DW_Current_ExecutionTable" ] 2025-12-10 11:18:24.8202: Request form: []
