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
8 subscribers
Views
2864 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 9 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 9 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 9 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 9 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 9 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
Piyush Khatri
Certified Lead Developer
over 9 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 9 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
Piyush Khatri
Certified Lead Developer
over 9 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 9 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