Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-119128

Column publishDate does not exist in table Layout - SQL Server upgrade

    Description

    Steps to reproduce:

    1. Populate SQLServer 2017 database with the attached data
    2. Run upgrade

    Expected result:

    Upgrade is successful without error.

    Actual result:

    The following error and warning are thrown.

    error:

    [java] 2020-08-12 09:48:53.899 ERROR [main][BaseUpgradeSQLServerDatetime:97] Column publishDate does not exist in table Layout 

    Warnings:

    [java] 2020-08-12 10:01:11.035 WARN  [main][BaseUpgradeSQLServerDatetime:109] Column statusDate in table KaleoDefinitionVersion already is datetime2(6)
         [java] 2020-08-12 10:01:11.043 WARN  [main][BaseUpgradeSQLServerDatetime:109] Column modifiedDate in table KaleoDefinitionVersion already is datetime2(6)
         [java] 2020-08-12 10:01:11.051 WARN  [main][BaseUpgradeSQLServerDatetime:109] Column createDate in table KaleoDefinitionVersion already is datetime2(6) 
    
    
    [java] 2020-08-12 09:50:20.031 WARN  [main][BaseUpgradeSQLServerDatetime:109] Column lastPublishDate in table DDMFormInstanceRecord already is datetime2(6)
         [java] 2020-08-12 09:50:20.040 WARN  [main][BaseUpgradeSQLServerDatetime:109] Column modifiedDate in table DDMFormInstanceRecord already is datetime2(6)
         [java] 2020-08-12 09:50:20.049 WARN  [main][BaseUpgradeSQLServerDatetime:109] Column createDate in table DDMFormInstanceRecord already is datetime2(6)
         [java] 2020-08-12 09:50:20.059 WARN  [main][BaseUpgradeSQLServerDatetime:109] Column statusDate in table DDMFormInstanceRecordVersion already is datetime2(6)
         [java] 2020-08-12 09:50:20.066 WARN  [main][BaseUpgradeSQLServerDatetime:109] Column createDate in table DDMFormInstanceRecordVersion already is datetime2(6)
         [java] 2020-08-12 09:50:20.077 WARN  [main][BaseUpgradeSQLServerDatetime:109] Column lastPublishDate in table DDMFormInstance already is datetime2(6)
         [java] 2020-08-12 09:50:20.087 WARN  [main][BaseUpgradeSQLServerDatetime:109] Column modifiedDate in table DDMFormInstance already is datetime2(6)
         [java] 2020-08-12 09:50:20.097 WARN  [main][BaseUpgradeSQLServerDatetime:109] Column createDate in table DDMFormInstance already is datetime2(6)
         [java] 2020-08-12 09:50:20.106 WARN  [main][BaseUpgradeSQLServerDatetime:109] Column statusDate in table DDMFormInstanceVersion already is datetime2(6)
         [java] 2020-08-12 09:50:20.115 WARN  [main][BaseUpgradeSQLServerDatetime:109] Column createDate in table DDMFormInstanceVersion already is datetime2(6)
    
    [java] 2020-08-12 10:02:00.464 WARN  [main][BaseUpgradeSQLServerDatetime:109] Column lastPublishDate in table LayoutPageTemplateCollection already is datetime2(6)
         [java] 2020-08-12 10:02:00.475 WARN  [main][BaseUpgradeSQLServerDatetime:109] Column modifiedDate in table LayoutPageTemplateCollection already is datetime2(6)
         [java] 2020-08-12 10:02:00.484 WARN  [main][BaseUpgradeSQLServerDatetime:109] Column createDate in table LayoutPageTemplateCollection already is datetime2(6)
         [java] 2020-08-12 10:02:00.495 WARN  [main][BaseUpgradeSQLServerDatetime:109] Column statusDate in table LayoutPageTemplateEntry already is datetime2(6)
         [java] 2020-08-12 10:02:00.506 WARN  [main][BaseUpgradeSQLServerDatetime:109] Column lastPublishDate in table LayoutPageTemplateEntry already is datetime2(6)
         [java] 2020-08-12 10:02:00.516 WARN  [main][BaseUpgradeSQLServerDatetime:109] Column modifiedDate in table LayoutPageTemplateEntry already is datetime2(6)
         [java] 2020-08-12 10:02:00.524 WARN  [main][BaseUpgradeSQLServerDatetime:109] Column createDate in table LayoutPageTemplateEntry already is datetime2(6)
      

    Reproduced on:
    7.0.10.6 > Master: f58ef75a756bf008ab5b2de50bcd2c295d04d89a
    7.1.10 > Master: f58ef75a756bf008ab5b2de50bcd2c295d04d89a
    7.1.10.3 > Master: f58ef75a756bf008ab5b2de50bcd2c295d04d89a

    7.0.10.6 > 7.2.x: 4781a40d6e74b1eb8a99c68c4c43ece96e1b3337
    7.1.10 > 7.2.x: 4781a40d6e74b1eb8a99c68c4c43ece96e1b3337
    7.1.10.3 > 7.2.x: 4781a40d6e74b1eb8a99c68c4c43ece96e1b3337

    Not Reproducible on:
    7.2.10 > Master: f58ef75a756bf008ab5b2de50bcd2c295d04d89a.

      Attachments

        Issue Links

          Activity

            People

            Assignee:
            support-lep@liferay.com SE Support
            Reporter:
            koor.gai Koor Gai
            Participants of an Issue:
            Recent user:
            Sharry Shi
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Days since last comment:
              2 weeks, 3 days ago

                Packages

                Version Package