项目任务启动结束后台提醒邮件功能失效怎么办？

栏目：k3wise知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

有可能是数据库存在错误数据，可以尝试执行下面脚本，进行数据修复：
Update PJ_WorkPerson set IsUser=1 where UserId in (select Userid from SM_Users)goUpdate PJ_WorkPerson set IsUser=0 where UserId not in (select Userid from SM_Users)godelete PJ_WorkPerson where WorkId in (select WorkId from PJ_WorkPiece where ModeState=0) and UserId not in (select Userid from SM_Users)go
可能是数据库存在错误数据，可以尝试执行下面脚本，进行数据修复：
Update PJ_WorkPerson set IsUser=1 where UserId in (select Userid from SM_Users)
go
Update PJ_WorkPerson set IsUser=0 where UserId not in (select Userid from SM_Users)
go
delete PJ_WorkPerson where WorkId in (select WorkId from PJ_WorkPiece where ModeState=0)
and UserId not in (select Userid from SM_Users)
go