不浪漫_罪名 2020-06-05 17:29 采纳率: 0%
浏览 1164

执行insert操作的时候报错 Exception info is org.springframework.dao.DataIntegrityViolationException: Cause: java.sql.SQLException: 没有找到合适的分区;这是什么原因

com.cesgroup.framework.exception.BusinessLayerException: Exception info is org.springframework.dao.DataIntegrityViolationException:

Error updating database. Cause: java.sql.SQLException: 没有找到合适的分区

The error may involve com.cesgroup.prison.zfxx.zfstat.dao.ZfStatZyDao.insert-Inline

The error occurred while setting parameters

SQL: INSERT INTO ZFINFO.T_ZF_STAT ( ID,JY_ID,JQ_ID,COUNT,ITEMS_ID,ITEMS_NAME,ITEMS_VALUE,ITEMS_PERCENT,TYPE,D_URL_TIME ) VALUES( ?,?,?,?,?,?,?,?,?,? )

Cause: java.sql.SQLException: 没有找到合适的分区

; SQL []; 没有找到合适的分区; nested exception is java.sql.SQLException: 没有找到合适的分区
2020-06-05 17:20:14.897 [Timer-3] ERROR c.c.framework.exception.BusinessLayerException - 10.同步【监狱关押能力】统计发生异常, Exception info is org.springframework.dao.DataIntegrityViolationException:
at com.cesgroup.prison.zfxx.zfstat.service.impl.ZfStatZyServiceImpl.synchroZfStatZyJyGynl(ZfStatZyServiceImpl.java:320)

Error updating database. Cause: java.sql.SQLException: 没有找到合适的分区

at com.cesgroup.prison.zfxx.zfstat.service.impl.ZfStatZyServiceImpl$$FastClassBySpringCGLIB$$95ffedbd.invoke(<generated>)

The error may involve com.cesgroup.prison.zfxx.zfstat.dao.ZfStatZyDao.insert-Inline

at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)

The error occurred while setting parameters

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:718)

SQL: INSERT INTO ZFINFO.T_ZF_STAT ( ID,JY_ID,JQ_ID,COUNT,ITEMS_ID,ITEMS_NAME,ITEMS_VALUE,ITEMS_PERCENT,TYPE,D_URL_TIME ) VALUES( ?,?,?,?,?,?,?,?,?,? )

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)

Cause: java.sql.SQLException: 没有找到合适的分区

at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)

; SQL []; 没有找到合适的分区; nested exception is java.sql.SQLException: 没有找到合适的分区
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)
at com.cesgroup.prison.zfxx.zfstat.service.impl.ZfStatZyServiceImpl$$EnhancerBySpringCGLIB$$3f0f19d8.synchroZfStatZyJyGynl()
at com.cesgroup.prison.jobs.service.impl.BjJobServiceImpl.getHY(BjJobServiceImpl.java:273)
at com.cesgroup.prison.jobs.service.impl.BjJobServiceImpl$$FastClassBySpringCGLIB$$768cad.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:718)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)
at com.cesgroup.prison.jobs.service.impl.BjJobServiceImpl$$EnhancerBySpringCGLIB$$ea5a4ac8.getHY()
at com.cesgroup.prison.listener.hyZfStat.SyncHyZfStatListener$1.run(SyncHyZfStatListener.java:60)
at java.util.TimerThread.mainLoop(Timer.java:555)
at java.util.TimerThread.run(Timer.java:505)

  • 写回答

1条回答 默认 最新

  • Json-Huang 2020-06-05 21:50
    关注

    debug或者打印日志看看传入的参数是否有异常数据

    评论

报告相同问题?

悬赏问题

  • ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
  • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
  • ¥30 截图中的mathematics程序转换成matlab
  • ¥15 动力学代码报错,维度不匹配
  • ¥15 Power query添加列问题
  • ¥50 Kubernetes&Fission&Eleasticsearch
  • ¥15 報錯:Person is not mapped,如何解決?
  • ¥15 c++头文件不能识别CDialog
  • ¥15 Excel发现不可读取的内容
  • ¥15 关于#stm32#的问题:CANOpen的PDO同步传输问题