备份账套，对账套库执行脚本，删除现有个人的查询方案， 执行脚本之后重启服务，清除缓存，再试试
declare @iduser int,@needIdUser INT select distinct @iduser = iduser from SM_VoucherMessageRule where iduser not in (select id from EAP_User) print @iduser select top 1 @needIdUser = id from EAP_User where isAdmin=1 and ActorType=0 and isStoped=0 print @needIdUser update SM_VoucherMessageRule set iduser=@needIdUser where iduser= @iduser
