Below exception is thrown after executing startup script for Analytic Engine.
Servers intsalled: MWS 9.9, IS 9.9, AE 9.9, DC9.9, UM server. Oracle DB with executed Optimize product create from Database configurator tool. AE was installed after MWS and IS.
Unable to start the engine: Error creating bean with name ‘processAnalyticsService’ defined in file [/opt/webMethods/optimize/analysis/conf/spring/uiservices.spring.xml]: Cannot resolve reference to bean ‘diagramAnalytics’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘diagramAnalytics’ defined in file [/opt/webMethods/optimize/analysis/conf/spring/uiservices.spring.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.webMethods.optimize.service.processanalytics.DiagramAnalytics]: Constructor threw exception; nested exception is java.lang.NullPointerException
jvm 5 | org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘processAnalyticsService’ defined in file [/opt/webMethods/optimize/analysis/conf/spring/uiservices.spring.xml]: Cannot resolve reference to bean ‘diagramAnalytics’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘diagramAnalytics’ defined in file [/opt/webMethods/optimize/analysis/conf/spring/uiservices.spring.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.webMethods.optimize.service.processanalytics.DiagramAnalytics]: Constructor threw exception; nested exception is java.lang.NullPointerException
jvm 5 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
jvm 5 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
jvm 5 | at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:616)
jvm 5 | at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148)
jvm 5 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003)
jvm 5 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907)
jvm 5 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
jvm 5 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
jvm 5 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
jvm 5 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
jvm 5 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
jvm 5 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192)
jvm 5 | at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585)
jvm 5 | at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
jvm 5 | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
jvm 5 | at com.webMethods.optimize.service.external.spring.SpringLoader.createApplicationContext(SpringLoader.java:43)
jvm 5 | at com.webMethods.optimize.service.external.util.HttpWSServer.startEngineServices(HttpWSServer.java:167)
jvm 5 | at com.webMethods.optimize.service.external.util.HttpWSServer.start(HttpWSServer.java:142)
jvm 5 | at com.webMethods.optimize.stack.Stack.(Stack.java:68)
jvm 5 | at com.webMethods.optimize.stack.Stack.main(Stack.java:393)
jvm 5 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
jvm 5 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
jvm 5 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
jvm 5 | at java.lang.reflect.Method.invoke(Method.java:498)
jvm 5 | at org.tanukisoftware.wrapper.WrapperStartStopApp.run(WrapperStartStopApp.java:264)
jvm 5 | at java.lang.Thread.run(Thread.java:745)
jvm 5 | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘diagramAnalytics’ defined in file [/opt/webMethods/optimize/analysis/conf/spring/uiservices.spring.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.webMethods.optimize.service.processanalytics.DiagramAnalytics]: Constructor threw exception; nested exception is java.lang.NullPointerException
jvm 5 | at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:288)
jvm 5 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003)
jvm 5 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907)
jvm 5 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
jvm 5 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
jvm 5 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
jvm 5 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
jvm 5 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
jvm 5 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192)
jvm 5 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
jvm 5 | … 25 more
jvm 5 | Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.webMethods.optimize.service.processanalytics.DiagramAnalytics]: Constructor threw exception; nested exception is java.lang.NullPointerException
jvm 5 | at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:141)
jvm 5 | at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:108)
jvm 5 | at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:280)
jvm 5 | … 34 more
jvm 5 | Caused by: java.lang.NullPointerException
jvm 5 | at com.webMethods.optimize.service.processanalytics.DiagramAnalytics.createStepInstanceCountsQuerySQL(DiagramAnalytics.java:323)
jvm 5 | at com.webMethods.optimize.service.processanalytics.DiagramAnalytics.(DiagramAnalytics.java:79)
jvm 5 | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
jvm 5 | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
jvm 5 | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
jvm 5 | at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
jvm 5 | at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:126)
jvm 5 | … 36 more
jvm 5 | (OPTIMIZE) [Analytic Engine v9.9.0.0.Stack.UnknownKey] 2018-06-29 11:51:33.53 UTC ERROR: Unable to start the engine.
jvm 5 | (OPTIMIZE) [Analytic Engine v9.9.0.0.Stack.UnknownKey] 2018-06-29 11:51:33.53 UTC ERROR: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘processAnalyticsService’ defined in file [/opt/webMethods/optimize/analysis/conf/spring/uiservices.spring.xml]: Cannot resolve reference to bean ‘diagramAnalytics’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘diagramAnalytics’ defined in file [/opt/webMethods/optimize/analysis/conf/spring/uiservices.spring.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.webMethods.optimize.service.processanalytics.DiagramAnalytics]: Constructor threw exception; nested exception is java.lang.NullPointerException
jvm 5 | (OPTIMIZE) [Analytic Engine v9.9.0.0.Stack.UnknownKey] 2018-06-29 11:51:33.53 UTC ERROR: at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
jvm 5 | (OPTIMIZE) [Analytic Engine v9.9.0.0.Stack.UnknownKey] 2018-06-29 11:51:33.53 UTC ERROR: wraps: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘diagramAnalytics’ defined in file [/opt/webMethods/optimize/analysis/conf/spring/uiservices.spring.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.webMethods.optimize.service.processanalytics.DiagramAnalytics]: Constructor threw exception; nested exception is java.lang.NullPointerException
jvm 5 | (OPTIMIZE) [Analytic Engine v9.9.0.0.Stack.UnknownKey] 2018-06-29 11:51:33.53 UTC ERROR: at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
jvm 5 | (OPTIMIZE) [Analytic Engine v9.9.0.0.Stack.UnknownKey] 2018-06-29 11:51:33.53 UTC ERROR: wraps: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.webMethods.optimize.service.processanalytics.DiagramAnalytics]: Constructor threw exception; nested exception is java.lang.NullPointerException
jvm 5 | (OPTIMIZE) [Analytic Engine v9.9.0.0.Stack.UnknownKey] 2018-06-29 11:51:33.53 UTC ERROR: at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
jvm 5 | (OPTIMIZE) [Analytic Engine v9.9.0.0.Stack.UnknownKey] 2018-06-29 11:51:33.53 UTC ERROR: wraps: java.lang.NullPointerException: null
jvm 5 | at com.webMethods.optimize.service.processanalytics.DiagramAnalytics.createStepInstanceCountsQuerySQL(DiagramAnalytics.java:323)
jvm 5 | at com.webMethods.optimize.service.processanalytics.DiagramAnalytics.(DiagramAnalytics.java:79)
jvm 5 | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
jvm 5 | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
jvm 5 | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
jvm 5 | at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
jvm 5 | at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:126)
jvm 5 | at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:108)
jvm 5 | at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:280)
jvm 5 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003)
jvm 5 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907)
jvm 5 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
jvm 5 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
jvm 5 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
jvm 5 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
jvm 5 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
jvm 5 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192)
jvm 5 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
jvm 5 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
jvm 5 | at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:616)
jvm 5 | at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148)
jvm 5 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003)
jvm 5 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907)
jvm 5 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
jvm 5 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
jvm 5 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
jvm 5 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
jvm 5 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
jvm 5 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192)
jvm 5 | at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585)
jvm 5 | at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
jvm 5 | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
jvm 5 | at com.webMethods.optimize.service.external.spring.SpringLoader.createApplicationContext(SpringLoader.java:43)
jvm 5 | at com.webMethods.optimize.service.external.util.HttpWSServer.startEngineServices(HttpWSServer.java:167)
jvm 5 | at com.webMethods.optimize.service.external.util.HttpWSServer.start(HttpWSServer.java:142)
jvm 5 | at com.webMethods.optimize.stack.Stack.(Stack.java:68)
jvm 5 | at com.webMethods.optimize.stack.Stack.main(Stack.java:393)
jvm 5 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
jvm 5 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
jvm 5 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
jvm 5 | at java.lang.reflect.Method.invoke(Method.java:498)
jvm 5 | at org.tanukisoftware.wrapper.WrapperStartStopApp.run(WrapperStartStopApp.java:264)
jvm 5 | at java.lang.Thread.run(Thread.java:745)
jvm 5 | (OPTIMIZE) [Analytic Engine v9.9.0.0.HttpWSServer.serverExiting] 2018-06-29 11:51:33.61 UTC INFO: Server exiting due to [Startup failure]