API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 11th, 2017
201
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 57.53 KB | None | 0 0
raw download clone embed print report
  1. AI13-app-one:/kohls/file/ecmdm/ai19/ecmdm-batch-atg-source-to-stage-job/incoming> java -jar /kohls/apps/uc/ecmdm-batch-atg-source-to-stage-job.jar --spring.config.location=file:/kohls/file/is/ecmdm-batch-atg-source-to-stage-job-passwd.properties,file:/kohls/file/is/properties/ecmdm-batch-atg-source-to-stage-job-props.properties user.accounts.file=/kohls/file/ecmdm/ai19/ecmdm-batch-atg-source-to-stage-job/incoming/USER_ACCOUNT_12122016_000000.dat.enc user.address.file=/kohls/file/ecmdm/ai19/ecmdm-batch-atg-source-to-stage-job/incoming/ADDRESS_12122016_000000.dat.enc
  2.  
  3. . ____ _ __ _ _
  4. /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
  5. ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
  6. \\/ ___)| |_)| | | | | || (_| | ) ) ) )
  7. ' |____| .__|_| |_|_| |_\__, | / / / /
  8. =========|_|==============|___/=/_/_/_/
  9. :: Spring Boot :: (v1.4.1.RELEASE)
  10.  
  11. 2017-01-11 07:36:42.343 INFO 15267 --- [ main] s.c.a.AnnotationConfigApplicationContext : Refreshing org.springframework.context.annotation.AnnotationConfigApplicationContext@21588809: startup date [Wed Jan 11 07:36:42 CST 2017]; root of context hierarchy
  12. 2017-01-11 07:36:42,343 INFO [main] o.s.c.a.AnnotationConfigApplicationContext - Refreshing org.springframework.context.annotation.AnnotationConfigApplicationContext@21588809: startup date [Wed Jan 11 07:36:42 CST 2017]; root of context hierarchy
  13. 2017-01-11 07:36:42.996 INFO 15267 --- [ main] o.s.b.f.config.PropertiesFactoryBean : Loading properties file from URL [jar:file:/kohls/apps/uc/ecmdm-batch-atg-source-to-stage-job.jar!/BOOT-INF/lib/spring-integration-core-4.3.2.RELEASE.jar!/META-INF/spring.integration.default.properties]
  14. 2017-01-11 07:36:42,996 INFO [main] o.s.b.f.config.PropertiesFactoryBean - Loading properties file from URL [jar:file:/kohls/apps/uc/ecmdm-batch-atg-source-to-stage-job.jar!/BOOT-INF/lib/spring-integration-core-4.3.2.RELEASE.jar!/META-INF/spring.integration.default.properties]
  15. 2017-01-11 07:36:42.999 INFO 15267 --- [ main] o.s.i.config.IntegrationRegistrar : No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
  16. 2017-01-11 07:36:42,999 INFO [main] o.s.i.config.IntegrationRegistrar - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
  17. 2017-01-11 07:36:43.253 WARN 15267 --- [ main] o.s.c.a.ConfigurationClassEnhancer : @Bean method ScopeConfiguration.stepScope is non-static and returns an object assignable to Spring's BeanFactoryPostProcessor interface. This will result in a failure to process annotations such as @Autowired, @Resource and @PostConstruct within the method's declaring @Configuration class. Add the 'static' modifier to this method to avoid these container lifecycle issues; see @Bean javadoc for complete details.
  18. 2017-01-11 07:36:43,253 WARN [main] o.s.c.a.ConfigurationClassEnhancer - @Bean method ScopeConfiguration.stepScope is non-static and returns an object assignable to Spring's BeanFactoryPostProcessor interface. This will result in a failure to process annotations such as @Autowired, @Resource and @PostConstruct within the method's declaring @Configuration class. Add the 'static' modifier to this method to avoid these container lifecycle issues; see @Bean javadoc for complete details.
  19. 2017-01-11 07:36:43.265 WARN 15267 --- [ main] o.s.c.a.ConfigurationClassEnhancer : @Bean method ScopeConfiguration.jobScope is non-static and returns an object assignable to Spring's BeanFactoryPostProcessor interface. This will result in a failure to process annotations such as @Autowired, @Resource and @PostConstruct within the method's declaring @Configuration class. Add the 'static' modifier to this method to avoid these container lifecycle issues; see @Bean javadoc for complete details.
  20. 2017-01-11 07:36:43,265 WARN [main] o.s.c.a.ConfigurationClassEnhancer - @Bean method ScopeConfiguration.jobScope is non-static and returns an object assignable to Spring's BeanFactoryPostProcessor interface. This will result in a failure to process annotations such as @Autowired, @Resource and @PostConstruct within the method's declaring @Configuration class. Add the 'static' modifier to this method to avoid these container lifecycle issues; see @Bean javadoc for complete details.
  21. 2017-01-11 07:36:43.266 INFO 15267 --- [ main] faultConfiguringBeanFactoryPostProcessor : No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
  22. 2017-01-11 07:36:43,266 INFO [main] o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
  23. 2017-01-11 07:36:43.273 INFO 15267 --- [ main] faultConfiguringBeanFactoryPostProcessor : No bean named 'taskScheduler' has been explicitly defined. Therefore, a default ThreadPoolTaskScheduler will be created.
  24. 2017-01-11 07:36:43,273 INFO [main] o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'taskScheduler' has been explicitly defined. Therefore, a default ThreadPoolTaskScheduler will be created.
  25. 2017-01-11 07:36:43.403 INFO 15267 --- [ main] o.s.b.f.config.PropertiesFactoryBean : Loading properties file from URL [jar:file:/kohls/apps/uc/ecmdm-batch-atg-source-to-stage-job.jar!/BOOT-INF/lib/spring-integration-core-4.3.2.RELEASE.jar!/META-INF/spring.integration.default.properties]
  26. 2017-01-11 07:36:43,403 INFO [main] o.s.b.f.config.PropertiesFactoryBean - Loading properties file from URL [jar:file:/kohls/apps/uc/ecmdm-batch-atg-source-to-stage-job.jar!/BOOT-INF/lib/spring-integration-core-4.3.2.RELEASE.jar!/META-INF/spring.integration.default.properties]
  27. 2017-01-11 07:36:43.404 INFO 15267 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'integrationGlobalProperties' of type [class org.springframework.beans.factory.config.PropertiesFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  28. 2017-01-11 07:36:43,404 INFO [main] o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'integrationGlobalProperties' of type [class org.springframework.beans.factory.config.PropertiesFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  29. 2017-01-11 07:36:43.415 INFO 15267 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [class org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$f6fa4caf] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  30. 2017-01-11 07:36:43,415 INFO [main] o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [class org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$f6fa4caf] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  31. 2017-01-11 07:36:43.453 INFO 15267 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'integrationGlobalProperties' of type [class java.util.Properties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  32. 2017-01-11 07:36:43,453 INFO [main] o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'integrationGlobalProperties' of type [class java.util.Properties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  33. 2017-01-11 07:36:44.389 INFO 15267 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'accountTaskExecutor'
  34. 2017-01-11 07:36:44,389 INFO [main] o.s.s.c.ThreadPoolTaskExecutor - Initializing ExecutorService 'accountTaskExecutor'
  35. 2017-01-11 07:36:44.425 WARN 15267 --- [ main] o.s.b.c.l.AbstractListenerFactoryBean : org.springframework.batch.item.ItemWriter is an interface. The implementing class will not be queried for annotation based listener configurations. If using @StepScope on a @Bean method, be sure to return the implementing class so listner annotations can be used.
  36. 2017-01-11 07:36:44,425 WARN [main] o.s.b.c.l.AbstractListenerFactoryBean - org.springframework.batch.item.ItemWriter is an interface. The implementing class will not be queried for annotation based listener configurations. If using @StepScope on a @Bean method, be sure to return the implementing class so listner annotations can be used.
  37. 2017-01-11 07:36:44.425 WARN 15267 --- [ main] o.s.b.c.l.AbstractListenerFactoryBean : org.springframework.batch.item.ItemProcessor is an interface. The implementing class will not be queried for annotation based listener configurations. If using @StepScope on a @Bean method, be sure to return the implementing class so listner annotations can be used.
  38. 2017-01-11 07:36:44,425 WARN [main] o.s.b.c.l.AbstractListenerFactoryBean - org.springframework.batch.item.ItemProcessor is an interface. The implementing class will not be queried for annotation based listener configurations. If using @StepScope on a @Bean method, be sure to return the implementing class so listner annotations can be used.
  39. 2017-01-11 07:36:44.441 INFO 15267 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'addressTaskExecutor'
  40. 2017-01-11 07:36:44,441 INFO [main] o.s.s.c.ThreadPoolTaskExecutor - Initializing ExecutorService 'addressTaskExecutor'
  41. 2017-01-11 07:36:44.443 WARN 15267 --- [ main] o.s.b.c.l.AbstractListenerFactoryBean : org.springframework.batch.item.ItemWriter is an interface. The implementing class will not be queried for annotation based listener configurations. If using @StepScope on a @Bean method, be sure to return the implementing class so listner annotations can be used.
  42. 2017-01-11 07:36:44,443 WARN [main] o.s.b.c.l.AbstractListenerFactoryBean - org.springframework.batch.item.ItemWriter is an interface. The implementing class will not be queried for annotation based listener configurations. If using @StepScope on a @Bean method, be sure to return the implementing class so listner annotations can be used.
  43. 2017-01-11 07:36:44.444 WARN 15267 --- [ main] o.s.b.c.l.AbstractListenerFactoryBean : org.springframework.batch.item.ItemProcessor is an interface. The implementing class will not be queried for annotation based listener configurations. If using @StepScope on a @Bean method, be sure to return the implementing class so listner annotations can be used.
  44. 2017-01-11 07:36:44,444 WARN [main] o.s.b.c.l.AbstractListenerFactoryBean - org.springframework.batch.item.ItemProcessor is an interface. The implementing class will not be queried for annotation based listener configurations. If using @StepScope on a @Bean method, be sure to return the implementing class so listner annotations can be used.
  45. 2017-01-11 07:36:44.469 INFO 15267 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'coreTaskExecutor'
  46. 2017-01-11 07:36:44,469 INFO [main] o.s.s.c.ThreadPoolTaskExecutor - Initializing ExecutorService 'coreTaskExecutor'
  47. 2017-01-11 07:36:44.475 WARN 15267 --- [ main] o.s.b.c.l.AbstractListenerFactoryBean : org.springframework.batch.item.ItemWriter is an interface. The implementing class will not be queried for annotation based listener configurations. If using @StepScope on a @Bean method, be sure to return the implementing class so listner annotations can be used.
  48. 2017-01-11 07:36:44,475 WARN [main] o.s.b.c.l.AbstractListenerFactoryBean - org.springframework.batch.item.ItemWriter is an interface. The implementing class will not be queried for annotation based listener configurations. If using @StepScope on a @Bean method, be sure to return the implementing class so listner annotations can be used.
  49. 2017-01-11 07:36:44.475 WARN 15267 --- [ main] o.s.b.c.l.AbstractListenerFactoryBean : org.springframework.batch.item.ItemProcessor is an interface. The implementing class will not be queried for annotation based listener configurations. If using @StepScope on a @Bean method, be sure to return the implementing class so listner annotations can be used.
  50. 2017-01-11 07:36:44,475 WARN [main] o.s.b.c.l.AbstractListenerFactoryBean - org.springframework.batch.item.ItemProcessor is an interface. The implementing class will not be queried for annotation based listener configurations. If using @StepScope on a @Bean method, be sure to return the implementing class so listner annotations can be used.
  51. 2017-01-11 07:36:44.478 WARN 15267 --- [ main] o.s.b.c.l.AbstractListenerFactoryBean : org.springframework.batch.item.ItemWriter is an interface. The implementing class will not be queried for annotation based listener configurations. If using @StepScope on a @Bean method, be sure to return the implementing class so listner annotations can be used.
  52. 2017-01-11 07:36:44,478 WARN [main] o.s.b.c.l.AbstractListenerFactoryBean - org.springframework.batch.item.ItemWriter is an interface. The implementing class will not be queried for annotation based listener configurations. If using @StepScope on a @Bean method, be sure to return the implementing class so listner annotations can be used.
  53. 2017-01-11 07:36:44.478 WARN 15267 --- [ main] o.s.b.c.l.AbstractListenerFactoryBean : org.springframework.batch.item.ItemProcessor is an interface. The implementing class will not be queried for annotation based listener configurations. If using @StepScope on a @Bean method, be sure to return the implementing class so listner annotations can be used.
  54. 2017-01-11 07:36:44,478 WARN [main] o.s.b.c.l.AbstractListenerFactoryBean - org.springframework.batch.item.ItemProcessor is an interface. The implementing class will not be queried for annotation based listener configurations. If using @StepScope on a @Bean method, be sure to return the implementing class so listner annotations can be used.
  55. 2017-01-11 07:36:44.493 WARN 15267 --- [ main] o.s.b.c.s.b.FaultTolerantStepBuilder : Asynchronous TaskExecutor detected with ItemStream reader. This is probably an error, and may lead to incorrect restart data being stored.
  56. 2017-01-11 07:36:44,493 WARN [main] o.s.b.c.s.b.FaultTolerantStepBuilder - Asynchronous TaskExecutor detected with ItemStream reader. This is probably an error, and may lead to incorrect restart data being stored.
  57. 2017-01-11 07:36:45.708 INFO 15267 --- [ main] o.s.b.c.r.s.JobRepositoryFactoryBean : No database type set, using meta data indicating: ORACLE
  58. 2017-01-11 07:36:45,708 INFO [main] o.s.b.c.r.s.JobRepositoryFactoryBean - No database type set, using meta data indicating: ORACLE
  59. 2017-01-11 07:36:45.842 INFO 15267 --- [ main] o.s.b.c.l.support.SimpleJobLauncher : No TaskExecutor has been set, defaulting to synchronous executor.
  60. 2017-01-11 07:36:45,842 INFO [main] o.s.b.c.l.support.SimpleJobLauncher - No TaskExecutor has been set, defaulting to synchronous executor.
  61. 2017-01-11 07:36:45.968 INFO 15267 --- [ main] o.s.jdbc.datasource.init.ScriptUtils : Executing SQL script from class path resource [org/springframework/batch/core/schema-oracle10g.sql]
  62. 2017-01-11 07:36:45,968 INFO [main] o.s.jdbc.datasource.init.ScriptUtils - Executing SQL script from class path resource [org/springframework/batch/core/schema-oracle10g.sql]
  63. 2017-01-11 07:36:46.506 INFO 15267 --- [ main] o.s.jdbc.datasource.init.ScriptUtils : Executed SQL script from class path resource [org/springframework/batch/core/schema-oracle10g.sql] in 538 ms.
  64. 2017-01-11 07:36:46,506 INFO [main] o.s.jdbc.datasource.init.ScriptUtils - Executed SQL script from class path resource [org/springframework/batch/core/schema-oracle10g.sql] in 538 ms.
  65. 2017-01-11 07:36:46.599 INFO 15267 --- [ main] o.f.core.internal.util.VersionPrinter : Flyway 3.2.1 by Boxfuse
  66. 2017-01-11 07:36:46,599 INFO [main] o.f.c.internal.util.VersionPrinter - Flyway 3.2.1 by Boxfuse
  67. 2017-01-11 07:36:46.607 INFO 15267 --- [ main] o.f.c.i.dbsupport.DbSupportFactory : Database: jdbc:oracle:thin:@192.168.211.3:1542/OT0140_APP_ECOM.kohls.com (Oracle 11.2)
  68. 2017-01-11 07:36:46,607 INFO [main] o.f.c.i.dbsupport.DbSupportFactory - Database: jdbc:oracle:thin:@192.168.211.3:1542/OT0140_APP_ECOM.kohls.com (Oracle 11.2)
  69. 2017-01-11 07:36:46.708 INFO 15267 --- [ main] o.f.core.internal.command.DbValidate : Validated 8 migrations (execution time 00:00.029s)
  70. 2017-01-11 07:36:46,708 INFO [main] o.f.core.internal.command.DbValidate - Validated 8 migrations (execution time 00:00.029s)
  71. 2017-01-11 07:36:46.729 INFO 15267 --- [ main] o.f.core.internal.command.DbMigrate : Current version of schema "K_UC11": 01.008
  72. 2017-01-11 07:36:46,729 INFO [main] o.f.core.internal.command.DbMigrate - Current version of schema "K_UC11": 01.008
  73. 2017-01-11 07:36:46.730 INFO 15267 --- [ main] o.f.core.internal.command.DbMigrate : Schema "K_UC11" is up to date. No migration necessary.
  74. 2017-01-11 07:36:46,730 INFO [main] o.f.core.internal.command.DbMigrate - Schema "K_UC11" is up to date. No migration necessary.
  75. 2017-01-11 07:36:46.776 INFO 15267 --- [ main] o.s.s.c.ThreadPoolTaskScheduler : Initializing ExecutorService 'taskScheduler'
  76. 2017-01-11 07:36:46,776 INFO [main] o.s.s.c.ThreadPoolTaskScheduler - Initializing ExecutorService 'taskScheduler'
  77. 2017-01-11 07:36:46.952 INFO 15267 --- [ main] o.s.j.e.a.AnnotationMBeanExporter : Registering beans for JMX exposure on startup
  78. 2017-01-11 07:36:46,952 INFO [main] o.s.j.e.a.AnnotationMBeanExporter - Registering beans for JMX exposure on startup
  79. 2017-01-11 07:36:46.960 INFO 15267 --- [ main] o.s.c.support.DefaultLifecycleProcessor : Starting beans in phase 0
  80. 2017-01-11 07:36:46,960 INFO [main] o.s.c.s.DefaultLifecycleProcessor - Starting beans in phase 0
  81. 2017-01-11 07:36:46.961 INFO 15267 --- [ main] o.s.i.endpoint.EventDrivenConsumer : Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
  82. 2017-01-11 07:36:46,961 INFO [main] o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
  83. 2017-01-11 07:36:46.961 INFO 15267 --- [ main] o.s.i.channel.PublishSubscribeChannel : Channel 'application.errorChannel' has 1 subscriber(s).
  84. 2017-01-11 07:36:46,961 INFO [main] o.s.i.c.PublishSubscribeChannel - Channel 'application.errorChannel' has 1 subscriber(s).
  85. 2017-01-11 07:36:46.962 INFO 15267 --- [ main] o.s.i.endpoint.EventDrivenConsumer : started _org.springframework.integration.errorLogger
  86. 2017-01-11 07:36:46,962 INFO [main] o.s.i.endpoint.EventDrivenConsumer - started _org.springframework.integration.errorLogger
  87. 2017-01-11 07:36:46.972 INFO 15267 --- [ main] o.s.b.a.b.JobLauncherCommandLineRunner : Running default command line with: [--spring.config.location=file:/kohls/file/is/ecmdm-batch-atg-source-to-stage-job-passwd.properties,file:/kohls/file/is/properties/ecmdm-batch-atg-source-to-stage-job-props.properties, user.accounts.file=/kohls/file/ecmdm/ai19/ecmdm-batch-atg-source-to-stage-job/incoming/USER_ACCOUNT_12122016_000000.dat.enc, user.address.file=/kohls/file/ecmdm/ai19/ecmdm-batch-atg-source-to-stage-job/incoming/ADDRESS_12122016_000000.dat.enc]
  88. 2017-01-11 07:36:46,972 INFO [main] o.s.b.a.b.JobLauncherCommandLineRunner - Running default command line with: [--spring.config.location=file:/kohls/file/is/ecmdm-batch-atg-source-to-stage-job-passwd.properties,file:/kohls/file/is/properties/ecmdm-batch-atg-source-to-stage-job-props.properties, user.accounts.file=/kohls/file/ecmdm/ai19/ecmdm-batch-atg-source-to-stage-job/incoming/USER_ACCOUNT_12122016_000000.dat.enc, user.address.file=/kohls/file/ecmdm/ai19/ecmdm-batch-atg-source-to-stage-job/incoming/ADDRESS_12122016_000000.dat.enc]
  89. 2017-01-11 07:36:47.116 INFO 15267 --- [ main] o.s.b.c.l.support.SimpleJobLauncher : Job: [FlowJob: [name=importAtgFeedJob]] launched with the following parameters: [{user.accounts.file=/kohls/file/ecmdm/ai19/ecmdm-batch-atg-source-to-stage-job/incoming/USER_ACCOUNT_12122016_000000.dat.enc, -spring.config.location=file:/kohls/file/is/ecmdm-batch-atg-source-to-stage-job-passwd.properties,file:/kohls/file/is/properties/ecmdm-batch-atg-source-to-stage-job-props.properties, user.address.file=/kohls/file/ecmdm/ai19/ecmdm-batch-atg-source-to-stage-job/incoming/ADDRESS_12122016_000000.dat.enc, run.id=1}]
  90. 2017-01-11 07:36:47,116 INFO [main] o.s.b.c.l.support.SimpleJobLauncher - Job: [FlowJob: [name=importAtgFeedJob]] launched with the following parameters: [{user.accounts.file=/kohls/file/ecmdm/ai19/ecmdm-batch-atg-source-to-stage-job/incoming/USER_ACCOUNT_12122016_000000.dat.enc, -spring.config.location=file:/kohls/file/is/ecmdm-batch-atg-source-to-stage-job-passwd.properties,file:/kohls/file/is/properties/ecmdm-batch-atg-source-to-stage-job-props.properties, user.address.file=/kohls/file/ecmdm/ai19/ecmdm-batch-atg-source-to-stage-job/incoming/ADDRESS_12122016_000000.dat.enc, run.id=1}]
  91. 2017-01-11 07:36:47.158 INFO 15267 --- [ main] o.s.batch.core.job.SimpleStepHandler : Executing step: [stageToCorePhaseStep]
  92. 2017-01-11 07:36:47,158 INFO [main] o.s.batch.core.job.SimpleStepHandler - Executing step: [stageToCorePhaseStep]
  93. 2017-01-11 07:36:47.199 INFO 15267 --- [OURCE-TO-STAGE2] o.s.batch.core.job.SimpleStepHandler : Executing step: [importAddressStep]
  94. 2017-01-11 07:36:47,199 INFO [ATG-SOURCE-TO-STAGE2] o.s.batch.core.job.SimpleStepHandler - Executing step: [importAddressStep]
  95. 2017-01-11 07:36:47.200 INFO 15267 --- [OURCE-TO-STAGE1] o.s.batch.core.job.SimpleStepHandler : Executing step: [importUserAccountStep]
  96. 2017-01-11 07:36:47,200 INFO [ATG-SOURCE-TO-STAGE1] o.s.batch.core.job.SimpleStepHandler - Executing step: [importUserAccountStep]
  97. 2017-01-11 07:36:48.659 INFO 15267 --- [CESSING-THREAD4] o.s.b.f.xml.XmlBeanDefinitionReader : Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
  98. 2017-01-11 07:36:48,659 INFO [ACCOUNT-PROCESSING-THREAD4] o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
  99. 2017-01-11 07:36:48.716 INFO 15267 --- [CESSING-THREAD4] o.s.jdbc.support.SQLErrorCodesFactory : SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase, Hana]
  100. 2017-01-11 07:36:48,716 INFO [ACCOUNT-PROCESSING-THREAD4] o.s.j.support.SQLErrorCodesFactory - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase, Hana]
  101. 2017-01-11 07:36:48.723 ERROR 15267 --- [OURCE-TO-STAGE1] o.s.batch.core.step.AbstractStep : Encountered an error executing step importUserAccountStep in job importAtgFeedJob
  102.  
  103. org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO K_UC11.UCTS_USER_ACCOUNT_ATG (
  104. USR_ID,
  105. USER_TYPE,
  106. LOGIN,
  107. PSWRD,
  108. FIRST_NAME,
  109. MIDDLE_NAME,
  110. LAST_NAME,
  111. EMAIL,
  112. HOME_PHONE,
  113. BUSINESS_PHONE,
  114. FAX_PHONE,
  115. USA_PAY_TYP_CD,
  116. USA_EMPLOYEE_NBR,
  117. USA_CUST_NBR,
  118. USA_PWD_EXP_IND,
  119. LAST_ACTIVITY_DATE,
  120. LAST_PWD_UPDATE,
  121. FAILED_LOGIN_COUNT,
  122. LOGIN_COUNT,
  123. BILLING_ADDR_ID,
  124. SHIPPING_ADDR_ID,
  125. USA_DEFAULT_CCD_ID,
  126. USA_DEFAULT_SHM_ID,
  127. USA_OPT_OUT,
  128. USA_RANDOM_NUM,
  129. USA_DEFAULT_USO_ID,
  130. USA_LEAD_GEN_IND,
  131. REGISTRATION_DATE,
  132. VERSION,
  133. USA_PUB_VERSION,
  134. USA_PARENT_ID,
  135. USER_STATUS,
  136. USA_APRV_STATUS_CDE,
  137. USA_NM,
  138. USA_NM_LOWER,
  139. USA_PATH,
  140. USA_PATH_LOWER,
  141. USA_LABEL,
  142. USA_DESC,
  143. USA_NOTES,
  144. USA_PRIORITY,
  145. USA_BEGIN_DT,
  146. USA_END_DTE,
  147. REGISTRATION_DATE1,
  148. USA_CREATED_BY,
  149. LAST_MODIFIED_DATE,
  150. USA_MODIFIED_BY,
  151. USA_ATTR_TEXT,
  152. USA_ATTR_UPTODATE,
  153. BRIDAL_EMAIL_OPT_BOOL,
  154. USA_BRIDAL_EMAIL_OPT_STATUS,
  155. EMAIL_OPT_BOOL,
  156. USA_EMAIL_OPT_STATUS,
  157. USA_KIOSK_ACCOUNT,
  158. USA_REGISTERDISCOUNTCOUNTER,
  159. USA_REGISTEREDEMAIL,
  160. USA_HINT,
  161. USA_HINTANSWER,
  162. LOYALTY_ID,
  163. SOR_EXTR_TMST,
  164. LOD_TMST,
  165. BTCH_ID)
  166. VALUES (
  167. ?,
  168. ?,
  169. ?,
  170. ?,
  171. ?,
  172. ?,
  173. ?,
  174. ?,
  175. ?,
  176. ?,
  177. ?,
  178. ?,
  179. ?,
  180. ?,
  181. ?,
  182. ?,
  183. ?,
  184. ?,
  185. ?,
  186. ?,
  187. ?,
  188. ?,
  189. ?,
  190. ?,
  191. ?,
  192. ?,
  193. ?,
  194. ?,
  195. ?,
  196. ?,
  197. ?,
  198. ?,
  199. ?,
  200. ?,
  201. ?,
  202. ?,
  203. ?,
  204. ?,
  205. ?,
  206. ?,
  207. ?,
  208. ?,
  209. ?,
  210. ?,
  211. ?,
  212. ?,
  213. ?,
  214. ?,
  215. ?,
  216. ?,
  217. ?,
  218. ?,
  219. ?,
  220. ?,
  221. ?,
  222. ?,
  223. ?,
  224. ?,
  225. ?,
  226. ?,
  227. ?,
  228. ?
  229. )
  230. ]; SQL state [72000]; error code [14400]; ORA-14400: inserted partition key does not map to any partition
  231. ; nested exception is java.sql.BatchUpdateException: ORA-14400: inserted partition key does not map to any partition
  232.  
  233. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)
  234. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  235. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  236. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:649)
  237. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:662)
  238. at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:950)
  239. at org.springframework.jdbc.core.namedparam.NamedParameterBatchUpdateUtils.executeBatchUpdateWithNamedParameters(NamedParameterBatchUpdateUtils.java:40)
  240. at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.batchUpdate(NamedParameterJdbcTemplate.java:335)
  241. at org.springframework.batch.item.database.JdbcBatchItemWriter.write(JdbcBatchItemWriter.java:181)
  242. at com.kohls.ecmdm.batch.atg.component.writer.stage.ItemWriterDecoratorImpl.write(ItemWriterDecoratorImpl.java:25)
  243. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  244. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  245. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  246. at java.lang.reflect.Method.invoke(Method.java:497)
  247. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
  248. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  249. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  250. at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
  251. at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
  252. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  253. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
  254. at com.sun.proxy.$Proxy58.write(Unknown Source)
  255. at org.springframework.batch.core.step.item.SimpleChunkProcessor.writeItems(SimpleChunkProcessor.java:175)
  256. at org.springframework.batch.core.step.item.SimpleChunkProcessor.doWrite(SimpleChunkProcessor.java:151)
  257. at org.springframework.batch.core.step.item.SimpleChunkProcessor.write(SimpleChunkProcessor.java:274)
  258. at org.springframework.batch.core.step.item.SimpleChunkProcessor.process(SimpleChunkProcessor.java:199)
  259. at org.springframework.batch.core.step.item.ChunkOrientedTasklet.execute(ChunkOrientedTasklet.java:75)
  260. at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:406)
  261. at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:330)
  262. at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
  263. at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:271)
  264. at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:81)
  265. at org.springframework.batch.repeat.support.TaskExecutorRepeatTemplate$ExecutingRunnable.run(TaskExecutorRepeatTemplate.java:262)
  266. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  267. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  268. at java.lang.Thread.run(Thread.java:745)
  269. Caused by: java.sql.BatchUpdateException: ORA-14400: inserted partition key does not map to any partition
  270.  
  271. at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10345)
  272. at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
  273. at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:966)
  274. at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:950)
  275. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633)
  276. ... 32 common frames omitted
  277.  
  278. 2017-01-11 07:36:48.723 ERROR 15267 --- [OURCE-TO-STAGE2] o.s.batch.core.step.AbstractStep : Encountered an error executing step importAddressStep in job importAtgFeedJob
  279.  
  280. org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO K_UC11.UCTS_ADDRESS_ATG (
  281. ID,
  282. USER_ID,
  283. STATUS_CD,
  284. ADDRESS1,
  285. ADDRESS2,
  286. ADDRESS3,
  287. CITY,
  288. STATE,
  289. UAD_STATE_NM,
  290. COUNTRY,
  291. POSTAL_CODE,
  292. FIRST_NAME,
  293. MIDDLE_NAME,
  294. LAST_NAME,
  295. PHONE_NUMBER,
  296. UAD_GIFT_IND,
  297. ADDRESS_TYPE,
  298. UAD_LABEL,
  299. UAD_NM,
  300. UAD_CREATE_DT,
  301. UAD_MODIFY_DT,
  302. UAD_CREATED_BY,
  303. UAD_MODIFIED_BY,
  304. UAD_SYS_TIMESTAMP,
  305. UAD_DEFAULT_SHIPMETHOD,
  306. UAD_KUAD_GEOCODE,
  307. UAD_SHIP_NOTES,
  308. UAD_UNREGEMAIL,
  309. LOD_TMST,
  310. BTCH_ID
  311. )
  312. VALUES (
  313. ?,
  314. ?,
  315. ?,
  316. ?,
  317. ?,
  318. ?,
  319. ?,
  320. ?,
  321. ?,
  322. ?,
  323. ?,
  324. ?,
  325. ?,
  326. ?,
  327. ?,
  328. ?,
  329. ?,
  330. ?,
  331. ?,
  332. ?,
  333. ?,
  334. ?,
  335. ?,
  336. ?,
  337. ?,
  338. ?,
  339. ?,
  340. ?,
  341. ?,
  342. ?
  343. )
  344. ]; SQL state [72000]; error code [14400]; ORA-14400: inserted partition key does not map to any partition
  345. ; nested exception is java.sql.BatchUpdateException: ORA-14400: inserted partition key does not map to any partition
  346.  
  347. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)
  348. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  349. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  350. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:649)
  351. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:662)
  352. at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:950)
  353. at org.springframework.jdbc.core.namedparam.NamedParameterBatchUpdateUtils.executeBatchUpdateWithNamedParameters(NamedParameterBatchUpdateUtils.java:40)
  354. at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.batchUpdate(NamedParameterJdbcTemplate.java:335)
  355. at org.springframework.batch.item.database.JdbcBatchItemWriter.write(JdbcBatchItemWriter.java:181)
  356. at com.kohls.ecmdm.batch.atg.component.writer.stage.ItemWriterDecoratorImpl.write(ItemWriterDecoratorImpl.java:25)
  357. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  358. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  359. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  360. at java.lang.reflect.Method.invoke(Method.java:497)
  361. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
  362. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  363. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  364. at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
  365. at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
  366. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  367. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
  368. at com.sun.proxy.$Proxy58.write(Unknown Source)
  369. at org.springframework.batch.core.step.item.SimpleChunkProcessor.writeItems(SimpleChunkProcessor.java:175)
  370. at org.springframework.batch.core.step.item.SimpleChunkProcessor.doWrite(SimpleChunkProcessor.java:151)
  371. at org.springframework.batch.core.step.item.SimpleChunkProcessor.write(SimpleChunkProcessor.java:274)
  372. at org.springframework.batch.core.step.item.SimpleChunkProcessor.process(SimpleChunkProcessor.java:199)
  373. at org.springframework.batch.core.step.item.ChunkOrientedTasklet.execute(ChunkOrientedTasklet.java:75)
  374. at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:406)
  375. at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:330)
  376. at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
  377. at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:271)
  378. at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:81)
  379. at org.springframework.batch.repeat.support.TaskExecutorRepeatTemplate$ExecutingRunnable.run(TaskExecutorRepeatTemplate.java:262)
  380. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  381. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  382. at java.lang.Thread.run(Thread.java:745)
  383. Caused by: java.sql.BatchUpdateException: ORA-14400: inserted partition key does not map to any partition
  384.  
  385. at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10345)
  386. at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
  387. at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:966)
  388. at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:950)
  389. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633)
  390. ... 32 common frames omitted
  391.  
  392. 2017-01-11 07:36:48,723 ERROR [ATG-SOURCE-TO-STAGE1] o.s.batch.core.step.AbstractStep - Encountered an error executing step importUserAccountStep in job importAtgFeedJob
  393. org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO K_UC11.UCTS_USER_ACCOUNT_ATG (
  394. USR_ID,
  395. USER_TYPE,
  396. LOGIN,
  397. PSWRD,
  398. FIRST_NAME,
  399. MIDDLE_NAME,
  400. LAST_NAME,
  401. EMAIL,
  402. HOME_PHONE,
  403. BUSINESS_PHONE,
  404. FAX_PHONE,
  405. USA_PAY_TYP_CD,
  406. USA_EMPLOYEE_NBR,
  407. USA_CUST_NBR,
  408. USA_PWD_EXP_IND,
  409. LAST_ACTIVITY_DATE,
  410. LAST_PWD_UPDATE,
  411. FAILED_LOGIN_COUNT,
  412. LOGIN_COUNT,
  413. BILLING_ADDR_ID,
  414. SHIPPING_ADDR_ID,
  415. USA_DEFAULT_CCD_ID,
  416. USA_DEFAULT_SHM_ID,
  417. USA_OPT_OUT,
  418. USA_RANDOM_NUM,
  419. USA_DEFAULT_USO_ID,
  420. USA_LEAD_GEN_IND,
  421. REGISTRATION_DATE,
  422. VERSION,
  423. USA_PUB_VERSION,
  424. USA_PARENT_ID,
  425. USER_STATUS,
  426. USA_APRV_STATUS_CDE,
  427. USA_NM,
  428. USA_NM_LOWER,
  429. USA_PATH,
  430. USA_PATH_LOWER,
  431. USA_LABEL,
  432. USA_DESC,
  433. USA_NOTES,
  434. USA_PRIORITY,
  435. USA_BEGIN_DT,
  436. USA_END_DTE,
  437. REGISTRATION_DATE1,
  438. USA_CREATED_BY,
  439. LAST_MODIFIED_DATE,
  440. USA_MODIFIED_BY,
  441. USA_ATTR_TEXT,
  442. USA_ATTR_UPTODATE,
  443. BRIDAL_EMAIL_OPT_BOOL,
  444. USA_BRIDAL_EMAIL_OPT_STATUS,
  445. EMAIL_OPT_BOOL,
  446. USA_EMAIL_OPT_STATUS,
  447. USA_KIOSK_ACCOUNT,
  448. USA_REGISTERDISCOUNTCOUNTER,
  449. USA_REGISTEREDEMAIL,
  450. USA_HINT,
  451. USA_HINTANSWER,
  452. LOYALTY_ID,
  453. SOR_EXTR_TMST,
  454. LOD_TMST,
  455. BTCH_ID)
  456. VALUES (
  457. ?,
  458. ?,
  459. ?,
  460. ?,
  461. ?,
  462. ?,
  463. ?,
  464. ?,
  465. ?,
  466. ?,
  467. ?,
  468. ?,
  469. ?,
  470. ?,
  471. ?,
  472. ?,
  473. ?,
  474. ?,
  475. ?,
  476. ?,
  477. ?,
  478. ?,
  479. ?,
  480. ?,
  481. ?,
  482. ?,
  483. ?,
  484. ?,
  485. ?,
  486. ?,
  487. ?,
  488. ?,
  489. ?,
  490. ?,
  491. ?,
  492. ?,
  493. ?,
  494. ?,
  495. ?,
  496. ?,
  497. ?,
  498. ?,
  499. ?,
  500. ?,
  501. ?,
  502. ?,
  503. ?,
  504. ?,
  505. ?,
  506. ?,
  507. ?,
  508. ?,
  509. ?,
  510. ?,
  511. ?,
  512. ?,
  513. ?,
  514. ?,
  515. ?,
  516. ?,
  517. ?,
  518. ?
  519. )
  520. ]; SQL state [72000]; error code [14400]; ORA-14400: inserted partition key does not map to any partition
  521. ; nested exception is java.sql.BatchUpdateException: ORA-14400: inserted partition key does not map to any partition
  522.  
  523. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)
  524. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  525. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  526. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:649)
  527. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:662)
  528. at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:950)
  529. at org.springframework.jdbc.core.namedparam.NamedParameterBatchUpdateUtils.executeBatchUpdateWithNamedParameters(NamedParameterBatchUpdateUtils.java:40)
  530. at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.batchUpdate(NamedParameterJdbcTemplate.java:335)
  531. at org.springframework.batch.item.database.JdbcBatchItemWriter.write(JdbcBatchItemWriter.java:181)
  532. at com.kohls.ecmdm.batch.atg.component.writer.stage.ItemWriterDecoratorImpl.write(ItemWriterDecoratorImpl.java:25)
  533. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  534. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  535. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  536. at java.lang.reflect.Method.invoke(Method.java:497)
  537. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
  538. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  539. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  540. at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
  541. at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
  542. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  543. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
  544. at com.sun.proxy.$Proxy58.write(Unknown Source)
  545. at org.springframework.batch.core.step.item.SimpleChunkProcessor.writeItems(SimpleChunkProcessor.java:175)
  546. at org.springframework.batch.core.step.item.SimpleChunkProcessor.doWrite(SimpleChunkProcessor.java:151)
  547. at org.springframework.batch.core.step.item.SimpleChunkProcessor.write(SimpleChunkProcessor.java:274)
  548. at org.springframework.batch.core.step.item.SimpleChunkProcessor.process(SimpleChunkProcessor.java:199)
  549. at org.springframework.batch.core.step.item.ChunkOrientedTasklet.execute(ChunkOrientedTasklet.java:75)
  550. at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:406)
  551. at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:330)
  552. at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
  553. at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:271)
  554. at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:81)
  555. at org.springframework.batch.repeat.support.TaskExecutorRepeatTemplate$ExecutingRunnable.run(TaskExecutorRepeatTemplate.java:262)
  556. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  557. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  558. at java.lang.Thread.run(Thread.java:745)
  559. Caused by: java.sql.BatchUpdateException: ORA-14400: inserted partition key does not map to any partition
  560.  
  561. at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10345)
  562. at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
  563. at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:966)
  564. at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:950)
  565. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633)
  566. ... 32 common frames omitted
  567. 2017-01-11 07:36:48,723 ERROR [ATG-SOURCE-TO-STAGE2] o.s.batch.core.step.AbstractStep - Encountered an error executing step importAddressStep in job importAtgFeedJob
  568. org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO K_UC11.UCTS_ADDRESS_ATG (
  569. ID,
  570. USER_ID,
  571. STATUS_CD,
  572. ADDRESS1,
  573. ADDRESS2,
  574. ADDRESS3,
  575. CITY,
  576. STATE,
  577. UAD_STATE_NM,
  578. COUNTRY,
  579. POSTAL_CODE,
  580. FIRST_NAME,
  581. MIDDLE_NAME,
  582. LAST_NAME,
  583. PHONE_NUMBER,
  584. UAD_GIFT_IND,
  585. ADDRESS_TYPE,
  586. UAD_LABEL,
  587. UAD_NM,
  588. UAD_CREATE_DT,
  589. UAD_MODIFY_DT,
  590. UAD_CREATED_BY,
  591. UAD_MODIFIED_BY,
  592. UAD_SYS_TIMESTAMP,
  593. UAD_DEFAULT_SHIPMETHOD,
  594. UAD_KUAD_GEOCODE,
  595. UAD_SHIP_NOTES,
  596. UAD_UNREGEMAIL,
  597. LOD_TMST,
  598. BTCH_ID
  599. )
  600. VALUES (
  601. ?,
  602. ?,
  603. ?,
  604. ?,
  605. ?,
  606. ?,
  607. ?,
  608. ?,
  609. ?,
  610. ?,
  611. ?,
  612. ?,
  613. ?,
  614. ?,
  615. ?,
  616. ?,
  617. ?,
  618. ?,
  619. ?,
  620. ?,
  621. ?,
  622. ?,
  623. ?,
  624. ?,
  625. ?,
  626. ?,
  627. ?,
  628. ?,
  629. ?,
  630. ?
  631. )
  632. ]; SQL state [72000]; error code [14400]; ORA-14400: inserted partition key does not map to any partition
  633. ; nested exception is java.sql.BatchUpdateException: ORA-14400: inserted partition key does not map to any partition
  634.  
  635. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)
  636. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  637. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  638. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:649)
  639. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:662)
  640. at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:950)
  641. at org.springframework.jdbc.core.namedparam.NamedParameterBatchUpdateUtils.executeBatchUpdateWithNamedParameters(NamedParameterBatchUpdateUtils.java:40)
  642. at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.batchUpdate(NamedParameterJdbcTemplate.java:335)
  643. at org.springframework.batch.item.database.JdbcBatchItemWriter.write(JdbcBatchItemWriter.java:181)
  644. at com.kohls.ecmdm.batch.atg.component.writer.stage.ItemWriterDecoratorImpl.write(ItemWriterDecoratorImpl.java:25)
  645. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  646. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  647. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  648. at java.lang.reflect.Method.invoke(Method.java:497)
  649. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
  650. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  651. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  652. at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
  653. at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
  654. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  655. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
  656. at com.sun.proxy.$Proxy58.write(Unknown Source)
  657. at org.springframework.batch.core.step.item.SimpleChunkProcessor.writeItems(SimpleChunkProcessor.java:175)
  658. at org.springframework.batch.core.step.item.SimpleChunkProcessor.doWrite(SimpleChunkProcessor.java:151)
  659. at org.springframework.batch.core.step.item.SimpleChunkProcessor.write(SimpleChunkProcessor.java:274)
  660. at org.springframework.batch.core.step.item.SimpleChunkProcessor.process(SimpleChunkProcessor.java:199)
  661. at org.springframework.batch.core.step.item.ChunkOrientedTasklet.execute(ChunkOrientedTasklet.java:75)
  662. at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:406)
  663. at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:330)
  664. at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
  665. at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:271)
  666. at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:81)
  667. at org.springframework.batch.repeat.support.TaskExecutorRepeatTemplate$ExecutingRunnable.run(TaskExecutorRepeatTemplate.java:262)
  668. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  669. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  670. at java.lang.Thread.run(Thread.java:745)
  671. Caused by: java.sql.BatchUpdateException: ORA-14400: inserted partition key does not map to any partition
  672.  
  673. at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10345)
  674. at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
  675. at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:966)
  676. at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:950)
  677. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633)
  678. ... 32 common frames omitted
  679. 2017-01-11 07:36:48.743 ERROR 15267 --- [OURCE-TO-STAGE1] o.s.batch.core.step.AbstractStep : Exception in afterStep callback in step importUserAccountStep in job importAtgFeedJob
  680.  
  681. java.lang.RuntimeException: java.io.FileNotFoundException: Source '/kohls/file/ecmdm/ai19/ecmdm-batch-atg-source-to-stage-job/incoming/USER_ACCOUNT_12122016_000000.dat.enc' does not exist
  682. at com.kohls.ecmdm.batch.component.ImportToStageStatusListener.moveFilesToErrorDir(ImportToStageStatusListener.java:65)
  683. at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
  684. at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)
  685. at java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
  686. at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)
  687. at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)
  688. at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
  689. at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
  690. at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
  691. at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:418)
  692. at com.kohls.ecmdm.batch.component.ImportToStageStatusListener.afterStep(ImportToStageStatusListener.java:48)
  693. at org.springframework.batch.core.listener.CompositeStepExecutionListener.afterStep(CompositeStepExecutionListener.java:62)
  694. at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:239)
  695. at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:148)
  696. at org.springframework.batch.core.job.flow.JobFlowExecutor.executeStep(JobFlowExecutor.java:64)
  697. at org.springframework.batch.core.job.flow.support.state.StepState.handle(StepState.java:67)
  698. at org.springframework.batch.core.job.flow.support.SimpleFlow.resume(SimpleFlow.java:169)
  699. at org.springframework.batch.core.job.flow.support.SimpleFlow.start(SimpleFlow.java:144)
  700. at org.springframework.batch.core.job.flow.support.state.SplitState$1.call(SplitState.java:93)
  701. at org.springframework.batch.core.job.flow.support.state.SplitState$1.call(SplitState.java:90)
  702. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  703. at java.lang.Thread.run(Thread.java:745)
  704. Caused by: java.io.FileNotFoundException: Source '/kohls/file/ecmdm/ai19/ecmdm-batch-atg-source-to-stage-job/incoming/USER_ACCOUNT_12122016_000000.dat.enc' does not exist
  705. at org.apache.commons.io.FileUtils.checkFileRequirements(FileUtils.java:1405)
  706. at org.apache.commons.io.FileUtils.copyFile(FileUtils.java:1072)
  707. at org.apache.commons.io.FileUtils.copyFile(FileUtils.java:1040)
  708. at org.apache.commons.io.FileUtils.moveFile(FileUtils.java:2993)
  709. at org.apache.commons.io.FileUtils.moveFileToDirectory(FileUtils.java:3033)
  710. at org.apache.commons.io.FileUtils.moveToDirectory(FileUtils.java:3065)
  711. at com.kohls.ecmdm.batch.component.impl.SimpleMoveStrategy.moveFile(SimpleMoveStrategy.java:23)
  712. at com.kohls.ecmdm.batch.component.ImportToStageStatusListener.moveFilesToErrorDir(ImportToStageStatusListener.java:63)
  713. ... 21 common frames omitted
  714.  
  715. 2017-01-11 07:36:48,743 ERROR [ATG-SOURCE-TO-STAGE1] o.s.batch.core.step.AbstractStep - Exception in afterStep callback in step importUserAccountStep in job importAtgFeedJob
  716. java.lang.RuntimeException: java.io.FileNotFoundException: Source '/kohls/file/ecmdm/ai19/ecmdm-batch-atg-source-to-stage-job/incoming/USER_ACCOUNT_12122016_000000.dat.enc' does not exist
  717. at com.kohls.ecmdm.batch.component.ImportToStageStatusListener.moveFilesToErrorDir(ImportToStageStatusListener.java:65)
  718. at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
  719. at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)
  720. at java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
  721. at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)
  722. at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)
  723. at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
  724. at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
  725. at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
  726. at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:418)
  727. at com.kohls.ecmdm.batch.component.ImportToStageStatusListener.afterStep(ImportToStageStatusListener.java:48)
  728. at org.springframework.batch.core.listener.CompositeStepExecutionListener.afterStep(CompositeStepExecutionListener.java:62)
  729. at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:239)
  730. at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:148)
  731. at org.springframework.batch.core.job.flow.JobFlowExecutor.executeStep(JobFlowExecutor.java:64)
  732. at org.springframework.batch.core.job.flow.support.state.StepState.handle(StepState.java:67)
  733. at org.springframework.batch.core.job.flow.support.SimpleFlow.resume(SimpleFlow.java:169)
  734. at org.springframework.batch.core.job.flow.support.SimpleFlow.start(SimpleFlow.java:144)
  735. at org.springframework.batch.core.job.flow.support.state.SplitState$1.call(SplitState.java:93)
  736. at org.springframework.batch.core.job.flow.support.state.SplitState$1.call(SplitState.java:90)
  737. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  738. at java.lang.Thread.run(Thread.java:745)
  739. Caused by: java.io.FileNotFoundException: Source '/kohls/file/ecmdm/ai19/ecmdm-batch-atg-source-to-stage-job/incoming/USER_ACCOUNT_12122016_000000.dat.enc' does not exist
  740. at org.apache.commons.io.FileUtils.checkFileRequirements(FileUtils.java:1405)
  741. at org.apache.commons.io.FileUtils.copyFile(FileUtils.java:1072)
  742. at org.apache.commons.io.FileUtils.copyFile(FileUtils.java:1040)
  743. at org.apache.commons.io.FileUtils.moveFile(FileUtils.java:2993)
  744. at org.apache.commons.io.FileUtils.moveFileToDirectory(FileUtils.java:3033)
  745. at org.apache.commons.io.FileUtils.moveToDirectory(FileUtils.java:3065)
  746. at com.kohls.ecmdm.batch.component.impl.SimpleMoveStrategy.moveFile(SimpleMoveStrategy.java:23)
  747. at com.kohls.ecmdm.batch.component.ImportToStageStatusListener.moveFilesToErrorDir(ImportToStageStatusListener.java:63)
  748. ... 21 common frames omitted
  749. 2017-01-11 07:36:48.832 INFO 15267 --- [ main] o.s.b.c.l.support.SimpleJobLauncher : Job: [FlowJob: [name=importAtgFeedJob]] completed with the following parameters: [{user.accounts.file=/kohls/file/ecmdm/ai19/ecmdm-batch-atg-source-to-stage-job/incoming/USER_ACCOUNT_12122016_000000.dat.enc, -spring.config.location=file:/kohls/file/is/ecmdm-batch-atg-source-to-stage-job-passwd.properties,file:/kohls/file/is/properties/ecmdm-batch-atg-source-to-stage-job-props.properties, user.address.file=/kohls/file/ecmdm/ai19/ecmdm-batch-atg-source-to-stage-job/incoming/ADDRESS_12122016_000000.dat.enc, run.id=1}] and the following status: [FAILED]
  750. 2017-01-11 07:36:48,832 INFO [main] o.s.b.c.l.support.SimpleJobLauncher - Job: [FlowJob: [name=importAtgFeedJob]] completed with the following parameters: [{user.accounts.file=/kohls/file/ecmdm/ai19/ecmdm-batch-atg-source-to-stage-job/incoming/USER_ACCOUNT_12122016_000000.dat.enc, -spring.config.location=file:/kohls/file/is/ecmdm-batch-atg-source-to-stage-job-passwd.properties,file:/kohls/file/is/properties/ecmdm-batch-atg-source-to-stage-job-props.properties, user.address.file=/kohls/file/ecmdm/ai19/ecmdm-batch-atg-source-to-stage-job/incoming/ADDRESS_12122016_000000.dat.enc, run.id=1}] and the following status: [FAILED]
  751. 2017-01-11 07:36:48.835 INFO 15267 --- [ Thread-2] s.c.a.AnnotationConfigApplicationContext : Closing org.springframework.context.annotation.AnnotationConfigApplicationContext@21588809: startup date [Wed Jan 11 07:36:42 CST 2017]; root of context hierarchy
  752. 2017-01-11 07:36:48,835 INFO [Thread-2] o.s.c.a.AnnotationConfigApplicationContext - Closing org.springframework.context.annotation.AnnotationConfigApplicationContext@21588809: startup date [Wed Jan 11 07:36:42 CST 2017]; root of context hierarchy
  753. 2017-01-11 07:36:48.836 INFO 15267 --- [ Thread-2] o.s.c.support.DefaultLifecycleProcessor : Stopping beans in phase 0
  754. 2017-01-11 07:36:48,836 INFO [Thread-2] o.s.c.s.DefaultLifecycleProcessor - Stopping beans in phase 0
  755. 2017-01-11 07:36:48.837 INFO 15267 --- [ Thread-2] o.s.i.endpoint.EventDrivenConsumer : Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
  756. 2017-01-11 07:36:48,837 INFO [Thread-2] o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
  757. 2017-01-11 07:36:48.838 INFO 15267 --- [ Thread-2] o.s.i.channel.PublishSubscribeChannel : Channel 'application.errorChannel' has 0 subscriber(s).
  758. 2017-01-11 07:36:48,838 INFO [Thread-2] o.s.i.c.PublishSubscribeChannel - Channel 'application.errorChannel' has 0 subscriber(s).
  759. 2017-01-11 07:36:48.838 INFO 15267 --- [ Thread-2] o.s.i.endpoint.EventDrivenConsumer : stopped _org.springframework.integration.errorLogger
  760. 2017-01-11 07:36:48,838 INFO [Thread-2] o.s.i.endpoint.EventDrivenConsumer - stopped _org.springframework.integration.errorLogger
  761. 2017-01-11 07:36:48.839 INFO 15267 --- [ Thread-2] o.s.s.c.ThreadPoolTaskScheduler : Shutting down ExecutorService 'taskScheduler'
  762. 2017-01-11 07:36:48,839 INFO [Thread-2] o.s.s.c.ThreadPoolTaskScheduler - Shutting down ExecutorService 'taskScheduler'
  763. 2017-01-11 07:36:48.839 INFO 15267 --- [ Thread-2] o.s.j.e.a.AnnotationMBeanExporter : Unregistering JMX-exposed beans on shutdown
  764. 2017-01-11 07:36:48,839 INFO [Thread-2] o.s.j.e.a.AnnotationMBeanExporter - Unregistering JMX-exposed beans on shutdown
  765. 2017-01-11 07:36:48.840 INFO 15267 --- [ Thread-2] o.s.s.concurrent.ThreadPoolTaskExecutor : Shutting down ExecutorService 'coreTaskExecutor'
  766. 2017-01-11 07:36:48,840 INFO [Thread-2] o.s.s.c.ThreadPoolTaskExecutor - Shutting down ExecutorService 'coreTaskExecutor'
  767. 2017-01-11 07:36:48.840 INFO 15267 --- [ Thread-2] o.s.s.concurrent.ThreadPoolTaskExecutor : Shutting down ExecutorService 'addressTaskExecutor'
  768. 2017-01-11 07:36:48,840 INFO [Thread-2] o.s.s.c.ThreadPoolTaskExecutor - Shutting down ExecutorService 'addressTaskExecutor'
  769. 2017-01-11 07:36:48.841 INFO 15267 --- [ Thread-2] o.s.s.concurrent.ThreadPoolTaskExecutor : Shutting down ExecutorService 'accountTaskExecutor'
  770. 2017-01-11 07:36:48,841 INFO [Thread-2] o.s.s.c.ThreadPoolTaskExecutor - Shutting down ExecutorService 'accountTaskExecutor'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!