Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

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


  • Frans de Jong 548 posts 1840 karma points MVP 4x c-trib
    Sep 13, 2018 @ 07:39
    Frans de Jong
    0

    Database schema validation after update

    Hi All,

    After I updated a site to the latest version of Umbraco and Umbraco forms I did the healthcheck. I now see a new category called database schema validation and it has 69 problems (reminds me of a talk last codegarden ;-) )

    It looks like something is wrong with the Umbraco forms update?

    Anyone knows whats going on here?

         2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFUserSecurity
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFUserFormSecurity
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecords
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordFields
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordDataString
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordDataLongString
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordDataInteger
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordDataBit
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Table: UFRecordDataDateTime
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserSecurity,User
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserSecurity,ManageDataSources
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserSecurity,ManagePreValueSources
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserSecurity,ManageWorkflows
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserSecurity,ManageForms
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,Id
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,User
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,Form
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,HasAccess
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,AllowInEditor
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFUserFormSecurity,SecurityType
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,Id
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,Form
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,Created
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,Updated
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,CurrentPage
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,UmbracoPageId
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,IP
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,MemberKey
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,UniqueId
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,State
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecords,RecordData
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordFields,Key
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordFields,FieldId
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordFields,Record
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordFields,Alias
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordFields,DataType
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataString,Id
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataString,Key
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataString,Value
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataLongString,Id
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataLongString,Key
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataLongString,Value
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataInteger,Id
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataInteger,Key
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataInteger,Value
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataBit,Id
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataBit,Key
     2018-09-13 09:32:08,388 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataBit,Value
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataDateTime,Id
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataDateTime,Key
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Column: UFRecordDataDateTime,Value
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Index: IX_databit_recordfield
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Index: IX_datadatetime_recordfield
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Index: IX_datainteger_recordfield
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Index: IX_datalongstring_recordfield
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Index: IX_datastring_recordfield
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Unknown: Id
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FK_UFRecordDataBit_UFRecordFields_Key
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FK_UFRecordDataDateTime_UFRecordFields_Key
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FK_UFRecordDataInteger_UFRecordFields_Key
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FK_UFRecordDataLongString_UFRecordFields_Key
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FK_UFRecordDataString_UFRecordFields_Key
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_UFRecordDataBit
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_UFRecordDataDateTime
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_UFRecordDataInteger
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_UFRecordDataLongString
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_UFRecordDataString
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_UFRecordFields
     2018-09-13 09:32:08,403 [P15848/D2/T243] WARN  Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: PK_UFRecords
    Copy Link
  • Kevin Jump 2342 posts 14869 karma points MVP 8x c-trib
    Sep 13, 2018 @ 08:27
    Kevin Jump
    100

    Hi Frans,

    I think you can safely ignore them.

    The Database Validation health check reports anything that isn't part of the core umbraco schema (including the tables in forms!).

    there is an issue for this https://issues.umbraco.org/issue/U4-11580

    i think the intention is to ignore the custom tables in future releases.

    Kevin

    Copy Link
  • Frans de Jong 548 posts 1840 karma points MVP 4x c-trib
    Sep 13, 2018 @ 08:40
    Frans de Jong
    0

    Ok, thanks!

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft