我在流程页面的JS中添加了几个流程数据的setValue 就报错

wujingchangye

data.setValue("FBFBM",djb_jbxx_data.getValue("F_FBFBM"),justep.Context.getProcessData1());
        data.setValue("FBFQC",djb_jbxx_data.getValue("F_FBFQCZD"),justep.Context.getProcessData1());//发包方全称 登记簿表里没有
        data.setValue("ZJHM",djb_jbxx_data.getValue("F_CBHZJHM"),justep.Context.getProcessData1());
        data.setValue("LXDH",djb_jbxx_data.getValue("F_LXDH"),justep.Context.getProcessData1());
        data.setValue("CBFS",djb_jbxx_data.getValue("F_CBFS"),justep.Context.getProcessData1());
        data.setValue("CBTDYT",djb_jbxx_data.getValue("F_CBTDYT"),justep.Context.getProcessData1());
        data.setValue("CBDKZS",djb_jbxx_data.getValue("F_CBDKZS"),justep.Context.getProcessData1());
        data.setValue("CBTDZMJ",djb_jbxx_data.getValue("F_CBDZMJ"),justep.Context.getProcessData1());
        data.setValue("SCZMJM",djb_jbxx_data.getValue("F_SCZMJM"),justep.Context.getProcessData1());



Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150186; 提示: 更新记录TB_JYQCSDJ, TB_JYQCSDJ, key="563795C6498143CA856C6401EF5571F5"出错, 不存在符合条件的数据, UPDATE TB_JYQCSDJ TB_JYQCSDJ SET TB_JYQCSDJ.XJBR = :XJBR_new, TB_JYQCSDJ.XJBRJG = :XJBRJG_new, TB_JYQCSDJ.XJBRRQ = :XJBRRQ_new, TB_JYQCSDJ.XSHYJ = :XSHYJ_new  WHERE TB_JYQCSDJ= :TB_JYQCSDJ_old AND TB_JYQCSDJ.TDCBHTBH = :TDCBHTBH_old AND (TB_JYQCSDJ.FBFBM is null OR TB_JYQCSDJ.FBFBM = '') AND (TB_JYQCSDJ.FBFQC is null OR TB_JYQCSDJ.FBFQC = '') AND TB_JYQCSDJ.CBFBM = :CBFBM_old AND TB_JYQCSDJ.CBFDBXM = :CBFDBXM_old AND TB_JYQCSDJ.ZJHM = :ZJHM_old AND (TB_JYQCSDJ.CBFZZ is null OR TB_JYQCSDJ.CBFZZ = '') AND (TB_JYQCSDJ.LXDH is null OR TB_JYQCSDJ.LXDH = '') AND (TB_JYQCSDJ.CBQSRQ is null OR TB_JYQCSDJ.CBQSRQ = '') AND (TB_JYQCSDJ.CBJSRQ is null OR TB_JYQCSDJ.CBJSRQ = '') AND TB_JYQCSDJ.CBFS = :CBFS_old AND (TB_JYQCSDJ.CBTDYT is null OR TB_JYQCSDJ.CBTDYT = '') AND TB_JYQCSDJ.CBDKZS = :CBDKZS_old AND TB_JYQCSDJ.CBTDZMJ = :CBTDZMJ_old AND TB_JYQCSDJ.SCZMJM is null  AND TB_JYQCSDJ.SCZMJ is null  AND TB_JYQCSDJ.HTZMJM is null  AND TB_JYQCSDJ.CJBR = :CJBR_old AND TB_JYQCSDJ.CJBRJG = :CJBRJG_old AND TB_JYQCSDJ.CJBRYJ = :CJBRYJ_old AND TB_JYQCSDJ.CJBRRQ = :CJBRRQ_old AND (TB_JYQCSDJ.ZJBR is null OR TB_JYQCSDJ.ZJBR = '') AND (TB_JYQCSDJ.ZJBRYJ is null OR TB_JYQCSDJ.ZJBRYJ = '') AND (TB_JYQCSDJ.ZJBRJG is null OR TB_JYQCSDJ.ZJBRJG = '') AND (TB_JYQCSDJ.ZJBRRQ is null OR TB_JYQCSDJ.ZJBRRQ = '') AND (TB_JYQCSDJ.ZSHR is null OR TB_JYQCSDJ.ZSHR = '') AND (TB_JYQCSDJ.ZSHYJ is null OR TB_JYQCSDJ.ZSHYJ = '') AND (TB_JYQCSDJ.ZSHJJ is null OR TB_JYQCSDJ.ZSHJJ = '') AND (TB_JYQCSDJ.ZSHRQ is null OR TB_JYQCSDJ.ZSHRQ = '') AND (TB_JYQCSDJ.XJBR is null OR TB_JYQCSDJ.XJBR = '') AND (TB_JYQCSDJ.XJBRYJ is null OR TB_JYQCSDJ.XJBRYJ = '') AND (TB_JYQCSDJ.XJBRJG is null OR TB_JYQCSDJ.XJBRJG = '') AND (TB_JYQCSDJ.XJBRRQ is null OR TB_JYQCSDJ.XJBRRQ = '') AND (TB_JYQCSDJ.XSHR is null OR TB_JYQCSDJ.XSHR = '') AND (TB_JYQCSDJ.XSHRQ is null OR TB_JYQCSDJ.XSHRQ = '') AND (TB_JYQCSDJ.XSHYJ is null OR TB_JYQCSDJ.XSHYJ = '') AND (TB_JYQCSDJ.XSHJG is null OR TB_JYQCSDJ.XSHJG = '') AND (TB_JYQCSDJ.FZSHR is null OR TB_JYQCSDJ.FZSHR = '') AND (TB_JYQCSDJ.FZSHRQ is null OR TB_JYQCSDJ.FZSHRQ = '') AND (TB_JYQCSDJ.FZSHYJ is null OR TB_JYQCSDJ.FZSHYJ = '') AND (TB_JYQCSDJ.FZSHJG is null OR TB_JYQCSDJ.FZSHJG = '') AND TB_JYQCSDJ.XZXQBM = :XZXQBM_old AND TB_JYQCSDJ.XZXZBM = :XZXZBM_old AND TB_JYQCSDJ.XZCBM = :XZCBM_old AND TB_JYQCSDJ.ZBM = :ZBM_old AND TB_JYQCSDJ.SPZT = :SPZT_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:24)
        ... 25 more

到了流程的第二部 保存这个数据的时候 就报错  这个该如何解决

zf_fz

看看，你是不是在流程的第二部分在保存前，或者流程流转之前对"FBFBM"的数据又进行了修改，还有就是看看你Data有没有在dataValueChaned的或dataValueChing中对数据进行了修改保存操作。

fpj

zf_fz 发表于 2014-4-13 19:56
看看，你是不是在流程的第二部分在保存前，或者流程流转之前对"FBFBM"的数据又进行了修改，还有就是看看你D ...

应该是你的概念主键的值被修改了，数据更新时找不到记录引起的。

楼主你把KSQL输出一下，看看输出的KSQL对应的SQL是什么，然后执行一下SQL会不会有问题。
KSQL输出需要修改配置文件，
配置文件\runtime\BusinessServer\WEB-INF\justep.log.properties
把其中的#log4j.logger.com.justep.system.ksql=DEBUG,CONSOLE
改为log4j.logger.com.justep.system.ksql=DEBUG,CONSOLE
加#默认是注释掉的，然后重启服务。

X5.2.6版本开始，可以在studio首选项中开启日志输出执行的KSQL和SQL语句以及执行的时间，时间选项的单位是毫秒，可以设置0，然后点应用、确定，最后重启tomcat

zhaixin

使用whereAll的更新方式容易出现这种问题，在sql语句的where条件中某些类型的字段用原始值无法找到匹配的记录，建议增加version字段，使用whereVersion进行更新，否则只能排查一下哪种类型的字段不能使用

wujingchangye

好的 谢谢 大家 问题已经解决了

zhaixin

能说一下原因和解决方法吗