2 Replies Latest reply on May 6, 2019 9:13 AM by Marek Ceizel

    MyIT and SmartIT URL does not work

    Rajeev Rai
      Share This:

      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'.