We did an upgrade from v9 to v10. They are on separate servers but on Windows 2008. Now after we brought users to v10, NT ID's of users on v9 and v10 do not match therefore creating mixup of users in old records. So when we run HR105 on v10, we see different users on a report, that's because NT id of users on v9 are not the same as on v10. Our senior guy is on vacation and I'm not sure how to solve this issue.
Our users are on ADFS and I tried to change some of users NT ID's using LDAP browser and now I don't see those users when I run 'listusermap -a'. And on a HR105 report it's printing NT id instead of username.
One viable option I'm thinking of is to write a script that will update data on productline databases. It will take a list of v9 and v10 users and do comparison of their ID and then update data running SQL statements. User_id field is on about 45 tables in productline databases. I'm new to Lawson and I thought there would be a standard way of dealing with this?! Also would it be safe to just update productline databases? Does GEN or LOGAN databases need to be updated as well? If you know of a better way to deal with this let me know.
Any suggestions would very appreciated. Thank you!
Edit: Our database vendor is SQL Server 2008.
Problem solved. I was changing the wrong thing in LDAP. I was changing SID instead of UID.
So here's the fix:
You open your LDAP in Jxplorer and change UID of v10 users to UID of v9 users. Lawson environment must be stopped before you do the change.
We had 50 users so it took me about 1 hour to update all of them.