Copied to clipboard

Flag this post as spam?

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


  • Duke 11 posts 102 karma points
    Jan 29, 2020 @ 16:45
    Duke
    0

    Database Migration Error

    Attempting database migration from Umbraco 7.15.3 to 8.5.1, following the steps found here.

    The migration runs for a couple of minutes then throws an error while trying to run an ALTER TABLE on umbracoMediaVersion. Here is the point in the log where the failure occurs

    {"@t":"2020-01-28T19:57:37.4533151Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":42056,"Sql":"ALTER TABLE [umbracoMediaVersion] ALTER COLUMN [id] INTEGER NOT NULL","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":22884,"ProcessName":"w3wp","ThreadId":65,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"201708-9RQ1JK2","Log4NetLevel":"INFO ","HttpRequestNumber":12,"HttpRequestId":"54809062-251f-4eac-b04b-f55fb44e64d5"} {"@t":"2020-01-28T19:57:42.6840535Z","@mt":"Exception ({InstanceId}).","@l":"Error","@x":"System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'id', table 'GraphicProducts.com715Upgrade.dbo.umbracoMediaVersion'; column does not allow nulls. UPDATE fails.\r\nThe statement has been terminated.\r\n at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)\r\n at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) in D:\\a\\1\\s\\src\\Umbraco.Core\\Persistence\\FaultHandling\\RetryPolicy.cs:line 172\r\n at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.ExecuteStatement(StringBuilder stmtBuilder) in D:\\a\\1\\s\\src\\Umbraco.Core\\Migrations\\MigrationExpressionBase.cs:line 121\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.Execute() in D:\\a\\1\\s\\src\\Umbraco.Core\\Migrations\\MigrationExpressionBase.cs:line 77\r\n at Umbraco.Core.Migrations.Upgrade.V_8_0_0.RenameMediaVersionTable.Migrate() in D:\\a\\1\\s\\src\\Umbraco.Core\\Migrations\\Upgrade\\V_8_0_0\\RenameMediaVersionTable.cs:line 28\r\n at Umbraco.Core.Migrations.MigrationBase.Umbraco.Core.Migrations.IMigration.Migrate() in D:\\a\\1\\s\\src\\Umbraco.Core\\Migrations\\MigrationBase.cs:line 73\r\n at Umbraco.Core.Migrations.MigrationPlan.Execute(IScope scope, String fromState, IMigrationBuilder migrationBuilder, ILogger logger) in D:\\a\\1\\s\\src\\Umbraco.Core\\Migrations\\MigrationPlan.cs:line 312\r\n at Umbraco.Core.Migrations.Upgrade.Upgrader.Execute(IScopeProvider scopeProvider, IMigrationBuilder migrationBuilder, IKeyValueService keyValueService, ILogger logger) in D:\\a\\1\\s\\src\\Umbraco.Core\\Migrations\\Upgrade\\Upgrader.cs:line 67\r\n at Umbraco.Core.Migrations.Install.DatabaseBuilder.UpgradeSchemaAndData(MigrationPlan plan) in D:\\a\\1\\s\\src\\Umbraco.Core\\Migrations\\Install\\DatabaseBuilder.cs:line 500\r\nClientConnectionId:46a73880-9876-4878-99a0-f2b882ad8e33\r\nError Number:515,State:2,Class:16","InstanceId":"bcd6b399","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":22884,"ProcessName":"w3wp","ThreadId":65,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"201708-9RQ1JK2","Log4NetLevel":"ERROR","HttpRequestNumber":12,"HttpRequestId":"54809062-251f-4eac-b04b-f55fb44e64d5"} {"@t":"2020-01-28T19:57:42.6849542Z","@mt":"Database configuration failed","@l":"Error","@x":"System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'id', table 'GraphicProducts.com_715_Upgrade.dbo.umbracoMediaVersion'; column does not allow nulls. UPDATE fails.\r\nThe statement has been terminated.\r\n at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)\r\n at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) in D:\a\1\s\src\Umbraco.Core\Persistence\FaultHandling\RetryPolicy.cs:line 172\r\n at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.ExecuteStatement(StringBuilder stmtBuilder) in D:\a\1\s\src\Umbraco.Core\Migrations\MigrationExpressionBase.cs:line 121\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.Execute() in D:\a\1\s\src\Umbraco.Core\Migrations\MigrationExpressionBase.cs:line 77\r\n at Umbraco.Core.Migrations.Upgrade.V800.RenameMediaVersionTable.Migrate() in D:\a\1\s\src\Umbraco.Core\Migrations\Upgrade\V800\RenameMediaVersionTable.cs:line 28\r\n at Umbraco.Core.Migrations.MigrationBase.Umbraco.Core.Migrations.IMigration.Migrate() in D:\a\1\s\src\Umbraco.Core\Migrations\MigrationBase.cs:line 73\r\n at Umbraco.Core.Migrations.MigrationPlan.Execute(IScope scope, String fromState, IMigrationBuilder migrationBuilder, ILogger logger) in D:\a\1\s\src\Umbraco.Core\Migrations\MigrationPlan.cs:line 312\r\n at Umbraco.Core.Migrations.Upgrade.Upgrader.Execute(IScopeProvider scopeProvider, IMigrationBuilder migrationBuilder, IKeyValueService keyValueService, ILogger logger) in D:\a\1\s\src\Umbraco.Core\Migrations\Upgrade\Upgrader.cs:line 67\r\n at Umbraco.Core.Migrations.Install.DatabaseBuilder.UpgradeSchemaAndData(MigrationPlan plan) in D:\a\1\s\src\Umbraco.Core\Migrations\Install\DatabaseBuilder.cs:line 500\r\nClientConnectionId:46a73880-9876-4878-99a0-f2b882ad8e33\r\nError Number:515,State:2,Class:16","SourceContext":"Umbraco.Core.Migrations.Install.DatabaseBuilder","ProcessId":22884,"ProcessName":"w3wp","ThreadId":65,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"201708-9RQ1JK2","Log4NetLevel":"ERROR","HttpRequestNumber":12,"HttpRequestId":"54809062-251f-4eac-b04b-f55fb44e64d5"} {"@t":"2020-01-28T19:57:42.6849542Z","@mt":"The database schema validation produced the following summary: {DbSchemaSummary}","DbSchemaSummary":"The following tables were found in the database, but are not in the current schema:\r\nuSyncSnapshotAudit,cmsTaskType,cmsTask,cmsPropertyData,NopCommerceProductCategories,MigrationHistory,ShippingCalcModels,cmsContent,ShopperApprovedDelete,cmsContentVersion,ShopperApproved,nopCommerceCategories,getResourceCenterMetadata,cmsDocument,RedirectList,CMUmbracoToolsSettings,CMUmbracoToolsPermanentRedirects,cmsMedia,jokeClicks,cmsDataType,cmsDataTypePreValues,NopProductViews,umbracoMigration,umbracoDomains,jokeOfTheDay,jokeRating,CMSImportState,CMSImportScheduledTask,CMSImportRelation,cmsContentXml,CMSImportMediaRelation,CMSImportScheduledItems,cmsPreviewXml,gpTopics,icUrlTracker,umbracoContent,umbracoContentVersion,umbracoMediaVersion,umbracoDocument,umbracoDataType,umbracoDomain,umbracoPropertyData,cmsContentNu,umbracoDocumentVersion,umbracoKeyValue,umbracoContentVersionCultureVariation,umbracoDocumentCultureVariation,umbracoContentSchedule\r\n \r\nThe following columns were found in the database, but are not in the current schema:\r\nuSyncSnapshotAudit,id,uSyncSnapshotAudit,Name,uSyncSnapshotAudit,Applied,uSyncSnapshotAudit,IsLocal,cmsTaskType,id,cmsTaskType,alias,cmsTask,closed,cmsTask,id,cmsTask,taskTypeId,cmsTask,nodeId,cmsTask,parentUserId,cmsTask,userId,cmsTask,DateTime,cmsTask,Comment,cmsPropertyData,id,cmsPropertyData,contentNodeId,cmsPropertyData,versionId,cmsPropertyData,propertytypeid,cmsPropertyData,dataInt,cmsPropertyData,dataDecimal,cmsPropertyData,dataDate,cmsPropertyData,dataNvarchar,cmsPropertyData,dataNtext,NopCommerceProductCategories,Id,NopCommerceProductCategories,Name,NopCommerceProductCategories,URLSegment,NopCommerceProductCategories,Description,NopCommerceProductCategories,MetaKeywords,NopCommerceProductCategories,MetaDescription,NopCommerceProductCategories,Published,NopCommerceProductCategories,MetaTitle,NopCommerceProductCategories,ParentCategoryId,NopCommerceProductCategories,SeoFilename,NopCommerceProductCategories,MimeType,MigrationHistory,MigrationId,MigrationHistory,ContextKey,MigrationHistory,Model,MigrationHistory,ProductVersion,cmsTemplate,design,ShippingCalcModels,Id,ShippingCalcModels,ShipingType,ShippingCalcModels,OrderTotalMin,ShippingCalcModels,OrderTotalMax,ShippingCalcModels,CostPercent,ShippingCalcModels,HandlingPrice,cmsContent,pk,cmsContent,nodeId,cmsContent,contentType,ShopperApprovedDelete,ItemName,ShopperApprovedDelete,Description,ShopperApprovedDelete,StoreURL,ShopperApprovedDelete,Sku,ShopperApprovedDelete,ParentSku,ShopperApprovedDelete,ImageLink,cmsContentVersion,id,cmsContentVersion,ContentId,cmsContentVersion,VersionId,cmsContentVersion,VersionDate,ShopperApproved,ParentSku,ShopperApproved,ItemName,ShopperApproved,Description,ShopperApproved,Sku,ShopperApproved,ImageLink,ShopperApproved,StoreURL,nopCommerceCategories,Id,nopCommerceCategories,Name,nopCommerceCategories,UrlSegment,nopCommerceCategories,ParentCategoryId,getResourceCenterMetadata,Id,getResourceCenterMetadata,nodeType,getResourceCenterMetadata,title,getResourceCenterMetadata,metaDescription,getResourceCenterMetadata,shortDescription,getResourceCenterMetadata,shortTitle,cmsDocument,nodeId,cmsDocument,published,cmsDocument,documentUser,cmsDocument,versionId,cmsDocument,text,cmsDocument,releaseDate,cmsDocument,expireDate,cmsDocument,updateDate,cmsDocument,templateId,cmsDocument,newest,RedirectList,nodeId,RedirectList,nodeType,RedirectList,title,RedirectList,Url,RedirectList,formerShortUrls,CMUmbracoToolsSettings,SettingID,CMUmbracoToolsSettings,Application,CMUmbracoToolsSettings,Name,CMUmbracoToolsSettings,Value,CMUmbracoToolsPermanentRedirects,PermanentRedirectID,CMUmbracoToolsPermanentRedirects,OriginalURL,CMUmbracoToolsPermanentRedirects,RedirectURL,CMUmbracoToolsPermanentRedirects,Notes,cmsMedia,nodeId,cmsMedia,versionId,cmsMedia,mediaPath,jokeClicks,id,jokeClicks,jokeId,jokeClicks,ipAddress,jokeClicks,clickedOn,cmsDataType,pk,cmsDataType,nodeId,cmsDataType,propertyEditorAlias,cmsDataType,dbType,cmsDataTypePreValues,id,cmsDataTypePreValues,datatypeNodeId,cmsDataTypePreValues,value,cmsDataTypePreValues,sortorder,cmsDataTypePreValues,alias,NopProductViews,Id,NopProductViews,Name,NopProductViews,ShortDescription,NopProductViews,FullDescription,NopProductViews,Sku,NopProductViews,SeName,NopProductViews,ProductPrice,umbracoMigration,id,umbracoMigration,name,umbracoMigration,createDate,umbracoMigration,version,umbracoDomains,id,umbracoDomains,domainDefaultLanguage,umbracoDomains,domainRootStructureID,umbracoDomains,domainName,jokeOfTheDay,id,jokeOfTheDay,joke,jokeOfTheDay,punchline,jokeOfTheDay,displayOn,jokeOfTheDay,addedOn,cmsMacro,macroScriptType,cmsMacro,macroScriptAssembly,cmsMacro,macroXSLT,cmsMacro,macroPython,jokeRating,id,jokeRating,jokeId,jokeRating,rating,jokeRating,ipAddress,jokeRating,ratedOn,CMSImportState,Id,CMSImportState,UniqueIdentifier,CMSImportState,Name,CMSImportState,ImportState,CMSImportState,Parent,CMSImportState,ImportProvider,CMSImportScheduledTask,ScheduleId,CMSImportScheduledTask,ScheduleGUID,CMSImportScheduledTask,ImportStateGUID,CMSImportScheduledTask,ScheduledTaskName,CMSImportScheduledTask,NotifyEmailAddress,CMSImportScheduledTask,ExecuteEvery,CMSImportScheduledTask,ExecuteDays,CMSImportScheduledTask,ExecuteHour,CMSImportScheduledTask,ExecuteMinute,CMSImportScheduledTask,ImportAsUser,CMSImportRelation,Id,CMSImportRelation,UmbracoID,CMSImportRelation,DataSourceKey,CMSImportRelation,ImportProvider,CMSImportRelation,Updated,CMSImportRelation,CustomId,cmsContentXml,nodeId,cmsContentXml,xml,CMSImportMediaRelation,Id,CMSImportMediaRelation,UmbracoMediaId,CMSImportMediaRelation,SourceUrl,CMSImportMediaRelation,ByteSize,CMSImportScheduledItems,ScheduledItemId,CMSImportScheduledItems,ScheduleldTaskId,CMSImportScheduledItems,ScheduledOn,CMSImportScheduledItems,ExecutedOn,CMSImportScheduledItems,InProgress,cmsPreviewXml,nodeId,cmsPreviewXml,versionId,cmsPreviewXml,timestamp,cmsPreviewXml,xml,gpTopics,id,gpTopics,tagName,cmsTags,ParentId,icUrlTracker,Id,icUrlTracker,OldUrl,icUrlTracker,OldUrlQueryString,icUrlTracker,OldRegex,icUrlTracker,RedirectRootNodeId,icUrlTracker,RedirectNodeId,icUrlTracker,RedirectUrl,icUrlTracker,RedirectHttpCode,icUrlTracker,RedirectPassThroughQueryString,icUrlTracker,ForceRedirect,icUrlTracker,Notes,icUrlTracker,Is404,icUrlTracker,Referrer,icUrlTracker,Inserted,cmsContentType,isElement,cmsContentType,variations,umbracoContent,nodeId,umbracoContent,contentTypeId,umbracoContentVersion,id,umbracoContentVersion,nodeId,umbracoContentVersion,versionDate,umbracoContentVersion,userId,umbracoContentVersion,current,umbracoContentVersion,text,umbracoMediaVersion,id,umbracoMediaVersion,path,umbracoDocument,nodeId,umbracoDocument,published,umbracoDocument,edited,umbracoDataType,nodeId,umbracoDataType,propertyEditorAlias,umbracoDataType,dbType,umbracoDataType,config,umbracoLanguage,isDefaultVariantLang,umbracoLanguage,mandatory,umbracoLanguage,fallbackLanguageId,umbracoDomain,id,umbracoDomain,domainDefaultLanguage,umbracoDomain,domainRootStructureID,umbracoDomain,domainName,umbracoLog,entityType,umbracoLog,parameters,cmsMacro,macroSource,cmsMacro,macroType,cmsPropertyType,variations,umbracoPropertyData,id,umbracoPropertyData,versionId,umbracoPropertyData,propertyTypeId,umbracoPropertyData,languageId,umbracoPropertyData,segment,umbracoPropertyData,intValue,umbracoPropertyData,decimalValue,umbracoPropertyData,dateValue,umbracoPropertyData,varcharValue,umbracoPropertyData,textValue,cmsTags,languageId,umbracoRedirectUrl,culture,cmsContentNu,nodeId,cmsContentNu,published,cmsContentNu,data,cmsContentNu,rv,umbracoDocumentVersion,id,umbracoDocumentVersion,templateId,umbracoDocumentVersion,published,umbracoKeyValue,key,umbracoKeyValue,value,umbracoKeyValue,updated,umbracoContentVersionCultureVariation,id,umbracoContentVersionCultureVariation,versionId,umbracoContentVersionCultureVariation,languageId,umbracoContentVersionCultureVariation,name,umbracoContentVersionCultureVariation,date,umbracoContentVersionCultureVariation,availableUserId,umbracoDocumentCultureVariation,id,umbracoDocumentCultureVariation,nodeId,umbracoDocumentCultureVariation,languageId,umbracoDocumentCultureVariation,edited,umbracoDocumentCultureVariation,available,umbracoDocumentCultureVariation,published,umbracoDocumentCultureVariation,name,umbracoContentSchedule,id,umbracoContentSchedule,nodeId,umbracoContentSchedule,languageId,umbracoContentSchedule,date,umbracoContentSchedule,action\r\n \r\nThe following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:\r\nFKcmsContentcmsContentTypenodeId,FKcmsContentumbracoNodeid,FKcmsContentVersioncmsContentnodeId,FKcmsContentXmlcmsContentnodeId,FKcmsDataTypeumbracoNodeid,FKcmsDataTypePreValuescmsDataTypenodeId,FKcmsDocumentcmsContentnodeId,FKcmsDocumentcmsTemplatenodeId,FKcmsDocumentumbracoNodeid,FKcmsMediacmsContentnodeId,FKcmsMediaumbracoNodeid,FKcmsMembercmsContentnodeId,FKcmsMemberumbracoNodeid,FKcmsPreviewXmlcmsContentnodeId,FKcmsPreviewXmlcmsContentVersionVersionId,FKcmsPropertyDatacmsPropertyTypeid,FKcmsPropertyDataumbracoNodeid,FKcmsPropertyTypecmsDataTypenodeId,FKcmsTagscmsTags,FKcmsTaskcmsTaskTypeid,FKcmsTaskumbracoNodeid,FKcmsTaskumbracoUser,FKcmsTaskumbracoUser1,FKumbracoDomainsumbracoNodeid,FKumbracoNodeumbracoUserid,FKumbracoContentumbracoNodeid,FKumbracoContentcmsContentTypeNodeId,FKumbracoContentVersionumbracoContentnodeId,FKumbracoContentVersionumbracoUserid,FKumbracoMediaVersionumbracoContentVersionid,FKumbracoDocumentumbracoContentnodeId,FKumbracoDataTypeumbracoNodeid,FKumbracoLanguageumbracoLanguageid,FKumbracoDomainumbracoNodeid,FKumbracoLogumbracoUserid,FKcmsMemberumbracoContentnodeId,FKcmsPropertyTypeumbracoDataTypenodeId,FKumbracoPropertyDataumbracoContentVersionid,FKumbracoPropertyDatacmsPropertyTypeid,FKumbracoPropertyDataumbracoLanguageid,FKcmsTagsumbracoLanguageid,FKcmsContentNuumbracoContentnodeId,FKumbracoDocumentVersionumbracoContentVersionid,FKumbracoDocumentVersioncmsTemplatenodeId,FKumbracoContentVersionCultureVariationumbracoContentVersionid,FKumbracoContentVersionCultureVariationumbracoLanguageid,FKumbracoContentVersionCultureVariationumbracoUserid,FKumbracoDocumentCultureVariationumbracoNodeid,FKumbracoDocumentCultureVariationumbracoLanguageid,FKumbracoContentScheduleumbracoContentnodeId,FKumbracoContentScheduleumbracoLanguageid,PKcmsContent,PKcmsContentPreviewXml,PKcmsContentVersion,PKcmsContentXml,PKcmsDataType,PKcmsDataTypePreValues,PKcmsDocument,PKCMSImportMediaRelation,PKCMSImportRelation,PKCMSImportScheduledItems,PKCMSImportScheduledTask,PKCMSImportState,PKcmsMedia,PKcmsPropertyData,PKcmsTask,PKcmsTaskType,PKCMUmbracoToolsPermanentRedirects,PKCMUmbracoToolsSettings,PKdbo.MigrationHistory,PKdbo.ShippingCalcModels,PKdbo.ShopperApproved,PKgpTopics,PKicUrlTracker,PKjokeClicks,PKjokeOfTheDay,PKjokeRating,PKstructure,PKumbracoDomains,PKumbracoMigration,PKuSyncSnapshotAudit,PKumbracoNode,PKumbracoContent,PKumbracoContentVersion,PKumbracoMediaVersion,PKumbracoDocument,PKumbracoDataType,PKumbracoDomain,PKumbracoPropertyData,PKcmsContentNu,PKumbracoDocumentVersion,PKumbracoKeyValue,PKumbracoContentVersionCultureVariation,PKumbracoDocumentCultureVariation,PKumbracoContentSchedule\r\n \r\nThe following indexes were found in the database, but are not in the current schema:\r\nIXcmsContent,IXcmsContentVersionContentId,IXcmsContentVersionVersionId,IXcmsDataTypenodeId,IXcmsDocument,IXcmsDocumentnewest,IXcmsDocumentpublished,IXcmsMedia,IXcmsPropertyData1,IXcmsPropertyData2,IXcmsPropertyData3,IXcmsTaskTypealias,IXicUrlTracker,IXumbracoMigration,IXumbracoNodeObjectType,IXumbracoNodeParentId,IXumbracoNodePath,IXumbracoNodeTrashed,IXumbracoNodeUniqueID,IXumbracoNodeUniqueId,IXumbracoNodeParentId,IXumbracoNodePath,IXumbracoNodeTrashed,IXumbracoNodeObjectType,IXumbracoMediaVersion,IXumbracoDocumentPublished,IXumbracoLanguagefallbackLanguageId,IXumbracoPropertyDataVersionId,IXumbracoPropertyDataPropertyTypeId,IXumbracoPropertyDataLanguageId,IXumbracoPropertyDataSegment,IXcmsTagsLanguageId,IXumbracoUserLoginlastValidatedUtc,IXumbracoContentVersionCultureVariationVersionId,IXumbracoContentVersionCultureVariationLanguageId,IXumbracoDocumentCultureVariationNodeId,IXumbracoDocumentCultureVariationLanguageId\r\n \r\n","SourceContext":"Umbraco.Core.Migrations.Install.DatabaseBuilder","ProcessId":22884,"ProcessName":"w3wp","ThreadId":65,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"201708-9RQ1JK2","Log4NetLevel":"INFO ","HttpRequestNumber":12,"HttpRequestId":"54809062-251f-4eac-b04b-f55fb44e64d5"} {"@t":"2020-01-28T19:57:42.6879455Z","@mt":"Installation step {Step} failed.","@l":"Error","@x":"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 the value NULL into column 'id', table 'GraphicProducts.com715Upgrade.dbo.umbracoMediaVersion'; column does not allow nulls. UPDATE fails.\r\nThe statement has been terminated.\n Please check log file for additional information (can be found in '/AppData/Logs/')\r\n at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.ExecuteAsync(Object model) in D:\a\1\s\src\Umbraco.Web\Install\InstallSteps\DatabaseUpgradeStep.cs:line 47\r\n --- End of inner exception stack trace ---\r\n at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)\r\n at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)\r\n at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.715Upgrade.dbo.umbracoMediaVersion'; column does not allow nulls. UPDATE fails.\r\nThe statement has been terminated.\n Please check log file for additional information (can be found in '/AppData/Logs/')\r\n at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.ExecuteAsync(Object model) in D:\a\1\s\src\Umbraco.Web\Install\InstallSteps\DatabaseUpgradeStep.cs:line 47\r\n --- End of inner exception stack trace ---\r\n at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)\r\n at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)\r\n at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.

  • Richard Hamilton 36 posts 158 karma points
    Jun 02, 2020 @ 14:32
    Richard Hamilton
    0

    Did you ever resolve this? Just doing a new install and getting a similar issue

  • Duke 11 posts 102 karma points
    Jun 02, 2020 @ 14:41
    Duke
    101

    Hi Richard,

    Yes I was able to work through this issue with the assistance an early version of Steve Megson's pre-migration health check tool.

    Best regards,

    Jon

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies