第一貨物 [Mirror]

発生箇所

スタックトレース

java : org.springframework.data.relational.core.conversion.DbActionExecutionException: Failed to execute InsertRoot{entity=REABAT05_1100TD(ID=null, UPSERTKB=I, DIDBOKNO=60592116955, DIDBIGKB=1, DIDBKKKB=0, DIDBSRKB=0, DIDBDAKB=0, DIDBMNKB=0, DIDBMSKB=0, DIDBIRDT=20260513, DIDBUKTC=0301, DIDBUYMD=202604221600, DIDUKEKB=31, DIDBDISH=15635745, DIDBUSHN=15635745, DIDBSHBN=15118, DIDBAAAA=962559, DIDBBBBB=      , DIDBBRTN=0301, DIDBSHCD=300, DIDBHCCD=03524, DIDBHNCD=2077031, DIDBHNNM=ﾄﾀﾞｷｭｳ        , DIDBHNZN=トダキュウ                                   , DIDBHGYC=1200, DIDBCHCD=22139, DIDBCNTL=0535867050 , DIDBCNNM=ﾆｯﾎﾟﾝｱｸｾｽﾊﾏﾏﾂﾌ, DIDBCNZN=ニッポンアクセスハママツフ                           , DIDBHSTC=0301, DIDBHSYM=20260422, DIDBHSCN=59729390, DIDBSYAB=     , DIDBAJYU=      , DIDBBJYU=      , DIDBBRNG=    , DIDBHTKB=1, DIDBHTTN=1301, DIDBHTDT=20260423, DIDBCUTC=1301, DIDBCUYM=20260423, DIDBCUSF=59736040, DIDBSYAN=     , DIDBJOBA=      , DIDBJOBB=      , DIDBSHOZ=    , DIDBCTKB=1, DIDBCTTN=2204, DIDBCTDT=20260424, DIDBHITC=2204, DIDBHIYM=202604240900, DIDBHIKB=31, DIDBHISH=10735745, DIDBHDID=10735745, DIDBSSBN=17332, DIDBWREA=980672, DIDBWREB=      , DIDBSYOZ=2204, DIDBYSYA=       , DIDBSATK=00, DIDBSTCD=2204, DIDBTONO=16673671        , DIDBTSUU=90, DIDBJURY=370, DIDBUTIN=11300, DIDBROKI=390, DIDBDITE=0, DIDBDIKE=0, DIDBHHKB=1, DIDBHKIN=0, DIDBHRYO=0, DIDBSYUK=0, DIDBTOSI=834, DIDBTITK=0, DIDBITAX=1169, DIDBCLMK=0, DIDBCLDT=        , DIDBIJPR=1, DIDITOYM=20260513, DIDITOTC=0601, DIDITOKB=4, DIDIAKYM=20260423, DIDIAKBA=11, DIDIGNAI=01, DIDIINCD=010, DIDIANCD=211749, DIDIKOSU=80, DIDIH3HT=    , DIDIH3CT=    , DIDIH4HT=    , DIDIH4CT=    , DIDIH5HT=    , DIDIH5CT=    , DIDIHKKB=5, DIDIESTC=    , DIDIESYM=        , DIDIESCD=00, DIDIENGK=柳川てすと260514, DIDIHHKB=1, DIDINCKB=1, DIDINCDT=20260423, DIDIWACD=1, DIDIWATC=0601, DIDISTAT=1, DIDHTRNO=0, DIDHTRDT=        , DIDHYRTC=    , DIDHYRYM=        , DIDHSSKB=1, DIDHBASY=  , DIDHINCD=   , DIDHYRKB=0, DIDHAIKN=0, DIDHSTNC=    , DIDHSSDT=        , DIDHSYKB=0, DIDHSHYC=    , DIDHSNDT=        , DIDHSNOO=     , DIDHSKIN=0, DIDHSBHD=0, DIDHSBC1=00, DIDHSBC2=00, DIDHSBC3=00, DIDHEKT1=    , DIDHEKP1=100, DIDHEKT2=    , DIDHEKP2=0, DIDHEKT3=    , DIDHEKP3=0, DIDHEKT4=    , DIDHEKP4=0, DIDHEKT5=    , DIDHEKP5=0, DIDHAGC1=110381, DIDHAGT1=0301, DIDHAGC2=      , DIDHAGT2=    , DIDHAGC3=      , DIDHAGT3=    , DIDHAGC4=      , DIDHAGT4=    , DIDHAGC5=      , DIDHAGT5=    , DIDHRSPT=       ), idValueSource=GENERATED}
発生場所 行:1 文字:1
+ java -jar D:\REABAT05\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 com.d3os.d3os_common.service.REABAT05_1100TDServiceImpl$$SpringCGLIB$$0.insert(<generated>)
	at com.d3os.d3os_batch.batch.REABAT05.BP30011.insertREABAT05_1100TD(BP30011.java:5520)
	at com.d3os.d3os_batch.batch.REABAT05.BP30011.mainProcess(BP30011.java:637)
	at com.d3os.d3os_batch_common.batch.BaseBatch.main(BaseBatch.java:158)

～中略～
	
	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 "REABAT05_1100TD" ("DIDBAAAA", "DIDBAJYU", "DIDBBBBB", "DIDBBJYU", "DIDBBRNG", "DIDBBRTN", "DIDBCHCD
", "DIDBCLDT", "DIDBCLMK", "DIDBCNNM", "DIDBCNTL", "DIDBCNZN", "DIDBCTDT", "DIDBCTKB", "DIDBCTTN", "DIDBCUSF", "DIDBCUT
C", "DIDBCUYM", "DIDBDAKB", "DIDBDIKE", "DIDBDISH", "DIDBDITE", "DIDBHCCD", "DIDBHDID", "DIDBHGYC", "DIDBHHKB", "DIDBHI
KB", "DIDBHISH", "DIDBHITC", "DIDBHIYM", "DIDBHKIN", "DIDBHNCD", "DIDBHNNM", "DIDBHNZN", "DIDBHRYO", "DIDBHSCN", "DIDBH
STC", "DIDBHSYM", "DIDBHTDT", "DIDBHTKB", "DIDBHTTN", "DIDBIGKB", "DIDBIJPR", "DIDBIRDT", "DIDBITAX", "DIDBJOBA", "DIDB
JOBB", "DIDBJURY", "DIDBKKKB", "DIDBMNKB", "DIDBMSKB", "DIDBOKNO", "DIDBROKI", "DIDBSATK", "DIDBSHBN", "DIDBSHCD", "DID
BSHOZ", "DIDBSRKB", "DIDBSSBN", "DIDBSTCD", "DIDBSYAB", "DIDBSYAN", "DIDBSYOZ", "DIDBSYUK", "DIDBTITK", "DIDBTONO", "DI
DBTOSI", "DIDBTSUU", "DIDBUKTC", "DIDBUSHN", "DIDBUTIN", "DIDBUYMD", "DIDBWREA", "DIDBWREB", "DIDBYSYA", "DIDHAGC1", "D
IDHAGC2", "DIDHAGC3", "DIDHAGC4", "DIDHAGC5", "DIDHAGT1", "DIDHAGT2", "DIDHAGT3", "DIDHAGT4", "DIDHAGT5", "DIDHAIKN", "
DIDHBASY", "DIDHEKP1", "DIDHEKP2", "DIDHEKP3", "DIDHEKP4", "DIDHEKP5", "DIDHEKT1", "DIDHEKT2", "DIDHEKT3", "DIDHEKT4", 
"DIDHEKT5", "DIDHINCD", "DIDHRSPT", "DIDHSBC1", "DIDHSBC2", "DIDHSBC3", "DIDHSBHD", "DIDHSHYC", "DIDHSKIN", "DIDHSNDT",
 "DIDHSNOO", "DIDHSSDT", "DIDHSSKB", "DIDHSTNC", "DIDHSYKB", "DIDHTRDT", "DIDHTRNO", "DIDHYRKB", "DIDHYRTC", "DIDHYRYM"
, "DIDIAKBA", "DIDIAKYM", "DIDIANCD", "DIDIENGK", "DIDIESCD", "DIDIESTC", "DIDIESYM", "DIDIGNAI", "DIDIH3CT", "DIDIH3HT
", "DIDIH4CT", "DIDIH4HT", "DIDIH5CT", "DIDIH5HT", "DIDIHHKB", "DIDIHKKB", "DIDIINCD", "DIDIKOSU", "DIDINCDT", "DIDINCK
B", "DIDISTAT", "DIDITOKB", "DIDITOTC", "DIDITOYM", "DIDIWACD", "DIDIWATC", "DIDUKEKB", "SYSCRDTS", "SYSCRJCD", "SYSCRP
ID", "SYSCRTID", "SYSCRVER", "SYSUPDTS", "SYSUPJCD", "SYSUPPID", "SYSUPTID", "SYSUPVER", "UPSERTKB", "VERSION") VALUES 
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
 ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL stat
e [72000]; error code [12899]; ORA-12899: 列"TEST_3DOS"."REABAT05_1100TD"."DIDBUYMD"の値が大きすぎます(実際: 12、最大: 8)

	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)
	... 107 more
Caused by: java.sql.SQLException: ORA-12899: 列"TEST_3DOS"."REABAT05_1100TD"."DIDBUYMD"の値が大きすぎます(実際: 12、最大: 8)

	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)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:298)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:511)

～以下省略～

原因¶

年月日時分の項目から年月日の値を抽出するセットが実装されていない箇所がいくつかある