| 问题原因： |
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中插入重复键的行；说明还是最大单据号表有问题。 |