U861升级到U872提示"日期不能小于源单据的日期"

happy2540

问题:数据库名: UFDATA_600_2009
E:\U8SOFT\Admin\SQLFILE8700\Main\Ufdata\Structure\Data_STR_ST_mix_NL.sql
错误信息:
-2147217900
日期不能小于源单据的日期

执行如下语句时出错:
update rdrecord set ireturncount=0,iverifystate=(case when isnull(chandler,N'')=N'' then 0 else 2 end) where ireturncount is null
update rdrecord set iswfcontrolled =0 where iswfcontrolled is null
解决办法:1、将业务日期校验先去掉在升级，
drop TRIGGER T_CheckDate1
2、升级完成后重新加上
CREATE TRIGGER [T_CheckDate1] ON [dbo].[RdRecord]
FOR UPDATE
AS
begin
if exists(
select rs.id from RdRecords rs inner join INSERTed r on rs.id=r.id inner join dispatchlists ds on rs.idlsid=ds.idlsid inner join dispatchlist d on d.dlid=ds.dlid  where r.cvouchtype=＇32＇ and isnull(rs.idlsid,0)<>0 and r.ddate )
   RAISERROR (＇日期不能小于源单据的日期
＇  , 16, 1)
end