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

            team-echo Product Team Echo
            koor.gai Koor Gai (Inactive)
            Felipe Lins Felipe Lins
            Jürgen Kappler Jürgen Kappler
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              1 year, 16 weeks, 5 days ago

              Packages

                Version Package
                7.3.X
                7.4.13 DXP GA1
                7.4.3.4 CE GA4
                Master
                7.3.10 DXP U17