LDAP Synchronization for one email ID does not happen

  • LDAP Synchronization for one email ID does not happen


  • User information from AD did not sync

Update the email ID of the user from the database 

  • Log on to oracle with the Windchill-user

  • Run the following SQL queries​​

select ida2a2 from wtuser where name like '%<username>%';

Result:

NAME
----------------
    IDA2A2
----------
<username>
 635226540


  • To be sure its the correct user run this to see the number is the same:

 select name, ida2a2 from wtuser where name like '%<username>%';
  • Create a Backup of the table

create table wtuser_bkp as select * from wtuser;
  • Update the e-mail address to the correct one:

update WTUser set email='<new email id of the user>' where ida2a2='<ida2a2 value of the user from previous query>';

IE:

update WTUser set email='patrik.larsson@mammasnyakille.se' where ida2a2='635226540';
  • Commit the change in Oracle:

commit;
  • Refresh the browser