During a recent trial SalesLogix upgrade from SalesLogix 7.2 Web to 7.5 Web we encountered the following error while browsing through the web client- “No row with the given identifier exists [Sage.SalesLogix.Security.User#…]”
If you see this error use the following procedure to fix.
First clean out the Role and UserRole tables because no valid role definitions exist.
Delete from sysdba.ROLE
Delete from sysdba.USERROLE
Then remove the records from the UserSecFunction table for any user that no longer exists.
Delete from sysdba.USERSECFUNCTIONS
where userid in (select a.userid from sysdba.usersecfunctions a
left join sysdba.userinfo b on a.userid=b.userid
where b.userid is null)
Now you have a clean system and you’re ready to Rock and Roll!