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
2866 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
Parents
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
Reply
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
Children
No Data