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.png

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.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License