traf-prcs-server/logs/backup/traf-prcs-server.err.log.2022-01-13_0.log

[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.<init>(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.<init>(AbstractCollectSystMapper.java:17)
	at com.its.traf.mapper.collect.CollectSystDao.<init>(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(<generated>)
	at com.its.traf.config.DatabaseConfig$$EnhancerBySpringCGLIB$$7946ad78$$FastClassBySpringCGLIB$$d4497c10.invoke(<generated>)
	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(<generated>)
	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.<init>(AbstractCollectSystMapper.java:17)
	at com.its.traf.mapper.collect.CollectSystDao.<init>(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(<generated>)
	at com.its.traf.config.DatabaseConfig$$EnhancerBySpringCGLIB$$26ef6251$$FastClassBySpringCGLIB$$845e80a5.invoke(<generated>)
	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(<generated>)
	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.<init>(MapperMethod.java:235)
	at org.apache.ibatis.binding.MapperMethod.<init>(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(<generated>)
	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(<generated>)
	at com.its.traf.service.pattern.PatternService.load(PatternService.java:75)
	at com.its.traf.service.pattern.PatternService$$FastClassBySpringCGLIB$$31739d14.invoke(<generated>)
	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(<generated>)
	at com.its.traf.scheduler.job.JobTraffic05MPrepare.run(JobTraffic05MPrepare.java:53)
	at com.its.traf.scheduler.job.JobTraffic05MPrepare$$FastClassBySpringCGLIB$$a6a9e27b.invoke(<generated>)
	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(<generated>)
	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.<init>(MapperMethod.java:235)
	at org.apache.ibatis.binding.MapperMethod.<init>(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(<generated>)
	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(<generated>)
	at com.its.traf.service.pattern.PatternService.load(PatternService.java:75)
	at com.its.traf.service.pattern.PatternService$$FastClassBySpringCGLIB$$31739d14.invoke(<generated>)
	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(<generated>)
	at com.its.traf.scheduler.job.JobTraffic05MPrepare.run(JobTraffic05MPrepare.java:53)
	at com.its.traf.scheduler.job.JobTraffic05MPrepare$$FastClassBySpringCGLIB$$a6a9e27b.invoke(<generated>)
	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(<generated>)
	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(<generated>)
	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(<generated>)
	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(<generated>)
	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(<generated>)
	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(<generated>)
	at com.its.traf.service.pattern.PatternService.load(PatternService.java:78)
	at com.its.traf.service.pattern.PatternService$$FastClassBySpringCGLIB$$31739d14.invoke(<generated>)
	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(<generated>)
	at com.its.traf.scheduler.job.JobTraffic05MPrepare.run(JobTraffic05MPrepare.java:53)
	at com.its.traf.scheduler.job.JobTraffic05MPrepare$$FastClassBySpringCGLIB$$a6a9e27b.invoke(<generated>)
	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(<generated>)
	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(<generated>)
	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(<generated>)
	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