[2022-01-13 10:01:45.827] [ERROR] Application Terminated: 2022-01-13 10:01:45, org.springframework.context.event.ContextClosedEvent[source=org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@67af4b93, started on Thu Jan 13 10:01:33 KST 2022] [2022-01-13 10:01:46.194] [ERROR] UnitSystService.destroy. system terminated....... [2022-01-13 10:01:47.488] [ERROR] *************************** APPLICATION FAILED TO START *************************** Description: Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured. Reason: Failed to determine a suitable driver class Action: Consider the following: If you want an embedded database (H2, HSQL or Derby), please put it on the classpath. If you have database settings to be loaded from a particular profile you may need to activate it (the profiles dev are currently active). [2022-01-13 10:57:28.397] [ERROR] Application Terminated: 2022-01-13 10:57:28, org.springframework.context.event.ContextClosedEvent[source=org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@53b921fe, started on Thu Jan 13 10:54:04 KST 2022] [2022-01-13 10:57:28.886] [ERROR] UnitSystService.destroy. system terminated....... [2022-01-13 10:59:07.508] [ERROR] Application Terminated: 2022-01-13 10:59:07, org.springframework.context.event.ContextClosedEvent[source=org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@29f2c8de, started on Thu Jan 13 10:57:29 KST 2022] [2022-01-13 10:59:08.212] [ERROR] UnitSystService.destroy. system terminated....... [2022-01-13 10:59:14.966] [ERROR] *************************** APPLICATION FAILED TO START *************************** Description: Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured. Reason: Failed to determine a suitable driver class Action: Consider the following: If you want an embedded database (H2, HSQL or Derby), please put it on the classpath. If you have database settings to be loaded from a particular profile you may need to activate it (the profiles dev are currently active). [2022-01-13 10:59:28.255] [ERROR] Application run failed org.springframework.beans.factory.BeanDefinitionStoreException: Failed to parse configuration class [com.its.traf.TrafProcessingServerApplication]; nested exception is java.io.FileNotFoundException: class path resource [com/its/traf/scheduler/job/AbstractJob.class] cannot be opened because it does not exist at org.springframework.context.annotation.ConfigurationClassParser.parse(ConfigurationClassParser.java:189) at org.springframework.context.annotation.ConfigurationClassPostProcessor.processConfigBeanDefinitions(ConfigurationClassPostProcessor.java:320) at org.springframework.context.annotation.ConfigurationClassPostProcessor.postProcessBeanDefinitionRegistry(ConfigurationClassPostProcessor.java:237) at org.springframework.context.support.PostProcessorRegistrationDelegate.invokeBeanDefinitionRegistryPostProcessors(PostProcessorRegistrationDelegate.java:280) at org.springframework.context.support.PostProcessorRegistrationDelegate.invokeBeanFactoryPostProcessors(PostProcessorRegistrationDelegate.java:96) at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:707) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:533) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:755) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:747) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:402) at org.springframework.boot.SpringApplication.run(SpringApplication.java:312) at com.its.traf.TrafProcessingServerApplication.main(TrafProcessingServerApplication.java:49) 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:483) at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) Caused by: java.io.FileNotFoundException: class path resource [com/its/traf/scheduler/job/AbstractJob.class] cannot be opened because it does not exist at org.springframework.core.io.ClassPathResource.getInputStream(ClassPathResource.java:187) at org.springframework.core.type.classreading.SimpleMetadataReader.getClassReader(SimpleMetadataReader.java:55) at org.springframework.core.type.classreading.SimpleMetadataReader.(SimpleMetadataReader.java:49) at org.springframework.core.type.classreading.SimpleMetadataReaderFactory.getMetadataReader(SimpleMetadataReaderFactory.java:103) at org.springframework.boot.type.classreading.ConcurrentReferenceCachingMetadataReaderFactory.createMetadataReader(ConcurrentReferenceCachingMetadataReaderFactory.java:86) at org.springframework.boot.type.classreading.ConcurrentReferenceCachingMetadataReaderFactory.getMetadataReader(ConcurrentReferenceCachingMetadataReaderFactory.java:73) at org.springframework.core.type.classreading.SimpleMetadataReaderFactory.getMetadataReader(SimpleMetadataReaderFactory.java:81) at org.springframework.context.annotation.ConfigurationClassParser.asSourceClass(ConfigurationClassParser.java:696) at org.springframework.context.annotation.ConfigurationClassParser$SourceClass.getInterfaces(ConfigurationClassParser.java:1024) at org.springframework.context.annotation.ConfigurationClassParser.processInterfaces(ConfigurationClassParser.java:386) at org.springframework.context.annotation.ConfigurationClassParser.doProcessConfigurationClass(ConfigurationClassParser.java:332) at org.springframework.context.annotation.ConfigurationClassParser.processConfigurationClass(ConfigurationClassParser.java:250) at org.springframework.context.annotation.ConfigurationClassParser.parse(ConfigurationClassParser.java:199) at org.springframework.context.annotation.ConfigurationClassParser.doProcessConfigurationClass(ConfigurationClassParser.java:304) at org.springframework.context.annotation.ConfigurationClassParser.processConfigurationClass(ConfigurationClassParser.java:250) at org.springframework.context.annotation.ConfigurationClassParser.parse(ConfigurationClassParser.java:207) at org.springframework.context.annotation.ConfigurationClassParser.parse(ConfigurationClassParser.java:175) ... 17 common frames omitted [2022-01-13 16:02:51.895] [ restartedMain] [ERROR] o.s.boot.SpringApplication.reportFailure 13012 Application run failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'collectSystDao' defined in file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\com\its\traf\mapper\collect\CollectSystDao.class]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.its.traf.mapper.collect.CollectSystDao]: Constructor threw exception; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sqlSession' defined in class path resource [com/its/traf/config/DatabaseConfig.class]: Unsatisfied dependency expressed through method 'sqlSession' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/its/traf/config/DatabaseConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactoryBean' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'com.its.traf.vo.pattern.IfscPtrnVo'. Cause: java.lang.ClassNotFoundException: Cannot find class: com.its.traf.vo.pattern.IfscPtrnVo at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:1318) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1213) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:556) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324) at org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$180/1778495808.getObject(Unknown Source) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:897) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:879) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) at com.its.traf.TrafProcessingServerApplication.main(TrafProcessingServerApplication.java:49) 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:483) at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.its.traf.mapper.collect.CollectSystDao]: Constructor threw exception; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sqlSession' defined in class path resource [com/its/traf/config/DatabaseConfig.class]: Unsatisfied dependency expressed through method 'sqlSession' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/its/traf/config/DatabaseConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactoryBean' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'com.its.traf.vo.pattern.IfscPtrnVo'. Cause: java.lang.ClassNotFoundException: Cannot find class: com.its.traf.vo.pattern.IfscPtrnVo at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:217) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:1310) ... 22 common frames omitted Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sqlSession' defined in class path resource [com/its/traf/config/DatabaseConfig.class]: Unsatisfied dependency expressed through method 'sqlSession' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/its/traf/config/DatabaseConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactoryBean' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'com.its.traf.vo.pattern.IfscPtrnVo'. Cause: java.lang.ClassNotFoundException: Cannot find class: com.its.traf.vo.pattern.IfscPtrnVo at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:797) at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:538) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1336) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1176) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:556) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324) at org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$180/1778495808.getObject(Unknown Source) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:227) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveNamedBean(DefaultListableBeanFactory.java:1175) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveBean(DefaultListableBeanFactory.java:420) at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBean(DefaultListableBeanFactory.java:349) at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBean(DefaultListableBeanFactory.java:342) at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1127) at com.its.app.AppUtils.getBean(AppUtils.java:12) at com.its.traf.mapper.collect.AbstractCollectSystMapper.(AbstractCollectSystMapper.java:17) at com.its.traf.mapper.collect.CollectSystDao.(CollectSystDao.java:13) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:408) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:204) ... 24 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/its/traf/config/DatabaseConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactoryBean' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'com.its.traf.vo.pattern.IfscPtrnVo'. Cause: java.lang.ClassNotFoundException: Cannot find class: com.its.traf.vo.pattern.IfscPtrnVo at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:655) at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:635) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1336) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1176) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:556) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324) at org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$180/1778495808.getObject(Unknown Source) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1307) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1227) at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:884) at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:788) ... 47 common frames omitted Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactoryBean' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'com.its.traf.vo.pattern.IfscPtrnVo'. Cause: java.lang.ClassNotFoundException: Cannot find class: com.its.traf.vo.pattern.IfscPtrnVo at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185) at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:650) ... 62 common frames omitted Caused by: org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'com.its.traf.vo.pattern.IfscPtrnVo'. Cause: java.lang.ClassNotFoundException: Cannot find class: com.its.traf.vo.pattern.IfscPtrnVo at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:613) at org.mybatis.spring.SqlSessionFactoryBean.afterPropertiesSet(SqlSessionFactoryBean.java:491) at org.mybatis.spring.SqlSessionFactoryBean.getObject(SqlSessionFactoryBean.java:633) at com.its.traf.config.DatabaseConfig.sqlSessionFactoryBean(DatabaseConfig.java:59) at com.its.traf.config.DatabaseConfig$$EnhancerBySpringCGLIB$$7946ad78.CGLIB$sqlSessionFactoryBean$3() at com.its.traf.config.DatabaseConfig$$EnhancerBySpringCGLIB$$7946ad78$$FastClassBySpringCGLIB$$d4497c10.invoke() at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244) at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331) at com.its.traf.config.DatabaseConfig$$EnhancerBySpringCGLIB$$7946ad78.sqlSessionFactoryBean() 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:483) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154) ... 63 common frames omitted Caused by: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'com.its.traf.vo.pattern.IfscPtrnVo'. Cause: java.lang.ClassNotFoundException: Cannot find class: com.its.traf.vo.pattern.IfscPtrnVo at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:123) at org.apache.ibatis.builder.xml.XMLMapperBuilder.parse(XMLMapperBuilder.java:95) at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:611) ... 76 common frames omitted Caused by: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'com.its.traf.vo.pattern.IfscPtrnVo'. Cause: java.lang.ClassNotFoundException: Cannot find class: com.its.traf.vo.pattern.IfscPtrnVo at org.apache.ibatis.builder.BaseBuilder.resolveClass(BaseBuilder.java:118) at org.apache.ibatis.builder.xml.XMLStatementBuilder.parseStatementNode(XMLStatementBuilder.java:102) at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:138) at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:131) at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:121) ... 78 common frames omitted Caused by: org.apache.ibatis.type.TypeException: Could not resolve type alias 'com.its.traf.vo.pattern.IfscPtrnVo'. Cause: java.lang.ClassNotFoundException: Cannot find class: com.its.traf.vo.pattern.IfscPtrnVo at org.apache.ibatis.type.TypeAliasRegistry.resolveAlias(TypeAliasRegistry.java:120) at org.apache.ibatis.builder.BaseBuilder.resolveAlias(BaseBuilder.java:149) at org.apache.ibatis.builder.BaseBuilder.resolveClass(BaseBuilder.java:116) ... 82 common frames omitted Caused by: java.lang.ClassNotFoundException: Cannot find class: com.its.traf.vo.pattern.IfscPtrnVo at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:196) at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:89) at org.apache.ibatis.io.Resources.classForName(Resources.java:261) at org.apache.ibatis.type.TypeAliasRegistry.resolveAlias(TypeAliasRegistry.java:116) ... 84 common frames omitted [2022-01-13 16:04:12.563] [ restartedMain] [ERROR] o.s.boot.SpringApplication.reportFailure 6632 Application run failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'collectSystDao' defined in file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\com\its\traf\mapper\collect\CollectSystDao.class]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.its.traf.mapper.collect.CollectSystDao]: Constructor threw exception; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sqlSession' defined in class path resource [com/its/traf/config/DatabaseConfig.class]: Unsatisfied dependency expressed through method 'sqlSession' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/its/traf/config/DatabaseConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactoryBean' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'com.its.traf.vo.pattern.IfscPtrnVo'. Cause: java.lang.ClassNotFoundException: Cannot find class: com.its.traf.vo.pattern.IfscPtrnVo at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:1318) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1213) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:556) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324) at org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$180/880644007.getObject(Unknown Source) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:897) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:879) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) at com.its.traf.TrafProcessingServerApplication.main(TrafProcessingServerApplication.java:49) 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:483) at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.its.traf.mapper.collect.CollectSystDao]: Constructor threw exception; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sqlSession' defined in class path resource [com/its/traf/config/DatabaseConfig.class]: Unsatisfied dependency expressed through method 'sqlSession' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/its/traf/config/DatabaseConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactoryBean' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'com.its.traf.vo.pattern.IfscPtrnVo'. Cause: java.lang.ClassNotFoundException: Cannot find class: com.its.traf.vo.pattern.IfscPtrnVo at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:217) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:1310) ... 22 common frames omitted Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sqlSession' defined in class path resource [com/its/traf/config/DatabaseConfig.class]: Unsatisfied dependency expressed through method 'sqlSession' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/its/traf/config/DatabaseConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactoryBean' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'com.its.traf.vo.pattern.IfscPtrnVo'. Cause: java.lang.ClassNotFoundException: Cannot find class: com.its.traf.vo.pattern.IfscPtrnVo at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:797) at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:538) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1336) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1176) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:556) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324) at org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$180/880644007.getObject(Unknown Source) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:227) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveNamedBean(DefaultListableBeanFactory.java:1175) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveBean(DefaultListableBeanFactory.java:420) at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBean(DefaultListableBeanFactory.java:349) at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBean(DefaultListableBeanFactory.java:342) at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1127) at com.its.app.AppUtils.getBean(AppUtils.java:12) at com.its.traf.mapper.collect.AbstractCollectSystMapper.(AbstractCollectSystMapper.java:17) at com.its.traf.mapper.collect.CollectSystDao.(CollectSystDao.java:13) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:408) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:204) ... 24 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/its/traf/config/DatabaseConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactoryBean' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'com.its.traf.vo.pattern.IfscPtrnVo'. Cause: java.lang.ClassNotFoundException: Cannot find class: com.its.traf.vo.pattern.IfscPtrnVo at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:655) at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:635) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1336) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1176) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:556) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324) at org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$180/880644007.getObject(Unknown Source) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1307) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1227) at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:884) at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:788) ... 47 common frames omitted Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactoryBean' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'com.its.traf.vo.pattern.IfscPtrnVo'. Cause: java.lang.ClassNotFoundException: Cannot find class: com.its.traf.vo.pattern.IfscPtrnVo at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185) at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:650) ... 62 common frames omitted Caused by: org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'com.its.traf.vo.pattern.IfscPtrnVo'. Cause: java.lang.ClassNotFoundException: Cannot find class: com.its.traf.vo.pattern.IfscPtrnVo at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:613) at org.mybatis.spring.SqlSessionFactoryBean.afterPropertiesSet(SqlSessionFactoryBean.java:491) at org.mybatis.spring.SqlSessionFactoryBean.getObject(SqlSessionFactoryBean.java:633) at com.its.traf.config.DatabaseConfig.sqlSessionFactoryBean(DatabaseConfig.java:59) at com.its.traf.config.DatabaseConfig$$EnhancerBySpringCGLIB$$26ef6251.CGLIB$sqlSessionFactoryBean$4() at com.its.traf.config.DatabaseConfig$$EnhancerBySpringCGLIB$$26ef6251$$FastClassBySpringCGLIB$$845e80a5.invoke() at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244) at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331) at com.its.traf.config.DatabaseConfig$$EnhancerBySpringCGLIB$$26ef6251.sqlSessionFactoryBean() 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:483) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154) ... 63 common frames omitted Caused by: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\pattern\IfscPtrn.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'com.its.traf.vo.pattern.IfscPtrnVo'. Cause: java.lang.ClassNotFoundException: Cannot find class: com.its.traf.vo.pattern.IfscPtrnVo at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:123) at org.apache.ibatis.builder.xml.XMLMapperBuilder.parse(XMLMapperBuilder.java:95) at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:611) ... 76 common frames omitted Caused by: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'com.its.traf.vo.pattern.IfscPtrnVo'. Cause: java.lang.ClassNotFoundException: Cannot find class: com.its.traf.vo.pattern.IfscPtrnVo at org.apache.ibatis.builder.BaseBuilder.resolveClass(BaseBuilder.java:118) at org.apache.ibatis.builder.xml.XMLStatementBuilder.parseStatementNode(XMLStatementBuilder.java:102) at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:138) at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:131) at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:121) ... 78 common frames omitted Caused by: org.apache.ibatis.type.TypeException: Could not resolve type alias 'com.its.traf.vo.pattern.IfscPtrnVo'. Cause: java.lang.ClassNotFoundException: Cannot find class: com.its.traf.vo.pattern.IfscPtrnVo at org.apache.ibatis.type.TypeAliasRegistry.resolveAlias(TypeAliasRegistry.java:120) at org.apache.ibatis.builder.BaseBuilder.resolveAlias(BaseBuilder.java:149) at org.apache.ibatis.builder.BaseBuilder.resolveClass(BaseBuilder.java:116) ... 82 common frames omitted Caused by: java.lang.ClassNotFoundException: Cannot find class: com.its.traf.vo.pattern.IfscPtrnVo at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:196) at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:89) at org.apache.ibatis.io.Resources.classForName(Resources.java:261) at org.apache.ibatis.type.TypeAliasRegistry.resolveAlias(TypeAliasRegistry.java:116) ... 84 common frames omitted [2022-01-13 16:05:38.180] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.load 16312 ptrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:05:00 KST 2022, STAT_DT=202201, STAT_HM=1605, DAY_TYPE_CD=DTW4, FROM_HM=1605, TO_HM_15M=1615, TO_HM_HH=1650, PTRN_DT05M=20211213160500, PTRN_DT15M=20211213160000) [2022-01-13 16:05:38.181] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.load 16312 prcsPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:05:00 KST 2021, STAT_DT=202112, STAT_HM=1605, DAY_TYPE_CD=DTW1, FROM_HM=1605, TO_HM_15M=1615, TO_HM_HH=1650, PTRN_DT05M=null, PTRN_DT15M=20211213160000) [2022-01-13 16:05:38.204] [ restartedMain] [ERROR] o.s.boot.SpringApplication.reportFailure 16312 Application run failed java.lang.IllegalStateException: Failed to execute CommandLineRunner at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:798) at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:779) at org.springframework.boot.SpringApplication.run(SpringApplication.java:322) at com.its.traf.TrafProcessingServerApplication.main(TrafProcessingServerApplication.java:49) 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:483) at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) Caused by: org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.its.traf.mapper.pattern.LinkPtrnMapper.selectPtrn15M at org.apache.ibatis.binding.MapperMethod$SqlCommand.(MapperMethod.java:235) at org.apache.ibatis.binding.MapperMethod.(MapperMethod.java:53) at org.apache.ibatis.binding.MapperProxy.lambda$cachedInvoker$0(MapperProxy.java:108) at org.apache.ibatis.binding.MapperProxy$$Lambda$613/2021603561.apply(Unknown Source) at org.apache.ibatis.util.MapUtil$$Lambda$471/1751560004.apply(Unknown Source) at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660) at org.apache.ibatis.util.MapUtil.computeIfAbsent(MapUtil.java:36) at org.apache.ibatis.binding.MapperProxy.cachedInvoker(MapperProxy.java:95) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) at com.sun.proxy.$Proxy80.selectPtrn15M(Unknown Source) at com.its.traf.service.pattern.PatternLinkService.load(PatternLinkService.java:109) at com.its.traf.service.pattern.PatternLinkService.load(PatternLinkService.java:67) at com.its.traf.service.pattern.PatternLinkService$$FastClassBySpringCGLIB$$552c303a.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88) at com.its.traf.aspectj.ApplicationElapsedAspect.loadingElapsedTime(ApplicationElapsedAspect.java:32) at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:483) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) at com.its.traf.service.pattern.PatternLinkService$$EnhancerBySpringCGLIB$$17c3bf9b.load() at com.its.traf.service.pattern.PatternService.load(PatternService.java:75) at com.its.traf.service.pattern.PatternService$$FastClassBySpringCGLIB$$31739d14.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88) at com.its.traf.aspectj.ApplicationElapsedAspect.loadingElapsedTime(ApplicationElapsedAspect.java:32) 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:483) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) at com.its.traf.service.pattern.PatternService$$EnhancerBySpringCGLIB$$610fde69.load() at com.its.traf.scheduler.job.JobTraffic05MPrepare.run(JobTraffic05MPrepare.java:53) at com.its.traf.scheduler.job.JobTraffic05MPrepare$$FastClassBySpringCGLIB$$a6a9e27b.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88) at com.its.traf.aspectj.ApplicationElapsedAspect.runElapsedTime(ApplicationElapsedAspect.java:52) 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:483) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) at com.its.traf.scheduler.job.JobTraffic05MPrepare$$EnhancerBySpringCGLIB$$81d9c6fe.run() at com.its.traf.TrafProcessingServerApplication.run(TrafProcessingServerApplication.java:80) at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:795) ... 8 common frames omitted [2022-01-13 16:05:38.526] [ restartedMain] [ERROR] c.its.traf.service.UnitSystService.destroyService 16312 UnitSystService.destroy. system terminated....... [2022-01-13 16:08:45.121] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.load 432 ptrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:05:00 KST 2022, STAT_DT=202201, STAT_HM=1605, DAY_TYPE_CD=DTW4, FROM_HM=1605, TO_HM_15M=1615, TO_HM_HH=1650, PTRN_DT05M=20211213160500, PTRN_DT15M=20211213160000) [2022-01-13 16:08:45.122] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.load 432 prcsPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:05:00 KST 2021, STAT_DT=202112, STAT_HM=1605, DAY_TYPE_CD=DTW1, FROM_HM=1605, TO_HM_15M=1615, TO_HM_HH=1650, PTRN_DT05M=null, PTRN_DT15M=20211213160000) [2022-01-13 16:08:45.143] [ restartedMain] [ERROR] o.s.boot.SpringApplication.reportFailure 432 Application run failed java.lang.IllegalStateException: Failed to execute CommandLineRunner at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:798) at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:779) at org.springframework.boot.SpringApplication.run(SpringApplication.java:322) at com.its.traf.TrafProcessingServerApplication.main(TrafProcessingServerApplication.java:49) 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:483) at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) Caused by: org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.its.traf.mapper.pattern.LinkPtrnMapper.selectPtrn15M at org.apache.ibatis.binding.MapperMethod$SqlCommand.(MapperMethod.java:235) at org.apache.ibatis.binding.MapperMethod.(MapperMethod.java:53) at org.apache.ibatis.binding.MapperProxy.lambda$cachedInvoker$0(MapperProxy.java:108) at org.apache.ibatis.binding.MapperProxy$$Lambda$613/1820465813.apply(Unknown Source) at org.apache.ibatis.util.MapUtil$$Lambda$471/252542271.apply(Unknown Source) at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660) at org.apache.ibatis.util.MapUtil.computeIfAbsent(MapUtil.java:36) at org.apache.ibatis.binding.MapperProxy.cachedInvoker(MapperProxy.java:95) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) at com.sun.proxy.$Proxy80.selectPtrn15M(Unknown Source) at com.its.traf.service.pattern.PatternLinkService.load(PatternLinkService.java:109) at com.its.traf.service.pattern.PatternLinkService.load(PatternLinkService.java:67) at com.its.traf.service.pattern.PatternLinkService$$FastClassBySpringCGLIB$$552c303a.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88) at com.its.traf.aspectj.ApplicationElapsedAspect.loadingElapsedTime(ApplicationElapsedAspect.java:32) at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:483) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) at com.its.traf.service.pattern.PatternLinkService$$EnhancerBySpringCGLIB$$e4802533.load() at com.its.traf.service.pattern.PatternService.load(PatternService.java:75) at com.its.traf.service.pattern.PatternService$$FastClassBySpringCGLIB$$31739d14.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88) at com.its.traf.aspectj.ApplicationElapsedAspect.loadingElapsedTime(ApplicationElapsedAspect.java:32) 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:483) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) at com.its.traf.service.pattern.PatternService$$EnhancerBySpringCGLIB$$2dcc4401.load() at com.its.traf.scheduler.job.JobTraffic05MPrepare.run(JobTraffic05MPrepare.java:53) at com.its.traf.scheduler.job.JobTraffic05MPrepare$$FastClassBySpringCGLIB$$a6a9e27b.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88) at com.its.traf.aspectj.ApplicationElapsedAspect.runElapsedTime(ApplicationElapsedAspect.java:52) 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:483) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) at com.its.traf.scheduler.job.JobTraffic05MPrepare$$EnhancerBySpringCGLIB$$4e962c96.run() at com.its.traf.TrafProcessingServerApplication.run(TrafProcessingServerApplication.java:80) at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:795) ... 8 common frames omitted [2022-01-13 16:08:45.441] [ restartedMain] [ERROR] c.its.traf.service.UnitSystService.destroyService 432 UnitSystService.destroy. system terminated....... [2022-01-13 16:11:00.709] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.load 16912 ptrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:10:00 KST 2022, STAT_DT=202201, STAT_HM=1610, DAY_TYPE_CD=DTW4, FROM_HM=1610, TO_HM_15M=1620, TO_HM_HH=1655, PTRN_DT05M=20211213161000, PTRN_DT15M=20211213160000) [2022-01-13 16:11:00.710] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.load 16912 prcsPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:10:00 KST 2021, STAT_DT=202112, STAT_HM=1610, DAY_TYPE_CD=DTW1, FROM_HM=1610, TO_HM_15M=1620, TO_HM_HH=1655, PTRN_DT05M=null, PTRN_DT15M=20211213160000) [2022-01-13 16:13:05.975] [ scheduleJob-7] [ERROR] c.i.t.s.pattern.PatternService.load 16912 ptrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:10:00 KST 2022, STAT_DT=202201, STAT_HM=1610, DAY_TYPE_CD=DTW4, FROM_HM=1610, TO_HM_15M=1620, TO_HM_HH=1655, PTRN_DT05M=20211213161000, PTRN_DT15M=20211213160000) [2022-01-13 16:13:05.977] [ scheduleJob-7] [ERROR] c.i.t.s.pattern.PatternService.load 16912 prcsPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:10:00 KST 2021, STAT_DT=202112, STAT_HM=1610, DAY_TYPE_CD=DTW1, FROM_HM=1610, TO_HM_15M=1620, TO_HM_HH=1655, PTRN_DT05M=null, PTRN_DT15M=20211213160000) [2022-01-13 16:14:12.978] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 2052 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:10:00 KST 2022, STAT_DT=202201, STAT_HM=1610, DAY_TYPE_CD=DTW4, FROM_HM=1610, TO_HM_15M=1620, TO_HM_HH=1655, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:14:12.979] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.load 2052 ptrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:10:00 KST 2022, STAT_DT=202201, STAT_HM=1610, DAY_TYPE_CD=DTW4, FROM_HM=1610, TO_HM_15M=1620, TO_HM_HH=1655, PTRN_DT05M=20211213161000, PTRN_DT15M=20211213160000) [2022-01-13 16:14:12.979] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 2052 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:10:00 KST 2021, STAT_DT=202112, STAT_HM=1610, DAY_TYPE_CD=DTW1, FROM_HM=1610, TO_HM_15M=1620, TO_HM_HH=1655, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:14:12.979] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.load 2052 prcsPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:10:00 KST 2021, STAT_DT=202112, STAT_HM=1610, DAY_TYPE_CD=DTW1, FROM_HM=1610, TO_HM_15M=1620, TO_HM_HH=1655, PTRN_DT05M=null, PTRN_DT15M=20211213160000) [2022-01-13 16:15:02.067] [ dbms-pool-2] [ERROR] o.s.a.i.SimpleAsyncUncaughtExceptionHandler.handleUncaughtException 2052 Unexpected exception occurred invoking async method: public void com.its.traf.process.DbmsJobTask.run(com.its.traf.process.AbstractDbmsJobProcess,com.its.traf.process.DbmsJobData) org.springframework.dao.DuplicateKeyException: ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 ### The error may exist in file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\UnitSyst.xml] ### The error may involve com.its.traf.mapper.UnitSystMapper.insertUnitSystSttsHs-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO TB_UNIT_SYST_STTS_HS ( CRTN_DT, SYST_ID, SYST_STTS_CD ) VALUES ( ?, ?, ? ) ### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 ; ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:247) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.$Proxy72.insert(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62) at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) at com.sun.proxy.$Proxy73.insertUnitSystSttsHs(Unknown Source) at com.its.traf.process.AbstractDbmsJobProcess.runJob(AbstractDbmsJobProcess.java:109) at com.its.traf.process.DbmsJobTask.run(DbmsJobTask.java:14) at com.its.traf.process.DbmsJobTask$$FastClassBySpringCGLIB$$aff10f07.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$$Lambda$623/1828631876.call(Unknown Source) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47) at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74) at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50) at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194) at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181) 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:483) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ... 19 common frames omitted [2022-01-13 16:15:10.725] [ scheduleJob-4] [ERROR] c.i.t.service.dao.BatchDaoService.insertBatch 2052 LinkDaoService.insertBatch: com.its.traf.mapper.base.LinkMapper.insertTrafficHs.insertTrafficHs: ERROR. Exception: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_TRAF_HS_PK)에 위배됩니다 ### Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_TRAF_HS_PK)에 위배됩니다 . [2022-01-13 16:15:10.736] [ dbms-pool-4] [ERROR] c.i.t.service.dao.BatchDaoService.insertBatch 2052 LinkDaoService.insertBatch: com.its.traf.mapper.base.LinkMapper.insertClctSystSttsHs.insertClctSystSttsHs: ERROR. Exception: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertClctSystSttsHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_CLCT_SYST_STTS_HS_PK)에 위배됩니다 ### Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertClctSystSttsHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_CLCT_SYST_STTS_HS_PK)에 위배됩니다 . [2022-01-13 16:15:10.742] [ dbms-pool-3] [ERROR] c.i.t.service.dao.BatchDaoService.insertBatch 2052 LinkDaoService.insertBatch: com.its.traf.mapper.base.LinkMapper.insertLinkTrafClctHs.insertLinkTrafClctHs: ERROR. Exception: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertLinkTrafClctHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_TRAF_CLCT_HS_PK)에 위배됩니다 ### Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertLinkTrafClctHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_TRAF_CLCT_HS_PK)에 위배됩니다 . [2022-01-13 16:15:10.757] [ scheduleJob-4] [ERROR] c.i.t.service.dao.BatchDaoService.insertBatch 2052 IfscDaoService.insertBatch: com.its.traf.mapper.base.IfscMapper.insertTrafficHs.insertTrafficHs: ERROR. Exception: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.IfscMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_IFSC_TRAF_HS_PK)에 위배됩니다 ### Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.IfscMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_IFSC_TRAF_HS_PK)에 위배됩니다 . [2022-01-13 16:15:10.777] [ scheduleJob-4] [ERROR] c.i.t.service.dao.BatchDaoService.insertBatch 2052 RoadDaoService.insertBatch: com.its.traf.mapper.base.RoadMapper.insertTrafficHs.insertTrafficHs: ERROR. Exception: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.RoadMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_ROAD_TRAF_HS_PK)에 위배됩니다 ### Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.RoadMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_ROAD_TRAF_HS_PK)에 위배됩니다 . [2022-01-13 16:15:10.786] [ scheduleJob-4] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 2052 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:10:00 KST 2022, STAT_DT=202201, STAT_HM=1610, DAY_TYPE_CD=DTW4, FROM_HM=1610, TO_HM_15M=1620, TO_HM_HH=1655, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:15:11.438] [ scheduleJob-4] [ERROR] c.i.traf.service.dao.LinkDaoService.insertTrafStat15M 2052 ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_15M_STAT_PK)에 위배됩니다 ### The error may exist in file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\base\Link.xml] ### The error may involve com.its.traf.mapper.base.LinkMapper.insertTrafStat15M-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO TB_LINK_15M_STAT ( STAT_DT, LINK_ID, DAY_TYPE_CD, TFVL, SPED, OCPY_RATE, TRVL_HH, DATA_NUM ) SELECT ? AS STAT_DT, LINK_ID AS LINK_ID, ? AS DAY_TYPE_CD, SUM(TFVL) AS TFVL, ROUND(AVG(SPED), 0) AS SPED, AVG(OCPY_RATE) AS OCPY_RATE, ROUND(AVG(TRVL_HH), 0) AS TRVL_HH, COUNT(DATA_NUM) AS DATA_NUM FROM TB_LINK_TRAF_HS WHERE PRCN_DT BETWEEN ? AND ? AND SPED > 0 AND SPED IS NOT NULL GROUP BY LINK_ID ### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_15M_STAT_PK)에 위배됩니다 ; ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_15M_STAT_PK)에 위배됩니다 ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_15M_STAT_PK)에 위배됩니다 [2022-01-13 16:15:11.447] [ scheduleJob-4] [ERROR] c.i.traf.service.dao.IfscDaoService.insertTrafStat15M 2052 ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_IFSC_15M_STAT_PK)에 위배됩니다 ### The error may exist in file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\base\Ifsc.xml] ### The error may involve com.its.traf.mapper.base.IfscMapper.insertTrafStat15M-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO TB_IFSC_15M_STAT (STAT_DT, IFSC_ID, DAY_TYPE_CD, TFVL, SPED, OCPY_RATE, TRVL_HH, DATA_NUM ) SELECT ? AS STAT_DT, IFSC_ID AS IFSC_ID, ? AS DAY_TYPE_CD, SUM(TFVL) AS TFVL, ROUND(AVG(SPED), 0) AS SPED, AVG(OCPY_RATE) AS OCPY_RATE, ROUND(AVG(TRVL_HH), 0) AS TRVL_HH, COUNT(DATA_NUM) AS DATA_NUM FROM TB_IFSC_TRAF_HS WHERE PRCN_DT BETWEEN ? AND ? GROUP BY IFSC_ID ### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_IFSC_15M_STAT_PK)에 위배됩니다 ; ORA-00001: 무결성 제약 조건(YIITS.IX_IFSC_15M_STAT_PK)에 위배됩니다 ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_IFSC_15M_STAT_PK)에 위배됩니다 [2022-01-13 16:15:11.457] [ scheduleJob-4] [ERROR] c.i.traf.service.dao.RoadDaoService.insertTrafStat15M 2052 ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_ROAD_15M_STAT_PK)에 위배됩니다 ### The error may exist in file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\base\Road.xml] ### The error may involve com.its.traf.mapper.base.RoadMapper.insertTrafStat15M-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO TB_ROAD_15M_STAT (STAT_DT, ROAD_ID, DAY_TYPE_CD, TFVL, SPED, OCPY_RATE, TRVL_HH, DATA_NUM ) SELECT ? AS STAT_DT, ROAD_ID AS ROAD_ID, ? AS DAY_TYPE_CD, SUM(TFVL) AS TFVL, ROUND(AVG(SPED), 0) AS SPED, AVG(OCPY_RATE) AS OCPY_RATE, ROUND(AVG(TRVL_HH), 0) AS TRVL_HH, COUNT(DATA_NUM) AS DATA_NUM FROM TB_ROAD_TRAF_HS WHERE PRCN_DT BETWEEN ? AND ? GROUP BY ROAD_ID ### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_ROAD_15M_STAT_PK)에 위배됩니다 ; ORA-00001: 무결성 제약 조건(YIITS.IX_ROAD_15M_STAT_PK)에 위배됩니다 ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_ROAD_15M_STAT_PK)에 위배됩니다 [2022-01-13 16:15:11.459] [ scheduleJob-4] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 2052 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:00:00 KST 2022, STAT_DT=202201, STAT_HM=1600, DAY_TYPE_CD=DTW4, FROM_HM=1600, TO_HM_15M=1610, TO_HM_HH=1645, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:15:11.468] [ scheduleJob-4] [ERROR] c.i.t.s.dao.LinkPtrnDaoService.selectPtrn15MByHistory 2052 Invalid bound statement (not found): com.its.traf.mapper.pattern.LinkPtrnMapper.selectPtrn15MByHistory [2022-01-13 16:15:11.469] [ scheduleJob-4] [ERROR] c.i.t.s.dao.IfscPtrnDaoService.selectPtrn15M 2052 Invalid bound statement (not found): com.its.traf.mapper.pattern.IfscPtrnMapper.selectPtrn15M [2022-01-13 16:15:11.470] [ scheduleJob-4] [ERROR] c.i.t.s.dao.IfscPtrnDaoService.selectPtrn15MByHistory 2052 Invalid bound statement (not found): com.its.traf.mapper.pattern.IfscPtrnMapper.selectPtrn15MByHistory [2022-01-13 16:15:11.470] [ scheduleJob-4] [ERROR] c.i.t.s.dao.RoadPtrnDaoService.selectPtrn15M 2052 Invalid bound statement (not found): com.its.traf.mapper.pattern.RoadPtrnMapper.selectPtrn15M [2022-01-13 16:15:11.471] [ scheduleJob-4] [ERROR] c.i.t.s.dao.RoadPtrnDaoService.selectPtrn15MByHistory 2052 Invalid bound statement (not found): com.its.traf.mapper.pattern.RoadPtrnMapper.selectPtrn15MByHistory [2022-01-13 16:18:06.106] [ scheduleJob-4] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 2052 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:15:00 KST 2022, STAT_DT=202201, STAT_HM=1615, DAY_TYPE_CD=DTW4, FROM_HM=1615, TO_HM_15M=1625, TO_HM_HH=1700, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:18:06.106] [ scheduleJob-4] [ERROR] c.i.t.s.pattern.PatternService.load 2052 ptrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:15:00 KST 2022, STAT_DT=202201, STAT_HM=1615, DAY_TYPE_CD=DTW4, FROM_HM=1615, TO_HM_15M=1625, TO_HM_HH=1700, PTRN_DT05M=20211213161500, PTRN_DT15M=20211213161500) [2022-01-13 16:18:06.107] [ scheduleJob-4] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 2052 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:15:00 KST 2021, STAT_DT=202112, STAT_HM=1615, DAY_TYPE_CD=DTW1, FROM_HM=1615, TO_HM_15M=1625, TO_HM_HH=1700, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:18:06.107] [ scheduleJob-4] [ERROR] c.i.t.s.pattern.PatternService.load 2052 prcsPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:15:00 KST 2021, STAT_DT=202112, STAT_HM=1615, DAY_TYPE_CD=DTW1, FROM_HM=1615, TO_HM_15M=1625, TO_HM_HH=1700, PTRN_DT05M=null, PTRN_DT15M=20211213161500) [2022-01-13 16:18:30.998] [ Thread-12] [ERROR] c.i.t.TrafProcessingServerApplication.onApplicationEvent 2052 Application Terminated: 2022-01-13 16:18:30, org.springframework.context.event.ContextClosedEvent[source=org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@6f8d27a7, started on Thu Jan 13 16:14:08 KST 2022] [2022-01-13 16:18:31.362] [ Thread-12] [ERROR] c.its.traf.service.UnitSystService.destroyService 2052 UnitSystService.destroy. system terminated....... [2022-01-13 16:18:35.409] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 2052 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:15:00 KST 2022, STAT_DT=202201, STAT_HM=1615, DAY_TYPE_CD=DTW4, FROM_HM=1615, TO_HM_15M=1625, TO_HM_HH=1700, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:18:35.410] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.load 2052 ptrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:15:00 KST 2022, STAT_DT=202201, STAT_HM=1615, DAY_TYPE_CD=DTW4, FROM_HM=1615, TO_HM_15M=1625, TO_HM_HH=1700, PTRN_DT05M=20211213161500, PTRN_DT15M=20211213161500) [2022-01-13 16:18:35.410] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 2052 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:15:00 KST 2021, STAT_DT=202112, STAT_HM=1615, DAY_TYPE_CD=DTW1, FROM_HM=1615, TO_HM_15M=1625, TO_HM_HH=1700, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:18:35.410] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.load 2052 prcsPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:15:00 KST 2021, STAT_DT=202112, STAT_HM=1615, DAY_TYPE_CD=DTW4, FROM_HM=1615, TO_HM_15M=1625, TO_HM_HH=1700, PTRN_DT05M=20211213161500, PTRN_DT15M=20211213161500) [2022-01-13 16:19:29.810] [ Thread-46] [ERROR] c.i.t.TrafProcessingServerApplication.onApplicationEvent 2052 Application Terminated: 2022-01-13 16:19:29, org.springframework.context.event.ContextClosedEvent[source=org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@f9f9737, started on Thu Jan 13 16:18:31 KST 2022] [2022-01-13 16:19:30.193] [ Thread-46] [ERROR] c.its.traf.service.UnitSystService.destroyService 2052 UnitSystService.destroy. system terminated....... [2022-01-13 16:19:33.990] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 2052 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:15:00 KST 2022, STAT_DT=202201, STAT_HM=1615, DAY_TYPE_CD=DTW4, FROM_HM=1615, TO_HM_15M=1625, TO_HM_HH=1700, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:19:33.991] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.load 2052 ptrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:15:00 KST 2022, STAT_DT=202201, STAT_HM=1615, DAY_TYPE_CD=DTW4, FROM_HM=1615, TO_HM_15M=1625, TO_HM_HH=1700, PTRN_DT05M=20211213161500, PTRN_DT15M=20211213161500) [2022-01-13 16:19:33.992] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 2052 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:15:00 KST 2021, STAT_DT=202112, STAT_HM=1615, DAY_TYPE_CD=DTW1, FROM_HM=1615, TO_HM_15M=1625, TO_HM_HH=1700, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:19:33.992] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.load 2052 prcsPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:15:00 KST 2021, STAT_DT=202112, STAT_HM=1615, DAY_TYPE_CD=DTW4, FROM_HM=1615, TO_HM_15M=1625, TO_HM_HH=1700, PTRN_DT05M=20211213161500, PTRN_DT15M=20211213161500) [2022-01-13 16:19:53.987] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 3104 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:15:00 KST 2022, STAT_DT=202201, STAT_HM=1615, DAY_TYPE_CD=DTW4, FROM_HM=1615, TO_HM_15M=1625, TO_HM_HH=1700, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:19:53.989] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.load 3104 ptrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:15:00 KST 2022, STAT_DT=202201, STAT_HM=1615, DAY_TYPE_CD=DTW4, FROM_HM=1615, TO_HM_15M=1625, TO_HM_HH=1700, PTRN_DT05M=20211213161500, PTRN_DT15M=20211213161500) [2022-01-13 16:19:53.989] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 3104 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:15:00 KST 2021, STAT_DT=202112, STAT_HM=1615, DAY_TYPE_CD=DTW1, FROM_HM=1615, TO_HM_15M=1625, TO_HM_HH=1700, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:19:53.989] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.load 3104 prcsPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:15:00 KST 2021, STAT_DT=202112, STAT_HM=1615, DAY_TYPE_CD=DTW4, FROM_HM=1615, TO_HM_15M=1625, TO_HM_HH=1700, PTRN_DT05M=20211213161500, PTRN_DT15M=20211213161500) [2022-01-13 16:20:02.057] [ dbms-pool-2] [ERROR] o.s.a.i.SimpleAsyncUncaughtExceptionHandler.handleUncaughtException 3104 Unexpected exception occurred invoking async method: public void com.its.traf.process.DbmsJobTask.run(com.its.traf.process.AbstractDbmsJobProcess,com.its.traf.process.DbmsJobData) org.springframework.dao.DuplicateKeyException: ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 ### The error may exist in file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\UnitSyst.xml] ### The error may involve com.its.traf.mapper.UnitSystMapper.insertUnitSystSttsHs-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO TB_UNIT_SYST_STTS_HS ( CRTN_DT, SYST_ID, SYST_STTS_CD ) VALUES ( ?, ?, ? ) ### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 ; ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:247) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.$Proxy72.insert(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62) at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) at com.sun.proxy.$Proxy73.insertUnitSystSttsHs(Unknown Source) at com.its.traf.process.AbstractDbmsJobProcess.runJob(AbstractDbmsJobProcess.java:109) at com.its.traf.process.DbmsJobTask.run(DbmsJobTask.java:14) at com.its.traf.process.DbmsJobTask$$FastClassBySpringCGLIB$$aff10f07.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$$Lambda$623/1506237663.call(Unknown Source) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47) at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74) at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50) at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194) at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181) 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:483) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ... 19 common frames omitted [2022-01-13 16:20:10.458] [ scheduleJob-2] [ERROR] c.i.t.service.dao.BatchDaoService.insertBatch 3104 LinkDaoService.insertBatch: com.its.traf.mapper.base.LinkMapper.insertTrafficHs.insertTrafficHs: ERROR. Exception: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_TRAF_HS_PK)에 위배됩니다 ### Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_TRAF_HS_PK)에 위배됩니다 . [2022-01-13 16:20:10.466] [ dbms-pool-4] [ERROR] c.i.t.service.dao.BatchDaoService.insertBatch 3104 LinkDaoService.insertBatch: com.its.traf.mapper.base.LinkMapper.insertClctSystSttsHs.insertClctSystSttsHs: ERROR. Exception: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertClctSystSttsHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_CLCT_SYST_STTS_HS_PK)에 위배됩니다 ### Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertClctSystSttsHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_CLCT_SYST_STTS_HS_PK)에 위배됩니다 . [2022-01-13 16:20:10.472] [ dbms-pool-3] [ERROR] c.i.t.service.dao.BatchDaoService.insertBatch 3104 LinkDaoService.insertBatch: com.its.traf.mapper.base.LinkMapper.insertLinkTrafClctHs.insertLinkTrafClctHs: ERROR. Exception: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertLinkTrafClctHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_TRAF_CLCT_HS_PK)에 위배됩니다 ### Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertLinkTrafClctHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_TRAF_CLCT_HS_PK)에 위배됩니다 . [2022-01-13 16:20:10.484] [ scheduleJob-2] [ERROR] c.i.t.service.dao.BatchDaoService.insertBatch 3104 IfscDaoService.insertBatch: com.its.traf.mapper.base.IfscMapper.insertTrafficHs.insertTrafficHs: ERROR. Exception: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.IfscMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_IFSC_TRAF_HS_PK)에 위배됩니다 ### Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.IfscMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_IFSC_TRAF_HS_PK)에 위배됩니다 . [2022-01-13 16:20:10.497] [ scheduleJob-2] [ERROR] c.i.t.service.dao.BatchDaoService.insertBatch 3104 RoadDaoService.insertBatch: com.its.traf.mapper.base.RoadMapper.insertTrafficHs.insertTrafficHs: ERROR. Exception: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.RoadMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_ROAD_TRAF_HS_PK)에 위배됩니다 ### Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.RoadMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_ROAD_TRAF_HS_PK)에 위배됩니다 . [2022-01-13 16:20:10.504] [ scheduleJob-2] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 3104 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:15:00 KST 2022, STAT_DT=202201, STAT_HM=1615, DAY_TYPE_CD=DTW4, FROM_HM=1615, TO_HM_15M=1625, TO_HM_HH=1700, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:23:05.918] [ scheduleJob-5] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 3104 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:20:00 KST 2022, STAT_DT=202201, STAT_HM=1620, DAY_TYPE_CD=DTW4, FROM_HM=1620, TO_HM_15M=1630, TO_HM_HH=1705, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:23:05.920] [ scheduleJob-5] [ERROR] c.i.t.s.pattern.PatternService.load 3104 ptrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:20:00 KST 2022, STAT_DT=202201, STAT_HM=1620, DAY_TYPE_CD=DTW4, FROM_HM=1620, TO_HM_15M=1630, TO_HM_HH=1705, PTRN_DT05M=20211213162000, PTRN_DT15M=20211213161500) [2022-01-13 16:23:05.920] [ scheduleJob-5] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 3104 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:20:00 KST 2021, STAT_DT=202112, STAT_HM=1620, DAY_TYPE_CD=DTW1, FROM_HM=1620, TO_HM_15M=1630, TO_HM_HH=1705, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:23:05.920] [ scheduleJob-5] [ERROR] c.i.t.s.pattern.PatternService.load 3104 prcsPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:20:00 KST 2021, STAT_DT=202112, STAT_HM=1620, DAY_TYPE_CD=DTW4, FROM_HM=1620, TO_HM_15M=1630, TO_HM_HH=1705, PTRN_DT05M=20211213162000, PTRN_DT15M=20211213161500) [2022-01-13 16:25:02.027] [ dbms-pool-1] [ERROR] o.s.a.i.SimpleAsyncUncaughtExceptionHandler.handleUncaughtException 3104 Unexpected exception occurred invoking async method: public void com.its.traf.process.DbmsJobTask.run(com.its.traf.process.AbstractDbmsJobProcess,com.its.traf.process.DbmsJobData) org.springframework.dao.DuplicateKeyException: ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 ### The error may exist in file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\UnitSyst.xml] ### The error may involve com.its.traf.mapper.UnitSystMapper.insertUnitSystSttsHs-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO TB_UNIT_SYST_STTS_HS ( CRTN_DT, SYST_ID, SYST_STTS_CD ) VALUES ( ?, ?, ? ) ### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 ; ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:247) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.$Proxy72.insert(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62) at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) at com.sun.proxy.$Proxy73.insertUnitSystSttsHs(Unknown Source) at com.its.traf.process.AbstractDbmsJobProcess.runJob(AbstractDbmsJobProcess.java:109) at com.its.traf.process.DbmsJobTask.run(DbmsJobTask.java:14) at com.its.traf.process.DbmsJobTask$$FastClassBySpringCGLIB$$aff10f07.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$$Lambda$623/1506237663.call(Unknown Source) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47) at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74) at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50) at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194) at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181) 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:483) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ... 19 common frames omitted [2022-01-13 16:51:59.649] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 768 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:50:00 KST 2022, STAT_DT=202201, STAT_HM=1650, DAY_TYPE_CD=DTW4, FROM_HM=1650, TO_HM_15M=1700, TO_HM_HH=1735, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:51:59.650] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.load 768 ptrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:50:00 KST 2022, STAT_DT=202201, STAT_HM=1650, DAY_TYPE_CD=DTW4, FROM_HM=1650, TO_HM_15M=1700, TO_HM_HH=1735, PTRN_DT05M=20211213165000, PTRN_DT15M=20211213164500) [2022-01-13 16:51:59.650] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 768 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:50:00 KST 2021, STAT_DT=202112, STAT_HM=1650, DAY_TYPE_CD=DTW1, FROM_HM=1650, TO_HM_15M=1700, TO_HM_HH=1735, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:51:59.651] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.load 768 prcsPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:50:00 KST 2021, STAT_DT=202112, STAT_HM=1650, DAY_TYPE_CD=DTW4, FROM_HM=1650, TO_HM_15M=1700, TO_HM_HH=1735, PTRN_DT05M=20211213165000, PTRN_DT15M=20211213164500) [2022-01-13 16:51:59.664] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternLinkService.load 768 ptrnCond15M: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:45:00 KST 2021, STAT_DT=null, STAT_HM=1645, DAY_TYPE_CD=DTW4, FROM_HM=1645, TO_HM_15M=null, TO_HM_HH=null, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:51:59.675] [ restartedMain] [ERROR] o.s.boot.SpringApplication.reportFailure 768 Application run failed java.lang.IllegalStateException: Failed to execute CommandLineRunner at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:798) at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:779) at org.springframework.boot.SpringApplication.run(SpringApplication.java:322) at com.its.traf.TrafProcessingServerApplication.main(TrafProcessingServerApplication.java:49) 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:483) at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) Caused by: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='cond.STAT_DT', mode=IN, javaType=class java.lang.Object, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting null for parameter #1 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLException: 부적합한 열 유형: 1111 at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.$Proxy72.selectList(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224) at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80) at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) at com.sun.proxy.$Proxy80.selectPtrn15M(Unknown Source) at com.its.traf.service.pattern.PatternLinkService.load(PatternLinkService.java:114) at com.its.traf.service.pattern.PatternLinkService.load(PatternLinkService.java:70) at com.its.traf.service.pattern.PatternLinkService$$FastClassBySpringCGLIB$$552c303a.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88) at com.its.traf.aspectj.ApplicationElapsedAspect.loadingElapsedTime(ApplicationElapsedAspect.java:32) at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:483) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) at com.its.traf.service.pattern.PatternLinkService$$EnhancerBySpringCGLIB$$71ad7d72.load() at com.its.traf.service.pattern.PatternService.load(PatternService.java:78) at com.its.traf.service.pattern.PatternService$$FastClassBySpringCGLIB$$31739d14.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88) at com.its.traf.aspectj.ApplicationElapsedAspect.loadingElapsedTime(ApplicationElapsedAspect.java:32) 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:483) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) at com.its.traf.service.pattern.PatternService$$EnhancerBySpringCGLIB$$baf99c40.load() at com.its.traf.scheduler.job.JobTraffic05MPrepare.run(JobTraffic05MPrepare.java:53) at com.its.traf.scheduler.job.JobTraffic05MPrepare$$FastClassBySpringCGLIB$$a6a9e27b.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88) at com.its.traf.aspectj.ApplicationElapsedAspect.runElapsedTime(ApplicationElapsedAspect.java:52) 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:483) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) at com.its.traf.scheduler.job.JobTraffic05MPrepare$$EnhancerBySpringCGLIB$$dbc384d5.run() at com.its.traf.TrafProcessingServerApplication.run(TrafProcessingServerApplication.java:80) at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:795) ... 8 common frames omitted Caused by: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='cond.STAT_DT', mode=IN, javaType=class java.lang.Object, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting null for parameter #1 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLException: 부적합한 열 유형: 1111 at org.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:89) at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:94) at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:64) at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:88) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) 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:483) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ... 83 common frames omitted Caused by: org.apache.ibatis.type.TypeException: Error setting null for parameter #1 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLException: 부적합한 열 유형: 1111 at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:67) at org.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:87) ... 99 common frames omitted Caused by: java.sql.SQLException: 부적합한 열 유형: 1111 at oracle.jdbc.driver.OracleStatement.getInternalType(OracleStatement.java:4369) at oracle.jdbc.driver.OraclePreparedStatement.setNullCritical(OraclePreparedStatement.java:5836) at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:5818) at oracle.jdbc.driver.OraclePreparedStatementWrapper.setNull(OraclePreparedStatementWrapper.java:1292) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.setNull(HikariProxyPreparedStatement.java) at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:65) ... 100 common frames omitted [2022-01-13 16:51:59.950] [ restartedMain] [ERROR] c.its.traf.service.UnitSystService.destroyService 768 UnitSystService.destroy. system terminated....... [2022-01-13 16:55:21.313] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 4544 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:55:00 KST 2022, STAT_DT=202201, STAT_HM=1655, DAY_TYPE_CD=DTW4, FROM_HM=1655, TO_HM_15M=1705, TO_HM_HH=1740, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:55:21.314] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.load 4544 ptrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:55:00 KST 2022, STAT_DT=202201, STAT_HM=1655, DAY_TYPE_CD=DTW4, FROM_HM=1655, TO_HM_15M=1705, TO_HM_HH=1740, PTRN_DT05M=20211213165500, PTRN_DT15M=20211213164500) [2022-01-13 16:55:21.314] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 4544 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:55:00 KST 2021, STAT_DT=202112, STAT_HM=1655, DAY_TYPE_CD=DTW1, FROM_HM=1655, TO_HM_15M=1705, TO_HM_HH=1740, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:55:21.314] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.load 4544 prcsPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:55:00 KST 2021, STAT_DT=202112, STAT_HM=1655, DAY_TYPE_CD=DTW4, FROM_HM=1655, TO_HM_15M=1705, TO_HM_HH=1740, PTRN_DT05M=20211213165500, PTRN_DT15M=20211213164500) [2022-01-13 16:55:21.327] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternLinkService.load 4544 ptrnCond15M: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:45:00 KST 2021, STAT_DT=202112, STAT_HM=1645, DAY_TYPE_CD=DTW4, FROM_HM=1645, TO_HM_15M=null, TO_HM_HH=null, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:58:05.620] [ scheduleJob-6] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 4544 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:55:00 KST 2022, STAT_DT=202201, STAT_HM=1655, DAY_TYPE_CD=DTW4, FROM_HM=1655, TO_HM_15M=1705, TO_HM_HH=1740, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:58:05.620] [ scheduleJob-6] [ERROR] c.i.t.s.pattern.PatternService.load 4544 ptrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:55:00 KST 2022, STAT_DT=202201, STAT_HM=1655, DAY_TYPE_CD=DTW4, FROM_HM=1655, TO_HM_15M=1705, TO_HM_HH=1740, PTRN_DT05M=20211213165500, PTRN_DT15M=20211213164500) [2022-01-13 16:58:05.621] [ scheduleJob-6] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 4544 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:55:00 KST 2021, STAT_DT=202112, STAT_HM=1655, DAY_TYPE_CD=DTW1, FROM_HM=1655, TO_HM_15M=1705, TO_HM_HH=1740, PTRN_DT05M=null, PTRN_DT15M=null) [2022-01-13 16:58:05.621] [ scheduleJob-6] [ERROR] c.i.t.s.pattern.PatternService.load 4544 prcsPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:55:00 KST 2021, STAT_DT=202112, STAT_HM=1655, DAY_TYPE_CD=DTW4, FROM_HM=1655, TO_HM_15M=1705, TO_HM_HH=1740, PTRN_DT05M=20211213165500, PTRN_DT15M=20211213164500) [2022-01-13 16:59:55.559] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 624 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:55:00 KST 2021, STAT_DT=202112, STAT_HM=1655, DAY_TYPE_CD=DTW1, FROM_HM=1655, TO_HM_15M=1705, TO_HM_HH=1740) [2022-01-13 16:59:55.560] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.load 624 ptrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:55:00 KST 2021, STAT_DT=202112, STAT_HM=1655, DAY_TYPE_CD=DTW4, FROM_HM=1655, TO_HM_15M=1705, TO_HM_HH=1740) [2022-01-13 16:59:55.591] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternLinkService.load 624 ptrnCond15M: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 16:45:00 KST 2021, STAT_DT=202112, STAT_HM=1645, DAY_TYPE_CD=DTW4, FROM_HM=1645, TO_HM_15M=null, TO_HM_HH=null) [2022-01-13 17:00:02.095] [ dbms-pool-2] [ERROR] o.s.a.i.SimpleAsyncUncaughtExceptionHandler.handleUncaughtException 624 Unexpected exception occurred invoking async method: public void com.its.traf.process.DbmsJobTask.run(com.its.traf.process.AbstractDbmsJobProcess,com.its.traf.process.DbmsJobData) org.springframework.dao.DuplicateKeyException: ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 ### The error may exist in file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\UnitSyst.xml] ### The error may involve com.its.traf.mapper.UnitSystMapper.insertUnitSystSttsHs-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO TB_UNIT_SYST_STTS_HS ( CRTN_DT, SYST_ID, SYST_STTS_CD ) VALUES ( ?, ?, ? ) ### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 ; ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:247) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.$Proxy72.insert(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62) at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) at com.sun.proxy.$Proxy73.insertUnitSystSttsHs(Unknown Source) at com.its.traf.process.AbstractDbmsJobProcess.runJob(AbstractDbmsJobProcess.java:109) at com.its.traf.process.DbmsJobTask.run(DbmsJobTask.java:14) at com.its.traf.process.DbmsJobTask$$FastClassBySpringCGLIB$$aff10f07.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$$Lambda$623/1841407108.call(Unknown Source) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47) at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74) at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50) at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194) at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181) 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:483) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ... 19 common frames omitted [2022-01-13 17:00:10.538] [ scheduleJob-3] [ERROR] c.i.t.service.dao.BatchDaoService.insertBatch 624 LinkDaoService.insertBatch: com.its.traf.mapper.base.LinkMapper.insertTrafficHs.insertTrafficHs: ERROR. Exception: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_TRAF_HS_PK)에 위배됩니다 ### Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_TRAF_HS_PK)에 위배됩니다 . [2022-01-13 17:00:10.548] [ dbms-pool-4] [ERROR] c.i.t.service.dao.BatchDaoService.insertBatch 624 LinkDaoService.insertBatch: com.its.traf.mapper.base.LinkMapper.insertClctSystSttsHs.insertClctSystSttsHs: ERROR. Exception: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertClctSystSttsHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_CLCT_SYST_STTS_HS_PK)에 위배됩니다 ### Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertClctSystSttsHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_CLCT_SYST_STTS_HS_PK)에 위배됩니다 . [2022-01-13 17:00:10.554] [ dbms-pool-3] [ERROR] c.i.t.service.dao.BatchDaoService.insertBatch 624 LinkDaoService.insertBatch: com.its.traf.mapper.base.LinkMapper.insertLinkTrafClctHs.insertLinkTrafClctHs: ERROR. Exception: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertLinkTrafClctHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_TRAF_CLCT_HS_PK)에 위배됩니다 ### Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertLinkTrafClctHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_TRAF_CLCT_HS_PK)에 위배됩니다 . [2022-01-13 17:00:10.571] [ scheduleJob-3] [ERROR] c.i.t.service.dao.BatchDaoService.insertBatch 624 IfscDaoService.insertBatch: com.its.traf.mapper.base.IfscMapper.insertTrafficHs.insertTrafficHs: ERROR. Exception: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.IfscMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_IFSC_TRAF_HS_PK)에 위배됩니다 ### Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.IfscMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_IFSC_TRAF_HS_PK)에 위배됩니다 . [2022-01-13 17:00:10.585] [ scheduleJob-3] [ERROR] c.i.t.service.dao.BatchDaoService.insertBatch 624 RoadDaoService.insertBatch: com.its.traf.mapper.base.RoadMapper.insertTrafficHs.insertTrafficHs: ERROR. Exception: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.RoadMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_ROAD_TRAF_HS_PK)에 위배됩니다 ### Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.RoadMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_ROAD_TRAF_HS_PK)에 위배됩니다 . [2022-01-13 17:00:10.591] [ scheduleJob-3] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 624 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:55:00 KST 2022, STAT_DT=202201, STAT_HM=1655, DAY_TYPE_CD=DTW4, FROM_HM=1655, TO_HM_15M=1705, TO_HM_HH=1740) [2022-01-13 17:00:11.162] [ scheduleJob-3] [ERROR] c.i.traf.service.dao.LinkDaoService.insertTrafStat15M 624 ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_15M_STAT_PK)에 위배됩니다 ### The error may exist in file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\base\Link.xml] ### The error may involve com.its.traf.mapper.base.LinkMapper.insertTrafStat15M-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO TB_LINK_15M_STAT ( STAT_DT, LINK_ID, DAY_TYPE_CD, TFVL, SPED, OCPY_RATE, TRVL_HH, DATA_NUM ) SELECT ? AS STAT_DT, LINK_ID AS LINK_ID, ? AS DAY_TYPE_CD, SUM(TFVL) AS TFVL, ROUND(AVG(SPED), 0) AS SPED, AVG(OCPY_RATE) AS OCPY_RATE, ROUND(AVG(TRVL_HH), 0) AS TRVL_HH, COUNT(DATA_NUM) AS DATA_NUM FROM TB_LINK_TRAF_HS WHERE PRCN_DT BETWEEN ? AND ? AND SPED > 0 AND SPED IS NOT NULL GROUP BY LINK_ID ### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_15M_STAT_PK)에 위배됩니다 ; ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_15M_STAT_PK)에 위배됩니다 ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_15M_STAT_PK)에 위배됩니다 [2022-01-13 17:00:11.170] [ scheduleJob-3] [ERROR] c.i.traf.service.dao.IfscDaoService.insertTrafStat15M 624 ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_IFSC_15M_STAT_PK)에 위배됩니다 ### The error may exist in file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\base\Ifsc.xml] ### The error may involve com.its.traf.mapper.base.IfscMapper.insertTrafStat15M-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO TB_IFSC_15M_STAT (STAT_DT, IFSC_ID, DAY_TYPE_CD, TFVL, SPED, OCPY_RATE, TRVL_HH, DATA_NUM ) SELECT ? AS STAT_DT, IFSC_ID AS IFSC_ID, ? AS DAY_TYPE_CD, SUM(TFVL) AS TFVL, ROUND(AVG(SPED), 0) AS SPED, AVG(OCPY_RATE) AS OCPY_RATE, ROUND(AVG(TRVL_HH), 0) AS TRVL_HH, COUNT(DATA_NUM) AS DATA_NUM FROM TB_IFSC_TRAF_HS WHERE PRCN_DT BETWEEN ? AND ? GROUP BY IFSC_ID ### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_IFSC_15M_STAT_PK)에 위배됩니다 ; ORA-00001: 무결성 제약 조건(YIITS.IX_IFSC_15M_STAT_PK)에 위배됩니다 ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_IFSC_15M_STAT_PK)에 위배됩니다 [2022-01-13 17:00:11.178] [ scheduleJob-3] [ERROR] c.i.traf.service.dao.RoadDaoService.insertTrafStat15M 624 ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_ROAD_15M_STAT_PK)에 위배됩니다 ### The error may exist in file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\base\Road.xml] ### The error may involve com.its.traf.mapper.base.RoadMapper.insertTrafStat15M-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO TB_ROAD_15M_STAT (STAT_DT, ROAD_ID, DAY_TYPE_CD, TFVL, SPED, OCPY_RATE, TRVL_HH, DATA_NUM ) SELECT ? AS STAT_DT, ROAD_ID AS ROAD_ID, ? AS DAY_TYPE_CD, SUM(TFVL) AS TFVL, ROUND(AVG(SPED), 0) AS SPED, AVG(OCPY_RATE) AS OCPY_RATE, ROUND(AVG(TRVL_HH), 0) AS TRVL_HH, COUNT(DATA_NUM) AS DATA_NUM FROM TB_ROAD_TRAF_HS WHERE PRCN_DT BETWEEN ? AND ? GROUP BY ROAD_ID ### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_ROAD_15M_STAT_PK)에 위배됩니다 ; ORA-00001: 무결성 제약 조건(YIITS.IX_ROAD_15M_STAT_PK)에 위배됩니다 ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_ROAD_15M_STAT_PK)에 위배됩니다 [2022-01-13 17:00:11.180] [ scheduleJob-3] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 624 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 16:45:00 KST 2022, STAT_DT=202201, STAT_HM=1645, DAY_TYPE_CD=DTW4, FROM_HM=1645, TO_HM_15M=1655, TO_HM_HH=1730) [2022-01-13 17:00:11.188] [ scheduleJob-3] [ERROR] c.i.t.s.dao.LinkPtrnDaoService.selectPtrn15MByHistory 624 Invalid bound statement (not found): com.its.traf.mapper.pattern.LinkPtrnMapper.selectPtrn15MByHistory [2022-01-13 17:00:11.189] [ scheduleJob-3] [ERROR] c.i.t.s.dao.IfscPtrnDaoService.selectPtrn15M 624 Invalid bound statement (not found): com.its.traf.mapper.pattern.IfscPtrnMapper.selectPtrn15M [2022-01-13 17:00:11.190] [ scheduleJob-3] [ERROR] c.i.t.s.dao.IfscPtrnDaoService.selectPtrn15MByHistory 624 Invalid bound statement (not found): com.its.traf.mapper.pattern.IfscPtrnMapper.selectPtrn15MByHistory [2022-01-13 17:00:11.190] [ scheduleJob-3] [ERROR] c.i.t.s.dao.RoadPtrnDaoService.selectPtrn15M 624 Invalid bound statement (not found): com.its.traf.mapper.pattern.RoadPtrnMapper.selectPtrn15M [2022-01-13 17:00:11.191] [ scheduleJob-3] [ERROR] c.i.t.s.dao.RoadPtrnDaoService.selectPtrn15MByHistory 624 Invalid bound statement (not found): com.its.traf.mapper.pattern.RoadPtrnMapper.selectPtrn15MByHistory [2022-01-13 17:28:35.911] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 18352 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 17:25:00 KST 2021, STAT_DT=202112, STAT_HM=1725, DAY_TYPE_CD=DTW1, FROM_HM=1725, TO_HM_15M=1735, TO_HM_HH=1810) [2022-01-13 17:28:35.912] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternService.load 18352 ptrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 17:25:00 KST 2021, STAT_DT=202112, STAT_HM=1725, DAY_TYPE_CD=DTW4, FROM_HM=1725, TO_HM_15M=1735, TO_HM_HH=1810) [2022-01-13 17:28:35.928] [ restartedMain] [ERROR] c.i.t.s.pattern.PatternLinkService.load 18352 ptrnCond15M: PtrnSelectCondVo(holiday=false, PRCN_DT=Mon Dec 13 17:15:00 KST 2021, STAT_DT=202112, STAT_HM=1715, DAY_TYPE_CD=DTW4, FROM_HM=1715, TO_HM_15M=null, TO_HM_HH=null) [2022-01-13 17:30:02.043] [ dbms-pool-3] [ERROR] o.s.a.i.SimpleAsyncUncaughtExceptionHandler.handleUncaughtException 18352 Unexpected exception occurred invoking async method: public void com.its.traf.process.DbmsJobTask.run(com.its.traf.process.AbstractDbmsJobProcess,com.its.traf.process.DbmsJobData) org.springframework.dao.DuplicateKeyException: ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 ### The error may exist in file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\UnitSyst.xml] ### The error may involve com.its.traf.mapper.UnitSystMapper.insertUnitSystSttsHs-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO TB_UNIT_SYST_STTS_HS ( CRTN_DT, SYST_ID, SYST_STTS_CD ) VALUES ( ?, ?, ? ) ### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 ; ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:247) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.$Proxy72.insert(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62) at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) at com.sun.proxy.$Proxy73.insertUnitSystSttsHs(Unknown Source) at com.its.traf.process.AbstractDbmsJobProcess.runJob(AbstractDbmsJobProcess.java:109) at com.its.traf.process.DbmsJobTask.run(DbmsJobTask.java:14) at com.its.traf.process.DbmsJobTask$$FastClassBySpringCGLIB$$aff10f07.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$$Lambda$623/759037368.call(Unknown Source) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_UNIT_SYST_STTS_HS_PK)에 위배됩니다 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47) at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74) at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50) at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194) at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181) 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:483) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ... 19 common frames omitted [2022-01-13 17:30:10.561] [ scheduleJob-5] [ERROR] c.i.t.service.dao.BatchDaoService.insertBatch 18352 LinkDaoService.insertBatch: com.its.traf.mapper.base.LinkMapper.insertTrafficHs.insertTrafficHs: ERROR. Exception: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_TRAF_HS_PK)에 위배됩니다 ### Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_TRAF_HS_PK)에 위배됩니다 . [2022-01-13 17:30:10.569] [ dbms-pool-5] [ERROR] c.i.t.service.dao.BatchDaoService.insertBatch 18352 LinkDaoService.insertBatch: com.its.traf.mapper.base.LinkMapper.insertClctSystSttsHs.insertClctSystSttsHs: ERROR. Exception: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertClctSystSttsHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_CLCT_SYST_STTS_HS_PK)에 위배됩니다 ### Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertClctSystSttsHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_CLCT_SYST_STTS_HS_PK)에 위배됩니다 . [2022-01-13 17:30:10.574] [ dbms-pool-4] [ERROR] c.i.t.service.dao.BatchDaoService.insertBatch 18352 LinkDaoService.insertBatch: com.its.traf.mapper.base.LinkMapper.insertLinkTrafClctHs.insertLinkTrafClctHs: ERROR. Exception: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertLinkTrafClctHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_TRAF_CLCT_HS_PK)에 위배됩니다 ### Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.LinkMapper.insertLinkTrafClctHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_TRAF_CLCT_HS_PK)에 위배됩니다 . [2022-01-13 17:30:10.588] [ scheduleJob-5] [ERROR] c.i.t.service.dao.BatchDaoService.insertBatch 18352 IfscDaoService.insertBatch: com.its.traf.mapper.base.IfscMapper.insertTrafficHs.insertTrafficHs: ERROR. Exception: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.IfscMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_IFSC_TRAF_HS_PK)에 위배됩니다 ### Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.IfscMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_IFSC_TRAF_HS_PK)에 위배됩니다 . [2022-01-13 17:30:10.602] [ scheduleJob-5] [ERROR] c.i.t.service.dao.BatchDaoService.insertBatch 18352 RoadDaoService.insertBatch: com.its.traf.mapper.base.RoadMapper.insertTrafficHs.insertTrafficHs: ERROR. Exception: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.RoadMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_ROAD_TRAF_HS_PK)에 위배됩니다 ### Cause: org.apache.ibatis.executor.BatchExecutorException: com.its.traf.mapper.base.RoadMapper.insertTrafficHs (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: 무결성 제약 조건(YIITS.IX_ROAD_TRAF_HS_PK)에 위배됩니다 . [2022-01-13 17:30:10.607] [ scheduleJob-5] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 18352 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 17:25:00 KST 2022, STAT_DT=202201, STAT_HM=1725, DAY_TYPE_CD=DTW4, FROM_HM=1725, TO_HM_15M=1735, TO_HM_HH=1810) [2022-01-13 17:30:11.099] [ scheduleJob-5] [ERROR] c.i.traf.service.dao.LinkDaoService.insertTrafStat15M 18352 ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_15M_STAT_PK)에 위배됩니다 ### The error may exist in file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\base\Link.xml] ### The error may involve com.its.traf.mapper.base.LinkMapper.insertTrafStat15M-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO TB_LINK_15M_STAT ( STAT_DT, LINK_ID, DAY_TYPE_CD, TFVL, SPED, OCPY_RATE, TRVL_HH, DATA_NUM ) SELECT ? AS STAT_DT, LINK_ID AS LINK_ID, ? AS DAY_TYPE_CD, SUM(TFVL) AS TFVL, ROUND(AVG(SPED), 0) AS SPED, AVG(OCPY_RATE) AS OCPY_RATE, ROUND(AVG(TRVL_HH), 0) AS TRVL_HH, COUNT(DATA_NUM) AS DATA_NUM FROM TB_LINK_TRAF_HS WHERE PRCN_DT BETWEEN ? AND ? AND SPED > 0 AND SPED IS NOT NULL GROUP BY LINK_ID ### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_15M_STAT_PK)에 위배됩니다 ; ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_15M_STAT_PK)에 위배됩니다 ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_LINK_15M_STAT_PK)에 위배됩니다 [2022-01-13 17:30:11.108] [ scheduleJob-5] [ERROR] c.i.traf.service.dao.IfscDaoService.insertTrafStat15M 18352 ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_IFSC_15M_STAT_PK)에 위배됩니다 ### The error may exist in file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\base\Ifsc.xml] ### The error may involve com.its.traf.mapper.base.IfscMapper.insertTrafStat15M-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO TB_IFSC_15M_STAT (STAT_DT, IFSC_ID, DAY_TYPE_CD, TFVL, SPED, OCPY_RATE, TRVL_HH, DATA_NUM ) SELECT ? AS STAT_DT, IFSC_ID AS IFSC_ID, ? AS DAY_TYPE_CD, SUM(TFVL) AS TFVL, ROUND(AVG(SPED), 0) AS SPED, AVG(OCPY_RATE) AS OCPY_RATE, ROUND(AVG(TRVL_HH), 0) AS TRVL_HH, COUNT(DATA_NUM) AS DATA_NUM FROM TB_IFSC_TRAF_HS WHERE PRCN_DT BETWEEN ? AND ? GROUP BY IFSC_ID ### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_IFSC_15M_STAT_PK)에 위배됩니다 ; ORA-00001: 무결성 제약 조건(YIITS.IX_IFSC_15M_STAT_PK)에 위배됩니다 ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_IFSC_15M_STAT_PK)에 위배됩니다 [2022-01-13 17:30:11.115] [ scheduleJob-5] [ERROR] c.i.traf.service.dao.RoadDaoService.insertTrafStat15M 18352 ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_ROAD_15M_STAT_PK)에 위배됩니다 ### The error may exist in file [C:\DEV\ITS\01.WINDOWS\22.01.YONGIN\JAVA\traf-prcs-server\target\classes\mybatis\mapper\base\Road.xml] ### The error may involve com.its.traf.mapper.base.RoadMapper.insertTrafStat15M-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO TB_ROAD_15M_STAT (STAT_DT, ROAD_ID, DAY_TYPE_CD, TFVL, SPED, OCPY_RATE, TRVL_HH, DATA_NUM ) SELECT ? AS STAT_DT, ROAD_ID AS ROAD_ID, ? AS DAY_TYPE_CD, SUM(TFVL) AS TFVL, ROUND(AVG(SPED), 0) AS SPED, AVG(OCPY_RATE) AS OCPY_RATE, ROUND(AVG(TRVL_HH), 0) AS TRVL_HH, COUNT(DATA_NUM) AS DATA_NUM FROM TB_ROAD_TRAF_HS WHERE PRCN_DT BETWEEN ? AND ? GROUP BY ROAD_ID ### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_ROAD_15M_STAT_PK)에 위배됩니다 ; ORA-00001: 무결성 제약 조건(YIITS.IX_ROAD_15M_STAT_PK)에 위배됩니다 ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 무결성 제약 조건(YIITS.IX_ROAD_15M_STAT_PK)에 위배됩니다 [2022-01-13 17:30:11.115] [ scheduleJob-5] [ERROR] c.i.t.s.pattern.PatternService.getPtrnCond 18352 getPtrnCond: PtrnSelectCondVo(holiday=false, PRCN_DT=Thu Jan 13 17:15:00 KST 2022, STAT_DT=202201, STAT_HM=1715, DAY_TYPE_CD=DTW4, FROM_HM=1715, TO_HM_15M=1725, TO_HM_HH=1800) [2022-01-13 17:30:11.602] [ scheduleJob-5] [ERROR] c.i.t.scheduler.ProcessingScheduler.runJob 18352 Invalid bound statement (not found): com.its.traf.mapper.pattern.IfscPtrnMapper.selectPtrn15M