Показать сообщение отдельно
Старый 16.07.2008, 11:45   #7  
aloha is offline
aloha
Участник
 
30 / 12 (1) ++
Регистрация: 27.05.2008
Thumbs up
"Вакцина" найдена!!!
Проблема напрямую связана с моим предыдущим постом:
Удаления Юзера из СРМа4

Я удалил записи из таблицы SystemUserBase, а "хвосты" дали о себе знать.
Вот решение, может кому пригодится:

This is caused by an orphan record in the database. To find out which one it is, run the following script against the MSCRM database.


select r.ResourceId, r.OrganizationId, r.BusinessUnitId, r.Name, u.FullName from Resource as r left outer join SystemUserBase as u on r.ResourceId = u.SystemUserId where r.ObjectTypeCode = 8


If the 4th and 5th columns do not match, this CRM user record has been deleted from the SystemUserBase table, then we need to remove the orphan record from the Resoursebase table. To do so, please run the following script.


delete from ResourceBase where ResourceId in (select r.ResourceId from Resource as r left outer join SystemUserBase as u on r.ResourceId = u.SystemUserId where r.ObjectTypeCode = 8 and u.FullName is null)


That should solve the issue. Ofcourse you should always make a backup before trying these kind of actions!
За это сообщение автора поблагодарили: Артем Enot Грунин (1), AlekseyS (1).