Problem Note 69382: The SAS® Visual Investigator sand service does not start after an update
 |  |  |  |  |
After a SAS Visual Investigator upgrade to 10.8 from Hot Fix 10.6 or Hot Fix 10.7, the svi-sand service fails to start and returns errors similar to the following in the svi-sand-service log:
Error Code : 0
Message : Unable to apply flyway changes to specified connection and schema [sandconfig]
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:342)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:113)
at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:692)
at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:509)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1341)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1181)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:556)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:374)
... 155 common frames omitted
Caused by: 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.internal.exception.FlywaySqlException:
Unable to obtain connection from database: Unable to apply flyway changes to specified connection and schema [sandconfig]
To work around this issue, run the following steps on every tenant database or tenant schema (including the sharedservices database or schema), depending on how your multi-tenancy is configured:
# Execute the following SQL
delete from sandconfig.schema_version where script = 'V11_3_1__reset_task_table.sql'
# Restart the svi-sand service
Ideally, you should run the above steps before the upgrade, but you can run them after the upgrade to allow the sand service to start up successfully.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Investigator | Linux for x64 | 10.8 | Viya | ||
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesAn 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#69382| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2022-09-22 09:44:22 |
| Date Created: | 2022-07-08 12:32:35 |