Problem Note 70070: Upgrade fails with error "... MigrateLegacyTimestampFields Failed! Changes successfully rolled back"
 |  |  |  |  |
If you have configured child entities and are upgrading to SAS® Visual Investigator version 10.8, the upgrade process might fail. In this scenario, the datahub log contains an error similar to the following:
2022-11-29 21:24:35.451 ERROR 1998 — [askBootstrap-11] c.s.f.d.c.s.v.VersionedValidator : sas.svi-datahub Version mismatch for object com.sas.fcs.datahub.core.metamodel.dto.StoredObjectDTO@167a8454[historyTableName=<null>,lastUpdatedByUserIdFieldName=<null>,versionNumberFieldName=<null>,createFlagHistoryColumnName=<null>,deleteFlagHistoryColumnName=<null>,deleteTableName=<null>,updateFlagHistoryColumnName=<null>]. New version: 142. Old version: 163
2022-11-29 21:24:35.466 ERROR 1998 — [askBootstrap-11] o.f.core.internal.command.DbMigrate : sas.svi-datahub Migration of schema "fdhmetadata" to version "10.8.0.6 - MigrateLegacyTimestampFields" failed! Changes successfully rolled back.
2022-11-29 21:24:35.466 ERROR 1998 — [askBootstrap-11] o.f.core.internal.command.DbMigrate : sas.svi-datahub Migration of schema "fdhmetadata" to version "10.8.0.6 - MigrateLegacyTimestampFields" failed! Changes successfully rolled back.
This problem is caused by time stamp updates to child objects, which in turn increment the version number of the parent object. When the parent object is updated, it is at the wrong version.
Click the Hot Fix tab in this note to access the hot fix for this issue.
With this fix, the latest version of an entity type is used before migrating that object.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Investigator (on SAS Viya 3.x) | Linux for x64 | 10.8 | Viya | ||
An update for this issue is available for SAS Visual Investigator 10.8. For instructions on how to access and apply these software updates, see the documentation links at the top of
https://tshf.sas.com/techsup/download/hotfix/HF2/Viya_VI_10_8_home.html#70070| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2023-05-05 11:06:39 |
| Date Created: | 2023-05-04 13:33:23 |