User cannot log in: VaultSqlConn.RollbackTransaction failed?

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

Moderator: SourceGear

Post Reply
montek
Posts: 107
Joined: Mon Jan 05, 2004 8:46 am

User cannot log in: VaultSqlConn.RollbackTransaction failed?

Post by montek » Fri Oct 02, 2009 6:51 am

I have a user (name replaced with myuser below) who suddenly cannot log into our Vault installation this morning. Every time she logs in, she sees the following error (Windows and Web client, both).

Login Failed: The username or password supplied is invalid.

The problem, however, is not with her username/password (I reset it and tried as well). I then looked at the server logs and saw the following error. I tried rebooting the server, but that did not change the outcome. Please advise.

Version 4.1.3.18336 Installed 10 November 2008


----10/2/2009 8:43:58 AM myuser --10.1.3.209(10.1.3.209)--SSL Disabled Rolling Back a transaction at VaultServiceSQL.VaultSqlConn.RollbackTransaction()
at VaultServiceAPILib.VaultServiceAPI.Login(VaultSqlConn conn, Boolean allowwebonly, String strLogin, String strDecryptedPassword, String strHostname, String strSessionID, String strDomain, String& strToken, VaultUser& vu, Int32& nValidUserAttempts)
at VaultServiceAPILib.VaultServiceAPISystem.DoLogin(Boolean allowwebonlyusers, Boolean bAdminLogin, HttpSessionState hss, String strHostname, String strLogin, String strPassword, String strRMKey, String& strAuthToken, String strDomain)
at VaultServiceAPILib.VaultServiceAPISystem.DoLogin(Boolean allowwebonlyusers, Boolean bAdminLogin, HttpSessionState hss, String strHostname, String strLogin, String strPassword, String strRMKey, String& strAuthToken)
at VaultService.VaultWeb.Login.DoLoginStuff(String strLogin, String strPassword, LoginToken lt)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.vaultweb_login_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)
at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
at System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

----10/2/2009 8:43:58 AM myuser--10.1.3.209(10.1.3.209)--SSL Disabled Login failed: FailInvalidPassword

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

Re: User cannot log in: VaultSqlConn.RollbackTransaction failed?

Post by Beth » Fri Oct 02, 2009 7:48 am

Are you using Active Directory authentication with Vault? If you are not, then you could set the user's password again using the Vault admin web page.

Is this user able to log in from another machine? Can a different user log into her machine?

Is there any additional information prior to the error you posted in the log, or is that the only entries at the time she tries to log in?
Beth Kieler
SourceGear Technical Support

montek
Posts: 107
Joined: Mon Jan 05, 2004 8:46 am

Re: User cannot log in: VaultSqlConn.RollbackTransaction failed?

Post by montek » Fri Oct 02, 2009 8:39 am

We are not using AD authentication. And I changed the password several times and tried to log in from a different client and the Web client than the user herself (so two completely different Windows clients, one of which is mine and works fine when I log in as myself). Anyway, it's not the username or password. The user does report that she probably hasn't logged into Vault in several weeks (unlike our developers, she doesn't access it every day).

There are other things in the log, but they're normal login/logouts from other users. Nothing else interesting except several copies of this same error for this one user.

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

Re: User cannot log in: VaultSqlConn.RollbackTransaction failed?

Post by Beth » Fri Oct 02, 2009 3:00 pm

Her login doesn't work when you use the web client on your machine? If that's the case, then I'd like you to send an email to support at sourcegear.com (attn: Beth) with a link to this forum thread.

If you can login as her using a web client, then that will help narrow this down.
Beth Kieler
SourceGear Technical Support

montek
Posts: 107
Joined: Mon Jan 05, 2004 8:46 am

Re: User cannot log in: VaultSqlConn.RollbackTransaction failed?

Post by montek » Fri Oct 02, 2009 6:12 pm

Email sent.

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

Re: User cannot log in: VaultSqlConn.RollbackTransaction failed?

Post by Beth » Mon Oct 05, 2009 9:56 am

Got it. Thanks.

HS: 217589
Beth Kieler
SourceGear Technical Support

Post Reply