Error in SalesLogix web client ‘Enum code does not map to a value on enum UserType’

I recently found I was running into an error in the SalesLogix web client when trying to launch activities or history that stated:

‘Enum code does not map to a value on enum UserType’

The stack trace on the error was quite lengthy but by reading through it I was able to determine that one user in the system did not have a proper TYPE defined. The Type of a user is what kind of license they are. In the case of the system I was working on there was one user that did not have a type.

Running this SQL query showed my the list of Types in the system for the users

select type, COUNT(type) from usersecurity group by type

The proper types should be one of the following:

N (Network)

M (Remote)

T (Web)

V (Web Viewer)

C (Concurrent)

R (Retired)

P (Template)

A (Add On)

W (Admin)

To fix my problems I simply set the offending record to be a retired user using this SQL statement: