保存提示错误

查查

请教一下：
1>bizdata:有ONAFTERNEW事件
2>TABLE中加了约束，QTY>=QTY_F
3>当我保存后，再改数量再保存，就出错了。
4>后台错误如下：
aused by: com.justep.exception.BusinessException: 编码: JUSTEP150186; 提示: 更新记录WOD, WOD, key="0B4554E2D95E4F7B9E7D816B1230A3E3"出错, 不存在符合条件的数据, UPDATE
为什么提示这个，其它程序没有这个问题。多谢

jishuang

每次新增数据保存修改都没稳定重现？
确认数据库中存在主键为0B4554E2D95E4F7B9E7D816B1230A3E3的数据吗

查查

0B4554E2D95E4F7B9E7D816B1230A3E3 有的

jishuang

发tomcat控制台完整的错误信息

查查

2018-01-31 15:50:18 system runtime:2018-01-31 09:50
2018-01-31 15:50:18 excute stream action, params:{"actions":[{"accept":"application/json","action":"saveWODAction","actionFlag":"__action_0__","activity":"mainActivity","contentType":"json","executeContext":"","executor":"","parameters":{"table":{"@type":"table","rows":[{"AF":{"changed":0,"originalValue":"保存成功","value":"保存成功"},"APPR_DATE":{"changed":0},"APPR_FLAG":{"changed":0},"APPR_USER":{"changed":0},"BC":{"changed":0},"BF":{"changed":0},"FH_DATE":{"changed":0,"originalValue":"2018-02-05T11:58:39.320Z","value":"2018-02-05T11:58:39.320Z"},"FILE_NO":{"changed":0,"originalValue":"3211-1801310002","value":"3211-1801310002"},"FRM_BOL_CODE":{"changed":0,"originalValue":"W301","value":"W301"},"FRM_BOL_DESC":{"changed":0,"originalValue":"半成品仓","value":"半成品仓"},"FRM_BOL_TYPE":{"changed":0,"originalValue":"白架","value":"白架"},"FRM_VDR_CODE":{"changed":0},"FRM_VDR_DESC":{"changed":0},"HID":{"changed":0,"originalValue":"64E9E0640CCB4A569832A3B32FBB89E3","value":"64E9E0640CCB4A569832A3B32FBB89E3"},"JOBFID":{"changed":0,"originalValue":"E01B6913-6635-44FB-8433-3F46285F9461","value":"E01B6913-6635-44FB-8433-3F46285F9461"},"JOB_NO":{"changed":0,"originalValue":"P0000001-02-99","value":"P0000001-02-99"},"LATEDATE":{"changed":0,"originalValue":0,"value":0},"LEAD_TIME1":{"changed":0,"originalValue":"10","value":"10"},"ORD_DESCC":{"changed":0,"originalValue":"外发","value":"外发"},"ORD_ID":{"changed":0,"originalValue":"W03211","value":"W03211"},"OVTYPE":{"changed":0,"originalValue":"正常","value":"正常"},"PT_NO":{"changed":0,"originalValue":"V0002-18013102","value":"V0002-18013102"},"QTY":{"changed":1,"originalValue":"10","value":"20"},"QTYTYPE":{"changed":0,"originalValue":"良品","value":"良品"},"QTY_BAL":{"changed":0,"originalValue":20,"value":20},"QTY_F":{"changed":0},"REMARK":{"changed":0},"R_BOL_CODE":{"changed":0},"R_BOL_DESC":{"changed":0},"R_DESC":{"changed":0},"SEQ_NO":{"changed":0},"SOHID":{"changed":0},"SYSDATE":{"changed":0,"originalValue":"2018-01-31T11:58:37.447Z","value":"2018-01-31T11:58:37.447Z"},"SYSUSER":{"changed":0,"originalValue":"六生","value":"六生"},"TO_BOL_CODE":{"changed":0,"originalValue":"DD","value":"DD"},"TO_BOL_DESC":{"changed":0,"originalValue":"电镀","value":"电镀"},"TO_BOL_TYPE":{"changed":0,"originalValue":"色架","value":"色架"},"TO_VDR_CODE":{"changed":0,"originalValue":"V0002","value":"V0002"},"TO_VDR_DESC":{"changed":0,"originalValue":"瑞兴电镀厂","value":"瑞兴电镀厂"},"TRAN_DATE":{"changed":0,"originalValue":"2018-01-31T11:58:46.623Z","value":"2018-01-31T11:58:46.623Z"},"UNIT_DESC":{"changed":0},"UNIT_PRICE":{"changed":0},"UNIT_PRICE_OV":{"changed":0,"originalValue":"5.00","value":"5.00"},"W":{"changed":0},"WIP_FH_DATE":{"changed":0},"WK_DESC":{"changed":0,"originalValue":"金色","value":"金色"},"W_F":{"changed":0},"userdata":{"id":{"changed":0,"originalValue":"0B4554E2D95E4F7B9E7D816B1230A3E3","value":"0B4554E2D95E4F7B9E7D816B1230A3E3"},"isModified":true,"recordState":"edit"},"version":{"changed":0,"originalValue":0,"value":0}}],"userdata":{"idColumnDefine":"WOD","idColumnName":"WOD","idColumnType":"String","model":"/E2018/WIP/data","relationAlias":"AF,APPR_DATE,APPR_FLAG,APPR_USER,BC,BF,FH_DATE,FILE_NO,FRM_BOL_CODE,FRM_BOL_DESC,FRM_BOL_TYPE,FRM_VDR_CODE,FRM_VDR_DESC,HID,JOBFID,JOB_NO,LATEDATE,LEAD_TIME1,ORD_DESCC,ORD_ID,OVTYPE,PT_NO,QTY,QTYTYPE,QTY_BAL,QTY_F,REMARK,R_BOL_CODE,R_BOL_DESC,R_DESC,SEQ_NO,SOHID,SYSDATE,SYSUSER,TO_BOL_CODE,TO_BOL_DESC,TO_BOL_TYPE,TO_VDR_CODE,TO_VDR_DESC,TRAN_DATE,UNIT_DESC,UNIT_PRICE,UNIT_PRICE_OV,W,WIP_FH_DATE,WK_DESC,W_F,version","relationTypes":"String,DateTime,String,String,String,String,DateTime,String,String,String,String,String,String,String,String,String,String,Decimal,String,String,String,String,Integer,String,String,Integer,String,String,String,String,Integer,String,DateTime,String,String,String,String,String,String,DateTime,String,Decimal,Decimal,Decimal,DateTime,String,Decimal,Integer","relations":"WOD.AF,WOD.APPR_DATE,WOD.APPR_FLAG,WOD.APPR_USER,WOD.BC,WOD.BF,WOD.FH_DATE,WOD.FILE_NO,WOD.FRM_BOL_CODE,WOD.FRM_BOL_DESC,WOD.FRM_BOL_TYPE,WOD.FRM_VDR_CODE,WOD.FRM_VDR_DESC,WOD.HID,WOD.JOBFID,WOD.JOB_NO,EXPRESS,JOBBOL.LEAD_TIME1,ORDID.ORD_DESCC,WOD.ORD_ID,WOD.OVTYPE,WOD.PT_NO,WOD.QTY,WOD.QTYTYPE,EXPRESS,WOD.QTY_F,WOD.REMARK,WOD.R_BOL_CODE,WOD.R_BOL_DESC,WOD.R_DESC,WOD.SEQ_NO,WOD.SOHID,WOD.SYSDATE,WOD.SYSUSER,WOD.TO_BOL_CODE,WOD.TO_BOL_DESC,WOD.TO_BOL_TYPE,WOD.TO_VDR_CODE,WOD.TO_VDR_DESC,WOD.TRAN_DATE,WOD.UNIT_DESC,WOD.UNIT_PRICE,WOD.UNIT_PRICE_OV,WOD.W,WOD.WIP_FH_DATE,WOD.WK_DESC,WOD.W_F,WOD.version","sys.count":4,"sys.rowid":"WOD","updateMode":"whereAll"}}},"process":"/E2018/WIP/process/WOD/wODProcess"},{"accept":"application/json","action":"wodzpsaveAction","actionFlag":"__action_1__","activity":"mainActivity","contentType":"application/json","parameters":{"CLIENT_ID":"47BB1E02CF694A0885A7F3D0912160E0","FID":"0B4554E2D95E4F7B9E7D816B1230A3E3"},"process":"/E2018/WIP/process/WOD/wODProcess"}]}
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150186; 提示: 更新记录WOD, WOD, key="0B4554E2D95E4F7B9E7D816B1230A3E3"出错, 不存在符合条件的数据, UPDATE WOD WOD SET WOD.QTY = :QTY_new  WHERE WOD= :WOD_old AND WOD.AF = :AF_old AND WOD.APPR_DATE is null  AND WOD.APPR_FLAG is null  AND WOD.APPR_USER is null  AND WOD.BC is null  AND WOD.BF is null  AND WOD.FH_DATE = :FH_DATE_old AND WOD.FILE_NO = :FILE_NO_old AND WOD.FRM_BOL_CODE = :FRM_BOL_CODE_old AND WOD.FRM_BOL_DESC = :FRM_BOL_DESC_old AND WOD.FRM_BOL_TYPE = :FRM_BOL_TYPE_old AND WOD.FRM_VDR_CODE is null  AND WOD.FRM_VDR_DESC is null  AND WOD.HID = :HID_old AND WOD.JOBFID = :JOBFID_old AND WOD.JOB_NO = :JOB_NO_old AND WOD.ORD_ID = :ORD_ID_old AND WOD.OVTYPE = :OVTYPE_old AND WOD.PT_NO = :PT_NO_old AND WOD.QTY = :QTY_old AND WOD.QTYTYPE = :QTYTYPE_old AND WOD.QTY_F is null  AND WOD.REMARK is null  AND WOD.R_BOL_CODE is null  AND WOD.R_BOL_DESC is null  AND WOD.R_DESC is null  AND WOD.SEQ_NO is null  AND WOD.SOHID is null  AND WOD.SYSDATE = :SYSDATE_old AND WOD.SYSUSER = :SYSUSER_old AND WOD.TO_BOL_CODE = :TO_BOL_CODE_old AND WOD.TO_BOL_DESC = :TO_BOL_DESC_old AND WOD.TO_BOL_TYPE = :TO_BOL_TYPE_old AND WOD.TO_VDR_CODE = :TO_VDR_CODE_old AND WOD.TO_VDR_DESC = :TO_VDR_DESC_old AND WOD.TRAN_DATE = :TRAN_DATE_old AND WOD.UNIT_DESC is null  AND WOD.UNIT_PRICE is null  AND WOD.UNIT_PRICE_OV = :UNIT_PRICE_OV_old AND WOD.W is null  AND WOD.WIP_FH_DATE is null  AND WOD.WK_DESC = :WK_DESC_old AND WOD.W_F is null  AND WOD.version = :version_old; 可能的原因: 数据被其他用户修改了; 数据被其他用户删除了
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableImpl.edit(Unknown Source)
        at com.justep.system.data.impl.TableImpl.save(Unknown Source)
        at com.justep.system.data.impl.TableImpl.save(Unknown Source)
        at com.justep.system.data.BizData.save(Unknown Source)
        at BizProcedure.save(BizProcedure.java:18)
        ... 27 more

jishuang

看数据库中这条记录的version的值是什么

查查

用的是whereAll，VERSION 是的0

jishuang

先把日期相关的字段去掉不修改看看