数据被其他用户修改了; 数据被其他用户删除了

wei

我加了这段代码后，就报这个错误，        if(length>100){        justep.Util.hint("评价说明最多输入100字");
        var substr = explain.substr(0,100);
        viewScoreData.setValueByID("EVALUATION_EXPLAIN",substr,guid)
}
2019-04-11 16:37:31 excute stream action, params:{"actions":[{"accept":"application/json","action":"saveVIEW_TSP_HA_SCOREAction","actionFlag":"__action_0__","activity":"businessActivity2","contentType":"json","executeContext":"","executor":"","parameters":{"table":{"@type":"table","rows":[{"EVALUATE_CONTENT":{"changed":0,"originalValue":"油位异常","value":"油位异常"},"EVALUATION_EXPLAIN":{"changed":1,"value":"{\"result\":[{\"appkey\":\"TSP@CRP\",\"create\":\"2019-04-11 14:24:28.382\",\"excutionId\":\"1297761\",\"hpi\":{\"appkey\":\"TSP@CRP\",\"businessKey\":\"24319123ED2D4A7CA8CF6A28B0F98665\",\"deploymentId\":\"668253\",\"end\":false,\"id\":\"1297708\",\"processDefinitionId\":\"TSPcheckResultProcess:67:668302\",\"processDefinitionKey\":\"TSPcheckResultProcess\",\"processDefinitionName\":\"检查评价计划执行\",\"processDefinitionVersion\":67,\"start\":\"2019-04-11 10:19:34.498\",\"startActivityId\":\"startEvent1\",\"startUserId\":\"TSP01\",\"suspended\":false,\"user\":\"TSP01\",\"vals\":{\"result\":\"Y\",\"nrOfActiveInstances\":6,\"initiator\":\"TSP01\",\"userIDs\":\"TESTUSER10\",\"userIDsList\":[\"TSP04\",\"TSP03\",\"TESTUSER07\",\"TESTUSER08\",\"TESTUSER09\",\"TSP01\",\"TESTUSER10\"],\"comment\":\"请确认，谢谢。\",\"loopCounter\":6,\"title\":\"南京化学工业园热电有限公司0411检查评价流程图和问题审核\",\"nrOfInstances\":7,\"nrOfCompletedInstances\":1}},\"id\":\"1299681\",\"locVals\":{},\"name\":\"专业专责/部门主任审核\",\"priority\":50,\"processDefinitionId\":\"TSPcheckResultProcess:67:668302\",\"processInstanceId\":\"1297708\",\"start\":\"2019-04-11 14:24:28.382\",\"taskDefKe"},"EVALUATION_ITEM":{"changed":0,"originalValue":"油位指示Ⅳ","value":"油位指示Ⅳ"},"EVALUATION_REMARK":{"changed":0},"EVALUATION_TYPE":{"changed":0,"originalValue":"运行","value":"运行"},"HA_ID":{"changed":0,"originalValue":"443A7790EB744E2094A4B3F0A3153DD8","value":"443A7790EB744E2094A4B3F0A3153DD8"},"PARENT_ID":{"changed":0,"originalValue":"IMPPJXM-20190402-2","value":"IMPPJXM-20190402-2"},"PARENT_NAME":{"changed":0,"originalValue":"套管","value":"套管"},"SCORE":{"changed":0,"originalValue":"0","value":"0"},"SORT_NUM":{"changed":0,"originalValue":65,"value":65},"STANDARD_SCORE":{"changed":0,"originalValue":"10","value":"10"},"TIME":{"changed":0,"originalValue":"0","value":"0"},"UNIT_RESULT":{"changed":0},"WEIGHT_COEFF":{"changed":0,"originalValue":"3","value":"3"},"userdata":{"id":{"changed":0,"originalValue":"IMPPJXM-20190402-2-004","value":"IMPPJXM-20190402-2-004"},"isModified":true,"recordState":"edit"}}],"userdata":{"idColumnDefine":"VIEW_TSP_HA_SCORE","idColumnName":"VIEW_TSP_HA_SCORE","idColumnType":"String","model":"/TSP/EquipmentHealthEvaluate/data","relationAlias":"EVALUATE_CONTENT,EVALUATION_EXPLAIN,EVALUATION_ITEM,EVALUATION_REMARK,EVALUATION_TYPE,HA_ID,PARENT_ID,PARENT_NAME,SCORE,SORT_NUM,STANDARD_SCORE,TIME,UNIT_RESULT,WEIGHT_COEFF","relationTypes":"String,String,String,String,String,String,String,String,Decimal,Integer,Decimal,String,String,Decimal","relations":"VIEW_TSP_HA_SCORE.EVALUATE_CONTENT,VIEW_TSP_HA_SCORE.EVALUATION_EXPLAIN,VIEW_TSP_HA_SCORE.EVALUATION_ITEM,VIEW_TSP_HA_SCORE.EVALUATION_REMARK,VIEW_TSP_HA_SCORE.EVALUATION_TYPE,VIEW_TSP_HA_SCORE.HA_ID,VIEW_TSP_HA_SCORE.PARENT_ID,VIEW_TSP_HA_SCORE.PARENT_NAME,VIEW_TSP_HA_SCORE.SCORE,VIEW_TSP_HA_SCORE.SORT_NUM,VIEW_TSP_HA_SCORE.STANDARD_SCORE,VIEW_TSP_HA_SCORE.TIME,VIEW_TSP_HA_SCORE.UNIT_RESULT,VIEW_TSP_HA_SCORE.WEIGHT_COEFF","sys.count":6,"sys.rowid":"VIEW_TSP_HA_SCORE","updateMode":"whereAll"}}},"process":"/TSP/EquipmentHealthEvaluate/process/EquipmentHealthEvaluate/equipmentHealthEvaluateProcess"}]}
java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor187.invoke(Unknown Source)
        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; 提示: 更新记录VIEW_TSP_HA_SCORE, VIEW_TSP_HA_SCORE, key="IMPPJXM-20190402-2-004"出错, 不存在符合条件的数据, UPDATE VIEW_TSP_HA_SCORE VIEW_TSP_HA_SCORE SET VIEW_TSP_HA_SCORE.EVALUATION_EXPLAIN = :EVALUATION_EXPLAIN_new  WHERE VIEW_TSP_HA_SCORE= :VIEW_TSP_HA_SCORE_old AND VIEW_TSP_HA_SCORE.EVALUATE_CONTENT = :EVALUATE_CONTENT_old AND VIEW_TSP_HA_SCORE.EVALUATION_EXPLAIN is null  AND VIEW_TSP_HA_SCORE.EVALUATION_ITEM = :EVALUATION_ITEM_old AND VIEW_TSP_HA_SCORE.EVALUATION_REMARK is null  AND VIEW_TSP_HA_SCORE.EVALUATION_TYPE = :EVALUATION_TYPE_old AND VIEW_TSP_HA_SCORE.HA_ID = :HA_ID_old AND VIEW_TSP_HA_SCORE.PARENT_ID = :PARENT_ID_old AND VIEW_TSP_HA_SCORE.PARENT_NAME = :PARENT_NAME_old AND VIEW_TSP_HA_SCORE.SCORE = :SCORE_old AND VIEW_TSP_HA_SCORE.SORT_NUM = :SORT_NUM_old AND VIEW_TSP_HA_SCORE.STANDARD_SCORE = :STANDARD_SCORE_old AND VIEW_TSP_HA_SCORE.TIME = :TIME_old AND VIEW_TSP_HA_SCORE.UNIT_RESULT is null  AND VIEW_TSP_HA_SCORE.WEIGHT_COEFF = :WEIGHT_COEFF_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)
        ... 26 more

这是错误信息，数据组件是个视图，然后是whereAll的，必须要加上version字段嘛，这个version机制是什么

jishuang

视图可以修改数据？

http://docs.wex5.com/bex5-server-question-list-10040/

wei

jishuang 发表于 2019-4-11 17:05
视图可以修改数据？

http://docs.wex5.com/bex5-server-question-list-10040/

可以修改，实质上还说修改的表里的数据

jishuang

把报错的sql拿到数据库执行看看

wei

jishuang 发表于 2019-4-11 17:41
把报错的sql拿到数据库执行看看

UPDATE VIEW_TSP_HA_SCORE VIEW_TSP_HA_SCORE SET VIEW_TSP_HA_SCORE.EVALUATION_EXPLAIN = :EVALUATION_EXPLAIN_new WHERE VIEW_TSP_HA_SCORE= :VIEW_TSP_HA_SCORE_old AND VIEW_TSP_HA_SCORE.EVALUATE_CONTENT = :EVALUATE_CONTENT_old AND VIEW_TSP_HA_SCORE.EVALUATION_EXPLAIN = :EVALUATION_EXPLAIN_old AND VIEW_TSP_HA_SCORE.EVALUATION_ITEM = :EVALUATION_ITEM_old AND VIEW_TSP_HA_SCORE.EVALUATION_REMARK = :EVALUATION_REMARK_old AND VIEW_TSP_HA_SCORE.EVALUATION_TYPE = :EVALUATION_TYPE_old AND VIEW_TSP_HA_SCORE.HA_ID = :HA_ID_old AND VIEW_TSP_HA_SCORE.PARENT_ID = ARENT_ID_old AND VIEW_TSP_HA_SCORE.PARENT_NAME = ARENT_NAME_old AND VIEW_TSP_HA_SCORE.SCORE = :SCORE_old AND VIEW_TSP_HA_SCORE.SORT_NUM = :SORT_NUM_old AND VIEW_TSP_HA_SCORE.STANDARD_SCORE = :STANDARD_SCORE_old AND VIEW_TSP_HA_SCORE.TIME = :TIME_old AND VIEW_TSP_HA_SCORE.UNIT_RESULT is null AND VIEW_TSP_HA_SCORE.WEIGHT_COEFF = :WEIGHT_COEFF_old

只有这个ksql  看不太懂也执行不了

wei

wei 发表于 2019-4-11 18:03
UPDATE VIEW_TSP_HA_SCORE VIEW_TSP_HA_SCORE SET VIEW_TSP_HA_SCORE.EVALUATION_EXPLAIN = :EVALUATION ...

还有个很奇怪的现象 图片中的两列是可以插入的，当最后一列输入100个字以上的时候会出现这个错

jishuang

数据库是什么类型的?

update语句中带:的改为你页面的值和要修改的值就可以到数据库中执行