Can't rename user!

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
BSayatovic
Posts: 47
Joined: Thu Jun 25, 2009 12:02 pm

Can't rename user!

Post by BSayatovic » Wed Feb 15, 2012 11:11 am

When I attempt to rename one particular user, it doesn't work. In fact, no error appears, but I remain on the edit screen. Using Fiddler2, I can see the HTTP response being an HTML response stating "Error in the application". Looking in the log, I see a violation of the "fk_loginattempts_login_users_login" constraint.

Meanwhile, if I attempt to instead add a new user with the desired username, that fails saying a user already exists!

But when I list all users (even showing inactive ones), no user with this username exists!

What gives?

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: Can't rename user!

Post by Beth » Wed Feb 15, 2012 1:19 pm

Is that user using Active Directory authentication? If so, then switch the user to Vault authentication first, and save that change. Then try renaming the user.
Beth Kieler
SourceGear Technical Support

rkamath
Posts: 1
Joined: Wed Feb 15, 2012 1:56 pm

Re: Can't rename user!

Post by rkamath » Wed Feb 15, 2012 2:06 pm

I tried what you suggested. Did not work. Basically, I changed the user's authentication from Active Directory to Vault Authentication. Saved this change. Opened the user, tried to change username to the one required in the active directory, but it did not allow me to save this change. Same error message in the log... The UPDATE statement conflicted with the REFERENCE constraint "fk_loginattempts_login_users_login".

BSayatovic
Posts: 47
Joined: Thu Jun 25, 2009 12:02 pm

Didn't work

Post by BSayatovic » Thu Feb 16, 2012 3:50 pm

I tried that, with my colleague rkamath, but it didn't work.
Beth wrote:Is that user using Active Directory authentication? If so, then switch the user to Vault authentication first, and save that change. Then try renaming the user.

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: Can't rename user!

Post by Beth » Thu Feb 16, 2012 5:14 pm

Can you open a Vault GUI client, login, then go to Help - Technical support and post the information from that window here? I don't need the license information. Just the client and server environment information.

Next, when users aren't connected, recycle the VaultAppPool from inside the IIS Manager. Recycling the VaultAppPool can be done one of two ways.
  • 1) Go to Start - Run and type iisreset. This will recycle all of IIS.

    2) (IIS6) Open your IIS Manager, expand Application Pools, right-click VaultAppPool and select Recycle.
    (IIS7) Open your IIS Manager, click on Application Pools, click VaultAppPool and then look to the far right pane to click the Recycle link.
All of these methods will cause users to be disconnected from Vault. It is best to not disconnect users during uploading and downloading files, so you may need to perform the recycle at a convenient time or forewarn your users.

Then immediately try renaming the user again. What are your results?
Beth Kieler
SourceGear Technical Support

BSayatovic
Posts: 47
Joined: Thu Jun 25, 2009 12:02 pm

Re: Can't rename user!

Post by BSayatovic » Fri Feb 17, 2012 7:11 am

FWIW, "iisreset" worked. We were able to rename the user. And since you asked for it, here's our client/server info:

Client Information
Vault Standard Client Version: 5.1.2.19281
.NET Framework Version: 2.0.50727.5448
Operating System: Microsoft Windows 7 Professional
Service Pack: 1.0
OS Version: 6.1.7601
Total Physical Memory: 15.89 GB
Time Zone: (UTC-05:00) Eastern Time (US & Canada)

Server Information
Server Version: 5.1.2.19248
.NET Framework Version: 2.0.50727.4216
Operating System: Microsoft® Windows Server® 2008 Standard
Service Pack: 2.0
OS Version: 6.0.6002
Timezone: (GMT-05:00) Eastern Time (US & Canada)
SQL Version: Microsoft SQL Server 2005 - 9.00.5057.00 (Intel X86)

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: Can't rename user!

Post by Beth » Fri Feb 17, 2012 8:57 am

Thanks for the update. I'm happy to hear you are working again.
Beth Kieler
SourceGear Technical Support

Post Reply