所有的单据都不能审核 提示有重复值, 问题描述:调拨单等单据审核提示 不能在具有唯一索引aa_rdrocords_pk的对象rdrecords中插入重复键的行 问题原因:1. --事件探查器跟踪发现 -- Insert Into ufdata_001_2005..Rdrecords(id,cinvcode,cbarcode,cfree1,cfree2,cfree3,cfree4,cfree5,cfree6,cfree7,cfree8, cfree9,cfree10,inquantity,innum,cbatch,cassunit,dmadedate,inum,iquantity,iunitcost,iprice,ipunitcost,ipprice,dvdate, cposition,autoid,cvouchcode,isoutquantity,isoutnum,cdefine22,cdefine23,cdefine24,cdefine25,cdefine26,cdefine27, cdefine28,cdefine29,cdefine30,cdefine31,cdefine32,cdefine33,cdefine34,cdefine35,cdefine36,cdefine37,impoids, icheckids,itrids,citemcode,citem_class,cname,citemcname,imassdate,cbvencode,cinvouchcode) Values (234296,'WP3111',NULL,'C','黑色','34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,0,1,799,799, NULL,NULL,NULL,'',1601710,NULL,0,0,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL,390975,NULL,NULL,NULL,NULL,NULL,NULL,NULL) 不能在具有唯一索引aa_rdrocords_pk的对象rdrecords中插入重复键的行 -- Insert Into ufdata_001_2005..Rdrecords(id,cinvcode,cbarcode,cfree1,cfree2,cfree3,cfree4,cfree5,cfree6,cfree7,cfree8, cfree9,cfree10,inquantity,innum,cbatch,cassunit,dmadedate,inum,iquantity,iunitcost,iprice,ipunitcost,ipprice,dvdate, cposition,autoid,cvouchcode,isoutquantity,isoutnum,cdefine22,cdefine23,cdefine24,cdefine25,cdefine26,cdefine27,cdefine28,cdefine29,cdefine30,cdefine31,cdefine32,cdefine33,cdefine34,cdefine35,cdefine36,cdefine37,impoids,icheckids, itrids,citemcode,citem_class,cname,citemcname,imassdate,cbvencode,cinvouchcode) Values(234296,'ATS833',NULL,'0','绿色','48',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,0,1,0,0,NULL,NULL, NULL,'',1601711,NULL,0,0,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,390976, NULL,NULL,NULL,NULL,NULL,NULL,NULL) 不能在具有唯一索引aa_rdrocords_pk的对象rdrecords中插入重复键的行;说明还是最大单据号表有问题。 解决方案:游客无权查看 相关补丁:模块:库存管理产品:852问题名称:所有的单据都不能审核 提示有重复值,更新时间:2005-06-28 00:00:00 有用 没用92 浏览 分类 U8知识库用友U8知识库(旧)畅捷通知识库用友NC知识库用友U9知识库用友政务知识库致远OA知识库U8Cloud知识库