操作
バグ #12074
完了検証環境にて例外が発生
ステータス:
終了
優先度:
通常
担当者:
菅間 聖耶
開始日:
期日:
進捗率:
0%
予定工数:
実開始日:
ＤＤ名:
INCLUDE:
DSN:
バグ区分:
QA分析:
方針（第一貨物）:
実終了日:
ツールのバージョン:
AsIsSource行:
進捗計画:
設計・開発者:
画面ID:
機能区分:
機能ID:
レビュー指摘区分:
検査完了日:
検査依頼日:
説明
Javaのスタックトレース
BaseJcl:main
SCRATCH:main
SA30060:main
java : org.springframework.data.relational.core.conversion.DbActionExecutionException: Failed to execute InsertRoot{ent
ity=REABAT06_2000TD(ID=null, R6FBTYMD=20261017, R6FBRCID=24, R6FBIYMD=20261017, R6FBIHMS=081656, R6FBJSMC=1, R6FBJSNO=3
0925144180, R6FBTSMC=1, R6FBTSNO=0000000000000, R6FBNNDA=00000, R6FBNNNI= , R6FBNNYB=0, R6FBUKTC=0301, R6FBUKDT=2
0261016, R6FBITTC= , R6FBITDT= , R6FBNICD=1931676, R6FBDTKB=40, R6FBHTCD=00401, R6FBHTNM= , R6FBHT
EL= , R6FBHYMD=20261017, R6FBHSBN=0009706, R6FBHJKB=00, R6FBHTHM=0816, R6FBHJTK=2, R6FBHRNM=
, R6FBIJNY= ), idValueSource=GENERATED}
発生場所 行:1 文字:1
+ java -jar D:\REABAT06\batch-0.0.1-SNAPSHOT.jar --spring.batch.job.nam ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (org.springframe...urce=GENERATED}:String) [], RemoteException
+ FullyQualifiedErrorId : NativeCommandError
at org.springframework.data.jdbc.core.AggregateChangeExecutor.execute(AggregateChangeExecutor.java:118)
～ 中略 ～
at com.d3os.d3os_common.service.REABAT06_2000TDServiceImpl$$SpringCGLIB$$0.insert(<generated>)
at com.d3os.d3os_batch.batch.REABAT06.SA30060.insertREABAT06_2000TD_Uke(SA30060.java:1074)
at com.d3os.d3os_batch.batch.REABAT06.SA30060.tyukeigoRireki(SA30060.java:428)
at com.d3os.d3os_batch.batch.REABAT06.SA30060.mainProcess(SA30060.java:239)
at com.d3os.d3os_batch_common.batch.BaseBatch.main(BaseBatch.java:168)
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.loader.launch.JarLauncher.main(JarLauncher.java:40)
Caused by: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException fo
r SQL [INSERT INTO "REABAT06_2000TD" ("R6FBDTKB", "R6FBHJKB", "R6FBHJTK", "R6FBHRNM", "R6FBHSBN", "R6FBHTCD", "R6FBHTEL
", "R6FBHTHM", "R6FBHTNM", "R6FBHYMD", "R6FBIHMS", "R6FBIJNY", "R6FBITDT", "R6FBITTC", "R6FBIYMD", "R6FBJSMC", "R6FBJSN
O", "R6FBNICD", "R6FBNNDA", "R6FBNNNI", "R6FBNNYB", "R6FBRCID", "R6FBTSMC", "R6FBTSNO", "R6FBTYMD", "R6FBUKDT", "R6FBUK
TC", "SYSCRDTS", "SYSCRJCD", "SYSCRPID", "SYSCRTID", "SYSCRVER", "SYSUPDTS", "SYSUPJCD", "SYSUPPID", "SYSUPTID", "SYSUP
VER", "VERSION") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
, ?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [12899]; ORA-12899: 列"TEST_3DOS"."REABAT06_2000TD"."R6FBHRNM"の値が大きす
ぎます(実際: 20、最大: 10)
at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1549)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:677)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:1001)
at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:365)
at org.springframework.data.jdbc.core.convert.IdGeneratingInsertStrategy.execute(IdGeneratingInsertStrategy.java:65)
at org.springframework.data.jdbc.core.convert.DefaultDataAccessStrategy.insert(DefaultDataAccessStrategy.java:110)
at org.springframework.data.jdbc.core.JdbcAggregateChangeExecutionContext.executeInsertRoot(JdbcAggregateChangeExecuti
onContext.java:83)
at org.springframework.data.jdbc.core.AggregateChangeExecutor.execute(AggregateChangeExecutor.java:85)
... 157 more
Caused by: java.sql.SQLException: ORA-12899: 列"TEST_3DOS"."REABAT06_2000TD"."R6FBHRNM"の値が大きすぎます(実際: 20、最大: 10)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:629)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:563)
～ 中略 ～
2026/10/23 18:04:17 INFO [SpringApplicationShutdownHook] - HikariPool-2 - Shutdown initiated...
2026/10/23 18:04:17 INFO [SpringApplicationShutdownHook] - HikariPool-2 - Shutdown completed.
2026/10/23 18:04:17 INFO [SpringApplicationShutdownHook] - HikariPool-1 - Shutdown initiated...
2026/10/23 18:04:17 INFO [SpringApplicationShutdownHook] - HikariPool-1 - Shutdown completed.
原因¶
オンライン → SSS165 → リアル01 → バッチ間16B → リアル06 → VKDXCYH
の処理の流れで、桁数が不一致な項目があったため。 #12090
操作