Hello Team, We are getting below error in logs. Any idea on this it s

The table in question is part of the primary data source of Appian and stores all users who have logged in to Tempo. The table is case insensitive meaning ggpand = GGPAND. If there's an entry with the same characters but different case (e.g. uppercase, camelcase, etc.) such as GGPAND already in the db.usr table and you try to login with ggpand you will see that error message and Tempo will not work properly for that account.

Assuming that the user account you really need is ggpand then simply use the Rename Users plug-in to rename GGPAND to GGPAND_OLD and then deactivate it. Then in the dbo.usr table rename GGPAND to GGPAND_OLD too. This will release the ggpand username so you stop seeing this error when ggpand logs in to Tempo

The table in question is part of the primary data source of Appian and stores all users who have logged in to Tempo. The table is case insensitive meaning ggpand = GGPAND. If there's an entry with the same characters but different case (e.g. uppercase, camelcase, etc.) such as GGPAND already in the db.usr table and you try to login with ggpand you will see that error message and Tempo will not work properly for that account.

Assuming that the user account you really need is ggpand then simply use the Rename Users plug-in to rename GGPAND to GGPAND_OLD and then deactivate it. Then in the dbo.usr table rename GGPAND to GGPAND_OLD too. This will release the ggpand username so you stop seeing this error when ggpand logs in to Tempo