操作
バグ #12147
未完了検証環境にて例外が発生
ステータス:
新規
優先度:
通常
担当者:
菅間 聖耶
開始日:
期日:
進捗率:
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 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.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.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.Launcher.launch(Launcher.java:102)
at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:64)
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)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1230)
～ 以下省略 ～
操作