Pentana Audit: Adding an identity fails with an error that one already exists, yet the user cannot log in

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.