Username update not reflected in NAV

njhansen

Background:
NAV2009R2 build 32775 talking to
SQL Server 2009R2
Windows authentication (except one vendor login using database authentication)

Recently, our domain admin changed a user's username in AD because she got married. It still shows as her old username when she logs into NAV (that is, orders she places have her old user as the assigned to, and both the NAV login list and SQL sp_who show the old username in the list of active users).

Her username does not exist in NAV or SQL Server (old username or the new), but rather, she is in a group that is defined in both NAV and SQL Server security. I'm not sure where NAV is getting the old username. I've tried everything I can think of, even the ridiculous ideas:

Synchronized security
Discarded ZUP
Closed/reopened database
Restarted computer
Logged in from computer never previously used
Checked that AD has replicated its changes to all DC's

Where is NAV looking for this information?

ara3n

Have you checked Salesperson code?

vaprog

What is the SourceExpr property of the control that prints the old name in the report and where does it's value come from?

njhansen

Yes, her salesperson record has changed.

As best I can tell, anywhere in the system that calls the USERID function returns her old name. For instance, it shows up in the change log, which has in its insert code:

  IF LogEmployeePortalActivity THEN
    ChangeLogEntry."User ID" := LogEmployeePortalUser
  ELSE
    ChangeLogEntry."User ID" := USERID;

We are not using employee portal at all.


We have since tried removing her (roaming) profile altogether -- still no change.

njhansen

For no apparent reason, after nearly two months, it suddenly started working. No one fixed it in NAV (at least not on purpose), and the network admins say nothing changed in AD. No patches (OS or NAV).

Marking as solved since the symptoms are gone. The problem is still present in that no one knows what NAV looks at to find this information.