プロジェクト

全般

プロフィール

タスク #8394

完了

クラス処理の時間が長い場合に、バッチ処理のDB接続が切れる

高梨 翔 さんが5ヶ月前に追加. 4ヶ月前に更新.

ステータス:
終了
優先度:
高め
担当者:
開始日:
期日:
進捗率:

0%

予定工数:
実開始日:
DD名:
INCLUDE:
DSN:
バグ区分:
QA分析:
方針(第一貨物):
実終了日:
ツールのバージョン:
AsIsSource行:
進捗計画:
設計・開発者:
画面ID:
機能区分:
機能ID:
レビュー指摘区分:
検査完了日:
検査依頼日:

説明

バッチ処理は以下のように進行しますが、

バッチ処理:OTZJOBKN[JOB実行管理テーブル].OTZJZKBN[実行区分:[0:処理待ち,1:処理中,9:処理終了]] を1に更新 他
⇓
クラス処理1
クラス処理2
クラス処...
⇓
バッチ処理:OTZJOBKN[JOB実行管理テーブル].OTZJZKBN[実行区分:[0:処理待ち,1:処理中,9:処理終了]] を9に更新 他

クラス処理時間が長い場合に最後タイミングの処理

バッチ処理:OTZJOBKN[JOB実行管理テーブル].OTZJZKBN[実行区分:[0:処理待ち,1:処理中,9:処理終了]] を9に更新 他

が以下のエラーで登録処理に失敗します。

BaseJcl:main
PS22500:main
2026/05/29 12:14:26 WARN  [restartedMain] - HikariPool-1 - Connection oracle.jdbc.driver.T4CConnection@6202253f marked as broken because of SQLSTATE(08006), ErrorCode(17002)
java.sql.SQLRecoverableException: IOエラー: Connection reset
	at oracle.jdbc.driver.T4CConnection.doCommit(T4CConnection.java:2116)
	at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2704)
	at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2766)
	at com.zaxxer.hikari.pool.ProxyConnection.commit(ProxyConnection.java:378)
	at com.zaxxer.hikari.pool.HikariProxyConnection.commit(HikariProxyConnection.java)
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:337)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:795)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:758)
	at com.d3os.d3os_batch_common.jcl.BaseJcl.executeStep(BaseJcl.java:787)
	at com.d3os.d3os_batch.jcl.TWPOSWRT.main(TWPOSWRT.java:46)
	at com.d3os.d3os_batch_common.jcl.BaseJcl.execute(BaseJcl.java:237)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)

※OTZJOBKN[JOB実行管理テーブル].OTZJZKBN[実行区分:[0:処理待ち,1:処理中,9:処理終了]]は1のままになります。


関連するチケット 1 (0件未完了 — 1件完了)

関連している タスク #2082: BaseJCL wait時、DBとのコネクションが切れる終了渡邉 拓英

操作

高梨 翔 さんが5ヶ月前に更新 · 編集済み

渡邉 拓英 さんが5ヶ月前に更新 · 編集済み

  • 関連している タスク #2082: BaseJCL wait時、DBとのコネクションが切れる を追加

渡邉 拓英 さんが4ヶ月前に更新 · 編集済み

BatchApplication:run
BatchApplication:run
11:36:02,726 |-INFO in ch.qos.logback.classic.LoggerContext[default] - This is logback-classic version 1.5.7
11:36:02,728 |-INFO in ch.qos.logback.classic.util.ContextInitializer@26ffaa54 - Here is a list of configurators discovered as a service, by rank: 
11:36:02,728 |-INFO in ch.qos.logback.classic.util.ContextInitializer@26ffaa54 -   org.springframework.boot.logging.logback.RootLogLevelConfigurator
11:36:02,728 |-INFO in ch.qos.logback.classic.util.ContextInitializer@26ffaa54 - They will be invoked in order until ExecutionStatus.DO_NOT_INVOKE_NEXT_IF_ANY is returned.
11:36:02,728 |-INFO in ch.qos.logback.classic.util.ContextInitializer@26ffaa54 - Constructed configurator of type class org.springframework.boot.logging.logback.RootLogLevelConfigurator
11:36:02,735 |-INFO in ch.qos.logback.classic.util.ContextInitializer@26ffaa54 - org.springframework.boot.logging.logback.RootLogLevelConfigurator.configure() call lasted 1 milliseconds. ExecutionStatus=INVOKE_NEXT_IF_ANY
11:36:02,735 |-INFO in ch.qos.logback.classic.util.ContextInitializer@26ffaa54 - Trying to configure with ch.qos.logback.classic.joran.SerializedModelConfigurator
11:36:02,737 |-INFO in ch.qos.logback.classic.util.ContextInitializer@26ffaa54 - Constructed configurator of type class ch.qos.logback.classic.joran.SerializedModelConfigurator
11:36:02,737 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback-test.scmo]
11:36:02,738 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback.scmo]
11:36:02,738 |-INFO in ch.qos.logback.classic.util.ContextInitializer@26ffaa54 - ch.qos.logback.classic.joran.SerializedModelConfigurator.configure() call lasted 1 milliseconds. ExecutionStatus=INVOKE_NEXT_IF_ANY
11:36:02,738 |-INFO in ch.qos.logback.classic.util.ContextInitializer@26ffaa54 - Trying to configure with ch.qos.logback.classic.util.DefaultJoranConfigurator
11:36:02,738 |-INFO in ch.qos.logback.classic.util.ContextInitializer@26ffaa54 - Constructed configurator of type class ch.qos.logback.classic.util.DefaultJoranConfigurator
11:36:02,739 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback-test.xml]
11:36:02,739 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback.xml]
11:36:02,739 |-INFO in ch.qos.logback.classic.util.ContextInitializer@26ffaa54 - ch.qos.logback.classic.util.DefaultJoranConfigurator.configure() call lasted 1 milliseconds. ExecutionStatus=INVOKE_NEXT_IF_ANY
11:36:02,739 |-INFO in ch.qos.logback.classic.util.ContextInitializer@26ffaa54 - Trying to configure with ch.qos.logback.classic.BasicConfigurator
11:36:02,741 |-INFO in ch.qos.logback.classic.util.ContextInitializer@26ffaa54 - Constructed configurator of type class ch.qos.logback.classic.BasicConfigurator
11:36:02,741 |-INFO in ch.qos.logback.classic.BasicConfigurator@7fa73ed - Setting up default configuration.
11:36:02,755 |-INFO in ch.qos.logback.classic.util.ContextInitializer@26ffaa54 - ch.qos.logback.classic.BasicConfigurator.configure() call lasted 14 milliseconds. ExecutionStatus=NEUTRAL
11:36:03,333 |-INFO in ch.qos.logback.core.model.processor.AppenderModelHandler - Processing appender named [STDOUT]
11:36:03,333 |-INFO in ch.qos.logback.core.model.processor.AppenderModelHandler - About to instantiate appender of type [ch.qos.logback.core.ConsoleAppender]
11:36:03,337 |-INFO in ch.qos.logback.core.model.processor.ImplicitModelHandler - Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] property
11:36:03,354 |-WARN in ch.qos.logback.core.model.processor.AppenderModelHandler - Appender named [APPLIATION_LOG] not referenced. Skipping further processing.
11:36:03,354 |-INFO in ch.qos.logback.core.model.processor.AppenderModelHandler - Processing appender named [DB_ORACLE]
11:36:03,354 |-INFO in ch.qos.logback.core.model.processor.AppenderModelHandler - About to instantiate appender of type [ch.qos.logback.classic.db.DBAppender]
11:36:03,739 |-INFO in ch.qos.logback.core.db.DriverManagerConnectionSource@5a2b19df - Driver name=Oracle JDBC driver
11:36:03,739 |-INFO in ch.qos.logback.core.db.DriverManagerConnectionSource@5a2b19df - Driver version=21.9.0.0.0
11:36:03,739 |-INFO in ch.qos.logback.core.db.DriverManagerConnectionSource@5a2b19df - supportsGetGeneratedKeys=true
11:36:03,745 |-WARN in ch.qos.logback.core.model.processor.ImplicitModelHandler - Ignoring unknown property [insertSQL] in [ch.qos.logback.classic.db.DBAppender]
11:36:03,745 |-WARN in ch.qos.logback.core.model.processor.ImplicitModelHandler - Ignoring unknown property [insertExceptionSQL] in [ch.qos.logback.classic.db.DBAppender]
11:36:03,745 |-WARN in ch.qos.logback.core.model.processor.ImplicitModelHandler - Ignoring unknown property [insertPropertySQL] in [ch.qos.logback.classic.db.DBAppender]
11:36:03,748 |-INFO in ch.qos.logback.classic.model.processor.RootLoggerModelHandler - Setting level of ROOT logger to INFO
11:36:03,748 |-INFO in ch.qos.logback.classic.jul.LevelChangePropagator@566b61e9 - Propagating INFO level on Logger[ROOT] onto the JUL framework
11:36:03,748 |-INFO in ch.qos.logback.core.model.processor.AppenderRefModelHandler - Attaching appender named [STDOUT] to Logger[ROOT]
11:36:03,748 |-INFO in ch.qos.logback.core.model.processor.AppenderRefModelHandler - Attaching appender named [DB_ORACLE] to Logger[ROOT]
11:36:03,748 |-INFO in ch.qos.logback.core.model.processor.DefaultProcessor@d9dcc7a - End of configuration.
11:36:03,748 |-INFO in org.springframework.boot.logging.logback.SpringBootJoranConfigurator@592cb33f - Registering current configuration as safe fallback point

2026/06/30 11:36:03 DEBUG [restartedMain] - Activating profiles [dev, batch]

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/

[32m :: Spring Boot :: [39m              [2m (v3.3.3)[0;39m

2026/06/30 11:36:04 INFO  [restartedMain] - Starting BatchApplication using Java 21.0.4 with PID 27972 (C:\DEV\3-DOS_ProjectSource\trunk\batch\bin\main started by takuei in C:\DEV\3-DOS_ProjectSource\trunk\batch)
2026/06/30 11:36:04 INFO  [restartedMain] - The following 2 profiles are active: "dev", "batch"
2026/06/30 11:36:04 DEBUG [restartedMain] - Loading source class com.d3os.d3os_batch.BatchApplication
2026/06/30 11:36:04 INFO  [restartedMain] - The Class-Path manifest attribute in C:\Users\takuei\.gradle\caches\modules-2\files-2.1\com.oracle.database.jdbc\ojdbc11\21.9.0.0\1aad2e20684ee075bb9ebdca2d83f028e4fd35fa\ojdbc11-21.9.0.0.jar referenced one or more files that do not exist: file:/C:/Users/takuei/.gradle/caches/modules-2/files-2.1/com.oracle.database.jdbc/ojdbc11/21.9.0.0/1aad2e20684ee075bb9ebdca2d83f028e4fd35fa/oraclepki.jar
2026/06/30 11:36:04 DEBUG [restartedMain] - Matching URLs for reloading : [file:/C:/DEV/3-DOS_ProjectSource/trunk/batch/bin/main/, file:/C:/DEV/3-DOS_ProjectSource/trunk/batch/bin/default/, file:/C:/DEV/3-DOS_ProjectSource/trunk/batch_common/bin/default/, file:/C:/DEV/3-DOS_ProjectSource/trunk/batch_common/bin/main/, file:/C:/DEV/3-DOS_ProjectSource/trunk/common/bin/default/, file:/C:/DEV/3-DOS_ProjectSource/trunk/common/bin/main/]
2026/06/30 11:36:04 DEBUG [restartedMain] - Included patterns for restart : []
2026/06/30 11:36:04 DEBUG [restartedMain] - Excluded patterns for restart : [/spring-boot-starter-[\w-]+/, /spring-boot/(bin|build|out)/, /spring-boot-starter/(bin|build|out)/, /spring-boot-devtools/(bin|build|out)/, /spring-boot-actuator/(bin|build|out)/, /spring-boot-autoconfigure/(bin|build|out)/]
2026/06/30 11:36:05 INFO  [restartedMain] - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
2026/06/30 11:36:05 INFO  [restartedMain] - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
2026/06/30 11:36:06 INFO  [restartedMain] - Bootstrapping Spring Data JDBC repositories in DEFAULT mode.
2026/06/30 11:36:08 INFO  [restartedMain] - Finished Spring Data repository scanning in 1155 ms. Found 370 JDBC repository interfaces.
2026/06/30 11:36:10 INFO  [restartedMain] - HikariPool-1 - Starting...
2026/06/30 11:36:10 INFO  [restartedMain] - HikariPool-1 - Added connection oracle.jdbc.driver.T4CConnection@7d609a40
2026/06/30 11:36:10 INFO  [restartedMain] - HikariPool-1 - Start completed.
2026/06/30 11:36:11 DEBUG [restartedMain] - Application Admin MBean registered with name 'org.springframework.boot:type=Admin,name=SpringApplication'
2026/06/30 11:36:11 DEBUG [restartedMain] - Starting live reload server on port 35731
2026/06/30 11:36:11 INFO  [restartedMain] - LiveReload server is running on port 35731
2026/06/30 11:36:37 DEBUG [restartedMain] - Found key 'app.jobFuncrionId' in PropertySource 'Config resource 'class path resource [application.properties]' via location 'optional:classpath:/'' with value of type String
2026/06/30 11:36:37 DEBUG [restartedMain] - Found key 'app.jobFuncrionId' in PropertySource 'Config resource 'class path resource [application.properties]' via location 'optional:classpath:/'' with value of type String
2026/06/30 11:36:38 DEBUG [restartedMain] - Found key 'app.jobFuncrionId' in PropertySource 'Config resource 'class path resource [application.properties]' via location 'optional:classpath:/'' with value of type String
2026/06/30 11:36:38 DEBUG [restartedMain] - Found key 'app.jobFuncrionId' in PropertySource 'Config resource 'class path resource [application.properties]' via location 'optional:classpath:/'' with value of type String
2026/06/30 11:36:38 DEBUG [restartedMain] - Found key 'app.jobFuncrionId' in PropertySource 'Config resource 'class path resource [application.properties]' via location 'optional:classpath:/'' with value of type String
2026/06/30 11:36:38 DEBUG [restartedMain] - Found key 'app.jobFuncrionId' in PropertySource 'Config resource 'class path resource [application.properties]' via location 'optional:classpath:/'' with value of type String
2026/06/30 11:36:38 DEBUG [restartedMain] - Found key 'app.jobFuncrionId' in PropertySource 'Config resource 'class path resource [application.properties]' via location 'optional:classpath:/'' with value of type String
2026/06/30 11:36:38 DEBUG [restartedMain] - Found key 'app.jobFuncrionId' in PropertySource 'Config resource 'class path resource [application.properties]' via location 'optional:classpath:/'' with value of type String
2026/06/30 11:36:39 DEBUG [restartedMain] - Found key 'app.jobFuncrionId' in PropertySource 'Config resource 'class path resource [application.properties]' via location 'optional:classpath:/'' with value of type String
2026/06/30 11:36:39 DEBUG [restartedMain] - Found key 'app.jobFuncrionId' in PropertySource 'Config resource 'class path resource [application.properties]' via location 'optional:classpath:/'' with value of type String
2026/06/30 11:36:39 INFO  [restartedMain] - HikariPool-2 - Starting...
2026/06/30 11:36:40 INFO  [restartedMain] - HikariPool-2 - Added connection conn0: url=jdbc:h2:mem:batchdb user=SA
2026/06/30 11:36:40 INFO  [restartedMain] - HikariPool-2 - Start completed.
2026/06/30 11:36:40 INFO  [restartedMain] - No database type set, using meta data indicating: H2
2026/06/30 11:36:40 INFO  [restartedMain] - No TaskExecutor has been set, defaulting to synchronous executor.
2026/06/30 11:36:41 INFO  [restartedMain] - Started BatchApplication in 38.75 seconds (process running for 39.76)
2026/06/30 11:36:41 DEBUG [restartedMain] - Application availability state LivenessState changed to CORRECT
2026/06/30 11:36:41 INFO  [restartedMain] - Job: [SimpleJob: [name=TXPOSRP1Job]] launched with the following parameters: [{'run.id':'{value=1, type=class java.lang.Long, identifying=true}'}]
2026/06/30 11:36:42 INFO  [restartedMain] - Executing step: [TXPOSRP1]
◆◆◆起動パラメータ◆◆◆
pram01: null
pram02: null
jobFuncrionId: null
BaseJcl:execute
JobName:TXPOSRP1Job
jobFuncrionId:[TXPOSRP1]
BaseJcl:step0000

�C���[�W��                     PID �Z�b�V������     �Z�b�V����# �������g�p��
========================= ======== ================ =========== ============
java.exe                     52908 Console                    2  1,046,512 K
◆◆◆  LOOP:1  ◆◆◆
BaseJcl:main
SCRATCH:main
TX30010:main
TX31020:main
2026/06/30 11:58:24 WARN  [restartedMain] - HikariPool-1 - Connection oracle.jdbc.driver.T4CConnection@1f8091c7 marked as broken because of SQLSTATE(08006), ErrorCode(17002)
java.sql.SQLRecoverableException: IOエラー: Connection reset
	at oracle.jdbc.driver.T4CConnection.doCommit(T4CConnection.java:2116)
	at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2704)
	at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2766)
	at com.zaxxer.hikari.pool.ProxyConnection.commit(ProxyConnection.java:378)
	at com.zaxxer.hikari.pool.HikariProxyConnection.commit(HikariProxyConnection.java)
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:337)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:795)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:758)
	at com.d3os.d3os_batch_common.jcl.BaseJcl.executeStep(BaseJcl.java:788)
	at com.d3os.d3os_batch.jcl.TXPOSRP1.main(TXPOSRP1.java:191)
	at com.d3os.d3os_batch_common.jcl.BaseJcl.execute(BaseJcl.java:237)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:355)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
	at com.d3os.d3os_common.entity.config.ExecutionProgramIdContextAspect.aroundFunctionType(ExecutionProgramIdContextAspect.java:42)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:637)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:627)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:71)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
	at com.d3os.d3os_common.entity.config.ExecutionProgramIdContextAspect.around(ExecutionProgramIdContextAspect.java:23)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:637)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:627)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:71)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:720)
	at com.d3os.d3os_batch.jcl.TXPOSRP1$$SpringCGLIB$$0.execute(<generated>)
	at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:388)
	at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:312)
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
	at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:255)
	at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:82)
	at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:369)
	at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:206)
	at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:140)
	at org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:240)
	at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:229)
	at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:153)
	at org.springframework.batch.core.job.AbstractJob.handleStep(AbstractJob.java:418)
	at org.springframework.batch.core.job.SimpleJob.doExecute(SimpleJob.java:132)
	at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:317)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:157)
	at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:148)
	at org.springframework.batch.core.launch.support.TaskExecutorJobLauncher.run(TaskExecutorJobLauncher.java:59)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.execute(JobLauncherApplicationRunner.java:210)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.executeLocalJobs(JobLauncherApplicationRunner.java:194)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.launchJobFromProperties(JobLauncherApplicationRunner.java:174)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:169)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:164)
	at org.springframework.boot.SpringApplication.lambda$callRunner$4(SpringApplication.java:786)
	at org.springframework.util.function.ThrowingConsumer$1.acceptWithException(ThrowingConsumer.java:83)
	at org.springframework.util.function.ThrowingConsumer.accept(ThrowingConsumer.java:60)
	at org.springframework.util.function.ThrowingConsumer$1.accept(ThrowingConsumer.java:88)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:798)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:786)
	at org.springframework.boot.SpringApplication.lambda$callRunners$3(SpringApplication.java:774)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at java.base/java.util.stream.SortedOps$SizedRefSortingSink.end(SortedOps.java:357)
	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:510)
	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:774)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:342)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1363)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1352)
	at com.d3os.d3os_batch.BatchApplication.main(BatchApplication.java:57)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:50)
Caused by: java.net.SocketException: Connection reset
	at java.base/sun.nio.ch.SocketChannelImpl.throwConnectionReset(SocketChannelImpl.java:401)
	at java.base/sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:434)
	at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:415)
	at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:1127)
	at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:266)
	at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:198)
	at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:140)
	at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:113)
	at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:97)
	at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:833)
	at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:486)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:622)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:298)
	at oracle.jdbc.driver.T4C7Ocommoncall.doOCOMMIT(T4C7Ocommoncall.java:117)
	at oracle.jdbc.driver.T4CConnection.doCommit(T4CConnection.java:2110)
	... 85 common frames omitted
org.springframework.transaction.TransactionSystemException: JDBC commit failed
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.translateException(DataSourceTransactionManager.java:439)
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:340)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:795)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:758)
	at com.d3os.d3os_batch_common.jcl.BaseJcl.executeStep(BaseJcl.java:788)
	at com.d3os.d3os_batch.jcl.TXPOSRP1.main(TXPOSRP1.java:191)
	at com.d3os.d3os_batch_common.jcl.BaseJcl.execute(BaseJcl.java:237)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:355)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
	at com.d3os.d3os_common.entity.config.ExecutionProgramIdContextAspect.aroundFunctionType(ExecutionProgramIdContextAspect.java:42)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:637)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:627)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:71)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
	at com.d3os.d3os_common.entity.config.ExecutionProgramIdContextAspect.around(ExecutionProgramIdContextAspect.java:23)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:637)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:627)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:71)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:720)
	at com.d3os.d3os_batch.jcl.TXPOSRP1$$SpringCGLIB$$0.execute(<generated>)
	at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:388)
	at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:312)
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
	at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:255)
	at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:82)
	at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:369)
	at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:206)
	at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:140)
	at org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:240)
	at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:229)
	at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:153)
	at org.springframework.batch.core.job.AbstractJob.handleStep(AbstractJob.java:418)
	at org.springframework.batch.core.job.SimpleJob.doExecute(SimpleJob.java:132)
	at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:317)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:157)
	at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:148)
	at org.springframework.batch.core.launch.support.TaskExecutorJobLauncher.run(TaskExecutorJobLauncher.java:59)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.execute(JobLauncherApplicationRunner.java:210)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.executeLocalJobs(JobLauncherApplicationRunner.java:194)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.launchJobFromProperties(JobLauncherApplicationRunner.java:174)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:169)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:164)
	at org.springframework.boot.SpringApplication.lambda$callRunner$4(SpringApplication.java:786)
	at org.springframework.util.function.ThrowingConsumer$1.acceptWithException(ThrowingConsumer.java:83)
	at org.springframework.util.function.ThrowingConsumer.accept(ThrowingConsumer.java:60)
	at org.springframework.util.function.ThrowingConsumer$1.accept(ThrowingConsumer.java:88)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:798)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:786)
	at org.springframework.boot.SpringApplication.lambda$callRunners$3(SpringApplication.java:774)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at java.base/java.util.stream.SortedOps$SizedRefSortingSink.end(SortedOps.java:357)
	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:510)
	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:774)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:342)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1363)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1352)
	at com.d3os.d3os_batch.BatchApplication.main(BatchApplication.java:57)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:50)
Caused by: java.sql.SQLRecoverableException: IOエラー: Connection reset
	at oracle.jdbc.driver.T4CConnection.doCommit(T4CConnection.java:2116)
	at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2704)
	at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2766)
	at com.zaxxer.hikari.pool.ProxyConnection.commit(ProxyConnection.java:378)
	at com.zaxxer.hikari.pool.HikariProxyConnection.commit(HikariProxyConnection.java)
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:337)
	... 80 more
Caused by: java.net.SocketException: Connection reset
	at java.base/sun.nio.ch.SocketChannelImpl.throwConnectionReset(SocketChannelImpl.java:401)
	at java.base/sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:434)
	at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:415)
	at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:1127)
	at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:266)
	at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:198)
	at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:140)
	at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:113)
	at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:97)
	at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:833)
	at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:486)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:622)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:298)
	at oracle.jdbc.driver.T4C7Ocommoncall.doOCOMMIT(T4C7Ocommoncall.java:117)
	at oracle.jdbc.driver.T4CConnection.doCommit(T4CConnection.java:2110)
	... 85 more
2026/06/30 11:58:28 WARN  [restartedMain] - HikariPool-1 - Connection oracle.jdbc.driver.T4CConnection@7d609a40 marked as broken because of SQLSTATE(08006), ErrorCode(17002)
java.sql.SQLRecoverableException: IOエラー: Connection reset
	at oracle.jdbc.driver.T4CConnection.doRollback(T4CConnection.java:2290)
	at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:2809)
	at com.zaxxer.hikari.pool.ProxyConnection.rollback(ProxyConnection.java:386)
	at com.zaxxer.hikari.pool.HikariProxyConnection.rollback(HikariProxyConnection.java)
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:352)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:897)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:866)
	at org.springframework.transaction.support.TransactionTemplate.rollbackOnException(TransactionTemplate.java:168)
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:144)
	at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:255)
	at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:82)
	at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:369)
	at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:206)
	at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:140)
	at org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:240)
	at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:229)
	at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:153)
	at org.springframework.batch.core.job.AbstractJob.handleStep(AbstractJob.java:418)
	at org.springframework.batch.core.job.SimpleJob.doExecute(SimpleJob.java:132)
	at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:317)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:157)
	at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:148)
	at org.springframework.batch.core.launch.support.TaskExecutorJobLauncher.run(TaskExecutorJobLauncher.java:59)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.execute(JobLauncherApplicationRunner.java:210)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.executeLocalJobs(JobLauncherApplicationRunner.java:194)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.launchJobFromProperties(JobLauncherApplicationRunner.java:174)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:169)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:164)
	at org.springframework.boot.SpringApplication.lambda$callRunner$4(SpringApplication.java:786)
	at org.springframework.util.function.ThrowingConsumer$1.acceptWithException(ThrowingConsumer.java:83)
	at org.springframework.util.function.ThrowingConsumer.accept(ThrowingConsumer.java:60)
	at org.springframework.util.function.ThrowingConsumer$1.accept(ThrowingConsumer.java:88)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:798)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:786)
	at org.springframework.boot.SpringApplication.lambda$callRunners$3(SpringApplication.java:774)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at java.base/java.util.stream.SortedOps$SizedRefSortingSink.end(SortedOps.java:357)
	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:510)
	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:774)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:342)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1363)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1352)
	at com.d3os.d3os_batch.BatchApplication.main(BatchApplication.java:57)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:50)
Caused by: java.net.SocketException: Connection reset
	at java.base/sun.nio.ch.SocketChannelImpl.throwConnectionReset(SocketChannelImpl.java:401)
	at java.base/sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:434)
	at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:415)
	at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:1127)
	at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:266)
	at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:198)
	at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:140)
	at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:113)
	at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:97)
	at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:833)
	at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:486)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:622)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:298)
	at oracle.jdbc.driver.T4C7Ocommoncall.doOROLLBACK(T4C7Ocommoncall.java:97)
	at oracle.jdbc.driver.T4CConnection.doRollback(T4CConnection.java:2280)
	... 51 common frames omitted
2026/06/30 11:58:28 ERROR [restartedMain] - Rolling back with transaction in unknown state
2026/06/30 11:58:28 ERROR [restartedMain] - Application exception overridden by rollback exception
org.springframework.transaction.IllegalTransactionStateException: Transaction is already completed - do not call commit or rollback more than once per transaction
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:861)
	at com.d3os.d3os_batch_common.jcl.BaseJcl.executeStep(BaseJcl.java:795)
	at com.d3os.d3os_batch.jcl.TXPOSRP1.main(TXPOSRP1.java:191)
	at com.d3os.d3os_batch_common.jcl.BaseJcl.execute(BaseJcl.java:237)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:355)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
	at com.d3os.d3os_common.entity.config.ExecutionProgramIdContextAspect.aroundFunctionType(ExecutionProgramIdContextAspect.java:42)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:637)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:627)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:71)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
	at com.d3os.d3os_common.entity.config.ExecutionProgramIdContextAspect.around(ExecutionProgramIdContextAspect.java:23)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:637)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:627)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:71)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:720)
	at com.d3os.d3os_batch.jcl.TXPOSRP1$$SpringCGLIB$$0.execute(<generated>)
	at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:388)
	at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:312)
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
	at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:255)
	at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:82)
	at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:369)
	at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:206)
	at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:140)
	at org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:240)
	at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:229)
	at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:153)
	at org.springframework.batch.core.job.AbstractJob.handleStep(AbstractJob.java:418)
	at org.springframework.batch.core.job.SimpleJob.doExecute(SimpleJob.java:132)
	at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:317)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:157)
	at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:148)
	at org.springframework.batch.core.launch.support.TaskExecutorJobLauncher.run(TaskExecutorJobLauncher.java:59)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.execute(JobLauncherApplicationRunner.java:210)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.executeLocalJobs(JobLauncherApplicationRunner.java:194)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.launchJobFromProperties(JobLauncherApplicationRunner.java:174)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:169)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:164)
	at org.springframework.boot.SpringApplication.lambda$callRunner$4(SpringApplication.java:786)
	at org.springframework.util.function.ThrowingConsumer$1.acceptWithException(ThrowingConsumer.java:83)
	at org.springframework.util.function.ThrowingConsumer.accept(ThrowingConsumer.java:60)
	at org.springframework.util.function.ThrowingConsumer$1.accept(ThrowingConsumer.java:88)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:798)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:786)
	at org.springframework.boot.SpringApplication.lambda$callRunners$3(SpringApplication.java:774)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at java.base/java.util.stream.SortedOps$SizedRefSortingSink.end(SortedOps.java:357)
	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:510)
	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:774)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:342)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1363)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1352)
	at com.d3os.d3os_batch.BatchApplication.main(BatchApplication.java:57)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:50)
2026/06/30 11:58:29 ERROR [restartedMain] - Encountered an error executing step TXPOSRP1 in job TXPOSRP1Job
org.springframework.transaction.TransactionSystemException: JDBC rollback failed
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.translateException(DataSourceTransactionManager.java:439)
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:355)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:897)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:866)
	at org.springframework.transaction.support.TransactionTemplate.rollbackOnException(TransactionTemplate.java:168)
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:144)
	at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:255)
	at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:82)
	at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:369)
	at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:206)
	at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:140)
	at org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:240)
	at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:229)
	at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:153)
	at org.springframework.batch.core.job.AbstractJob.handleStep(AbstractJob.java:418)
	at org.springframework.batch.core.job.SimpleJob.doExecute(SimpleJob.java:132)
	at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:317)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:157)
	at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:148)
	at org.springframework.batch.core.launch.support.TaskExecutorJobLauncher.run(TaskExecutorJobLauncher.java:59)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.execute(JobLauncherApplicationRunner.java:210)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.executeLocalJobs(JobLauncherApplicationRunner.java:194)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.launchJobFromProperties(JobLauncherApplicationRunner.java:174)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:169)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:164)
	at org.springframework.boot.SpringApplication.lambda$callRunner$4(SpringApplication.java:786)
	at org.springframework.util.function.ThrowingConsumer$1.acceptWithException(ThrowingConsumer.java:83)
	at org.springframework.util.function.ThrowingConsumer.accept(ThrowingConsumer.java:60)
	at org.springframework.util.function.ThrowingConsumer$1.accept(ThrowingConsumer.java:88)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:798)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:786)
	at org.springframework.boot.SpringApplication.lambda$callRunners$3(SpringApplication.java:774)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at java.base/java.util.stream.SortedOps$SizedRefSortingSink.end(SortedOps.java:357)
	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:510)
	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:774)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:342)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1363)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1352)
	at com.d3os.d3os_batch.BatchApplication.main(BatchApplication.java:57)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:50)
Caused by: java.sql.SQLRecoverableException: IOエラー: Connection reset
	at oracle.jdbc.driver.T4CConnection.doRollback(T4CConnection.java:2290)
	at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:2809)
	at com.zaxxer.hikari.pool.ProxyConnection.rollback(ProxyConnection.java:386)
	at com.zaxxer.hikari.pool.HikariProxyConnection.rollback(HikariProxyConnection.java)
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:352)
	... 47 common frames omitted
Caused by: java.net.SocketException: Connection reset
	at java.base/sun.nio.ch.SocketChannelImpl.throwConnectionReset(SocketChannelImpl.java:401)
	at java.base/sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:434)
	at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:415)
	at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:1127)
	at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:266)
	at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:198)
	at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:140)
	at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:113)
	at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:97)
	at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:833)
	at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:486)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:622)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:298)
	at oracle.jdbc.driver.T4C7Ocommoncall.doOROLLBACK(T4C7Ocommoncall.java:97)
	at oracle.jdbc.driver.T4CConnection.doRollback(T4CConnection.java:2280)
	... 51 common frames omitted
2026/06/30 11:58:29 INFO  [restartedMain] - Step: [TXPOSRP1] executed in 21m46s894ms
2026/06/30 11:58:29 INFO  [restartedMain] - Job: [SimpleJob: [name=TXPOSRP1Job]] completed with the following parameters: [{'run.id':'{value=1, type=class java.lang.Long, identifying=true}'}] and the following status: [UNKNOWN] in 21m47s251ms
2026/06/30 11:58:29 DEBUG [restartedMain] - Creating new Restarter for thread Thread[#1,main,5,main]
2026/06/30 11:58:29 DEBUG [restartedMain] - Immediately restarting application
2026/06/30 11:58:29 DEBUG [restartedMain] - Starting application com.d3os.d3os_batch.BatchApplication with URLs [file:/C:/DEV/3-DOS_ProjectSource/trunk/batch/bin/main/, file:/C:/DEV/3-DOS_ProjectSource/trunk/batch/bin/default/, file:/C:/DEV/3-DOS_ProjectSource/trunk/batch_common/bin/default/, file:/C:/DEV/3-DOS_ProjectSource/trunk/batch_common/bin/main/, file:/C:/DEV/3-DOS_ProjectSource/trunk/common/bin/default/, file:/C:/DEV/3-DOS_ProjectSource/trunk/common/bin/main/]
2026/06/30 11:58:29 DEBUG [restartedMain] - Application availability state ReadinessState changed to ACCEPTING_TRAFFIC
BatchApplication:run>>>
exitCode:0
2026/06/30 11:58:29 INFO  [SpringApplicationShutdownHook] - HikariPool-2 - Shutdown initiated...
2026/06/30 11:58:30 INFO  [SpringApplicationShutdownHook] - HikariPool-2 - Shutdown completed.
2026/06/30 11:58:30 INFO  [SpringApplicationShutdownHook] - HikariPool-1 - Shutdown initiated...
2026/06/30 11:58:30 INFO  [SpringApplicationShutdownHook] - HikariPool-1 - Shutdown completed.

渡邉 拓英 さんが4ヶ月前に更新 · 編集済み

根本原因候補

可能性が高い順です。

原因 可能性 確認方法
① ネットワーク(FW/LB)がTCP切断 ★★★★★ ネットワークログ
② Oracleが接続切断 ★★★★☆ alert.log、listener.log
③ JDBC/Hikariが保持していたConnectionが無効 ★★★★☆ Hikari DEBUGログ
④ OSレベル(TCP KeepAlive) ★★★☆☆ OS設定
⑤ Spring Transaction Timeout ★★☆☆☆ 設定確認
⑥ Oracle PROFILE(IDLE_TIME等) ★★☆☆☆ DBA確認

渡邉 拓英 さんが4ヶ月前に更新 · 編集済み

  • ステータス を 新規 から 進行中 に変更
  • 優先度 を 通常 から 高め に変更

渡邉 拓英 さんが4ヶ月前に更新 · 編集済み

ID OTZJBTID OTZJJOBN OTZJZCLS OTZJMCLS OTZJSYKE OTZJZKBN OTZJTROK OTZJWPID OTZJSKAI OTZJSSYU OTZJCFLG SYSCRDTS SYSCRTID SYSCRJCD SYSCRPID SYSCRVER SYSUPDTS SYSUPTID SYSUPJCD SYSUPPID SYSUPVER VERSION
4896 TXPOSRP1 TXPOSRP1 R P 1 20260630122346 0 20260630122346 0 2026/06/30 12:23:46.413 ACT26002 BATCH TXPOSRP1 1.2026.0624.0_B 2026/06/30 12:23:46.602 ACT26002 BATCH TXPOSRP1 1.2026.0624.0_B 1
TX31040:main
TX30180:main
TX31060:main
TX30190:main
TX30310:main
TX31010:main
TX30061:main
TX31030:main
TX33010:main
TX30100:main
TX30140:main
TX34000:main
TX34030:main
TX32030:main
TX34041:main
TX34050:main
BaseJcl:step9990
2026/06/30 13:07:00 WARN  [restartedMain] - HikariPool-1 - Connection oracle.jdbc.driver.T4CConnection@7be8038f marked as broken because of SQLSTATE(08006), ErrorCode(17002)
java.sql.SQLRecoverableException: IOエラー: Connection reset
	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1250)
	at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1819)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1471)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3760)
	at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:4061)
	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4036)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:995)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
	at org.springframework.jdbc.core.JdbcTemplate.lambda$update$2(JdbcTemplate.java:975)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:658)
	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:970)
	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:991)
	at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:337)
	at org.springframework.data.jdbc.core.convert.DefaultDataAccessStrategy.updateWithVersion(DefaultDataAccessStrategy.java:148)
	at org.springframework.data.jdbc.core.JdbcAggregateChangeExecutionContext.updateWithVersion(JdbcAggregateChangeExecutionContext.java:348)
	at org.springframework.data.jdbc.core.JdbcAggregateChangeExecutionContext.executeUpdateRoot(JdbcAggregateChangeExecutionContext.java:127)
	at org.springframework.data.jdbc.core.AggregateChangeExecutor.execute(AggregateChangeExecutor.java:93)
	at org.springframework.data.jdbc.core.AggregateChangeExecutor.lambda$executeSave$0(AggregateChangeExecutor.java:61)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)
	at org.springframework.data.relational.core.conversion.SaveBatchingAggregateChange.forEachAction(SaveBatchingAggregateChange.java:70)
	at org.springframework.data.jdbc.core.AggregateChangeExecutor.executeSave(AggregateChangeExecutor.java:61)
	at org.springframework.data.jdbc.core.JdbcAggregateTemplate.performSave(JdbcAggregateTemplate.java:499)
	at org.springframework.data.jdbc.core.JdbcAggregateTemplate.save(JdbcAggregateTemplate.java:170)
	at org.springframework.data.jdbc.repository.support.SimpleJdbcRepository.save(SimpleJdbcRepository.java:68)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:355)
	at org.springframework.data.repository.core.support.RepositoryMethodInvoker$RepositoryFragmentMethodInvoker.lambda$new$0(RepositoryMethodInvoker.java:277)
	at org.springframework.data.repository.core.support.RepositoryMethodInvoker.doInvoke(RepositoryMethodInvoker.java:170)
	at org.springframework.data.repository.core.support.RepositoryMethodInvoker.invoke(RepositoryMethodInvoker.java:158)
	at org.springframework.data.repository.core.support.RepositoryComposition$RepositoryFragments.invoke(RepositoryComposition.java:516)
	at org.springframework.data.repository.core.support.RepositoryComposition.invoke(RepositoryComposition.java:285)
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$ImplementationMethodExecutionInterceptor.invoke(RepositoryFactorySupport.java:628)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:173)
	at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:148)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:70)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:379)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:223)
	at jdk.proxy4/jdk.proxy4.$Proxy185.save(Unknown Source)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:355)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:223)
	at jdk.proxy4/jdk.proxy4.$Proxy185.save(Unknown Source)
	at com.d3os.d3os_common.service.OTZJOBKNServiceImpl.update(OTZJOBKNServiceImpl.java:38)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:355)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:379)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:720)
	at com.d3os.d3os_common.service.OTZJOBKNServiceImpl$$SpringCGLIB$$0.update(<generated>)
	at com.d3os.d3os_batch_common.jcl.BaseJcl.step9990(BaseJcl.java:660)
	at com.d3os.d3os_batch_common.jcl.BaseJcl.execute(BaseJcl.java:244)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:355)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
	at com.d3os.d3os_common.entity.config.ExecutionProgramIdContextAspect.aroundFunctionType(ExecutionProgramIdContextAspect.java:42)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:637)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:627)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:71)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
	at com.d3os.d3os_common.entity.config.ExecutionProgramIdContextAspect.around(ExecutionProgramIdContextAspect.java:23)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:637)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:627)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:71)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:720)
	at com.d3os.d3os_batch.jcl.TXPOSRP1$$SpringCGLIB$$0.execute(<generated>)
	at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:388)
	at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:312)
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
	at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:255)
	at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:82)
	at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:369)
	at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:206)
	at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:140)
	at org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:240)
	at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:229)
	at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:153)
	at org.springframework.batch.core.job.AbstractJob.handleStep(AbstractJob.java:418)
	at org.springframework.batch.core.job.SimpleJob.doExecute(SimpleJob.java:132)
	at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:317)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:157)
	at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:148)
	at org.springframework.batch.core.launch.support.TaskExecutorJobLauncher.run(TaskExecutorJobLauncher.java:59)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.execute(JobLauncherApplicationRunner.java:210)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.executeLocalJobs(JobLauncherApplicationRunner.java:194)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.launchJobFromProperties(JobLauncherApplicationRunner.java:174)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:169)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:164)
	at org.springframework.boot.SpringApplication.lambda$callRunner$4(SpringApplication.java:786)
	at org.springframework.util.function.ThrowingConsumer$1.acceptWithException(ThrowingConsumer.java:83)
	at org.springframework.util.function.ThrowingConsumer.accept(ThrowingConsumer.java:60)
	at org.springframework.util.function.ThrowingConsumer$1.accept(ThrowingConsumer.java:88)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:798)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:786)
	at org.springframework.boot.SpringApplication.lambda$callRunners$3(SpringApplication.java:774)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at java.base/java.util.stream.SortedOps$SizedRefSortingSink.end(SortedOps.java:357)
	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:510)
	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:774)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:342)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1363)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1352)
	at com.d3os.d3os_batch.BatchApplication.main(BatchApplication.java:57)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:50)
Caused by: java.net.SocketException: Connection reset
	at java.base/sun.nio.ch.SocketChannelImpl.throwConnectionReset(SocketChannelImpl.java:401)
	at java.base/sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:434)
	at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:415)
	at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:1127)
	at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:266)
	at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:198)
	at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:140)
	at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:113)
	at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:97)
	at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:833)
	at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:486)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:622)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:298)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:511)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:162)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1240)
	... 147 common frames omitted
2026/06/30 13:07:00 ERROR [restartedMain] - Rolling back with transaction in unknown state
2026/06/30 13:07:00 ERROR [restartedMain] - Application exception overridden by rollback exception
org.springframework.data.relational.core.conversion.DbActionExecutionException: Failed to execute DbAction.UpdateRoot(entity=OTZJOBKN(ID=4896, OTZJBTID=TXPOSRP1, OTZJJOBN=TXPOSRP1, OTZJZCLS=R , OTZJMCLS=P, OTZJSYKE=0, OTZJZKBN=9, OTZJTROK=20260630122346, OTZJWPID=0, OTZJSKAI=20260630122346, OTZJSSYU=20260630130700, OTZJCFLG=0))
	at org.springframework.data.jdbc.core.AggregateChangeExecutor.execute(AggregateChangeExecutor.java:118)
	at org.springframework.data.jdbc.core.AggregateChangeExecutor.lambda$executeSave$0(AggregateChangeExecutor.java:61)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)
	at org.springframework.data.relational.core.conversion.SaveBatchingAggregateChange.forEachAction(SaveBatchingAggregateChange.java:70)
	at org.springframework.data.jdbc.core.AggregateChangeExecutor.executeSave(AggregateChangeExecutor.java:61)
	at org.springframework.data.jdbc.core.JdbcAggregateTemplate.performSave(JdbcAggregateTemplate.java:499)
	at org.springframework.data.jdbc.core.JdbcAggregateTemplate.save(JdbcAggregateTemplate.java:170)
	at org.springframework.data.jdbc.repository.support.SimpleJdbcRepository.save(SimpleJdbcRepository.java:68)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:355)
	at org.springframework.data.repository.core.support.RepositoryMethodInvoker$RepositoryFragmentMethodInvoker.lambda$new$0(RepositoryMethodInvoker.java:277)
	at org.springframework.data.repository.core.support.RepositoryMethodInvoker.doInvoke(RepositoryMethodInvoker.java:170)
	at org.springframework.data.repository.core.support.RepositoryMethodInvoker.invoke(RepositoryMethodInvoker.java:158)
	at org.springframework.data.repository.core.support.RepositoryComposition$RepositoryFragments.invoke(RepositoryComposition.java:516)
	at org.springframework.data.repository.core.support.RepositoryComposition.invoke(RepositoryComposition.java:285)
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$ImplementationMethodExecutionInterceptor.invoke(RepositoryFactorySupport.java:628)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:173)
	at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:148)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:70)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:379)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:223)
	at jdk.proxy4/jdk.proxy4.$Proxy185.save(Unknown Source)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:355)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:223)
	at jdk.proxy4/jdk.proxy4.$Proxy185.save(Unknown Source)
	at com.d3os.d3os_common.service.OTZJOBKNServiceImpl.update(OTZJOBKNServiceImpl.java:38)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:355)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:379)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:720)
	at com.d3os.d3os_common.service.OTZJOBKNServiceImpl$$SpringCGLIB$$0.update(<generated>)
	at com.d3os.d3os_batch_common.jcl.BaseJcl.step9990(BaseJcl.java:660)
	at com.d3os.d3os_batch_common.jcl.BaseJcl.execute(BaseJcl.java:244)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:355)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
	at com.d3os.d3os_common.entity.config.ExecutionProgramIdContextAspect.aroundFunctionType(ExecutionProgramIdContextAspect.java:42)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:637)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:627)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:71)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
	at com.d3os.d3os_common.entity.config.ExecutionProgramIdContextAspect.around(ExecutionProgramIdContextAspect.java:23)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:637)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:627)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:71)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:720)
	at com.d3os.d3os_batch.jcl.TXPOSRP1$$SpringCGLIB$$0.execute(<generated>)
	at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:388)
	at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:312)
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
	at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:255)
	at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:82)
	at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:369)
	at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:206)
	at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:140)
	at org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:240)
	at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:229)
	at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:153)
	at org.springframework.batch.core.job.AbstractJob.handleStep(AbstractJob.java:418)
	at org.springframework.batch.core.job.SimpleJob.doExecute(SimpleJob.java:132)
	at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:317)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:157)
	at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:148)
	at org.springframework.batch.core.launch.support.TaskExecutorJobLauncher.run(TaskExecutorJobLauncher.java:59)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.execute(JobLauncherApplicationRunner.java:210)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.executeLocalJobs(JobLauncherApplicationRunner.java:194)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.launchJobFromProperties(JobLauncherApplicationRunner.java:174)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:169)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:164)
	at org.springframework.boot.SpringApplication.lambda$callRunner$4(SpringApplication.java:786)
	at org.springframework.util.function.ThrowingConsumer$1.acceptWithException(ThrowingConsumer.java:83)
	at org.springframework.util.function.ThrowingConsumer.accept(ThrowingConsumer.java:60)
	at org.springframework.util.function.ThrowingConsumer$1.accept(ThrowingConsumer.java:88)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:798)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:786)
	at org.springframework.boot.SpringApplication.lambda$callRunners$3(SpringApplication.java:774)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at java.base/java.util.stream.SortedOps$SizedRefSortingSink.end(SortedOps.java:357)
	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:510)
	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:774)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:342)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1363)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1352)
	at com.d3os.d3os_batch.BatchApplication.main(BatchApplication.java:57)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:50)
Caused by: org.springframework.dao.RecoverableDataAccessException: PreparedStatementCallback; SQL [UPDATE "OTZJOBKN" SET "OTZJBTID" = ?, "OTZJJOBN" = ?, "OTZJZCLS" = ?, "OTZJMCLS" = ?, "OTZJSYKE" = ?, "OTZJZKBN" = ?, "OTZJTROK" = ?, "OTZJWPID" = ?, "OTZJSKAI" = ?, "OTZJSSYU" = ?, "OTZJCFLG" = ?, "SYSCRDTS" = ?, "SYSCRTID" = ?, "SYSCRJCD" = ?, "SYSCRPID" = ?, "SYSCRVER" = ?, "SYSUPDTS" = ?, "SYSUPTID" = ?, "SYSUPJCD" = ?, "SYSUPPID" = ?, "SYSUPVER" = ?, "VERSION" = ? WHERE "OTZJOBKN"."ID" = ? AND "OTZJOBKN"."VERSION" = ?]; IOエラー: Connection reset
	at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:110)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:107)
	at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1548)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:677)
	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:970)
	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:991)
	at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:337)
	at org.springframework.data.jdbc.core.convert.DefaultDataAccessStrategy.updateWithVersion(DefaultDataAccessStrategy.java:148)
	at org.springframework.data.jdbc.core.JdbcAggregateChangeExecutionContext.updateWithVersion(JdbcAggregateChangeExecutionContext.java:348)
	at org.springframework.data.jdbc.core.JdbcAggregateChangeExecutionContext.executeUpdateRoot(JdbcAggregateChangeExecutionContext.java:127)
	at org.springframework.data.jdbc.core.AggregateChangeExecutor.execute(AggregateChangeExecutor.java:93)
	... 130 common frames omitted
Caused by: java.sql.SQLRecoverableException: IOエラー: Connection reset
	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1250)
	at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1819)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1471)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3760)
	at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:4061)
	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4036)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:995)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
	at org.springframework.jdbc.core.JdbcTemplate.lambda$update$2(JdbcTemplate.java:975)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:658)
	... 137 common frames omitted
Caused by: java.net.SocketException: Connection reset
	at java.base/sun.nio.ch.SocketChannelImpl.throwConnectionReset(SocketChannelImpl.java:401)
	at java.base/sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:434)
	at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:415)
	at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:1127)
	at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:266)
	at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:198)
	at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:140)
	at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:113)
	at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:97)
	at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:833)
	at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:486)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:622)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:298)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:511)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:162)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1240)
	... 147 common frames omitted
2026/06/30 13:07:00 ERROR [restartedMain] - Encountered an error executing step TXPOSRP1 in job TXPOSRP1Job
org.springframework.transaction.TransactionSystemException: JDBC rollback failed
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.translateException(DataSourceTransactionManager.java:439)
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:355)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:897)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:866)
	at org.springframework.transaction.support.TransactionTemplate.rollbackOnException(TransactionTemplate.java:168)
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:144)
	at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:255)
	at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:82)
	at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:369)
	at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:206)
	at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:140)
	at org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:240)
	at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:229)
	at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:153)
	at org.springframework.batch.core.job.AbstractJob.handleStep(AbstractJob.java:418)
	at org.springframework.batch.core.job.SimpleJob.doExecute(SimpleJob.java:132)
	at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:317)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:157)
	at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:148)
	at org.springframework.batch.core.launch.support.TaskExecutorJobLauncher.run(TaskExecutorJobLauncher.java:59)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.execute(JobLauncherApplicationRunner.java:210)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.executeLocalJobs(JobLauncherApplicationRunner.java:194)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.launchJobFromProperties(JobLauncherApplicationRunner.java:174)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:169)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:164)
	at org.springframework.boot.SpringApplication.lambda$callRunner$4(SpringApplication.java:786)
	at org.springframework.util.function.ThrowingConsumer$1.acceptWithException(ThrowingConsumer.java:83)
	at org.springframework.util.function.ThrowingConsumer.accept(ThrowingConsumer.java:60)
	at org.springframework.util.function.ThrowingConsumer$1.accept(ThrowingConsumer.java:88)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:798)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:786)
	at org.springframework.boot.SpringApplication.lambda$callRunners$3(SpringApplication.java:774)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at java.base/java.util.stream.SortedOps$SizedRefSortingSink.end(SortedOps.java:357)
	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:510)
	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:774)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:342)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1363)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1352)
	at com.d3os.d3os_batch.BatchApplication.main(BatchApplication.java:57)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:50)
Caused by: java.sql.SQLException: Connection is closed
	at com.zaxxer.hikari.pool.ProxyConnection$ClosedConnection.lambda$getClosedConnection$0(ProxyConnection.java:503)
	at jdk.proxy3/jdk.proxy3.$Proxy70.rollback(Unknown Source)
	at com.zaxxer.hikari.pool.ProxyConnection.rollback(ProxyConnection.java:386)
	at com.zaxxer.hikari.pool.HikariProxyConnection.rollback(HikariProxyConnection.java)
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:352)
	... 47 common frames omitted
2026/06/30 13:07:00 INFO  [restartedMain] - Step: [TXPOSRP1] executed in 43m14s866ms
2026/06/30 13:07:01 INFO  [restartedMain] - Job: [SimpleJob: [name=TXPOSRP1Job]] completed with the following parameters: [{'run.id':'{value=1, type=class java.lang.Long, identifying=true}'}] and the following status: [UNKNOWN] in 43m15s182ms
2026/06/30 13:07:01 DEBUG [restartedMain] - Creating new Restarter for thread Thread[#1,main,5,main]
2026/06/30 13:07:01 DEBUG [restartedMain] - Immediately restarting application
2026/06/30 13:07:01 DEBUG [restartedMain] - Starting application com.d3os.d3os_batch.BatchApplication with URLs [file:/C:/DEV/3-DOS_ProjectSource/trunk/batch/bin/main/, file:/C:/DEV/3-DOS_ProjectSource/trunk/batch/bin/default/, file:/C:/DEV/3-DOS_ProjectSource/trunk/batch_common/bin/default/, file:/C:/DEV/3-DOS_ProjectSource/trunk/batch_common/bin/main/, file:/C:/DEV/3-DOS_ProjectSource/trunk/common/bin/default/, file:/C:/DEV/3-DOS_ProjectSource/trunk/common/bin/main/]
2026/06/30 13:07:01 DEBUG [restartedMain] - Application availability state ReadinessState changed to ACCEPTING_TRAFFIC
BatchApplication:run>>>
exitCode:0
2026/06/30 13:07:01 INFO  [SpringApplicationShutdownHook] - HikariPool-2 - Shutdown initiated...
2026/06/30 13:07:01 INFO  [SpringApplicationShutdownHook] - HikariPool-2 - Shutdown completed.
2026/06/30 13:07:01 INFO  [SpringApplicationShutdownHook] - HikariPool-1 - Shutdown initiated...
2026/06/30 13:07:02 INFO  [SpringApplicationShutdownHook] - HikariPool-1 - Shutdown completed.

渡邉 拓英 さんが4ヶ月前に更新 · 編集済み

現在の設計は「1トランザクションで長時間処理する」ことを前提としている。

その前提を満たすためには、アプリケーションだけではなく、Oracle・JDBC・ネットワーク機器を含めた通信経路全体で、長時間接続を維持できる設定であることを確認する必要がある。

今回の Connection reset は、トランザクションの途中ではなく commit 時に発生しており、OracleやSpringのトランザクション制御というよりも、接続の維持に関するインフラ要因が疑われる。

渡邉 拓英 さんが4ヶ月前に更新 · 編集済み

ID MLOGLEVL MLOGFNID MLOGLMSG MLOGPGVR MLOGJBID MLOGSTNO SYSCRDTS SYSCRTID SYSCRJCD SYSCRPID SYSCRVER SYSUPDTS SYSUPTID SYSUPJCD SYSUPPID SYSUPVER VERSION
597769 INFO TXPOSRP1 TX34000 Start 1.2026.0625.0_B 4904 0160 2026/07/01 21:11:27.757 HK-BT01 BATCH TX34000 1.2026.0625.0_B 2026/07/01 21:11:27.757 HK-BT01 BATCH TX34000 1.2026.0625.0_B 0
597770 INFO TXPOSRP1 JOB登録LOG 1.2026.0625.0_B 4905 0000 2026/07/02 9:28:02.200 HK-BT01 BATCH TXPOSRP1 1.2026.0625.0_B 2026/07/02 9:28:02.200 HK-BT01 BATCH TXPOSRP1 1.2026.0625.0_B 0
597771 INFO TXPOSRP1 Process Start 1.2026.0625.0_B 4905 0000 2026/07/02 9:28:02.257 HK-BT01 BATCH TXPOSRP1 1.2026.0625.0_B 2026/07/02 9:28:02.257 HK-BT01 BATCH TXPOSRP1 1.2026.0625.0_B 0
597772 INFO TXPOSRP1 SCRATCH Start 1.2026.0625.0_B 4905 0010 2026/07/02 9:28:02.280 HK-BT01 BATCH SCRATCH 1.2026.0625.0_B 2026/07/02 9:28:02.280 HK-BT01 BATCH SCRATCH 1.2026.0625.0_B 0
597773 INFO TXPOSRP1 SCRATCH End Result =Success 1.2026.0625.0_B 4905 0010 2026/07/02 9:30:49.012 HK-BT01 BATCH SCRATCH 1.2026.0625.0_B 2026/07/02 9:30:49.012 HK-BT01 BATCH SCRATCH 1.2026.0625.0_B 0
597774 INFO TXPOSRP1 TX30010 Start 1.2026.0625.0_B 4905 0020 2026/07/02 9:30:49.019 HK-BT01 BATCH TX30010 1.2026.0625.0_B 2026/07/02 9:30:49.019 HK-BT01 BATCH TX30010 1.2026.0625.0_B 0
597775 INFO TXPOSRP1 TX30010 End Result =Success 1.2026.0625.0_B 4905 0020 2026/07/02 10:56:43.956 HK-BT01 BATCH TX30010 1.2026.0625.0_B 2026/07/02 10:56:43.956 HK-BT01 BATCH TX30010 1.2026.0625.0_B 0
597776 INFO TXPOSRP1 TX31020 Start 1.2026.0625.0_B 4905 0030 2026/07/02 10:56:43.969 HK-BT01 BATCH TX31020 1.2026.0625.0_B 2026/07/02 10:56:43.969 HK-BT01 BATCH TX31020 1.2026.0625.0_B 0
597777 INFO TXPOSRP1 TX31020 End Result =Success 1.2026.0625.0_B 4905 0030 2026/07/02 11:14:08.472 HK-BT01 BATCH TX31020 1.2026.0625.0_B 2026/07/02 11:14:08.472 HK-BT01 BATCH TX31020 1.2026.0625.0_B 0
597778 INFO TXPOSRP1 TX30020 Start 1.2026.0625.0_B 4905 0040 2026/07/02 11:14:08.479 HK-BT01 BATCH TX30020 1.2026.0625.0_B 2026/07/02 11:14:08.479 HK-BT01 BATCH TX30020 1.2026.0625.0_B 0
597779 INFO TXPOSRP1 << SYSTEM DATE >>20260321 1.2026.0625.0_B 4905 0040 2026/07/02 11:14:08.497 HK-BT01 BATCH TX30020 1.2026.0625.0_B 2026/07/02 11:14:08.497 HK-BT01 BATCH TX30020 1.2026.0625.0_B 0
597780 INFO TXPOSRP1 20260316 1.2026.0625.0_B 4905 0040 2026/07/02 11:14:08.513 HK-BT01 BATCH TX30020 1.2026.0625.0_B 2026/07/02 11:14:08.513 HK-BT01 BATCH TX30020 1.2026.0625.0_B 0
597781 INFO TXPOSRP1 INP_CNT =1550307 1.2026.0625.0_B 4905 0040 2026/07/02 11:57:01.270 HK-BT01 BATCH TX30020 1.2026.0625.0_B 2026/07/02 11:57:01.270 HK-BT01 BATCH TX30020 1.2026.0625.0_B 0
597782 INFO TXPOSRP1 OUT_CNT =0 1.2026.0625.0_B 4905 0040 2026/07/02 11:57:01.274 HK-BT01 BATCH TX30020 1.2026.0625.0_B 2026/07/02 11:57:01.274 HK-BT01 BATCH TX30020 1.2026.0625.0_B 0
597783 INFO TXPOSRP1 NOT_CNT =80814 1.2026.0625.0_B 4905 0040 2026/07/02 11:57:01.277 HK-BT01 BATCH TX30020 1.2026.0625.0_B 2026/07/02 11:57:01.277 HK-BT01 BATCH TX30020 1.2026.0625.0_B 0
597784 INFO TXPOSRP1 DEL_CNT =13 1.2026.0625.0_B 4905 0040 2026/07/02 11:57:01.279 HK-BT01 BATCH TX30020 1.2026.0625.0_B 2026/07/02 11:57:01.279 HK-BT01 BATCH TX30020 1.2026.0625.0_B 0
597785 INFO TXPOSRP1 1126,2803 YAMADA?? DEL_CNT =0 1.2026.0625.0_B 4905 0040 2026/07/02 11:57:01.281 HK-BT01 BATCH TX30020 1.2026.0625.0_B 2026/07/02 11:57:01.281 HK-BT01 BATCH TX30020 1.2026.0625.0_B 0
597786 INFO TXPOSRP1 TX30020 End Result =Success 1.2026.0625.0_B 4905 0040 2026/07/02 11:57:01.325 HK-BT01 BATCH TX30020 1.2026.0625.0_B 2026/07/02 11:57:01.325 HK-BT01 BATCH TX30020 1.2026.0625.0_B 0
597787 INFO TXPOSRP1 TX31040 Start 1.2026.0625.0_B 4905 0050 2026/07/02 11:57:01.331 HK-BT01 BATCH TX31040 1.2026.0625.0_B 2026/07/02 11:57:01.331 HK-BT01 BATCH TX31040 1.2026.0625.0_B 0
597788 INFO TXPOSRP1 TX31040 End Result =Success 1.2026.0625.0_B 4905 0050 2026/07/02 11:57:06.682 HK-BT01 BATCH TX31040 1.2026.0625.0_B 2026/07/02 11:57:06.682 HK-BT01 BATCH TX31040 1.2026.0625.0_B 0
597789 INFO TXPOSRP1 TX30180 Start 1.2026.0625.0_B 4905 0060 2026/07/02 11:57:06.685 HK-BT01 BATCH TX30180 1.2026.0625.0_B 2026/07/02 11:57:06.685 HK-BT01 BATCH TX30180 1.2026.0625.0_B 0
597790 INFO TXPOSRP1 <<< CHECK YYYYMMDD >>>20260317 1.2026.0625.0_B 4905 0060 2026/07/02 11:57:06.694 HK-BT01 BATCH TX30180 1.2026.0625.0_B 2026/07/02 11:57:06.694 HK-BT01 BATCH TX30180 1.2026.0625.0_B 0
597791 INFO TXPOSRP1 INP_CNT =7257 1.2026.0625.0_B 4905 0060 2026/07/02 11:57:18.092 HK-BT01 BATCH TX30180 1.2026.0625.0_B 2026/07/02 11:57:18.092 HK-BT01 BATCH TX30180 1.2026.0625.0_B 0
597792 INFO TXPOSRP1 OUT_CNT =0 1.2026.0625.0_B 4905 0060 2026/07/02 11:57:18.095 HK-BT01 BATCH TX30180 1.2026.0625.0_B 2026/07/02 11:57:18.095 HK-BT01 BATCH TX30180 1.2026.0625.0_B 0
597793 INFO TXPOSRP1 UNM_CNT =7257 1.2026.0625.0_B 4905 0060 2026/07/02 11:57:18.097 HK-BT01 BATCH TX30180 1.2026.0625.0_B 2026/07/02 11:57:18.097 HK-BT01 BATCH TX30180 1.2026.0625.0_B 0
597794 INFO TXPOSRP1 DELW =0 1.2026.0625.0_B 4905 0060 2026/07/02 11:57:18.099 HK-BT01 BATCH TX30180 1.2026.0625.0_B 2026/07/02 11:57:18.099 HK-BT01 BATCH TX30180 1.2026.0625.0_B 0
597795 INFO TXPOSRP1 DELI =0 1.2026.0625.0_B 4905 0060 2026/07/02 11:57:18.101 HK-BT01 BATCH TX30180 1.2026.0625.0_B 2026/07/02 11:57:18.101 HK-BT01 BATCH TX30180 1.2026.0625.0_B 0
597796 INFO TXPOSRP1 DELE =0 1.2026.0625.0_B 4905 0060 2026/07/02 11:57:18.102 HK-BT01 BATCH TX30180 1.2026.0625.0_B 2026/07/02 11:57:18.102 HK-BT01 BATCH TX30180 1.2026.0625.0_B 0
597797 INFO TXPOSRP1 DELF =0 1.2026.0625.0_B 4905 0060 2026/07/02 11:57:18.104 HK-BT01 BATCH TX30180 1.2026.0625.0_B 2026/07/02 11:57:18.104 HK-BT01 BATCH TX30180 1.2026.0625.0_B 0
597798 INFO TXPOSRP1 DELM =0 1.2026.0625.0_B 4905 0060 2026/07/02 11:57:18.105 HK-BT01 BATCH TX30180 1.2026.0625.0_B 2026/07/02 11:57:18.105 HK-BT01 BATCH TX30180 1.2026.0625.0_B 0
597799 INFO TXPOSRP1 DELG =0 1.2026.0625.0_B 4905 0060 2026/07/02 11:57:18.108 HK-BT01 BATCH TX30180 1.2026.0625.0_B 2026/07/02 11:57:18.108 HK-BT01 BATCH TX30180 1.2026.0625.0_B 0
597800 INFO TXPOSRP1 TX30180 End Result =Success 1.2026.0625.0_B 4905 0060 2026/07/02 11:57:18.112 HK-BT01 BATCH TX30180 1.2026.0625.0_B 2026/07/02 11:57:18.112 HK-BT01 BATCH TX30180 1.2026.0625.0_B 0
597801 INFO TXPOSRP1 TX31060 Start 1.2026.0625.0_B 4905 0070 2026/07/02 11:57:18.116 HK-BT01 BATCH TX31060 1.2026.0625.0_B 2026/07/02 11:57:18.116 HK-BT01 BATCH TX31060 1.2026.0625.0_B 0
597802 INFO TXPOSRP1 TX31060 End Result =Success 1.2026.0625.0_B 4905 0070 2026/07/02 11:57:22.212 HK-BT01 BATCH TX31060 1.2026.0625.0_B 2026/07/02 11:57:22.212 HK-BT01 BATCH TX31060 1.2026.0625.0_B 0
597803 INFO TXPOSRP1 TX30190 Start 1.2026.0625.0_B 4905 0080 2026/07/02 11:57:22.215 HK-BT01 BATCH TX30190 1.2026.0625.0_B 2026/07/02 11:57:22.215 HK-BT01 BATCH TX30190 1.2026.0625.0_B 0
597804 INFO TXPOSRP1 <<< CHECK YYYYMMDD >>>20260317 1.2026.0625.0_B 4905 0080 2026/07/02 11:57:22.221 HK-BT01 BATCH TX30190 1.2026.0625.0_B 2026/07/02 11:57:22.221 HK-BT01 BATCH TX30190 1.2026.0625.0_B 0
597805 INFO TXPOSRP1 IN_CNT =5592 1.2026.0625.0_B 4905 0080 2026/07/02 11:57:31.863 HK-BT01 BATCH TX30190 1.2026.0625.0_B 2026/07/02 11:57:31.863 HK-BT01 BATCH TX30190 1.2026.0625.0_B 0
597806 INFO TXPOSRP1 OUT_CNT =0 1.2026.0625.0_B 4905 0080 2026/07/02 11:57:31.867 HK-BT01 BATCH TX30190 1.2026.0625.0_B 2026/07/02 11:57:31.867 HK-BT01 BATCH TX30190 1.2026.0625.0_B 0
597807 INFO TXPOSRP1 OKRNO DUPLI =0 1.2026.0625.0_B 4905 0080 2026/07/02 11:57:31.869 HK-BT01 BATCH TX30190 1.2026.0625.0_B 2026/07/02 11:57:31.869 HK-BT01 BATCH TX30190 1.2026.0625.0_B 0
597808 INFO TXPOSRP1 UNMATCH =5592 1.2026.0625.0_B 4905 0080 2026/07/02 11:57:31.871 HK-BT01 BATCH TX30190 1.2026.0625.0_B 2026/07/02 11:57:31.871 HK-BT01 BATCH TX30190 1.2026.0625.0_B 0
597809 INFO TXPOSRP1 UNMATCH DEL =0 1.2026.0625.0_B 4905 0080 2026/07/02 11:57:31.874 HK-BT01 BATCH TX30190 1.2026.0625.0_B 2026/07/02 11:57:31.874 HK-BT01 BATCH TX30190 1.2026.0625.0_B 0
597810 INFO TXPOSRP1 F-PATTERN =0 1.2026.0625.0_B 4905 0080 2026/07/02 11:57:31.875 HK-BT01 BATCH TX30190 1.2026.0625.0_B 2026/07/02 11:57:31.875 HK-BT01 BATCH TX30190 1.2026.0625.0_B 0
597811 INFO TXPOSRP1 HCG14 NOT2 =0 1.2026.0625.0_B 4905 0080 2026/07/02 11:57:31.877 HK-BT01 BATCH TX30190 1.2026.0625.0_B 2026/07/02 11:57:31.877 HK-BT01 BATCH TX30190 1.2026.0625.0_B 0
597812 INFO TXPOSRP1 DTID ERROR =0 1.2026.0625.0_B 4905 0080 2026/07/02 11:57:31.879 HK-BT01 BATCH TX30190 1.2026.0625.0_B 2026/07/02 11:57:31.879 HK-BT01 BATCH TX30190 1.2026.0625.0_B 0
597813 INFO TXPOSRP1 TX30190 End Result =Success 1.2026.0625.0_B 4905 0080 2026/07/02 11:57:31.884 HK-BT01 BATCH TX30190 1.2026.0625.0_B 2026/07/02 11:57:31.884 HK-BT01 BATCH TX30190 1.2026.0625.0_B 0
597814 INFO TXPOSRP1 TX30310 Start 1.2026.0625.0_B 4905 0090 2026/07/02 11:57:31.887 HK-BT01 BATCH TX30310 1.2026.0625.0_B 2026/07/02 11:57:31.887 HK-BT01 BATCH TX30310 1.2026.0625.0_B 0
597815 INFO TXPOSRP1 TX30310 End Result =Success 1.2026.0625.0_B 4905 0090 2026/07/02 12:17:25.359 HK-BT01 BATCH TX30310 1.2026.0625.0_B 2026/07/02 12:17:25.359 HK-BT01 BATCH TX30310 1.2026.0625.0_B 0
597816 INFO TXPOSRP1 TX31010 Start 1.2026.0625.0_B 4905 0100 2026/07/02 12:17:25.364 HK-BT01 BATCH TX31010 1.2026.0625.0_B 2026/07/02 12:17:25.364 HK-BT01 BATCH TX31010 1.2026.0625.0_B 0
597817 INFO TXPOSRP1 TX31010 End Result =Success 1.2026.0625.0_B 4905 0100 2026/07/02 12:28:58.564 HK-BT01 BATCH TX31010 1.2026.0625.0_B 2026/07/02 12:28:58.564 HK-BT01 BATCH TX31010 1.2026.0625.0_B 0
597818 INFO TXPOSRP1 TX30061 Start 1.2026.0625.0_B 4905 0110 2026/07/02 12:28:58.570 HK-BT01 BATCH TX30061 1.2026.0625.0_B 2026/07/02 12:28:58.570 HK-BT01 BATCH TX30061 1.2026.0625.0_B 0
597819 INFO TXPOSRP1 45ニチマエ =20260204 1.2026.0625.0_B 4905 0110 2026/07/02 12:28:58.580 HK-BT01 BATCH TX30061 1.2026.0625.0_B 2026/07/02 12:28:58.580 HK-BT01 BATCH TX30061 1.2026.0625.0_B 0
597820 INFO TXPOSRP1 INP_CNT =998846 1.2026.0625.0_B 4905 0110 2026/07/02 12:51:03.874 HK-BT01 BATCH TX30061 1.2026.0625.0_B 2026/07/02 12:51:03.874 HK-BT01 BATCH TX30061 1.2026.0625.0_B 0
597821 INFO TXPOSRP1 OUT_CNT =947875 1.2026.0625.0_B 4905 0110 2026/07/02 12:51:03.874 HK-BT01 BATCH TX30061 1.2026.0625.0_B 2026/07/02 12:51:03.874 HK-BT01 BATCH TX30061 1.2026.0625.0_B 0
597822 INFO TXPOSRP1 OUT_WAR =16796 1.2026.0625.0_B 4905 0110 2026/07/02 12:51:03.874 HK-BT01 BATCH TX30061 1.2026.0625.0_B 2026/07/02 12:51:03.874 HK-BT01 BATCH TX30061 1.2026.0625.0_B 0
597823 INFO TXPOSRP1 WAR_DEL =3 1.2026.0625.0_B 4905 0110 2026/07/02 12:51:03.874 HK-BT01 BATCH TX30061 1.2026.0625.0_B 2026/07/02 12:51:03.874 HK-BT01 BATCH TX30061 1.2026.0625.0_B 0
597824 INFO TXPOSRP1 UNM_CNT =34172 1.2026.0625.0_B 4905 0110 2026/07/02 12:51:03.890 HK-BT01 BATCH TX30061 1.2026.0625.0_B 2026/07/02 12:51:03.890 HK-BT01 BATCH TX30061 1.2026.0625.0_B 0
597825 INFO TXPOSRP1 OKR_SCN =0 1.2026.0625.0_B 4905 0110 2026/07/02 12:51:03.890 HK-BT01 BATCH TX30061 1.2026.0625.0_B 2026/07/02 12:51:03.890 HK-BT01 BATCH TX30061 1.2026.0625.0_B 0
597826 INFO TXPOSRP1 TX30061 End Result =Success 1.2026.0625.0_B 4905 0110 2026/07/02 12:51:03.998 HK-BT01 BATCH TX30061 1.2026.0625.0_B 2026/07/02 12:51:03.998 HK-BT01 BATCH TX30061 1.2026.0625.0_B 0
597827 INFO TXPOSRP1 TX31030 Start 1.2026.0625.0_B 4905 0120 2026/07/02 12:51:04.004 HK-BT01 BATCH TX31030 1.2026.0625.0_B 2026/07/02 12:51:04.004 HK-BT01 BATCH TX31030 1.2026.0625.0_B 0
597828 INFO TXPOSRP1 TX31030 End Result =Success 1.2026.0625.0_B 4905 0120 2026/07/02 12:58:56.891 HK-BT01 BATCH TX31030 1.2026.0625.0_B 2026/07/02 12:58:56.891 HK-BT01 BATCH TX31030 1.2026.0625.0_B 0
597829 INFO TXPOSRP1 TX33010 Start 1.2026.0625.0_B 4905 0130 2026/07/02 12:58:56.897 HK-BT01 BATCH TX33010 1.2026.0625.0_B 2026/07/02 12:58:56.897 HK-BT01 BATCH TX33010 1.2026.0625.0_B 0
597830 INFO TXPOSRP1 TX33010 End Result =Success 1.2026.0625.0_B 4905 0130 2026/07/02 13:10:38.321 HK-BT01 BATCH TX33010 1.2026.0625.0_B 2026/07/02 13:10:38.321 HK-BT01 BATCH TX33010 1.2026.0625.0_B 0
597831 INFO TXPOSRP1 TX30100 Start 1.2026.0625.0_B 4905 0140 2026/07/02 13:10:38.326 HK-BT01 BATCH TX30100 1.2026.0625.0_B 2026/07/02 13:10:38.326 HK-BT01 BATCH TX30100 1.2026.0625.0_B 0
597832 INFO TXPOSRP1 TX30100 End Result =Success 1.2026.0625.0_B 4905 0140 2026/07/02 13:11:26.889 HK-BT01 BATCH TX30100 1.2026.0625.0_B 2026/07/02 13:11:26.889 HK-BT01 BATCH TX30100 1.2026.0625.0_B 0
597833 INFO TXPOSRP1 TX30140 Start 1.2026.0625.0_B 4905 0150 2026/07/02 13:11:26.893 HK-BT01 BATCH TX30140 1.2026.0625.0_B 2026/07/02 13:11:26.893 HK-BT01 BATCH TX30140 1.2026.0625.0_B 0
597834 INFO TXPOSRP1 TX30140 End Result =Success 1.2026.0625.0_B 4905 0150 2026/07/02 13:12:37.269 HK-BT01 BATCH TX30140 1.2026.0625.0_B 2026/07/02 13:12:37.269 HK-BT01 BATCH TX30140 1.2026.0625.0_B 0
597835 INFO TXPOSRP1 TX34000 Start 1.2026.0625.0_B 4905 0160 2026/07/02 13:12:37.273 HK-BT01 BATCH TX34000 1.2026.0625.0_B 2026/07/02 13:12:37.273 HK-BT01 BATCH TX34000 1.2026.0625.0_B 0

接続が切れるのはローカルPCで実行しているため。
ルーターなどのどこかで切られる。
バッチサーバーでは切れない。

渡邉 拓英 さんが4ヶ月前に更新 · 編集済み

  • ステータス を 進行中 から 終了 に変更

他の形式にエクスポート: Atom PDF