Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
8 replies
Subscribers
6 subscribers
Views
3269 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Administration
We currently have a user set up with an incorrect username. What is the easiest
michaeldc
over 10 years ago
We currently have a user set up with an incorrect username. What is the easiest way to amend this please?
Thanks
OriginalPostID-138141
OriginalPostID-138141
Discussion posts and replies are publicly visible
0
jackm829
A Score Level 3
over 10 years ago
You could deactivate that user and create a new user with the desired name.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 10 years ago
As long as the username is not the same set of characters but different case. For example, if my user is Eduardo.fuentes I can't deactivate it and create eduardo.fuentes because since 7.4 Eduardo.fuentes = eduardo.fuentes only for the validation of available usernames.
In that case you will have to use the Rename Users plug-in to rename Eduardo.fuentes to eduardo.fuentes_tmp then eduardo.fuentes_tmp to eduardo.fuentes.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aasuliman
over 10 years ago
thank you eduardo.fuentes...
why Eduardo.fuentes = eduardo.fuentes is not apply in Login Page ....
many of users type a first character in capital case as long as all email service authentication(Gmail ,hotmail) that apply Eduardo.fuentes = eduardo.fuentes
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 10 years ago
That's a design consideration in the product also described in the documentation:
forum.appian.com/.../User_Management.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
piyushk
Certified Lead Developer
over 10 years ago
Hi Eduardo, even we were facing the same problem and reacted the problem in the same way by renaming it to a temp value and then renaming back to required value. Rename worked but the problem is that we are getting this error in logs for that user "ERROR org.hibernate.util.JDBCExceptionReporter - Violation of UNIQUE KEY constraint 'usr_username_uc'. Cannot insert duplicate key in object 'dbo.usr'. " Also since the user's entry in usr table is with old username, the user cannot post news feed. Is updating the usr table a good option? Can the plugin be updated to handle this?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 10 years ago
Forgot to mention that part. Yes, you'll have to rename it in the usr table too.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
piyushk
Certified Lead Developer
over 10 years ago
Thanks Eduardo. I just want to make sure that updating the usr table in primary DB won't have any bad outcomes(The overall idea of changing something in Primary DB).
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 10 years ago
This is the only scenario where you have to update the Primary DS and has to be done only when you can't really create a new account for a user instead and you really need to rename the user.
Until there's an automated way to rename users from the UI this is required.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel