Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • Tony Lorentzen 85 posts 174 karma points
    Jul 15, 2016 @ 19:29
    Tony Lorentzen
    0

    Error after upgrade from 7.2.6 to 7.4.3

    Using Umbraco And Getting Started
    Umbraco 7

    Seems like I always have issues when upgrading my Umbraco installations for clients... Urgh :-( I've done all the version specific upgrades and followed the steps to update config files, but after finishing the upgrade I get this error:

    Update error

    Any ideas? I'm running it on a Windows Server 2012 R2 using SQL Server CE on the installation.

    Help! :-)

    Copy Link
  • Tony Lorentzen 85 posts 174 karma points
    Jul 15, 2016 @ 19:37
    Tony Lorentzen
    0

    The error I'm getting in the EventLog is:

    Type validation failed. The value type: 'DateTime' does not match the > DataType in PropertyType with alias: 'producedFromDate'

    Copy Link
  • Tony Lorentzen 85 posts 174 karma points
    Jul 15, 2016 @ 22:04
    Tony Lorentzen
    0

    Here's an excerpt from the UmbracoTraceLog: 

     2016-07-15 18:53:42,593 [P10792/D5/T1] INFO  Umbraco.Core.CoreBootManager - Umbraco 7.4.3 application starting on SRVWEB
 2016-07-15 18:53:42,686 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Determining hash of code files on disk
 2016-07-15 18:53:42,700 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Hash determined (took 15ms)
 2016-07-15 18:53:42,818 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Starting resolution types of umbraco.interfaces.IApplicationStartupHandler
 2016-07-15 18:53:42,839 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Completed resolution of types of umbraco.interfaces.IApplicationStartupHandler, found 0 (took 21ms)
 2016-07-15 18:53:42,880 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter
 2016-07-15 18:53:42,882 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter, found 0 (took 2ms)
 2016-07-15 18:53:42,883 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IPropertyValueConverter
 2016-07-15 18:53:42,884 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyValueConverter, found 0 (took 1ms)
 2016-07-15 18:53:42,908 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Web.Mvc.SurfaceController
 2016-07-15 18:53:42,909 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Web.Mvc.SurfaceController, found 0 (took 0ms)
 2016-07-15 18:53:42,909 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Web.WebApi.UmbracoApiController
 2016-07-15 18:53:42,913 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Web.WebApi.UmbracoApiController, found 0 (took 3ms)
 2016-07-15 18:53:42,962 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Media.IThumbnailProvider
 2016-07-15 18:53:42,963 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Media.IThumbnailProvider, found 0 (took 0ms)
 2016-07-15 18:53:42,963 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Media.IImageUrlProvider
 2016-07-15 18:53:42,964 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Media.IImageUrlProvider, found 0 (took 0ms)
 2016-07-15 18:53:46,601 [P10792/D5/T1] INFO  Umbraco.Core.CoreBootManager - Umbraco application startup complete (took 4436ms)
 2016-07-15 18:53:49,562 [P10792/D5/T57] INFO  Umbraco.Core.Sync.ApplicationUrlHelper - ApplicationUrl: http://beta.mysitedomain.dk:80/umbraco (UmbracoModule request)
 2016-07-15 18:54:01,881 [P10792/D5/T59] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: Permissions
 2016-07-15 18:54:01,905 [P10792/D5/T59] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 23ms)
 2016-07-15 18:54:01,969 [P10792/D5/T50] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: Upgrade
 2016-07-15 18:54:01,970 [P10792/D5/T50] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 0ms)
 2016-07-15 18:54:02,011 [P10792/D5/T52] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: DatabaseInstall
 2016-07-15 18:54:02,028 [P10792/D5/T52] INFO  Umbraco.Core.DatabaseContext - Database configuration status: Started
 2016-07-15 18:54:02,032 [P10792/D5/T52] INFO  Umbraco.Core.DatabaseContext - Database requires upgrade
 2016-07-15 18:54:02,033 [P10792/D5/T52] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 21ms)
 2016-07-15 18:54:02,056 [P10792/D5/T55] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: DatabaseUpgrade
 2016-07-15 18:54:02,063 [P10792/D5/T55] INFO  Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep - Running 'Upgrade' service
 2016-07-15 18:54:02,076 [P10792/D5/T55] INFO  Umbraco.Core.DatabaseContext - Database upgrade started
 2016-07-15 18:54:02,109 [P10792/D5/T55] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Persistence.Mappers.BaseMapper
 2016-07-15 18:54:02,111 [P10792/D5/T55] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Persistence.Mappers.BaseMapper, found 0 (took 1ms)
 2016-07-15 18:54:02,625 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Initializing database migrations
 2016-07-15 18:54:02,628 [P10792/D5/T55] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Persistence.Migrations.IMigration
 2016-07-15 18:54:02,630 [P10792/D5/T55] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Persistence.Migrations.IMigration, found 0 (took 2ms)
 2016-07-15 18:54:02,755 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddRelationTypeForDocumentOnDelete' to context
 2016-07-15 18:54:02,787 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'CreateCacheInstructionTable' to context
 2016-07-15 18:54:02,862 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'MigrateAndRemoveTemplateMasterColumn' to context
 2016-07-15 18:54:02,916 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'MigrateStylesheetDataToFile' to context
 2016-07-15 18:54:02,943 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveStylesheetDataAndTables' to context
 2016-07-15 18:54:03,001 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveLanguageLocaleColumn' to context
 2016-07-15 18:54:03,054 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateUniqueIdToHaveCorrectIndexType' to context
 2016-07-15 18:54:03,077 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddPublicAccessTables' to context
 2016-07-15 18:54:03,126 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'MovePublicAccessXmlDataToDb' to context
 2016-07-15 18:54:03,173 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveHelpTextColumn' to context
 2016-07-15 18:54:03,190 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddExternalLoginsTable' to context
 2016-07-15 18:54:03,233 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUserColumns' to context
 2016-07-15 18:54:03,250 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddMigrationTable' to context
 2016-07-15 18:54:03,293 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUniqueIdPropertyTypeColumn' to context
 2016-07-15 18:54:03,369 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddForeignKeysForLanguageAndDictionaryTables' to context
 2016-07-15 18:54:03,404 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveUmbracoLoginsTable' to context
 2016-07-15 18:54:03,459 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddServerRegistrationColumnsAndLock' to context
 2016-07-15 18:54:03,487 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'CleanUpCorruptedPublishedFlags' to context
 2016-07-15 18:54:03,506 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateUserLanguagesToIsoCode' to context
 2016-07-15 18:54:03,508 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'EnsureMigrationsTableIdentityIsCorrect' to context
 2016-07-15 18:54:03,539 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddDataDecimalColumn' to context
 2016-07-15 18:54:03,570 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUniqueIdPropertyTypeGroupColumn' to context
 2016-07-15 18:54:03,605 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'EnsureContentTypeUniqueIdsAreConsistent' to context
 2016-07-15 18:54:03,621 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'FixListViewMediaSortOrder' to context
 2016-07-15 18:54:03,651 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveParentIdPropertyTypeGroupColumn' to context
 2016-07-15 18:54:03,665 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUmbracoDeployTables' to context
 2016-07-15 18:54:03,686 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 2: DELETE FROM [umbracoMigration] WHERE 1 = 1

 2016-07-15 18:54:03,709 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 4: UPDATE [umbracoNode] SET [uniqueID] = 'd96f6272-7598-8bad-e91c-37fa1d18af87' WHERE [id] = 1044

 2016-07-15 18:54:03,710 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 5: UPDATE [umbracoNode] SET [uniqueID] = 'e7242b78-ed06-2d23-5649-0602dc83036a' WHERE [id] = 2003

 2016-07-15 18:54:03,711 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 6: UPDATE [umbracoNode] SET [uniqueID] = 'd8cf185c-392f-591a-6100-c1d9d9963817' WHERE [id] = 1031

 2016-07-15 18:54:03,711 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 7: UPDATE [umbracoNode] SET [uniqueID] = '16bc0049-e8f5-d321-6c76-3dfbb1367a2d' WHERE [id] = 1032

 2016-07-15 18:54:03,712 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 8: UPDATE [umbracoNode] SET [uniqueID] = '34599b89-f7f5-1535-66e0-c6fd0ea11880' WHERE [id] = 1033

 2016-07-15 18:54:03,712 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 9: UPDATE [umbracoNode] SET [uniqueID] = 'cacc31a9-5416-0a6f-ed9c-17aec8c35e20' WHERE [id] = 1420

 2016-07-15 18:54:03,713 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 10: UPDATE [umbracoNode] SET [uniqueID] = 'd758b615-fd3c-693b-7e5a-a65f374e3628' WHERE [id] = 1421

 2016-07-15 18:54:03,713 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 11: UPDATE [umbracoNode] SET [uniqueID] = '54ef81ba-af55-f832-1528-954d451331e5' WHERE [id] = 2548

 2016-07-15 18:54:03,713 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 12: UPDATE [umbracoNode] SET [uniqueID] = '205fd936-d956-4a30-691c-ca1dac51d2bd' WHERE [id] = 2552

 2016-07-15 18:54:03,714 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 13: UPDATE [umbracoNode] SET [uniqueID] = '341ad732-b802-ec51-7576-cde0b1c9d44e' WHERE [id] = 2569

 2016-07-15 18:54:03,714 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 14: UPDATE [umbracoNode] SET [uniqueID] = '2c461702-de8a-5413-8aa4-0a2cafe01960' WHERE [id] = 1051

 2016-07-15 18:54:03,715 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 15: UPDATE [umbracoNode] SET [uniqueID] = 'f47d11f3-2266-ca30-379b-c5002f63a962' WHERE [id] = 1053

 2016-07-15 18:54:03,715 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 16: UPDATE [umbracoNode] SET [uniqueID] = 'aee5ce48-d999-f45c-6dc5-5e435d3b5ee4' WHERE [id] = 1055

 2016-07-15 18:54:03,715 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 17: UPDATE [umbracoNode] SET [uniqueID] = 'b78c1159-b060-dbbf-fa88-e996e499d69d' WHERE [id] = 1064

 2016-07-15 18:54:03,716 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 18: UPDATE [umbracoNode] SET [uniqueID] = '65f3b6b6-9467-c010-c0cf-1e851b039e1c' WHERE [id] = 1066

 2016-07-15 18:54:03,716 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 19: UPDATE [umbracoNode] SET [uniqueID] = '3bd332dd-c821-8a02-6971-4874c889c232' WHERE [id] = 1444

 2016-07-15 18:54:03,717 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 20: UPDATE [umbracoNode] SET [uniqueID] = 'c22f3edd-4402-0492-755a-f002f672ce67' WHERE [id] = 1451

 2016-07-15 18:54:03,717 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 21: UPDATE [umbracoNode] SET [uniqueID] = '22ad3c40-920c-b047-2b2f-5f503020ed0b' WHERE [id] = 1992

 2016-07-15 18:54:03,718 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 22: UPDATE [umbracoNode] SET [uniqueID] = '9613608b-571b-fd7e-2861-c23484710bf7' WHERE [id] = 2095

 2016-07-15 18:54:03,718 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 23: UPDATE [umbracoNode] SET [uniqueID] = '36afc3c0-26cd-5919-815c-6b227fc4c593' WHERE [id] = 2178

 2016-07-15 18:54:03,893 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\animate.min.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\animate.min.css.bak before being migrated to new format
 2016-07-15 18:54:03,895 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\blue.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\blue.css.bak before being migrated to new format
 2016-07-15 18:54:03,897 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\bootstrap.min.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\bootstrap.min.css.bak before being migrated to new format
 2016-07-15 18:54:03,899 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\custom.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\custom.css.bak before being migrated to new format
 2016-07-15 18:54:03,900 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\gray.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\gray.css.bak before being migrated to new format
 2016-07-15 18:54:03,902 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\green.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\green.css.bak before being migrated to new format
 2016-07-15 18:54:03,904 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\main.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\main.css.bak before being migrated to new format
 2016-07-15 18:54:03,906 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\navy.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\navy.css.bak before being migrated to new format
 2016-07-15 18:54:03,908 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\orange.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\orange.css.bak before being migrated to new format
 2016-07-15 18:54:03,910 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\owl.carousel.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\owl.carousel.css.bak before being migrated to new format
 2016-07-15 18:54:03,912 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\owl.transitions.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\owl.transitions.css.bak before being migrated to new format
 2016-07-15 18:54:03,913 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\pink.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\pink.css.bak before being migrated to new format
 2016-07-15 18:54:03,915 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\purple.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\purple.css.bak before being migrated to new format
 2016-07-15 18:54:03,917 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\red.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\red.css.bak before being migrated to new format
 2016-07-15 18:54:03,919 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\twentytwenty.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\twentytwenty.css.bak before being migrated to new format
 2016-07-15 18:54:03,920 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\XSLTsearch.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\XSLTsearch.css.bak before being migrated to new format
 2016-07-15 18:54:03,945 [P10792/D5/T55] INFO  Umbraco.Core.DatabaseContext - Database configuration status: <p>Upgrade completed!</p>
 2016-07-15 18:54:03,951 [P10792/D5/T55] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 1896ms)
 2016-07-15 18:54:03,961 [P10792/D5/T60] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: UmbracoVersion
 2016-07-15 18:54:04,007 [P10792/D5/T60] INFO  Umbraco.Core.PluginManager - Starting resolution types of umbraco.interfaces.ICacheRefresher
 2016-07-15 18:54:04,009 [P10792/D5/T60] INFO  Umbraco.Core.PluginManager - Completed resolution of types of umbraco.interfaces.ICacheRefresher, found 0 (took 2ms)
 2016-07-15 18:54:04,091 [P10792/D5/T60] INFO  umbraco.content - Load Xml from file...
 2016-07-15 18:54:04,132 [P10792/D5/T60] INFO  umbraco.content - Loaded Xml from file.
 2016-07-15 18:54:04,195 [P10792/D5/T60] INFO  umbraco.content - Loading content from database...
 2016-07-15 18:54:06,005 [P10792/D5/T60] INFO  Umbraco.Core.Configuration.ClientDependencyConfiguration - Updated version number from 1418882887 to 1456837871
 2016-07-15 18:54:06,394 [P10792/D5/T60] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 2433ms)
 2016-07-15 18:54:06,618 [P10792/D5/T52] ERROR UmbracoExamine.DataServices.UmbracoLogService - Provider=ExternalIndexer, NodeId=-1
System.Exception: Cannot index queue items, the index doesn't exist!,, IndexSet: ExternalIndexSet
 2016-07-15 18:54:06,692 [P10792/D5/T63] INFO  umbraco.content - Save Xml to file...
 2016-07-15 18:54:06,837 [P10792/D5/T68] INFO  umbraco.content - Saved Xml to file.
 2016-07-15 18:54:07,569 [P10792/D6/T65] INFO  Umbraco.Core.CoreBootManager - Umbraco 7.4.3 application starting on SRVWEB
 2016-07-15 18:54:07,735 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Determining hash of code files on disk
 2016-07-15 18:54:07,767 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Hash determined (took 31ms)
 2016-07-15 18:54:07,964 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Starting resolution types of umbraco.interfaces.IApplicationStartupHandler
 2016-07-15 18:54:08,010 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Completed resolution of types of umbraco.interfaces.IApplicationStartupHandler, found 0 (took 45ms)
 2016-07-15 18:54:08,091 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter
 2016-07-15 18:54:08,095 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter, found 0 (took 4ms)
 2016-07-15 18:54:08,096 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IPropertyValueConverter
 2016-07-15 18:54:08,098 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyValueConverter, found 0 (took 1ms)
 2016-07-15 18:54:08,150 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Web.Mvc.SurfaceController
 2016-07-15 18:54:08,153 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Web.Mvc.SurfaceController, found 0 (took 2ms)
 2016-07-15 18:54:08,154 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Web.WebApi.UmbracoApiController
 2016-07-15 18:54:08,165 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Web.WebApi.UmbracoApiController, found 0 (took 11ms)
 2016-07-15 18:54:08,296 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Media.IThumbnailProvider
 2016-07-15 18:54:08,298 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Media.IThumbnailProvider, found 0 (took 1ms)
 2016-07-15 18:54:08,298 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Media.IImageUrlProvider
 2016-07-15 18:54:08,299 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Media.IImageUrlProvider, found 0 (took 0ms)
 2016-07-15 18:54:11,655 [P10792/D6/T65] INFO  Umbraco.Core.DatabaseContext - CanConnect = True
 2016-07-15 18:54:12,752 [P10792/D6/T65] INFO  Umbraco.Core.DatabaseContext - CanConnect = True
 2016-07-15 18:54:12,780 [P10792/D6/T65] INFO  Umbraco.Core.DatabaseContext - CanConnect = True
 2016-07-15 18:54:12,833 [P10792/D6/T65] WARN  Umbraco.Core.Sync.DatabaseServerMessenger - No last synced Id found, this generally means this is a new server/install. The server will build its caches and indexes, and then adjust its last synced Id to the latest found in the database and maintain cache updates based on that Id.
 2016-07-15 18:54:12,904 [P10792/D6/T65] INFO  umbraco.content - Load Xml from file...
 2016-07-15 18:54:12,943 [P10792/D6/T65] INFO  umbraco.content - Loaded Xml from file.
 2016-07-15 18:54:13,011 [P10792/D6/T65] INFO  umbraco.content - Loading content from database...
 2016-07-15 18:54:17,079 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IParameterEditor
 2016-07-15 18:54:17,083 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IParameterEditor, found 0 (took 4ms)
 2016-07-15 18:54:18,049 [P10792/D6/T59] INFO  UmbracoExamine.DataServices.UmbracoLogService - Field "email" is listed multiple times in the index set "InternalMemberIndexSet". Please ensure all names are unique, Provider=InternalMemberIndexer, NodeId=2559
 2016-07-15 18:54:18,106 [P10792/D6/T59] INFO  UmbracoExamine.DataServices.UmbracoLogService - Field "email" is listed multiple times in the index set "InternalMemberIndexSet". Please ensure all names are unique, Provider=InternalMemberIndexer, NodeId=2559
 2016-07-15 18:54:18,511 [P10792/D6/T59] INFO  UmbracoExamine.DataServices.UmbracoLogService - Field "email" is listed multiple times in the index set "InternalMemberIndexSet". Please ensure all names are unique, Provider=InternalMemberIndexer, NodeId=1415
 2016-07-15 18:54:19,304 [P10792/D6/T66] INFO  umbraco.content - Save Xml to file...
 2016-07-15 18:54:19,335 [P10792/D6/T55] INFO  umbraco.content - Saved Xml to file.
 2016-07-15 18:54:28,811 [P10792/D6/T65] ERROR Umbraco.Core.CoreBootManager - An error occurred running OnApplicationStarted for handler Umbraco.Web.BatchedDatabaseServerMessengerStartup
System.Exception: Type validation failed. The value type: 'DateTime' does not match the DataType in PropertyType with alias: 'producedFromDate'
   at Umbraco.Core.Models.Property.set_Value(Object value)
   at Umbraco.Core.Persistence.Factories.PropertyFactory.BuildEntity(PropertyDataDto[] dtos)
   at Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2.GetPropertyCollection(Sql docSql, IEnumerable`1 documentDefs)
   at Umbraco.Core.Persistence.Repositories.ContentRepository.ProcessQuery(Sql sql)
   at Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2.GetPagedResultsByQuery[TDto,TContentBase](IQuery`1 query, Int64 pageIndex, Int32 pageSize, Int64& totalRecords, Tuple`2 nodeIdSelect, Func`2 processQuery, String orderBy, Direction orderDirection, Func`1 defaultFilter)
   at Umbraco.Core.Persistence.Repositories.ContentRepository.GetPagedResultsByQuery(IQuery`1 query, Int64 pageIndex, Int32 pageSize, Int64& totalRecords, String orderBy, Direction orderDirection, String filter)
   at Umbraco.Core.Services.ContentService.GetPagedDescendants(Int32 id, Int64 pageIndex, Int32 pageSize, Int64& totalChildren, String orderBy, Direction orderDirection, String filter)
   at UmbracoExamine.UmbracoContentIndexer.PerformIndexAll(String type)
   at UmbracoExamine.BaseUmbracoIndexer.PerformIndexRebuild()
   at Umbraco.Web.WebBootManager.<InitializeResolvers>b__f()
   at Umbraco.Core.Sync.DatabaseServerMessenger.Initialize()
   at Umbraco.Core.Sync.DatabaseServerMessenger.Boot()
   at Umbraco.Core.CoreBootManager.<Complete>b__a(IApplicationEventHandler x)
 2016-07-15 18:54:28,818 [P10792/D6/T65] ERROR Umbraco.Core.UmbracoApplicationBase - An unhandled exception occurred
System.Exception: Type validation failed. The value type: 'DateTime' does not match the DataType in PropertyType with alias: 'producedFromDate'
   at Umbraco.Core.Models.Property.set_Value(Object value)
   at Umbraco.Core.Persistence.Factories.PropertyFactory.BuildEntity(PropertyDataDto[] dtos)
   at Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2.GetPropertyCollection(Sql docSql, IEnumerable`1 documentDefs)
   at Umbraco.Core.Persistence.Repositories.ContentRepository.ProcessQuery(Sql sql)
   at Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2.GetPagedResultsByQuery[TDto,TContentBase](IQuery`1 query, Int64 pageIndex, Int32 pageSize, Int64& totalRecords, Tuple`2 nodeIdSelect, Func`2 processQuery, String orderBy, Direction orderDirection, Func`1 defaultFilter)
   at Umbraco.Core.Persistence.Repositories.ContentRepository.GetPagedResultsByQuery(IQuery`1 query, Int64 pageIndex, Int32 pageSize, Int64& totalRecords, String orderBy, Direction orderDirection, String filter)
   at Umbraco.Core.Services.ContentService.GetPagedDescendants(Int32 id, Int64 pageIndex, Int32 pageSize, Int64& totalChildren, String orderBy, Direction orderDirection, String filter)
   at UmbracoExamine.UmbracoContentIndexer.PerformIndexAll(String type)
   at UmbracoExamine.BaseUmbracoIndexer.PerformIndexRebuild()
   at Umbraco.Web.WebBootManager.<InitializeResolvers>b__f()
   at Umbraco.Core.Sync.DatabaseServerMessenger.Initialize()
   at Umbraco.Core.Sync.DatabaseServerMessenger.Boot()
   at Umbraco.Core.CoreBootManager.<Complete>b__a(IApplicationEventHandler x)
   at Umbraco.Core.EnumerableExtensions.ForEach[TItem](IEnumerable`1 items, Action`1 action)
   at Umbraco.Core.CoreBootManager.Complete(Action`1 afterComplete)
   at Umbraco.Web.WebBootManager.Complete(Action`1 afterComplete)
   at Umbraco.Core.UmbracoApplicationBase.StartApplication(Object sender, EventArgs e)
 2016-07-15 18:54:36,903 [P10792/D5/T52] INFO  Umbraco.Core.UmbracoApplicationBase - Application shutdown. Details: ConfigurationChange

_shutDownMessage=CONFIG change
HostingEnvironment initiated shutdown
CONFIG change
CONFIG change
CONFIG change
CONFIG change
HostingEnvironment caused shutdown

_shutDownStack=   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at System.Web.Hosting.HostingEnvironment.InitiateShutdownInternal()
   at System.Web.HttpRuntime.ShutdownAppDomain(String stackTrace)
   at System.Web.HttpRuntime.OnConfigChange(String message)
   at System.Configuration.BaseConfigurationRecord.OnStreamChanged(String streamname)
   at System.Web.DirectoryMonitor.FireNotifications()
   at System.Web.Util.WorkItem.CallCallbackWithAssert(WorkItemCallback callback)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
   at System.Threading.ThreadPoolWorkQueue.Dispatch()
 2016-07-15 18:54:38,884 [P10792/D6/T50] ERROR UmbracoExamine.DataServices.UmbracoLogService - Provider=ExternalIndexer, NodeId=-1
System.Exception: Cannot index queue items, the index doesn't exist!,, IndexSet: ExternalIndexSet
 2016-07-15 18:55:08,952 [P10792/D6/T45] INFO  Umbraco.Core.UmbracoApplicationBase - Application shutdown. Details: InitializationError

_shutDownMessage=Initialization Error
HostingEnvironment initiated shutdown
HostingEnvironment caused shutdown

_shutDownStack=   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at System.Web.Hosting.HostingEnvironment.InitiateShutdownInternal()
   at System.Web.HttpRuntime.ShutdownAppDomain(String stackTrace)
   at System.Web.HttpRuntime.AppDomainShutdownTimerCallback(Object state)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.TimerQueueTimer.CallCallback()
   at System.Threading.TimerQueueTimer.Fire()
   at System.Threading.TimerQueue.FireNextTimers()
    Copy Link
  • Dennis Aaen 4499 posts 18254 karma points admin hq c-trib
    Jul 16, 2016 @ 07:52
    Dennis Aaen
    0

    Hi Tony,

    You said that you have done all the version specific upgrades and followed the steps to update config files.

    Did you remember to copy over the folders:

    Bin

    Umbraco

    Umbraco_Client from the new fresh 7.4.3 installation https://our.umbraco.org/documentation/Getting-Started/Setup/Upgrading/general

    Also remember to merge the global.aspx and web.config file.

    Hope this helps,

    /Dennis

    Copy Link
  • Sebastiaan Janssen 5045 posts 15476 karma points MVP admin hq
    Jul 16, 2016 @ 08:41
    Sebastiaan Janssen
    0

    I get a few results when I Google for Type validation failed. The value type: 'DateTime' does not match the > DataType in PropertyType with alias: 'producedFromDate' but nothing really conclusive and no real solutions.

    What packages do you have installed?

    If you can take a backup of your database and send me a Dropbox/WeTransfer link then I can have a look at what the problem is ([email protected]).

    Copy Link
  • Tony Lorentzen 85 posts 174 karma points
    Jul 16, 2016 @ 08:55
    Tony Lorentzen
    0

    Yeah i've done all of those things too :-)

    It seems like Umbraco thinks the document property is a datetime type when it is a string... ?

    Copy Link
  • Tony Lorentzen 85 posts 174 karma points
    Jul 16, 2016 @ 14:05
    Tony Lorentzen
    0

    Hey Sebastiaan - appreciate your offer to look at the Database but unfortunately due to client confidentiality I'm unable to share it with anyone :-(

    Copy Link
  • Sebastiaan Janssen 5045 posts 15476 karma points MVP admin hq
    Jul 18, 2016 @ 05:46
    Sebastiaan Janssen
    1

    Try to go in and query the database: 

    SELECT * FROM cmsPropertyData WHERE propertyTypeId IN (
    SELECT id FROM cmsPropertyType WHERE alias = 'producedFromDate'
) AND (dataInt IS NOT NULL OR dataDecimal IS NOT NULL OR dataNVarChar IS NOT NULL OR dataNtext IS NOT NULL)

    This will result in all the data that is stored for the producedFromDate property that is NOT in the dataDate column, where it was supposed to be stored. You can then move this data into the dataDate column.

    It's hard to tell why this data was stored in the wrong column, especially if this site started as a v7 site. It could be a package, or an import?
    I can imagine that in older versions of Umbraco we sometimes might have stored things wrong, but since v6 that should not have happened any more. This is why I wanted to look at your database to see if I could figure out the cause and improve Umbraco for everyone if possible.

    Copy Link
  • Tony Lorentzen 85 posts 174 karma points
    Jul 20, 2016 @ 09:11
    Tony Lorentzen
    1

    All of the data is stored correctly in the datanvarchar fields (as they should be) as the the data isn't a date type but rather a period i.e. "Fall 2016", "Spring 2016". They aren't precise dates which is why the date type isn't set to a date.

    However - this led me onto investigate something else because I remember we changed the documenttype from Date to Textbook (or rather from DateTime to Nvarchar) and sure enough - there's was still some "old" data in the dataDate column which was causing the problems. Seems like when you change a document property type that the data isn't converted into the new format until the corresponding document has been opened and saved/published again. It'd be nice if there was a way to specify if you want to convert or maybe nullify the data for that particular document property when it is being changed. Obviously - some conversions are pretty straightforward like from date to string, whereas others aren't that easily convertible if at all.

    Anyhow - I nulled all of the old data in the dataDate field for that document property and one more and then my upgrade worked.

    Thanks for your help Sebastian!

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft