所有的单据都不能审核提示有重复值,-用友U8

对应版本:用友U8.52对应产品线：供应链对应模块：库存管理模块问题现象:调拨单等单据审核提示不能在具有唯一索引aa_rdrocords_pk的对象rdrecords中插入重复键的行问题原因：1.--事件探查器跟踪发现--InsertIntoufdata_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中插入重复键的行--InsertIntoufdata_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中插入重复键的行；说明还是最大单据号表有问题。解决方案：1.--select*fromua_identitywherecacc_id=001andcVouchtype=’rd’--iFatherID=234295iChildID=1601709--selectmax(id)fromufdata_001_2005..rdrecords--489878--selexctmax(id)fromufdata_001_2005..rdrecord--4898782.备份数据\\\\lisheng(192.168.0.99)\\d$\\用友备份\\200503010944ufsubufsystemufdata_001_2003ufdata_001_2004ufdata_001_20053.修改相应字段--updateua_identitysetifatherid=489878wherecacc_id=001andcVouchtype=’rd’--updateua_identitysetichildid=489878wherecacc_id=001andcVouchtype=’rd’4.验证OK

本文链接：https://www.bbsufida.com/u8/42535.html