Copied to clipboard

Flag this post as spam?

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


  • Aleksander 43 posts 203 karma points
    Mar 23, 2018 @ 14:45
    Aleksander
    0

    Error when upgrading database to anything higher than 7.5 [Solved]

    Hi.

    I'm having major issues upgrading an umbraco solution from version 7.2.2.

    When i'm running the database step i'm getting the following error:

    The database failed to upgrade. ERROR: The database configuration failed with the following message: Cannot insert duplicate key row in object 'dbo.umbracoNode' with unique index 'IX_umbracoNode_uniqueID'. The duplicate key value is (dfab0389-5001-3e87-8d80-ce45b313e25b).
     The statement has been terminated. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
    

    The thing is i cannot even find a property in my database with that UniqueID... Anything encountered something similar ?

  • Aleksander 43 posts 203 karma points
    Mar 26, 2018 @ 08:11
    Aleksander
    0

    this is the final part of the tracelog:

    2018-03-26 09:54:00,993 [P25652/D9/T22] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 405: CREATE UNIQUE NONCLUSTERED INDEX [IX_cmsMacroProperty_UniquePropertyId] ON [cmsMacroProperty] ([uniquePropertyId])
    
     2018-03-26 09:54:01,010 [P25652/D9/T22] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (b098a7f9).
    System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.umbracoNode' with unique index 'IX_umbracoNode_uniqueID'. The duplicate key value is (dfab0389-5001-3e87-8d80-ce45b313e25b).
    The statement has been terminated.
       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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
       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 StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 266
       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.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy)
       at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy retryPolicy)
       at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command)
       at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args)
    ClientConnectionId:ace7ef62-fe22-46be-8820-3af294256b94
    Error Number:2601,State:1,Class:14
     2018-03-26 09:54:01,035 [P25652/D9/T22] ERROR Umbraco.Core.DatabaseContext - Database configuration failed
    System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.umbracoNode' with unique index 'IX_umbracoNode_uniqueID'. The duplicate key value is (dfab0389-5001-3e87-8d80-ce45b313e25b).
    The statement has been terminated.
       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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
       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 StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 266
       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.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy)
       at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy retryPolicy)
       at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command)
       at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args)
       at Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenSixZero.NormalizeTemplateGuids.UpdateTemplateGuids(Database database)
       at Umbraco.Core.Persistence.Migrations.Syntax.Execute.Expressions.ExecuteCodeStatementExpression.Process(Database database)
       at Umbraco.Core.Persistence.Migrations.MigrationRunner.ExecuteMigrations(IMigrationContext context, Database database)
       at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade)
       at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, Boolean isUpgrade)
       at Umbraco.Core.DatabaseContext.UpgradeSchemaAndData(IMigrationEntryService migrationEntryService)
    ClientConnectionId:ace7ef62-fe22-46be-8820-3af294256b94
    Error Number:2601,State:1,Class:14
     2018-03-26 09:54:01,039 [P25652/D9/T22] INFO  Umbraco.Core.DatabaseContext - The database schema validation produced the following summary: 
    The following tables were found in the database, but are not in the current schema:
    umbracoUser2app,umbracoUser2NodePermission,UFRecords,UFRecordFields,UFRecordDataString,UFRecordDataLongString,UFRecordDataInteger,UFRecordDataBit,UFRecordDataDateTime,UFUserSecurity,UFUserFormSecurity,appstractQuestionPoll,cmsStylesheet,cmsStylesheetProperty,umbracoUserLogins,umbracoUserType,cmsMedia,umbracoAccess,umbracoAccessRule,umbracoCacheInstruction,umbracoExternalLogin,umbracoMigration,umbracoRedirectUrl,umbracoLock,umbracoUserGroup,umbracoUser2UserGroup,umbracoUserGroup2NodePermission,umbracoUserGroup2App,umbracoUserStartNode,umbracoUserLogin,umbracoConsent,umbracoAudit
    
    The following columns were found in the database, but are not in the current schema:
    cmsTemplate,master,umbracoUser2app,user,umbracoUser2app,app,cmsContentVersion,LanguageLocale,umbracoUser2NodePermission,userId,umbracoUser2NodePermission,nodeId,umbracoUser2NodePermission,permission,UFRecords,Id,UFRecords,Form,UFRecords,Created,UFRecords,Updated,UFRecords,CurrentPage,UFRecords,UmbracoPageId,UFRecords,IP,UFRecords,MemberKey,UFRecords,UniqueId,UFRecords,State,UFRecords,RecordData,UFRecordFields,Key,UFRecordFields,FieldId,UFRecordFields,Record,UFRecordFields,Alias,UFRecordFields,DataType,UFRecordDataString,Id,UFRecordDataString,Key,UFRecordDataString,Value,UFRecordDataLongString,Id,UFRecordDataLongString,Key,UFRecordDataLongString,Value,UFRecordDataInteger,Id,UFRecordDataInteger,Key,UFRecordDataInteger,Value,UFRecordDataBit,Id,UFRecordDataBit,Key,UFRecordDataBit,Value,UFRecordDataDateTime,Id,UFRecordDataDateTime,Key,UFRecordDataDateTime,Value,UFUserSecurity,User,UFUserSecurity,ManageDataSources,UFUserSecurity,ManagePreValueSources,UFUserSecurity,ManageWorkflows,UFUserSecurity,ManageForms,UFUserFormSecurity,Id,UFUserFormSecurity,User,UFUserFormSecurity,Form,UFUserFormSecurity,HasAccess,UFUserFormSecurity,AllowInEditor,UFUserFormSecurity,SecurityType,appstractQuestionPoll,question_id,appstractQuestionPoll,answer_text,appstractQuestionPoll,count,cmsPropertyTypeGroup,parentGroupId,cmsPropertyType,helpText,cmsStylesheet,nodeId,cmsStylesheet,filename,cmsStylesheet,content,cmsStylesheetProperty,nodeId,cmsStylesheetProperty,stylesheetPropertyEditor,cmsStylesheetProperty,stylesheetPropertyAlias,cmsStylesheetProperty,stylesheetPropertyValue,umbracoUserLogins,contextID,umbracoUserLogins,userID,umbracoUserLogins,timeout,umbracoUserType,id,umbracoUserType,userTypeAlias,umbracoUserType,userTypeName,umbracoUserType,userTypeDefaultPermissions,umbracoUser,userType,umbracoUser,startStructureID,umbracoUser,startMediaID,cmsMedia,nodeId,cmsMedia,versionId,cmsMedia,mediaPath,cmsMacro,uniqueId,cmsMacroProperty,uniquePropertyId,cmsMemberType,isSensitive,cmsPropertyTypeGroup,uniqueID,cmsPropertyType,UniqueID,cmsPropertyData,dataDecimal,umbracoRelationType,typeUniqueId,umbracoUser,passwordConfig,umbracoUser,securityStampToken,umbracoUser,failedLoginAttempts,umbracoUser,lastLockoutDate,umbracoUser,lastPasswordChangeDate,umbracoUser,lastLoginDate,umbracoUser,emailConfirmedDate,umbracoUser,invitedDate,umbracoUser,createDate,umbracoUser,updateDate,umbracoUser,avatar,umbracoUser,tourData,umbracoServer,isMaster,umbracoAccess,id,umbracoAccess,nodeId,umbracoAccess,loginNodeId,umbracoAccess,noAccessNodeId,umbracoAccess,createDate,umbracoAccess,updateDate,umbracoAccessRule,id,umbracoAccessRule,accessId,umbracoAccessRule,ruleValue,umbracoAccessRule,ruleType,umbracoAccessRule,createDate,umbracoAccessRule,updateDate,umbracoCacheInstruction,id,umbracoCacheInstruction,utcStamp,umbracoCacheInstruction,jsonInstruction,umbracoCacheInstruction,originated,umbracoCacheInstruction,instructionCount,umbracoExternalLogin,id,umbracoExternalLogin,userId,umbracoExternalLogin,loginProvider,umbracoExternalLogin,providerKey,umbracoExternalLogin,createDate,umbracoMigration,id,umbracoMigration,name,umbracoMigration,createDate,umbracoMigration,version,umbracoRedirectUrl,id,umbracoRedirectUrl,contentKey,umbracoRedirectUrl,createDateUtc,umbracoRedirectUrl,url,umbracoRedirectUrl,urlHash,umbracoLock,id,umbracoLock,value,umbracoLock,name,umbracoUserGroup,id,umbracoUserGroup,userGroupAlias,umbracoUserGroup,userGroupName,umbracoUserGroup,userGroupDefaultPermissions,umbracoUserGroup,createDate,umbracoUserGroup,updateDate,umbracoUserGroup,icon,umbracoUserGroup,startContentId,umbracoUserGroup,startMediaId,umbracoUser2UserGroup,userId,umbracoUser2UserGroup,userGroupId,umbracoUserGroup2NodePermission,userGroupId,umbracoUserGroup2NodePermission,nodeId,umbracoUserGroup2NodePermission,permission,umbracoUserGroup2App,userGroupId,umbracoUserGroup2App,app,umbracoUserStartNode,id,umbracoUserStartNode,userId,umbracoUserStartNode,startNode,umbracoUserStartNode,startNodeType,umbracoUserLogin,sessionId,umbracoUserLogin,userId,umbracoUserLogin,loggedInUtc,umbracoUserLogin,lastValidatedUtc,umbracoUserLogin,loggedOutUtc,umbracoUserLogin,ipAddress,umbracoConsent,id,umbracoConsent,current,umbracoConsent,source,umbracoConsent,context,umbracoConsent,action,umbracoConsent,createDate,umbracoConsent,state,umbracoConsent,comment,umbracoAudit,id,umbracoAudit,performingUserId,umbracoAudit,performingDetails,umbracoAudit,performingIp,umbracoAudit,eventDateUtc,umbracoAudit,affectedUserId,umbracoAudit,affectedDetails,umbracoAudit,eventType,umbracoAudit,eventDetails
    
    The following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:
    FK_cmsPropertyTypeGroup_cmsPropertyTypeGroup_id,FK_cmsStylesheet_umbracoNode_id,FK_cmsTemplate_cmsTemplate,FK_UFRecordDataBit_UFRecordFields_Key,FK_UFRecordDataDateTime_UFRecordFields_Key,FK_UFRecordDataInteger_UFRecordFields_Key,FK_UFRecordDataLongString_UFRecordFields_Key,FK_UFRecordDataString_UFRecordFields_Key,FK_umbracoUser_umbracoUserType_id,FK_umbracoUser2app_umbracoUser_id,FK_umbracoUser2NodePermission_umbracoNode_id,FK_umbracoUser2NodePermission_umbracoUser_id,FK_cmsMedia_cmsContent_nodeId,FK_cmsMedia_umbracoNode_id,FK_cmsDictionary_cmsDictionary_id,FK_cmsLanguageText_umbracoLanguage_id,FK_umbracoAccess_umbracoNode_id,FK_umbracoAccess_umbracoNode_id1,FK_umbracoAccess_umbracoNode_id2,FK_umbracoAccessRule_umbracoAccess_id,FK_umbracoRedirectUrl_umbracoNode_uniqueID,FK_startContentId_umbracoNode_id,FK_startMediaId_umbracoNode_id,FK_umbracoUser2UserGroup_umbracoUser_id,FK_umbracoUser2UserGroup_umbracoUserGroup_id,FK_umbracoUserGroup2NodePermission_umbracoUserGroup_id,FK_umbracoUserGroup2NodePermission_umbracoNode_id,FK_umbracoUserGroup2App_umbracoUserGroup_id,FK_umbracoUserStartNode_umbracoUser_id,FK_umbracoUserStartNode_umbracoNode_id,FK_umbracoUserLogin_umbracoUser_id,PK_appstractQuestionPoll,PK_cmsStylesheet,PK_cmsStylesheetProperty,PK_UFRecordDataBit,PK_UFRecordDataDateTime,PK_UFRecordDataInteger,PK_UFRecordDataLongString,PK_UFRecordDataString,PK_UFRecordFields,PK_UFRecords,PK_umbracoUser2NodePermission,PK_umbracoUserType,PK_user2app,PK_cmsMedia,PK_umbracoAccess,PK_umbracoAccessRule,PK_umbracoCacheInstruction,PK_umbracoExternalLogin,PK_umbracoMigration,PK_umbracoRedirectUrl,PK_umbracoLock,PK_umbracoUserGroup,PK_user2userGroup,PK_umbracoUserGroup2NodePermission,PK_userGroup2App,PK_userStartNode,PK_umbracoUserLogin,PK_umbracoConsent,PK_umbracoAudit,IX_umbracoNodeTrashed,IX_umbracoNodeParentId,IX_umbracoNodePath,IX_umbracoNodeUniqueID,IX_umbracoNodeObjectType,IX_cmsContentType,IX_cmsContentType_icon,IX_cmsTemplate_nodeId,IX_cmsContent,IX_cmsContentVersion_ContentId,IX_cmsContentVersion_VersionId,IX_cmsDocument,IX_cmsDocument_published,IX_cmsDocument_newest,IX_cmsMedia,IX_cmsDataType_nodeId,IX_cmsDictionary_id,IX_cmsDictionary_key,IX_umbracoLanguage_languageISOCode,IX_umbracoLog,IX_cmsMacro_UniqueId,IX_cmsMacroPropertyAlias,IX_cmsMacroProperty_UniquePropertyId,IX_cmsMacroProperty_Alias,IX_cmsMember_LoginName,IX_cmsPropertyTypeGroupUniqueID,IX_cmsPropertyTypeAlias,IX_cmsPropertyTypeUniqueID,IX_cmsPropertyData_1,IX_cmsPropertyData_2,IX_cmsPropertyData_3,IX_umbracoRelationType_UniqueId,IX_umbracoRelationType_name,IX_umbracoRelationType_alias,IX_umbracoRelation_parentChildType,IX_cmsTags,IX_umbracoUser_userLogin,IX_cmsTaskType_alias,IX_computerName,IX_umbracoServer_isActive,IX_umbracoAccess_nodeId,IX_umbracoAccessRule,IX_umbracoMigration,IX_umbracoRedirectUrl,IX_umbracoUserGroup_userGroupAlias,IX_umbracoUserGroup_userGroupName,IX_umbracoUser2NodePermission_nodeId,IX_umbracoUserStartNode_startNodeType
    
    The following indexes were found in the database, but are not in the current schema:
    IX_cmsPropertyData,IX_databit_recordfield,IX_datadatetime_recordfield,IX_datainteger_recordfield,IX_datalongstring_recordfield,IX_datastring_recordfield,Id,IX_umbracoUserLogins_Index,IX_umbracoNodePath,IX_cmsMedia,IX_cmsDictionary_key,IX_cmsMacro_UniqueId,IX_cmsMacroProperty_UniquePropertyId,IX_cmsMember_LoginName,IX_cmsPropertyTypeGroupUniqueID,IX_cmsPropertyTypeAlias,IX_cmsPropertyTypeUniqueID,IX_umbracoRelationType_UniqueId,IX_umbracoRelationType_name,IX_umbracoRelationType_alias,IX_umbracoRelation_parentChildType,IX_umbracoAccess_nodeId,IX_umbracoAccessRule,IX_umbracoMigration,IX_umbracoRedirectUrl,IX_umbracoUserGroup_userGroupAlias,IX_umbracoUserGroup_userGroupName,IX_umbracoUser2NodePermission_nodeId,IX_umbracoUserStartNode_startNodeType
    
    The following unknown constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:
    Id
    
    
     2018-03-26 09:54:01,040 [P25652/D9/T22] ERROR Umbraco.Web.Install.Controllers.InstallApiController - Installation step DatabaseUpgrade failed.
    System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Cannot insert duplicate key row in object 'dbo.umbracoNode' with unique index 'IX_umbracoNode_uniqueID'. The duplicate key value is (dfab0389-5001-3e87-8d80-ce45b313e25b).
    The statement has been terminated.
     Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
       at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model)
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
       at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction)
     2018-03-26 09:54:01,041 [P25652/D9/T22] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 1170ms)
     2018-03-26 09:54:01,041 [P25652/D9/T22] ERROR Umbraco.Web.Install.Controllers.InstallApiController - An error occurred during installation step DatabaseUpgrade
    System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Cannot insert duplicate key row in object 'dbo.umbracoNode' with unique index 'IX_umbracoNode_uniqueID'. The duplicate key value is (dfab0389-5001-3e87-8d80-ce45b313e25b).
    The statement has been terminated.
     Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
       at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model)
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
       at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction)
       at Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel)
    
  • Nik 1142 posts 4730 karma points MVP 2x c-trib
    Mar 26, 2018 @ 09:59
    Nik
    0

    Hi Aleksander,

    How are you going about the upgrade? Have you tried making large jumps or have you been going through smaller increments?

    If upgrading from 7.2.2, I would advise upgrading in fairly small increments and making sure you read the version specific upgrades notes. Some of the early upgrades can be pretty problematic if you take too big a jump.

    So my upgrade process would probably be:

    1. Upgrade to the latest 7.2.* version
    2. Upgrade to 7.3.0
    3. Upgrade to 7.3.* latest
    4. Upgrade to 7.4.* latest
    5. Upgrade to 7.5.* latest etc.

    After about 7.4, I've found the upgrades have become a lot smoother but the version-specific notes are still very important, particularly the 7.6 notes.

  • Aleksander 43 posts 203 karma points
    Mar 26, 2018 @ 11:44
    Aleksander
    0

    I've done several upgrades of different sites.

    One from 6 straight to 7.8,

    and a few from 7.5.x to 7.9.

    for all those projects the Database upgrade had no issues, only the solutions upgrades proved problematic, yet doable.

    For this project i can update the database to 7.5 with no errors, but anything higher gives that error.

  • Steve Morgan 1030 posts 3195 karma points c-trib
    Mar 26, 2018 @ 13:12
    Steve Morgan
    100

    Hi Aleksander,

    Looks similar to this:

    https://stackoverflow.com/questions/44263266/umbraco-upgrading-from-7-4-3-to-7-6-1-cannot-insert-duplicate-key https://our.umbraco.org/forum/using-umbraco-and-getting-started/87380-cannot-insert-duplicate-key-row-in-object-dboumbraconode-upgrading-75x-to-76x

    Try changing / checking the default schema on your Umbraco db.

    Kind regards

    Steve

  • Aleksander 43 posts 203 karma points
    Mar 27, 2018 @ 08:48
    Aleksander
    0

    HI Steve.

    Yeah i also came across that thread before posting here. Should have mentioned that obviously. Anyway i tried both deleting that index, and unless im at a fault then my user should be set to DBO.

    just to be sure: the default schema is configured by (using MS SQL Server management studio) rightclicking my user. clicking properties. selecting user mapping and then setting the database role as db_owner on the user. I altroed pressing the "Default schema" box, and then manually typing DBO for object names. but i think those two solutions are equivalent....

  • Steve Morgan 1030 posts 3195 karma points c-trib
    Mar 27, 2018 @ 09:26
    Steve Morgan
    1

    Yes - that sounds right to me (though I'm no DBA!).

    Wonder if anyone else has any suggestions.

  • Aleksander 43 posts 203 karma points
    Apr 04, 2018 @ 13:25
    Aleksander
    0

    Got it to 7.6 now... Seems like i didn't drop the index correctly last time i tried..

    Well i'll give a round of beer for my mistake!

  • Laurence Gillian 595 posts 1211 karma points
    Mar 05, 2019 @ 16:11
    Laurence Gillian
    0

    This thread, and the recommendation to ensure the user is db_owner helped resolve an upgrade issue for me.

    I ran the following SQL on the database to ensure the user had the correct permissions:

    EXEC sp_addrolemember 'db_owner', 'username';

Please Sign in or register to post replies

Write your reply to:

Draft