Error Page Appears when Adding Some Users as Primary Contacts

Article:TECH189118  |  Created: 2012-05-18  |  Updated: 2012-05-22  |  Article URL http://www.symantec.com/docs/TECH189118
Article Type
Technical Solution


Environment

Issue



Error Page Appears when Adding Some Users as Primary Contacts


Error



 'The Primary Contact does not exist in the portal"  and 'Could not find [UserInfo] where [EmailAddress] Equal [email@domain.com]

 



Environment



Servicedesk 7.1.1


Cause



Missing a correlated Email Address in the UserEmailAddress table for the Primary Contact


Solution



The following script generates the missing email addresses in the UserEmailAddress table

-- run to fix broken users - "can't find userinfo for blahblah"

declare @userid nvarchar(36),

        @primaryemail nvarchar(255)

declare u_cursor CURSOR FOR select u.UserID, u.PrimaryEmail

from [User] u

where not exists (Select *

                    from UserEmailAddress uea

                    where u.UserID = uea.UserID and

                    u.PrimaryEmail = uea.EmailAddress)

open u_cursor

fetch next from u_cursor INTO @userid, @primaryemail

while @@fetch_status = 0

begin

    insert into UserEmailAddress (UserEmailAddressID, EmailAddress, UserID, SendNotificationsHere) values

    (NEWID(), @primaryemail, @userid, 1)

    fetch next from u_cursor INTO @userid, @primaryemail

end

close u_cursor

deallocate u_cursor




Article URL http://www.symantec.com/docs/TECH189118


Terms of use for this information are found in Legal Notices