Hi,

I installed arserver+myit and smartIT on a single server then,

I moved  AR server+myit and smart IT application from one server to another where we just copied that VM to another New location:

Product Version:

Remedy with Smart IT 2.0.00.001

Digital Workplace 18.02.00

I did changes in following file for reference for new server but it is not working:

  Location: C:\Program Files\Apache Software Foundation\Tomcat8.5\external-conf

     Connection.properties file--> server references update

     Location: C:\Program Files\Apache Software Foundation\Tomcat8.5\conf\Catalina\localhost

     ux.xml --> database references update

     C:\Program Files\BMC Software\Smart_IT_MyIT\Smart_IT_MyIT\openfire\conf

     openfire.xml--> update database references

     ON Remedy Application End Update MyIT Administration Console:

     Applications Persistent data Stores-- update previous server to new server

     On Database End  update references in following tables:

    PROVIDER_SETTINGS

      CONFIGURATION_PARAMETER

Please suggest How to fix this because after changes above all stuff , still myit and smarit application url does not open on new server.

I found Error in Log file localhost.2019-04-29.log as below:

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'locationFloorMapAssetActionDao' defined in class path resource [app-context-jpa.xml]: Cannot resolve reference to bean 'pluggableProviderManager' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'pluggableProviderManager': Invocation of init method failed; nested exception is com.bmc.bsm.myit.service.exceptions.ServiceException: com.bmc.bsm.myit.dao.DaoException

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)

at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:648)

at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:145)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1148)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1051)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:510)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:751)

at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:861)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:541)

at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444)

at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326)

at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4745)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5207)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:630)

at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1842)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'pluggableProviderManager': Invocation of init method failed; nested exception is com.bmc.bsm.myit.service.exceptions.ServiceException: com.bmc.bsm.myit.dao.DaoException

at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:136)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:408)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1575)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)

... 30 more

Caused by: com.bmc.bsm.myit.service.exceptions.ServiceException: com.bmc.bsm.myit.dao.DaoException

at com.bmc.bsm.myit.service.system.ProviderServiceImpl.getByClass(ProviderServiceImpl.java:81)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)

at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)

at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)

at com.sun.proxy.$Proxy83.getByClass(Unknown Source)

at com.bmc.bsm.myit.providers.PluggableProviderManagerImpl.createProviderFactory(PluggableProviderManagerImpl.java:516)

at com.bmc.bsm.myit.providers.PluggableProviderManagerImpl.loadProviders(PluggableProviderManagerImpl.java:503)

at com.bmc.bsm.myit.providers.PluggableProviderManagerImpl.initialize(PluggableProviderManagerImpl.java:556)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:365)

at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:310)

at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:133)

... 39 more

Caused by: com.bmc.bsm.myit.dao.DaoException

at com.bmc.bsm.myit.dao.jpa.system.ProviderDaoJpaImpl.getByProviderClass(ProviderDaoJpaImpl.java:45)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)

at com.sun.proxy.$Proxy82.getByProviderClass(Unknown Source)

at com.bmc.bsm.myit.service.system.ProviderServiceImpl.getByClass(ProviderServiceImpl.java:79)

... 62 more

Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'PROVIDER'.

Error Code: 208

Call: SELECT PK, ACTIVE, ID, NAME, PROVIDER_CLASS FROM PROVIDER WHERE (PROVIDER_CLASS = ?)

bind => [com.bmc.bsm.myit.providers.hrcm.srm.HrcmPluggableProviderFactory]

Query: ReadAllQuery(name="Provider.selectByProviderClass" referenceClass=Provider sql="SELECT PK, ACTIVE, ID, NAME, PROVIDER_CLASS FROM PROVIDER WHERE (PROVIDER_CLASS = ?)")

at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:378)

at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:260)

at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:469)

at com.bmc.bsm.myit.dao.jpa.system.ProviderDaoJpaImpl.getByProviderClass(ProviderDaoJpaImpl.java:43)

... 70 more

Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'PROVIDER'.