解决方法 :
删除分配表T_ORG_BASEDATAALLOCATEENTRY表中存在,在基础资料表T_BD_MATERIAL 中不存在的数据,属于异常数据,分配时会提示已经分配过的错误!
DELETE T_ORG_BASEDATAALLOCATEENTRY WHERE FENTRYID in ( select a.FENTRYID from T_ORG_BASEDATAALLOCATEENTRY a left join T_BD_MATERIAL b on a.FDESTID=b.FMATERIALID where a.FTABLENAME='T_BD_MATERIAL' and b.FMATERIALID is null);