有一段时间自用的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服务就变成这个样子):
重新启动Bot Insight的方法是:
在服务里找到Automation Anywhere Bot Insight Service Discovery,选择重新启动。
重新启动完毕后等2分钟再登录,世界和平了~