Automation Anywhere控制中心报错备忘录

有一段时间自用的CR总是报错，放置了很久。知道是Bot Insight的服务出错了，没什么动力修改。

{"code":"UM1117","details":null,"message":"Access token expected in the 'X-Authorization' header"}

这周末为了体检基本没吃饭，饿昏了。转移注意力吧算是，琢磨这个事儿了。
C:\ProgramData\AutomationAnywhere\Logs\zoomdata.log里看到以下错误。

2019-12-28 22:23:21,739 INFO  [, , ] [liquibase] Reading from [BIVisualization].[dbo].[DATABASECHANGELOG] 
2019-12-28 22:23:22,125 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:23:32,128 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:23:42,137 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:23:52,144 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:24:02,238 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:24:12,243 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:24:22,250 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:24:32,254 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:24:42,264 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:24:52,268 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:25:02,334 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:25:12,339 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:25:22,347 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:25:32,353 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:25:42,358 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:25:52,363 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:26:02,367 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:26:12,372 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:26:22,376 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:26:32,383 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:26:42,387 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:26:52,392 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:27:02,397 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:27:12,403 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:27:22,408 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:27:32,413 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:27:42,419 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:27:52,429 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:28:02,436 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:28:12,449 INFO  [, , ] [liquibase] Waiting for changelog lock.... 
2019-12-28 22:28:22,494 ERROR [, , ] [o.s.b.SpringApplication] Application run failed 
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in com.zoomdata.dao.liquibase.LiquibaseConfiguration: Invocation of init method failed; nested exception is liquibase.exception.LockException: Could not acquire change log lock.  Currently locked by WIN-QE8QUS8C9HU (10.0.1.13) since 19-12-2 上午10:24
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1708)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:581)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:503)
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:317)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:760)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:869)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550)
    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:759)
    at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:395)
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:327)
    at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:137)
    at org.springframework.boot.builder.SpringApplicationBuilder.configureAsChildIfNecessary(SpringApplicationBuilder.java:150)
    at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:133)
    at com.zoomdata.web.ZoomdataMain.main(ZoomdataMain.java:97)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
    at org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
    at org.springframework.boot.loader.Launcher.launch(Launcher.java:50)
    at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51)
Caused by: liquibase.exception.LockException: Could not acquire change log lock.  Currently locked by WIN-QE8QUS8C9HU (10.0.1.13) since 19-12-2 上午10:24
    at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:187)
    at liquibase.Liquibase.update(Liquibase.java:196)
    at liquibase.Liquibase.update(Liquibase.java:192)
    at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:434)
    at com.zoomdata.dao.liquibase.LiquibaseConfiguration$1.afterPropertiesSet(LiquibaseConfiguration.java:87)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1767)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1704)
    ... 24 common frames omitted
2019-12-28 22:28:34,960 INFO  [, , ] [c.z.w.ZoomdataMain] The following profiles are active: sqlserver,default 
2019-12-28 22:28:39,874 INFO  [, , ] [liquibase] Reading from [BIVisualization].[dbo].[DATABASECHANGELOG] 

既然时lock了，呵呵。。。手动改掉Locked为False。以下是示意图（改过后重新启动Bot Insight服务就变成这个样子）：

image.png

重新启动Bot Insight的方法是：
在服务里找到Automation Anywhere Bot Insight Service Discovery，选择重新启动。

image.png
重新启动完毕后等2分钟再登录，世界和平了~