批量调整错误日志
9.88 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
{"status":1,"msg":"success","data":{"内部错误":"org.springframework.dao.DataIntegrityViolationException: \n### Error updating database.
Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into (\"GRADATA\".\"GRAS_ASSIGN_BATCH_RECORD\".\"BRANCH_CODE\")\n\n###
The error may involve com.funde.gras.oracle.mapper.GrasAssignBatchRecordMapper.insert-Inline\n### The error occurred while setting parameters\n###
SQL: insert into GRAS_ASSIGN_BATCH_RECORD (BRANCH_CODE, DUE_MONTH, BATCH_CODE, BATCH_SEQ, FINISH_FLAG, PK_SERIAL, CREATED_USER, CREATED_DATE, UPDATED_USER,
UPDATED_DATE) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL
into (\"GRADATA\".\"GRAS_ASSIGN_BATCH_RECORD\".\"BRANCH_CODE\")\n\n; SQL []; ORA-01400: cannot insert NULL into (\"GRADATA\".\"GRAS_ASSIGN_BATCH_RECORD\".\"BRANCH_CODE\")\n;
nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into (\"GRADATA\".\"GRAS_ASSIGN_BATCH_RECORD\".\"BRANCH_CODE\")\n\norg.sp
ringframework.dao.DataIntegrityViolationException: \n### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException:
ORA-01400: cannot insert NULL into (\"GRADATA\".\"GRAS_ASSIGN_BATCH_RECORD\".\"BRANCH_CODE\")\n\n### The error may involve com.funde.gras.oracle.mapper.GrasAssignBatchRecordMapper.
insert-Inline\n### The error occurred while setting parameters\n### SQL: insert into GRAS_ASSIGN_BATCH_RECORD (BRANCH_CODE, DUE_MONTH, BATCH_CODE, BATCH_SEQ,
FINISH_FLAG, PK_SERIAL, CREATED_USER, CREATED_DATE, UPDATED_USER, UPDATED_DATE) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n###
Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into (\"GRADATA\".\"GRAS_ASSIGN_BATCH_RECORD\".\"BRANCH_CODE\")\n\n; SQL [];
ORA-01400: cannot insert NULL into (\"GRADATA\".\"GRAS_ASSIGN_BATCH_RECORD\".\"BRANCH_CODE\")\n; nested exception is java.sql.SQLIntegrityConstraintViolationException:
ORA-01400: cannot insert NULL into (\"GRADATA\".\"GRAS_ASSIGN_BATCH_RECORD\".\"BRANCH_CODE\")\n\n\tat org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.
doTranslate(SQLErrorCodeSQLExceptionTranslator.java:243)\n\tat org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate
(AbstractFallbackSQLExceptionTranslator.java:73)\n\tat org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
\n\tat org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)\n\tat com.sun.proxy.$Proxy64.insert(Unknown Source)\n\tat
org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)\n\tat org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:57)\n\tat
org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)\n\tat com.sun.proxy.$Proxy83.insert(Unknown Source)\n\tat
com.funde.gras.oracle.service.impl.OracleGrasAssignBatchRecordServiceImpl.insertBatchRecord(OracleGrasAssignBatchRecordServiceImpl.java:60)\n\tat
com.funde.gras.oracle.service.impl.OracleGrasAssignBatchRecordServiceImpl$$FastClassBySpringCGLIB$$386d990f.invoke(<generated>)\n\tat org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
\n\tat org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.
proceed(ReflectiveMethodInvocation.java:157)\n\tat org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
\n\tat org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)\n\tat
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation
.proceed(ReflectiveMethodInvocation.java:179)\n\tat org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)\n\tat
com.funde.gras.oracle.service.impl.OracleGrasAssignBatchRecordServiceImpl$$EnhancerBySpringCGLIB$$7c087d65.insertBatchRecord(<generated>)\n\tat com.alibaba.dubbo.common.bytecode.
Wrapper14.invokeMethod(Wrapper14.java)\n\tat com.alibaba.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:46)\n\tat
com.alibaba.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:72)\n\tat com.alibaba.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:53
)\n\tat com.alibaba.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:64)\n\tat com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.
java:91)\n\tat com.alibaba.dubbo.monitor.support.MonitorFilter.invoke(MonitorFilter.java:75)\n\tat com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(
ProtocolFilterWrapper.java:91)\n\tat com.alibaba.dubbo.rpc.filter.TimeoutFilter.invoke(TimeoutFilter.java:42)\n\tat com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.
invoke(ProtocolFilterWrapper.java:91)\n\tat com.alibaba.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:78)\n\tat com.alibaba.dubbo.rpc.protocol.
ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)\n\tat com.alibaba.dubbo.rpc.filter.ContextFilter.invoke(ContextFilter.java:60)\n\tat com.alibaba.dubbo.rpc.
protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)\n\tat com.alibaba.dubbo.rpc.filter.GenericFilter.invoke(GenericFilter.java:112)\n\tat
com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)\n\tat com.alibaba.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter
.java:38)\n\tat com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)\n\tat com.alibaba.dubbo.rpc.filter.EchoFilter.invoke
(EchoFilter.java:38)\n\tat com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)\n\tat com.alibaba.dubbo.rpc.protocol.dubbo
.DubboProtocol$1.reply(DubboProtocol.java:108)\n\tat com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:84)
\n\tat com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:170)\n\tat com.alibaba.dubbo.remoting.transport.DecodeHan
dler.received(DecodeHandler.java:52)\n\tat com.alibaba.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:82)\n\tat java.util.concurrent.
ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)\n\tat java.lang.Thread.run(Th
read.java:748)\nCaused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into (\"GRADATA\".\"GRAS_ASSIGN_BATCH_RECORD\".\"BRANCH_CODE\")\n\
n\tat oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)\n\tat oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)\n\tat oracle.jdbc.driver.T4C8Oall.pro
cessError(T4C8Oall.java:1017)\n\tat oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)\n\tat oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)\n\tat oracle.jdbc.
driver.T4C8Oall.doOALL(T4C8Oall.java:566)\n\tat oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)\n\tat oracle.jdbc.driver.T4CPreparedStatement.
doOall8(T4CPreparedStatement.java:58)\n\tat oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)\n\tat oracle.jdbc.driver.OracleStatement.
doExecuteWithTimeout(OracleStatement.java:1075)\n\tat oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)\n\tat oracle.jdbc.driver.
OraclePreparedStatement.execute(OraclePreparedStatement.java:3923)\n\tat oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385)
\n\tat com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931)\n\tat com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute
(FilterEventAdapter.java:440)\n\tat com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929)\n\tat com.alibaba.druid.proxy.jdbc.Prepared
StatementProxyImpl.execute(PreparedStatementProxyImpl.java:131)\n\tat com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)\n
\tat sun.reflect.GeneratedMethodAccessor243.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat
java.lang.reflect.Method.invoke(Method.java:498)\n\tat org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)\n\tat com.sun.proxy.
$Proxy122.execute(Unknown Source)\n\tat org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46)\n\tat org.apache.ibatis.
executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)\n\tat org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)\n\tat
org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)\n\tat org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)\n\tat org.apache.ib
atis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)\n\tat org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)\n
\tat sun.reflect.GeneratedMethodAccessor305.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.
lang.reflect.Method.invoke(Method.java:498)\n\tat org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)\n\t... 44 more\n"}}