The following situation is possible:
- You cannot add an identity for a person, as Pentana Audit tells you that UniqueID requires a value to be entered or The identity for this Person is already in use by another Person
- The user in question cannot login - they get the following error: A valid user could not be found matching the identity [identity]
The cause of this is as follows:
- The identity being added has already been assigned to a Staff or Contact user
- The identity or user has been marked as inactive
To remedy this, manually check the Staff and Contact records for the existing identity, or run the following query:
SELECT P.Name, P.Active AS PersonActiveState, P.IdentityCount, I.UniqueID, I.Active AS IdentityActiveState,
CASE P.TypeID
WHEN '1' THEN 'Staff'
WHEN '2' THEN 'Contact'
END
AS UserType
FROM Person AS P
INNER JOIN [Identity] AS I ON I.PersonID = P.ID
WHERE P.TYPEID IS NOT NULL
ORDER BY I.UniqueID, P.Name;
This will show all of the users with identities, sorted alphabetically by identity. You can find easily to which user an identity is assigned, and whether they are a Staff or Contact user.
Article Comments
0 comments