IMC进程无法启动

jserver 进程无法启动，提示无法连接数据库。

还有其他很多进程提示，进程启动过程中发生错误

2021-06-23 12:47:01 [WARN ] [main] [com.imc.traceLog.IMCTraceBeanPostProcessor::postProcessAfterInitialization] ****iMC Startup tarce log: Bean after 'dndSessionFactory' created : org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean@6b16de91 spend ms is 51

2021-06-23 12:47:01 [WARN ] [main] [com.imc.traceLog.IMCTraceBeanPostProcessor::postProcessAfterInitialization] ****iMC Startup tarce log: Bean after 'dndSessionFactory' created : org.hibernate.impl.SessionFactoryImpl@3cf55e0c spend ms is 54

2021-06-23 12:47:01 [INFO ] [main] [com.imc.restplug.func.RestPluginMgrImpl::init] restPlugin is not enabled.

2021-06-23 12:47:01 [INFO ] [main] [com.imc.restplug.func.RestPluginMgrImpl::init] restPlugin is enabled on 127.0.0.1:9000

2021-06-23 12:47:01 [WARN ] [main] [com.imc.traceLog.IMCTraceBeanPostProcessor::postProcessAfterInitialization] ****iMC Startup tarce log: Bean after 'platOperationLogMgr' created : com.imc.plat.operlog.func.OperationLogMgrImpl@64bba0eb spend ms is 87

2021-06-23 12:47:01 [INFO ] [main] [org.springframework.beans.factory.support.DefaultSingletonBeanRegistry::destroySingletons] Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@4201a617: defining beans [bsModuleMgr,bsViewMgr,bsWidgetMgr,bsModuleDao,bsViewDao,bsWidgetDao,assetIpAssignExportMgr,assetIpAssignMgr,assetIpSecAssignMgr,assetIpMacBindMgr,assetIpMacLocateMgr,assetIpMacLearnMgr,assetIpMacArpMgr,assetIfAccessBindMgr,assetIllegalAccessStrategyMgr,assetMacAccessBindMgr,assetAbnormalLogMgr,assetIllegalAccessMgr,assetIpRecycleStrategyMgr,assetDhcpServerMgr,assetVendorMacMgr,assetIpAssignOperatorGroupDao,assetIpAssignDao,assetIpMacBindDao,assetIpMacLocateDao,assetIpMacLearnDao,assetIpMacArpDao,assetIfAccessBindDao,assetIllegalAccessStrategyDao,assetDhcpServerDao,assetVendorMacDao,cccessLogExportTask,platDesktopCacheManager,platDesktopDataSource,platDesktopSessionFactory,platDesktopTxManager,org.springframework.scheduling.quartz.SchedulerFactoryBean#0,platDesktopInfoFromEhcacheToDaoJobDetail,platDesktopInfoFromEhcacheToDaoTrigger,platDesktopDao,platDesktopMgr,platDesktopEhCacheManagerPathMgr,platDesktopInstanceCache,platDesktopRegisteDao,platDesktopRegisteMgr,ehCacheListener,dndSessionFactory,dndRegisteredWidgetDao,dndRegisteredTypeDao,dndUserSpaceDao,dndRestrictedInfoDao,dndPushInfoTypeDao,dndPushInfoHistoryDao,dndNavigationTypeDao,dndInteNavigationTypeDao,dndNavigationDao,dndTransferDao,dndRegisteredWidgetMgr,dndRegisteredTypeMgr,dndUserSpaceMgr,dndRestrictedInfoMgr,rssProxyMgr,dndPushInfoTypeMgr,dndPushInfoHistoryMgr,dndNavigationTypeMgr,dndInteNavigationTypeMgr,dndNavigationMgr,dndMonitorTaskMgr,dndTransferMgr,dndHeartbeatMgr,cleanPushInfoHistoryJobDetail,cleanPushInfoCountJobDetail,org.springframework.scheduling.quartz.SchedulerFactoryBean#1,cacheManager,platDataSource,platSessionFactory,platTxManager,org.springframework.aop.framework.autoproxy.DefaultAdvisorAutoProxyCreator#0,org.springframework.transaction.interceptor.TransactionAttributeSourceAdvisor#0,platTransactionInterceptor,platTransactionTemplate,platTraceBean,platLogRotateTaskTrigger,platTempFileCleanerTaskTrigger,platNNMiDeviceImportJobDetail,platNNMiDeviceImportTrigger,platDataExportJobDetail,platDataExportTrigger,platDeleteCancelUserJobDetail,platDeleteCancelUserTrigger,org.springframework.scheduling.quartz.SchedulerFactoryBean#2,platComponentRegister,platDataExporterFactory,platTxtFileUserImporter,platUserImportAction,platOperatorDao,platOperatorGroupDao,platRoleDao,platFavouriteDao,timeconfigDao,datetimeDao,holidaydateDao,platLogCollectionDao,logCollectionInit,privilegeInit,liveUpdateClient,platRoleMgr,platFavouriteMgr,shortcutInit,platPsdStrategyMgr,platOperatorGroupMgr,platOperatorMgr,platThirdPartyAuth,platRadiusAuth,platLdapAuth,platTacacsAuth,platAclMgr,platTimeConfigMgr,platDateTimeMgr,platHolidayDateMgr,platLogCollectionMgr,platServerModeMgr,platConfigParaMgr,paltConfigParaDao,platInetConnMgr,platOperationLogMgr,platDataExportMgr,platOperLogExpTask,platUserGroupBaseMgr,platUserGroupDao,platDevGroupMgr,paltDevGroupAgentMgr,platDevGroupDao,platUserBaseMgr,platUserBasicMgr,platPreUserMgr,platUserDao,userAppendDefineMgr,platDeployCloudMgr,platSsUserGroupMgr,platUserPermMgr,euplatServiceRegisterDao,platDeployMgr,platProcessMgr,platDBManMgr,platDMSAccessMgr,platDBCapacityInfoMgr,platAuthServerMgr,wsInit,ictJythonMgr,platLoanMgr,resDeviceLoanMgr,platRegisterExtInfoBase,platAgentMgr,platProxy,platAgentTaskMgr,platConfigParaAgentMgr,platAgentDevMgr,platByteMessageMgr,executionPermissionDefinition,platFlexViewDao,platFlexViewMgr,platFlexWidgetDao,platFlexWidgetMgr,platFlexModuleDao,platFlexModuleMgr,platFlexTopoConfigDao,platFlexTopoSubcfgDao,platFlexTopoConfigMgr,platImcTaskMgr,platImcSearchService,platImcIndexBlockingQueueDao,platImcSearchOrdinaryDao,platImcIndexLocalMgr,platImcSearchLocalMgr,platRemoteIndexDao,platRemoteSearchDao,platImcSearchRemoteMgrService,platImcSearchServiceManager,platImcSearchServiceTestMgr,platImcSearchTaskMgr,platImcLocalSearchService,platImcLocalSearchServiceManager,platHelpSearchImplementMgr,platErrorCodeLookup,com.imc.plat.PlatErrorCodesProvider#0,platDelegateShapeRender,platChartMessageInboundMgr,twplatDelegateShapeRender,platCmdLogDao,platCmdLogMgr,platRequestReceiverDispatcher,platOperatorPerspectiveAccessPrivilegeTask,perspectiveInit,platPerspectiveDao,perspectiveLeftTreeInit,perspectiveMgr,imcLogConfigInit,imcLogConfigDao,imcLogConfigMgr,imcJserverLogConfigMgr,platAppTemplateDao,platAppTemplateMgr,platRestPluginMgr,imcPingTaskManager,platRestTaskExecutor,platSubServerDeviceMemMgr,platSubServerSyncMgr,platSubServerMessageMgr,platSubServerResourceMgr,platHttpsProxyService,resQueryStackDevIfs,httpsAccessCfgMgr,componentsInfoMgr,platImcIndexRemoteMgr,platImcSearchRemoteMgr,platComponentRestPortMgr,platComponentRestPortDao,platOEMMgr,platLocalRestDao,euSsoDao,euSsoService,serviceDeskDao,serviceDeskRmiService,itsmDao,itsmRmiService,com.imc.common.MsgComm$MsgCommDestroyHelper#0,com.imc.res.InitRegManager#0,resCustomViewBoracastReceiver,resUsedLicenseCount,resComponentLicenseLoanMgr,resMemSymbolMgr,resDealAgentBroadcastMgr,platOperatorDevIdRelaCalculate,com.imc.res.DeviceAppendInfoReader#0,com.imc.res.InterfaceAppendInfoReader#0,resDBAcess,resGroupMgr,resGroupDao,resCustomViewMgr,resDeviceDao,resDeviceMgr,resFindResMgr,resSnmpTemplateMgr,resSnmpTemplateAgentMgr,resTelnetTemplateDao,resTelnetTemplateMgr,resTelnetTemplateAgentMgr,resSSHTemplateDao,resSSHTemplateMgr,resSSHTemplateAgentMgr,resAutoDiscoverMgr,resImportExportDeviceMgr,resImportExportDao,resImportDeviceReceiver,resMailServerCfgMgr,resMailServerCfgDao,resSmsInternetInfoInit,simpleThirdMgr,resSmscCfgMgr,resShortMsgSeriServiceMgr,resTopoImportExportMgr,resDeviceCategoryMgr,resDeviceTemplateMgr,resDeviceVendorDao,resDeviceSeriesDao,resDeviceTypeDao,resDeviceCategoryDao,resDeviceTemplateAgentMgr,resDeviceCategoryAgentMgr,resdeviceIconDao,resDeviceIconMgr,resDevicIMCSeverIf,resDeviceSubServerMgr,resSubServerMgr,platImcLoginMgr,resDynamicRegister,resQueryMemResMgr,resDeviceAppendMgr,resDeviceHistoryMgr,appendInfoDefineMgr,resDeviceRegMgr,resConfigTaskMgr,resTopoExtentionConfigMgr,resStpCfgMgr,resCommonViewMgrSupport,resInterfaceViewMgr,resInterfaceViewDao,resAppendInfoMgr,resAppendInfoDao,resFilterMgr,resFilterDao,com.imc.res.interfaceView.InterfaceViewExtendColumnResImpl#0,com.imc.res.interfaceView.InterfaceViewExtendColumnAppendImpl#0,com.imc.res.device.ResDeviceAppendExtendColumnImpl#0,com.imc.res.device.ResDeviceExtendColumnImpl#0,resTerminalMgr,resDeviceVerDao,resDeviceJobDao,resConfigTaskDao,resDevRegDao,resSmscCfgDao,resShortMsgSeriServiceDao,resSnmpTemplateDao,resFindResourceDao,resCustomViewDao,resDeviceImcServerDao,resDeviceAppendInfoDao,appendInfoDefineDao,resLiveUpdateMgr,resDevPrivilegeUpdate,resDeviceVerMgr,resDeviceJobMgr,resDeviceSearchImplementMgr,resNetConfTemplateDao,resNetConfTemplateMgr,resTemplatePrivilegeDao,resTemplatePrivilegeMgr,resTemplateOperLogDao,resTemplateOperLogMgr,resSuspensionDao,resSuspensionMgr,devRestMgr,resWeChatDao,resWeChatMgr,resWeChatReadInfoInit,resWeChatPredefinedMgrImpl,resDevPollCfgDao,resDevPollCfgMgr,resThirdPartyLoginMgr,resRouterInfoDao,resRouterInfoMgr,resSubServerDeviceDao,resSubServerDeviceMgr,resSubServerDeviceGroupDao,resSubServerDeviceGroupMgr,resSubServerOperatorDao,resSubServerOperatorMgr,resSubServerRelaDao,resSubServerRelaMgr,resSubServerSymbolDao,resSubServerSymbolMgr,resSuperServerDao,resSuperServerMgr,resSuperServerByteMessageHandler,resSubServerByteMessageHandler,resSystemParameterDao,resSystemParameterMgr,resDeviceHoldHistoryDao,resDeviceHoldHistoryMgr,topoSaveMgr,topoGoogleGeoCoordinateMgr,resTopoLog,resNMETopoMgr,resOverallTopoMgr,resBaseLineInfoMgr,resDcTopoMgr,resRoomTopoMgr,resRackTopoMgr,topoLinkMgr,topoSaveDao,resBaseLineInfoDao,resNMETopoDao,resOverallTopoDao,resDcTopoDao,resRoomTopoDao,resRackTopoDao,resDcTopoUpgrade,resTopoClassLoaderManager,topoChartMessageInboundMgr,mibFileMgr,mibNodeRequestMgr,snmpServiceMgr,com.imc.netconf.utils.log.LoggingReconfigurationWatcher#0,platNetconfService,platNetconfLogConfigRegisterBean,platNetconfCloseExpiredConnectionsTaskTrigger,bdpConfiguration,bdpConnectionPool,bdpSessionFactory,ehcacheConnection,bdpRedisConnectionPool,bdpRedisConnection,mongoConnection,bdpServiceMgr,gencfgReqDispatcher,gencfgCommonMgr,gencfgSendMsgMgr,gencfgCreateTaskMgr,gencfgOperationInitMgr,gencfgReceiveMsgMgr,gencfgReportMgr,gencfgDndMonitorTaskMgrImpl,iccconfTabExtendsionConfigMgr,commonDevComEnv,commonDevEnvCommMgr,commonSnmpConfFileMgr,commonSnmpBuilder,snmpOperationMgr,notifyIf,dataCenterRender,d3TopoRestConfMgr,d3MonitorMgr,d3TopoEquipmentManageMgr,d3TopoRackMgr,d3TopoRelativeEquipmentMgr,d3TopoRelativeTypeMgr,d3TopoDataCenterGetRestDataMgr,d3TopoDeviceRestMgr,d3TopoDataCenterGetSocketDataMgr,dataCenterAlarmRender,d3TopoRoomMgr,d3TopoTemplateMgr,d3TopoTemplateTypeMgr,d3TopoTemplateDefineTypeMgr,dc2dTopoMgr,dataCenterExtendManager,dcFaultAlarm,d3TopoEquipmentManageDao,d3TopoRestConfDao,d3MonitorDao,d3TopoRackDao,d3TopoRelativeTypeDao,d3TopoRelativeEquipmentDao,d3TopoRoomDao,d3TopoOtherDao,d3TopoTemplateDao,d3TopoTemplateTypeDao,d3TopoTemplateDefineTypeDao,dc2dTopoDao,3dChartMessageInboundMgr,datacenterExternalInterface,d3DeviceExtendColumnIf,d3MonitorDataReceiver]; root of factory hierarchy

2021-06-23 12:47:01 [INFO ] [main] [com.imc.plat.agent.AgentTaskMgrImpl::destroy] One-off scheduler for agent task shutdown.

2021-06-23 12:47:01 [INFO ] [main] [com.imc.plat.agent.AgentTaskMgrImpl::destroy] Periodic scheduler for agent task shutdown.

2021-06-23 12:47:01 [INFO ] [main] [org.springframework.orm.hibernate3.AbstractSessionFactoryBean::destroy] Closing Hibernate SessionFactory

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.ApplicationContextLocator::loadAllSvcContext] Load spring config files error, files=[/opt/iMC/client/conf/bsAppContext.xml, /opt/iMC/client/conf/assetAppContext.xml, /opt/iMC/client/conf/commonThirdpartyAppContext.xml, /opt/iMC/client/conf/desktopAppContext.xml, /opt/iMC/client/conf/dndAppContext.xml, /opt/iMC/client/conf/platAppContext.xml, /opt/iMC/client/conf/platRmiAppContext.xml, /opt/iMC/client/conf/resAppContext.xml, /opt/iMC/client/conf/topoAppContext.xml, /opt/iMC/client/conf/webdmMibBrowserAppContext.xml, /opt/iMC/client/conf/netconfAppContext.xml, /opt/iMC/client/conf/bdpAppContext.xml, /opt/iMC/client/conf/gencfgAppContext.xml, /opt/iMC/client/conf/iccConfAppContext.xml, /opt/iMC/client/conf/dataCenterAppContext.xml]

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'platUserImportAction' defined in file [/opt/iMC/client/conf/platAppContext.xml]: Cannot resolve reference to bean 'platUserBaseMgr' while setting bean property 'userBaseMgr'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'platUserBaseMgr' defined in file [/opt/iMC/client/conf/platAppContext.xml]: Cannot resolve reference to bean 'platLocalRestDao' while setting bean property 'localRestDao'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'platLocalRestDao' defined in file [/opt/iMC/client/conf/platAppContext.xml]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'platComponentRestPortMgr' defined in file [/opt/iMC/client/conf/platAppContext.xml]: Invocation of init method failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select componentr0_.ID as ID171_, componentr0_.COMPONENT_ID as COMPONENT2_171_, componentr0_.PORT as PORT171_ from TBL_COMPONENT_REST_PORT componentr0_ where componentr0_.COMPONENT_ID=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

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

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

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1417)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1158)

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

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

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

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

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

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

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

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

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

at com.imc.bootstrap.ApplicationContextLocator.loadAllSvcContext(ApplicationContextLocator.java:386)

at com.imc.bootstrap.ApplicationContextLocator.<init>(ApplicationContextLocator.java:229)

at com.imc.bootstrap.ApplicationContextLocator.getInstance(ApplicationContextLocator.java:194)

at com.imc.bootstrap.ApplicationContextLocator.getSvcInstance(ApplicationContextLocator.java:123)

at com.imc.bootstrap.IMCServer.load(IMCServer.java:80)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:566)

at com.imc.bootstrap.ServerStartup.load(ServerStartup.java:709)

at com.imc.bootstrap.ServerStartup.start(ServerStartup.java:543)

at com.imc.bootstrap.ServerStartup.process(ServerStartup.java:416)

at com.imc.bootstrap.Bootstrap.process(Bootstrap.java:139)

at com.imc.bootstrap.Bootstrap.main(Bootstrap.java:249)

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'platUserBaseMgr' defined in file [/opt/iMC/client/conf/platAppContext.xml]: Cannot resolve reference to bean 'platLocalRestDao' while setting bean property 'localRestDao'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'platLocalRestDao' defined in file [/opt/iMC/client/conf/platAppContext.xml]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'platComponentRestPortMgr' defined in file [/opt/iMC/client/conf/platAppContext.xml]: Invocation of init method failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select componentr0_.ID as ID171_, componentr0_.COMPONENT_ID as COMPONENT2_171_, componentr0_.PORT as PORT171_ from TBL_COMPONENT_REST_PORT componentr0_ where componentr0_.COMPONENT_ID=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

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

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

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1417)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1158)

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

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

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

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

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

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

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

... 26 more

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'platLocalRestDao' defined in file [/opt/iMC/client/conf/platAppContext.xml]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'platComponentRestPortMgr' defined in file [/opt/iMC/client/conf/platAppContext.xml]: Invocation of init method failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select componentr0_.ID as ID171_, componentr0_.COMPONENT_ID as COMPONENT2_171_, componentr0_.PORT as PORT171_ from TBL_COMPONENT_REST_PORT componentr0_ where componentr0_.COMPONENT_ID=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

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

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

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

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

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

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

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

... 36 more

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'platComponentRestPortMgr' defined in file [/opt/iMC/client/conf/platAppContext.xml]: Invocation of init method failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select componentr0_.ID as ID171_, componentr0_.COMPONENT_ID as COMPONENT2_171_, componentr0_.PORT as PORT171_ from TBL_COMPONENT_REST_PORT componentr0_ where componentr0_.COMPONENT_ID=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

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

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

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

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

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

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

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

at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1117)

at com.imc.common.rest.CommonRestTemplate.setApplicationContext(CommonRestTemplate.java:857)

at org.springframework.context.support.ApplicationContextAwareProcessor.invokeAwareInterfaces(ApplicationContextAwareProcessor.java:117)

at org.springframework.context.support.ApplicationContextAwareProcessor.postProcessBeforeInitialization(ApplicationContextAwareProcessor.java:92)

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

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

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

... 42 more

Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select componentr0_.ID as ID171_, componentr0_.COMPONENT_ID as COMPONENT2_171_, componentr0_.PORT as PORT171_ from TBL_COMPONENT_REST_PORT componentr0_ where componentr0_.COMPONENT_ID=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:635)

at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)

at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:412)

at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)

at com.imc.common.CommonDaoSupport.queryList(CommonDaoSupport.java:46)

at com.imc.common.rest.dao.ComponentRESTPortDAOImpl.query(ComponentRESTPortDAOImpl.java:43)

at com.imc.common.rest.func.ComponentRESTPortMgrImpl.queryByComponetId(ComponentRESTPortMgrImpl.java:52)

at com.imc.common.rest.func.ComponentRESTPortMgrImpl.afterPropertiesSet(ComponentRESTPortMgrImpl.java:66)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1571)

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

... 55 more

Caused by: org.hibernate.exception.SQLGrammarException: could not execute query

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

at org.hibernate.loader.Loader.doList(Loader.java:2545)

at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)

at org.hibernate.loader.Loader.list(Loader.java:2271)

at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)

at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)

at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)

at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)

at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)

at com.imc.common.CommonDaoSupport$1.doInHibernate(CommonDaoSupport.java:138)

at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:407)

... 62 more

Caused by: java.sql.SQLSyntaxErrorException: Table 'config_db.TBL_COMPONENT_REST_PORT' doesn't exist

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)

at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1025)

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)

at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)

at org.hibernate.loader.Loader.doQuery(Loader.java:802)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)

at org.hibernate.loader.Loader.doList(Loader.java:2542)

... 71 more

2021-06-23 12:47:01 [INFO ] [main] [com.imc.bootstrap.ApplicationContextLocator::loadAllSvcContext] Load SvcContext for Component: iMC-PLAT, takes 4837ms.

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.DeployConfigParser::getNextSvcSpringConfigFiles] Component "iMC-PLAT" is skipped for loading: ERROR_DBERROR

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.DeployConfigParser::getNextSvcSpringConfigFiles] Component "iMC-ISP" removed from loading list, due to dependences has been removed.

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.DeployConfigParser::getNextSvcSpringConfigFiles] Component "iMC-ICC" removed from loading list, due to dependences has been removed.

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.DeployConfigParser::getNextSvcSpringConfigFiles] Component "iMC-UAM-PS" removed from loading list, due to dependences has been removed.

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.DeployConfigParser::getNextSvcSpringConfigFiles] Component "iMC-NETASSET" removed from loading list, due to dependences has been removed.

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.DeployConfigParser::getNextSvcSpringConfigFiles] Component "iMC-PORTAL-KERNEL" removed from loading list, due to dependences has been removed.

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.DeployConfigParser::getNextSvcSpringConfigFiles] Component "iMC-EAD" removed from loading list, due to dependences has been removed.

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.DeployConfigParser::getNextSvcSpringConfigFiles] Component "iMC-UAM" removed from loading list, due to dependences has been removed.

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.DeployConfigParser::getNextSvcSpringConfigFiles] Component "iMC-TAM" removed from loading list, due to dependences has been removed.

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.DeployConfigParser::getNextSvcSpringConfigFiles] Component "iMC-UAM-WEB" removed from loading list, due to dependences has been removed.

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.DeployConfigParser::getNextSvcSpringConfigFiles] Component "iMC-UAM-SSV" removed from loading list, due to dependences has been removed.

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.DeployConfigParser::getNextSvcSpringConfigFiles] Component "iMC-SYSLOG" removed from loading list, due to dependences has been removed.

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.DeployConfigParser::getNextSvcSpringConfigFiles] Component "iMC-UAM-WEIXIN" removed from loading list, due to dependences has been removed.

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.DeployConfigParser::getNextSvcSpringConfigFiles] Component "iMC-NME-FAULT" removed from loading list, due to dependences has been removed.

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.DeployConfigParser::getNextSvcSpringConfigFiles] Component "iMC-UAM-BYOD" removed from loading list, due to dependences has been removed.

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.DeployConfigParser::getNextSvcSpringConfigFiles] Component "iMC-REPORT" removed from loading list, due to dependences has been removed.

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.DeployConfigParser::getNextSvcSpringConfigFiles] Component "iMC-DAM" removed from loading list, due to dependences has been removed.

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.DeployConfigParser::getNextSvcSpringConfigFiles] Component "iMC-DM" removed from loading list, due to dependences has been removed.

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.DeployConfigParser::getNextSvcSpringConfigFiles] Component "iMC-NME-PERF" removed from loading list, due to dependences has been removed.

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.DeployConfigParser::getNextSvcSpringConfigFiles] Component "iMC-VNM" removed from loading list, due to dependences has been removed.

2021-06-23 12:47:01 [ERROR] [main] [com.imc.bootstrap.IMCServer::load] Root context load failed.

centos+mysql远程部署