Problem Note 62801: Deploying services for a SASĀ® Visual Investigator 10.4 update might fail with a BeanCreationException error
After you update SAS Visual Investigator 10.3.1 (with Hot Fix 3 or a later hot fix) to SAS Visual Investigator 10.4 (without hot fixes), the Visual Investigator services can fail to start with an exception that is similar to the following:
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.api.FlywayException: Validate failed: Detected applied migration not resolved locally: 1.34.1
The workaround for this issue can be performed before or after the update to SAS Visual Investigator 10.4. The workaround is to manually run the following SQL command either on the SharedServices database for a non-multi-tenant system, or on the tenant databases for a multi-tenant system:
DELETE FROM "svi_visual_investigator"."svi_schema_version" WHERE version IN ('1.34.1', '1.34.2')
The SAS Visual Investigator services need to be restarted afterward.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Verify That the Update Is Installed
To verify that the fix is installed, run the following rpm command:
rpm -qa | grep sas-svi-visual-investigator-7.1.53
To complete this process, make sure that the package version that is shown in the rpm output either matches or is newer than 7.1.53 with the following command:
rpm -qi sas-svi-visual-investigator
Additional Assistance
If you need additional assistance, contact SAS Technical Support.
Operating System and Release Information
SAS System | SAS Visual Investigator | Linux for x64 | 10.4 | 10.4 | Viya | Viya |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Updating to SAS Visual Investigator 10.4 (without any hot fixes) from SAS Visual Investigator 10.3.1 Hot Fix 3 (or any later hot fix) can cause the Visual Investigator services to fail during start-up.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2018-08-23 09:31:20 |
Date Created: | 2018-08-21 10:10:08 |