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

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.2.X, 7.3.X, Master
• Fix Version/s: 7.4.13 DXP GA1, 7.4.3.4 CE GA4, Master
• Component/s: Pages > Page Administration
• Labels:
  • 7.3-known-issues
  • 7.4-known-issues
  • QA-AUTOMATION
  • liferay-ga1-ce-740
  • liferay-ga2-ce-741
  • liferay-ga6-ce-735
  • liferay-ga7-ce-736
  • liferay-ga8-ce-737
  • pt-upgrade-review
  • upgrade_stability_audit
• Fix Priority: 4
• Git Pull Request: https://github.com/liferay-echo/liferay-portal/pull/5472
• Bug Type: Database Upgrade
• QA Test Name:
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive70106
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive7110
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive71103
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchiveAutoUpgrade70106
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchiveAutoUpgrade7110
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchiveAutoUpgrade71103
• QA Test Score: 30

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.