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

• Type: Bug
• Status: Verified
• Resolution: Unresolved
• Affects Version/s: 7.2.X, Master
• Fix Version/s: None
• Component/s: Core Infrastructure, Environments > Databases
• Labels:
  • 7.3-known-issues
  • QA-AUTOMATION
  • liferay-ga6-ce-735
• Fix Priority: 3
• QA Test Name:
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive70106
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive7110
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive71103
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchiveAutoUpgrade70106
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchiveAutoUpgrade7110
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchiveAutoUpgrade71103
  • LocalFile.SearchUpgrade#ViewClassicSearchPortletConfigurationArchiveAutoUpgrade70106
  • LocalFile.SearchUpgrade#ViewClassicSearchPortletConfigurationArchiveAutoUpgrade7110
  • LocalFile.SearchUpgrade#ViewSearchPortletsConfigurationArchiveAutoUpgrade7110
• QA Test Score: 45

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.