Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Gary 80 posts 377 karma points
    Sep 12, 2018 @ 15:32
    Gary
    0

    Manual Upgrade of Websites

    We currently have a handful of websites on 7.1.4, 7.4.3 and 7.5.2.

    I am putting a plan together to get all these sites on the same version and with a roadmap of upgrades etc. However, i have just attempted to upgrade one of our 7.1.4 sites to 7.12.0 and have come across the error below. I followed the steps that our provides.

    Stack Trace:

       Attempt by security transparent method 'Microsoft.Web.Helpers.PreApplicationStartCode.Start()' to access security critical method 'System.Web.WebPages.Razor.WebPageRazorHost.AddGlobalImport(System.String)' failed. 
    
    [
    
        MethodAccessException: Attempt by security transparent method 'Microsoft.Web.Helpers.PreApplicationStartCode.Start()' to access security critical method 'System.Web.WebPages.Razor.WebPageRazorHost.AddGlobalImport(System.String)' failed.]
           Microsoft.Web.Helpers.PreApplicationStartCode.Start() +50
    
        [InvalidOperationException: The pre-application start initialization method Start on type Microsoft.Web.Helpers.PreApplicationStartCode threw an exception with the following error message: Attempt by security transparent method 'Microsoft.Web.Helpers.PreApplicationStartCode.Start()' to access security critical method 'System.Web.WebPages.Razor.WebPageRazorHost.AddGlobalImport(System.String)' failed..]
           System.Web.Compilation.BuildManager.InvokePreStartInitMethodsCore(ICollection`1 methods, Func`1 setHostingEnvironmentCultures) +850
           System.Web.Compilation.BuildManager.InvokePreStartInitMethods(ICollection`1 methods) +162
           System.Web.Compilation.BuildManager.CallPreStartInitMethods(String preStartInitListPath, Boolean& isRefAssemblyLoaded) +128
           System.Web.Compilation.BuildManager.ExecutePreAppStart() +170
           System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters, PolicyLevel policyLevel, Exception appDomainCreationException) +695
    
        [HttpException (0x80004005): The pre-application start initialization method Start on type Microsoft.Web.Helpers.PreApplicationStartCode threw an exception with the following error message: Attempt by security transparent method 'Microsoft.Web.Helpers.PreApplicationStartCode.Start()' to access security critical method 'System.Web.WebPages.Razor.WebPageRazorHost.AddGlobalImport(System.String)' failed..]
           System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +523
           System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +118
           System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +704
    

    Can anyone shed any light on why this would be happening? I checked permissions for the site in IIS and all seems fine.

    Thank you.

  • Marc Goodson 2155 posts 14406 karma points MVP 9x c-trib
    Sep 15, 2018 @ 11:21
    Marc Goodson
    1

    Hi Gary

    Have you cleaned your bin folder, during the upgrade?

    I have a feeling that Microsoft.Web.Helpers.dll is not used in the latest versions of Umbraco, but was present in the earlier version you are upgrading from.

    If you've applied the Umbraco upgrade dlls over the top of the existing bin folder, it will update the Umbraco dlls, but not necessarily remove Microsoft.Web.Helpers.dll

    So try deleting this dll, and recycle, see if you receive the same issue.

    regards

    marc

  • Gary 80 posts 377 karma points
    Sep 17, 2018 @ 15:44
    Gary
    0

    Hi Marc,

    Thank you for the tip. That seems to have fixed it. However, it is now saying failed login for my user (which i know is definitely right). I have ensured the useLegacyEncoding hasn't changed but after checking the logs, it seems it cannot find some SQL tables?

    Invalid object name 'umbracoUser2UserGroup'.
    

    It maybe that the upgrade is halted at this? Any ideas?

    Kind Regards,

    Gary Henshall

  • Marc Goodson 2155 posts 14406 karma points MVP 9x c-trib
    Sep 17, 2018 @ 19:34
    Marc Goodson
    0

    Hi Gary

    Yes, the table you mention is one of the new tables added for User Group management in Umbraco 7.7 and above.

    You'd expect a migration to update this in your Umbraco database.

    So maybe something hasn't quite completed.

    With the issue you had with dlls remaining in the bin folder, it might be worth taking a new backup and firing up the upgrade again.

    Essentially you should be prompted to login to authorize the upgrade which should trigger the database schema upgrade.

    so is useLegacyEncoding set to true?

    regards

    Marc

  • Gary 80 posts 377 karma points
    Sep 18, 2018 @ 12:44
    Gary
    0

    Hi Marc,

    I have removed the current backup and created a fresh copy with a fresh backup of the database.

    Having done all the steps above and gone straight to the login page to authorize the upgrade, when i login it says login failed. Then i check the logs and it still references the "UmbracoUser2UserGroup" table.

    I have useLegacyEncoding set to true as that is how it was before upgrading and specifies to NOT change this in 7.6.0 version specific. I feel that i may have to do incremental upgrades but i was just hoping there was a way round this.

    Cheers for the help.

    Gary

  • Marc Goodson 2155 posts 14406 karma points MVP 9x c-trib
    Sep 18, 2018 @ 19:16
    Marc Goodson
    0

    Hi Gary

    discovered this thread:

    https://our.umbraco.com/forum/using-umbraco-and-getting-started/89324-ugrading-to-776-invalid-object-name-umbracouser2usergroup

    wonder if it's worth going to 7.7.13 first as Markus suggests, it's basically the migration that adds the database tables for the new User Group functionality you are trying to get triggered!

    See this issue: https://issues.umbraco.org/issue/U4-10138

    regards

    Marc

  • Gary 80 posts 377 karma points
    Sep 19, 2018 @ 12:40
    Gary
    0

    Hi Marc,

    I have tried another fresh copy install to 7.7.13 from 7.1.4, still having issues relating to the missing tables. I have also tried to perform all the specific version upgrade steps but still no look. Below is the full error log from where the database errors begin, maybe this will shed some light?

     2018-09-19 13:05:45,800 [P17720/D8/T89] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (cae4837a).
    System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoUser2UserGroup'.
       at System.Data.SqlClient.SqlConnection.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.SqlDataReader.TryConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass5_0.<ExecuteReaderWithRetry>b__0()
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
       at Umbraco.Core.Persistence.Database.<Query>d__115`1.MoveNext()
    ClientConnectionId:9c4f7c9e-37ca-4d5c-b85c-958da3703254
    Error Number:208,State:1,Class:16
     2018-09-19 13:05:45,987 [P17720/D8/T89] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (eb24ca27).
    System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoUser2UserGroup'.
       at System.Data.SqlClient.SqlConnection.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.SqlDataReader.TryConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass5_0.<ExecuteReaderWithRetry>b__0()
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
       at Umbraco.Core.Persistence.Database.<Query>d__115`1.MoveNext()
    ClientConnectionId:9c4f7c9e-37ca-4d5c-b85c-958da3703254
    Error Number:208,State:1,Class:16
     2018-09-19 13:05:46,003 [P17720/D8/T89] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (2fcdddee).
    System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoUser2UserGroup'.
       at System.Data.SqlClient.SqlConnection.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.SqlDataReader.TryConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass5_0.<ExecuteReaderWithRetry>b__0()
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
       at Umbraco.Core.Persistence.Database.<Query>d__115`1.MoveNext()
    ClientConnectionId:9c4f7c9e-37ca-4d5c-b85c-958da3703254
    Error Number:208,State:1,Class:16
     2018-09-19 13:05:46,050 [P17720/D8/T89] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (ebf51274).
    System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'securityStampToken'.
    Invalid column name 'failedLoginAttempts'.
    Invalid column name 'createDate'.
    Invalid column name 'updateDate'.
       at System.Data.SqlClient.SqlConnection.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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass2_0.<ExecuteNonQueryWithRetry>b__0()
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
       at Umbraco.Core.Persistence.Database.Update(String tableName, String primaryKeyName, Object poco, Object primaryKeyValue, IEnumerable`1 columns)
    ClientConnectionId:9c4f7c9e-37ca-4d5c-b85c-958da3703254
    Error Number:207,State:1,Class:16
     2018-09-19 13:05:46,050 [P17720/D8/T89] WARN  Umbraco.Core.Services.UserService - An error occurred attempting to save a user instance during upgrade, normally this warning can be ignored. Exception: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'securityStampToken'.
    Invalid column name 'failedLoginAttempts'.
    Invalid column name 'createDate'.
    Invalid column name 'updateDate'.
       at System.Data.SqlClient.SqlConnection.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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass2_0.<ExecuteNonQueryWithRetry>b__0()
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
       at Umbraco.Core.Persistence.Database.Update(String tableName, String primaryKeyName, Object poco, Object primaryKeyValue, IEnumerable`1 columns)
       at Umbraco.Core.Persistence.Database.Update(Object poco, Object primaryKeyValue, IEnumerable`1 columns)
       at Umbraco.Core.Persistence.Repositories.UserRepository.PersistUpdatedItem(IUser entity)
       at Umbraco.Core.Cache.DefaultRepositoryCachePolicy`2.Update(TEntity entity, Action`1 persistUpdated)
       at Umbraco.Core.Persistence.UnitOfWork.ScopeUnitOfWork.Commit(Action`1 transactionCompleting)
       at Umbraco.Core.Services.UserService.Save(IUser entity, Boolean raiseEvents)
    ClientConnectionId:9c4f7c9e-37ca-4d5c-b85c-958da3703254
    Error Number:207,State:1,Class:16
     2018-09-19 13:05:46,050 [P17720/D8/T89] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (43419d36).
    System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoUser2UserGroup'.
       at System.Data.SqlClient.SqlConnection.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.SqlDataReader.TryConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass5_0.<ExecuteReaderWithRetry>b__0()
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
       at Umbraco.Core.Persistence.Database.<Query>d__115`1.MoveNext()
    ClientConnectionId:9c4f7c9e-37ca-4d5c-b85c-958da3703254
    Error Number:208,State:1,Class:16
     2018-09-19 13:05:46,081 [P17720/D8/T89] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (dd0f35c0).
    System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoUser2UserGroup'.
       at System.Data.SqlClient.SqlConnection.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.SqlDataReader.TryConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass5_0.<ExecuteReaderWithRetry>b__0()
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
       at Umbraco.Core.Persistence.Database.<Query>d__115`1.MoveNext()
    ClientConnectionId:9c4f7c9e-37ca-4d5c-b85c-958da3703254
    Error Number:208,State:1,Class:16
     2018-09-19 13:05:46,096 [P17720/D8/T89] INFO  Umbraco.Core.Security.BackOfficeSignInManager - Event Id: 0, state: Login attempt failed for username gary henshall from IP address ::1
    

    EDIT: Just done incremental upgrades to see the issue. I managed to go from 7.1.4 -> 7.4.3 -> 7.5.14 -> 7.6.1 -> 7.6.13 -> 7.7.0. All worked apart from upgrading to 7.7.0 gave me the issue again (luckily i kept a backup of the 7.6.13 step). It doesn't like something..

    Cheers again.

    Kind Regards,

    Gary

  • Gary 80 posts 377 karma points
    Sep 19, 2018 @ 13:45
    Gary
    100

    Hi Marc,

    I have found the problem. When merging the configuration files, even making sure that the legacy encoding was correct, it seems to remove some configurations for the user Membership Provider.

    The merge overwrites it with the below config:

    <add name="UsersMembershipProvider" type="Umbraco.Web.Security.Providers.UsersMembershipProvider, Umbraco" />
    

    but if i replace it back to how it was, it allows me to login and the upgrade completes:

    <add name="UsersMembershipProvider" type="Umbraco.Web.Security.Providers.UsersMembershipProvider, Umbraco" minRequiredNonalphanumericCharacters="0" minRequiredPasswordLength="10" useLegacyEncoding="true" enablePasswordRetrieval="false" enablePasswordReset="false" requiresQuestionAndAnswer="false" passwordFormat="Hashed" allowManuallyChangingPassword="false" />
    

    So now i have managed to upgrade the site to 7.12.0. Thank you very much for the help. I am not sure if this is an umbraco issue or if i have missed a certain step somewhere..

    Kind Regards,

    Gary Henshall

  • Marc Goodson 2155 posts 14406 karma points MVP 9x c-trib
    Sep 19, 2018 @ 17:24
    Marc Goodson
    1

    Hi Gary

    Awesome!

    So once you could login the migration that adds those tables could occur, hence the original thought it was useLegacyEncoding related...

    ... but great you now have it resolved!

    ... and all that point release practice!

    regards

    Marc

  • DonZalmrol 220 posts 833 karma points
    Sep 15, 2018 @ 12:49
    DonZalmrol
    0

    You can test what Marc said easily by commenting the Microsoft.Web.Helpers.dll in your config.web file and restarting your site.

    If the site then loads in fine you can go ahead and delete the DLL file from your bin folder.

    Had this happen to me in the past as well with a different plugin.

    Edit: Unless the DLL isn't called from the config.web file move it out of your bin folder and try again.

Please Sign in or register to post replies

Write your reply to:

Draft