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

Please Sign in or register to post replies

Write your reply to:

Draft