We are trying to upgrade from 5.6 to 6.1 and when the cs_Security_EffectivePermissions_Calculate starts executing it takes over 5 hours to complete. This is blocking us from getting the package ready for an upgrade. We also have been in contact with hosting about this. Thank you in advance for any help.
We believe that it is somewhere located in the following area.
DECLARE pCursor CURSOR FOR
select t1.PName+N'':''+t1.PType+N'':''+convert(nvarchar,coalesce(sum(t2.PValueLen),0))+N'':''+convert(nvarchar,t1.PValueLen)+N'':'',t1.PValue
from @t t1 left outer join @t t2 on t1.GroupID=t2.GroupID and t1.id>t2.id
where t1.GroupID=@GroupID
group by t1.id,t1.GroupID,t1.PName,t1.PType,t1.PValueLen,t1.PValue
order by t1.id
open pCursor
fetch next from pCursor into @PName,@PValue
while @@fetch_status = 0
begin
updatetext cs_Groups.PropertyNames @namesPtr null 0 @PName
updatetext cs_Groups.PropertyValues @valuesPtr null 0 @PValue
--select @GroupID,@PName,@PValue
fetch next from pCursor into @PName,@PValue
end
close pCursor
deallocate pCursor