操作
バグ #12006
完了検証環境にて例外が発生
ステータス:
終了
優先度:
通常
担当者:
菅間 聖耶
開始日:
期日:
進捗率:
0%
予定工数:
実開始日:
DD名:
INCLUDE:
DSN:
バグ区分:
データ等の不備(修正不要)
QA分析:
方針(第一貨物):
実終了日:
ツールのバージョン:
AsIsSource行:
進捗計画:
設計・開発者:
画面ID:
機能区分:
機能ID:
レビュー指摘区分:
検査完了日:
検査依頼日:
説明
Javaのスタックトレース
TX30010:main
java : org.springframework.data.relational.core.conversion.DbActionExecutionException: Failed to execute InsertRoot{ent
ity=TXPOSRP1_0070TD(ID=null, KCENOKRN=12946360 90, KCENEDBN=004, KCENDTID=GA, KCENTNCD=0609, KCENHYNO=12946360
, KCENJGCD= , KCENSYNO= , KCENDYMD=20261014, KCENTIME=002341, KCENIJKB=0, KCENHDNO=500045849 ,
KCENYTHM=0000, KCENJYKB= ), idValueSource=GENERATED}
発生場所 行:1 文字:1
+ java -jar D:\TXPOSRP1\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.data.relational.core.conversion.SaveBatchingAggregateChange.forEachAction(SaveBatchingAggregate
~ 中略 ~
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:720)
at com.d3os.d3os_common.service.TXPOSRP1_0070TDServiceImpl$$SpringCGLIB$$0.insert(<generated>)
at com.d3os.d3os_batch.batch.TXPOSRP1.TX30010.insertTXPOSRP1_0070TD(TX30010.java:521)
at com.d3os.d3os_batch.batch.TXPOSRP1.TX30010.mainProcess(TX30010.java:246)
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.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:355)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
~ 中略 ~
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 "TXPOSRP1_0070TD" ("KCENDTID", "KCENDYMD", "KCENEDBN", "KCENHDNO", "KCENHYNO", "KCENIJKB", "KCENJGCD
", "KCENJYKB", "KCENOKRN", "KCENSYNO", "KCENTIME", "KCENTNCD", "KCENYTHM", "SYSCRDTS", "SYSCRJCD", "SYSCRPID", "SYSCRTI
D", "SYSCRVER", "SYSUPDTS", "SYSUPJCD", "SYSUPPID", "SYSUPTID", "SYSUPVER", "VERSION") VALUES (?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [12899]; ORA-12899: 列"TEST_3DOS"."TXPOS
RP1_0070TD"."KCENOKRN"の値が大きすぎます(実際: 18、最大: 11)
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)
2026/10/20 16:34:12 INFO [main] - Job: [SimpleJob: [name=TXPOSRP1Job]] completed with the following parameters: [{'jobParm02':'{value=ABCXXX, type=class java.lang.String, identifying=true}','jobParm01':'{value=1234XXX, type=class java.lang.String, identifying=true}','run.id':'{value=1, type=class java.lang.Long, identifying=true}','jobFuncrionId':'{value=TXPOSRP1, type=class java.lang.String, identifying=true}'}] and the following status: [COMPLETED] in 6s821ms
at org.springframework.data.jdbc.core.JdbcAggregateChangeExecutionContext.executeInsertRoot(JdbcAggregateChangeExecuti
onContext.java:83)
at org.springframework.data.jdbc.core.AggregateChangeExecutor.execute(AggregateChangeExecutor.java:85)
... 156 more
Caused by: java.sql.SQLException: ORA-12899: 列"TEST_3DOS"."TXPOSRP1_0070TD"."KCENOKRN"の値が大きすぎます(実際: 18、最大: 11)
~ 以下省略 ~
ファイル
操作

