Copied to clipboard

Flag this post as spam?

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


  • Tom Engan 430 posts 1163 karma points
    Aug 16, 2018 @ 08:29
    Tom Engan
    0

    Health Check, Data Integrity - Database Schema Validation: 53 WARN

    After upgrading from Umbraco v7.11.0 to v7.12.0, I immediately performed a health check:

     X    53 problems were detected with your database schema (Check the log for details).
    

    The message only applies to custom tables, or tables integrated from other packages.


    My App_Data/Logs/UmbracoTraceLog.WS12R2IISU.txt log file:

     2018-08-16 09:58:17,017 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Some errors were detected while validating the database schema against the current version of Umbraco.
     2018-08-16 09:58:17,017 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: HikingDestinations
     2018-08-16 09:58:17,017 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: NoZipCodes
     2018-08-16 09:58:17,018 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: perplexUmbracoMemberAccessLog
     2018-08-16 09:58:17,018 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: perplexUmbracoMemberLog
     2018-08-16 09:58:17,018 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: perplexUmbracoUserLog
     2018-08-16 09:58:17,019 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: Postnummer
     2018-08-16 09:58:17,019 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: HikingDestinations,Id
     2018-08-16 09:58:17,019 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: HikingDestinations,nodeId
     2018-08-16 09:58:17,020 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: HikingDestinations,SelectedHikingDestination
     2018-08-16 09:58:17,020 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: HikingDestinations,StartDate
     2018-08-16 09:58:17,020 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: HikingDestinations,HikingCode
     2018-08-16 09:58:17,021 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: HikingDestinations,NumberOfHikingDestinations
     2018-08-16 09:58:17,021 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: HikingDestinations,ActivityGrading
     2018-08-16 09:58:17,021 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: HikingDestinations,Mobile
     2018-08-16 09:58:17,022 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: NoZipCodes,ID
     2018-08-16 09:58:17,022 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: NoZipCodes,PostNr
     2018-08-16 09:58:17,022 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: NoZipCodes,Poststed
     2018-08-16 09:58:17,023 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: NoZipCodes,KommuneNr
     2018-08-16 09:58:17,023 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: NoZipCodes,Kommunenavn
     2018-08-16 09:58:17,023 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: NoZipCodes,Kategori
     2018-08-16 09:58:17,024 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: NoZipCodes,ImagePath
     2018-08-16 09:58:17,024 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberAccessLog,Id
     2018-08-16 09:58:17,024 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberAccessLog,MemberId
     2018-08-16 09:58:17,025 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberAccessLog,UserId
     2018-08-16 09:58:17,025 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberAccessLog,Timestamp
     2018-08-16 09:58:17,025 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberAccessLog,IpAddress
     2018-08-16 09:58:17,026 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberAccessLog,Action
     2018-08-16 09:58:17,030 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberLog,Id
     2018-08-16 09:58:17,031 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberLog,UserId
     2018-08-16 09:58:17,038 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberLog,Date
     2018-08-16 09:58:17,038 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberLog,IP
     2018-08-16 09:58:17,039 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberLog,AuditAction
     2018-08-16 09:58:17,039 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoMemberLog,Url
     2018-08-16 09:58:17,040 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoUserLog,Id
     2018-08-16 09:58:17,040 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoUserLog,PerformingUserId
     2018-08-16 09:58:17,041 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoUserLog,AffectedUserId
     2018-08-16 09:58:17,042 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoUserLog,Username
     2018-08-16 09:58:17,042 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoUserLog,AuditEvent
     2018-08-16 09:58:17,043 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoUserLog,IpAddress
     2018-08-16 09:58:17,043 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: perplexUmbracoUserLog,Timestamp
     2018-08-16 09:58:17,044 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: Postnummer,ID
     2018-08-16 09:58:17,044 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: Postnummer,Postnummer
     2018-08-16 09:58:17,045 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: Postnummer,Poststed
     2018-08-16 09:58:17,045 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: Postnummer,Kommunenummer
     2018-08-16 09:58:17,046 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: Postnummer,Kommunenavn
     2018-08-16 09:58:17,047 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: Postnummer,Kategori
     2018-08-16 09:58:17,048 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FK_HikingDestinations__nodeId_cmsMember_nodeId
     2018-08-16 09:58:17,049 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_HikingDestination
     2018-08-16 09:58:17,050 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_NoZipCodes
     2018-08-16 09:58:17,050 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_perplexUmbracoMemberAccessLog
     2018-08-16 09:58:17,051 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_perplexUmbracoMemberLog
     2018-08-16 09:58:17,052 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_perplexUmbracoUserLog
     2018-08-16 09:58:17,052 [P12332/D10/T73] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_Postnummer
    

    How can I fix these errors?

  • Sebastiaan Janssen 4669 posts 13087 karma points MVP admin hq
    Aug 16, 2018 @ 08:48
    Sebastiaan Janssen
    0

    Seems fine, none of these are Umbraco tables.

    So the question is: how should Umbraco fix showing these errors? 😉

  • Sebastiaan Janssen 4669 posts 13087 karma points MVP admin hq
    Aug 16, 2018 @ 08:50
    Sebastiaan Janssen
    1

    I've created an issue for it: http://issues.umbraco.org/issue/U4-11580

  • Tom Engan 430 posts 1163 karma points
    Aug 16, 2018 @ 08:55
    Tom Engan
    0

    Health Check on Database Schedule Validation appears to be new in version 7.12.0, so it's just fine that you created an issue. I suppose customs tables work just as well as before (will of course be tested..).

  • Umbraco Newbie 22 posts 124 karma points
    Sep 25, 2018 @ 21:08
    Umbraco Newbie
    2

    Hi

    Just upgraded to Umbraco version 7.12.3 assembly: 1.0.6837.12334 and can confirm this is still an issue with custom tables.

    I have a custom table that stores 120,000 IMEI numbers on a customers website allowing customers to search for their phone. Don't really want to store them in Umbraco so a custom table works fine, but this is flagged up in the back office when doing a health check.

    Does not appear to affect performance

  • Thomas 126 posts 278 karma points
    Oct 08, 2018 @ 08:27
    Thomas
    0

    I just upgrade my site from v7.5.11 to v7.12.3 and i am facing the same issue. 81 errors which are the followings...

    2018-10-08 11:08:48,555 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Some errors were detected while validating the database schema against the current version of Umbraco. 2018-10-08 11:08:48,555 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: CMUmbracoToolsSettings 2018-10-08 11:08:48,555 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: CMUmbracoToolsPermanentRedirects 2018-10-08 11:08:48,555 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecords 2018-10-08 11:08:48,555 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordFields 2018-10-08 11:08:48,555 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordDataString 2018-10-08 11:08:48,555 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordDataLongString 2018-10-08 11:08:48,555 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordDataInteger 2018-10-08 11:08:48,555 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordDataBit 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordDataDateTime 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFUserSecurity 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFUserFormSecurity 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: CMUmbracoToolsSettings,SettingID 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: CMUmbracoToolsSettings,Application 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: CMUmbracoToolsSettings,Name 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: CMUmbracoToolsSettings,Value 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: CMUmbracoToolsPermanentRedirects,PermanentRedirectID 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: CMUmbracoToolsPermanentRedirects,OriginalURL 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: CMUmbracoToolsPermanentRedirects,RedirectURL 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: CMUmbracoToolsPermanentRedirects,Notes 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,Id 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,Form 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,Created 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,Updated 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,CurrentPage 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,UmbracoPageId 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,IP 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,MemberKey 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,UniqueId 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,State 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,RecordData 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordFields,Key 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordFields,FieldId 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordFields,Record 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordFields,Alias 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordFields,DataType 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataString,Id 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataString,Key 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataString,Value 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataLongString,Id 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataLongString,Key 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataLongString,Value 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataInteger,Id 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataInteger,Key 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataInteger,Value 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataBit,Id 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataBit,Key 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataBit,Value 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataDateTime,Id 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataDateTime,Key 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataDateTime,Value 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserSecurity,User 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserSecurity,ManageDataSources 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserSecurity,ManagePreValueSources 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserSecurity,ManageWorkflows 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserSecurity,ManageForms 2018-10-08 11:08:48,571 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,Id 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,User 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,Form 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,HasAccess 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,AllowInEditor 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,SecurityType 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Index: IXdatabitrecordfield 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Index: IXdatadatetimerecordfield 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Index: IXdataintegerrecordfield 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Index: IXdatalongstringrecordfield 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Index: IXdatastringrecordfield 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Unknown: Id 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKUFRecordDataBitUFRecordFieldsKey 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKUFRecordDataDateTimeUFRecordFieldsKey 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKUFRecordDataIntegerUFRecordFieldsKey 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKUFRecordDataLongStringUFRecordFieldsKey 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKUFRecordDataStringUFRecordFieldsKey 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PKCMUmbracoToolsPermanentRedirects 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PKCMUmbracoToolsSettings 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PKUFRecordDataBit 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PKUFRecordDataDateTime 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PKUFRecordDataInteger 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PKUFRecordDataLongString 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PKUFRecordDataString 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PKUFRecordFields 2018-10-08 11:08:48,586 [P19988/D10/T52] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PKUFRecords

  • Andreas 6 posts 76 karma points
    1 week ago
    Andreas
    0

    I just updated to Umbraco 7.12.1 and I got 22 errors as well, but this seems to be umbraco tables/fields.

    2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Some errors were detected while validating the database schema against the current version of Umbraco. 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKumbracoRedirectUrl 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsContentcmsContentTypenodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsContentVersioncmsContentnodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDocumentcmsContentnodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDocumentcmsTemplatenodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDocumentTypecmsContentTypenodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDocumentTypecmsTemplatenodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDataTypePreValuescmsDataTypenodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDictionarycmsDictionarayid 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsLanguageTextcmsDictionaryid 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsMemberTypecmsContentTypenodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsMembercmsContentnodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsContentXmlcmsContentnodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsPreviewXmlcmsContentnodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsPreviewXmlcmsContentVersionVersionId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsPropertyTypeGroupcmsContentTypenodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsPropertyTypecmsDataTypenodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsPropertyTypecmsContentTypenodeId 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsTagRelationshipcmsContent 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsContentTypeAllowedContentTypecmsContentType 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsContentTypeAllowedContentTypecmsContentType1 2018-12-03 09:56:43,838 [P2964/D2/T24] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKumbracoRedirectUrlumbracoNode_uniqueID

Please Sign in or register to post replies

Write your reply to:

Draft