-
Type:
Bug
-
Status: Verified
-
Resolution: Unresolved
-
Affects Version/s: 7.2.X, Master
-
Fix Version/s: None
-
Component/s: Core Infrastructure, Environments > Databases
-
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:
- Populate SQLServer 2017 database with the attached data
- 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.
- is duplicated by
-
LPS-99861 Upgrade to 7.2: Column publishDate does not exist in table Layout
- Verified