Only One Primary Email Permitted

After upgrading to PeopleTools 8.51, the sign on page started displaying the following message:

Only one Primary Email Address is permitted. (48,9)

This message may also appear when you are trying to update a user profile. It is caused by users having more than one primary email address flagged in the PSUSEREMAIL table:

select OPRID, count(*)

from PSUSEREMAIL

where PRIMARY_EMAIL = 'Y'

group by OPRID

having count(PRIMARY_EMAIL) > 1;

The fix is to change the PRIMARY_EMAIL flag from Y for all but one email address for each User (OPRID).

One way is to set the primary email flag to N where an email address has not been specified (this may not always be an option).

update PSUSEREMAIL

set PRIMARY_EMAIL = 'N'

where PRIMARY_EMAIL = 'Y'

and EMAILID = ' '

and OPRID in (

 select OPRID

 from PSUSEREMAIL

 where PRIMARY_EMAIL = 'Y'

 group by OPRID

 having count(PRIMARY_EMAIL) > 1

);

Other fixes might including picking a specific email type (e.g. BUS) as the primary email and changing all other types so that the primary email flag is N.