Error retrieve notification message

If you are having a problem using Vault, post a message here.
Post Reply
jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Error retrieve notification message

Post by jkp*74 » Tue May 06, 2014 3:28 am

Just upgraded to Vault 7.1.0

From time to time, i see this message appears in the Messages Pane:
[6/5/2014 2:47:41 PM] An error occurred retrieving application notification messages from http://www.mmsvault.com/VaultNotifyServ ... rvice.asmx - Failure

I can receive notification in my email & also in the Notifications pane in vault client.

I wonder why above message appear?

I check the server log - sgvault.log, nothing unusual.
I check vaultnotifyservice.txt:

Code: Select all

5/1/2014 3:13:59 PM <generic>:  [System.Data.SqlClient.SqlException (0x80131904): Cannot open database "sgmaster" requested by the login. The login failed.
Login failed for user 'sgvaultuser'.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at VaultPluginLib.PluginSQLConn.OpenSqlConnection(String strConn, Int32 nCommandTimeout, ResourceManager rm, Boolean bThrowException, PluginSQLConn& conn, Exception& exGenerated)
ClientConnectionId:220072e4-83eb-4be5-b8d4-b88b778ccd33] Cannot open database "sgmaster" requested by the login. The login failed.
Login failed for user 'sgvaultuser'.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at VaultPluginLib.PluginSQLConn.OpenSqlConnection(String strConn, Int32 nCommandTimeout, ResourceManager rm, Boolean bThrowException, PluginSQLConn& conn, Exception& exGenerated)

5/1/2014 3:14:50 PM <generic>: SimpleLogger finalized
5/1/2014 5:13:20 PM <generic>: GetEntryAssembly() returned null; not logging assembly name
5/1/2014 5:13:20 PM <generic>: SourceGear Notification Service started.
5/1/2014 10:00:09 PM <generic>: SimpleLogger finalized
5/2/2014 8:34:54 AM <generic>: GetEntryAssembly() returned null; not logging assembly name
5/2/2014 8:34:54 AM <generic>: SourceGear Notification Service started.
5/2/2014 9:52:34 AM <generic>: GetEntryAssembly() returned null; not logging assembly name
5/2/2014 9:52:34 AM <generic>: SourceGear Notification Service started.
5/2/2014 9:52:35 AM <generic>: SimpleLogger finalized
5/2/2014 9:54:16 AM <generic>: SimpleLogger finalized
5/2/2014 9:57:24 AM <generic>: GetEntryAssembly() returned null; not logging assembly name
5/2/2014 9:57:24 AM <generic>: SourceGear Notification Service started.

I check VaultGUIClient.txt in my laptop and nothing unusual.
Joel
Micro Modular System
http://www.mmsis.com

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

Re: Error retrieve notification message

Post by Beth » Tue May 06, 2014 7:33 am

Check the web.config in that is found under the vaultservice directory that is part of the website on the Vault server. Towards the bottom should be the SQL connect string. Does that list sgvaultuser?
Beth Kieler
SourceGear Technical Support

jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Re: Error retrieve notification message

Post by jkp*74 » Tue May 06, 2014 7:41 pm

These are entries i can find.

Code: Select all

<sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;user id=sa;password=" cookieless="false" timeout="10080"/>
Note: i have removed the pwd value.

Code: Select all

  <appSettings>
    <add key="ConfigPath" value="C:\inetpub\wwwroot\VaultService\Vault.config"/>
    <add key="BugTrackingPath" value="C:\inetpub\wwwroot\VaultPro"/>

    <add key="ConnectString" value="Application Name='SourceGear Vault Server'; Connection Reset='true'; Server=(local); Database=sgvault; User ID=sgvaultuser; pwd=" />
    <!-- INTEGRATEDWINDOWSMODE-add key="ConnectString" value="Application Name='SourceGear Vault Server'; Connection Reset='true'; Server=(local); Database=sgvault; Integrated Security='true'" />INTEGRATEDWINDOWSMODE- -->

    <add key="SGIndex_ConnectString" value="Application Name='SourceGear Vault Server (Find in Files)'; Connection Reset='true'; Server=(local); Database=sgvaultindex; User ID=sgvaultuser; pwd=" />
    <!-- INTEGRATEDWINDOWSMODE-add key="SGIndex_ConnectString" value="Application Name='SourceGear Vault Server (Find in Files)'; Connection Reset='true'; Server=(local); Database=sgvaultindex; Integrated Security='true'" />INTEGRATEDWINDOWSMODE- -->

    <add key="SGNotify_ConnectString" value="Application Name='SourceGear Vault Server (Notification)'; Connection Reset='true'; Server=(local); Database=sgnotify; User ID=sgvaultuser; pwd=" />
    <!-- INTEGRATEDWINDOWSMODE-add key="SGNotify_ConnectString" value="Application Name='SourceGear Vault Server (Notification)'; Connection Reset='true'; Server=(local); Database=sgnotify; Integrated Security='true'" />INTEGRATEDWINDOWSMODE- -->

    <add key="SecurityToken" value="7b6c2ffd-9b53-47df-ba3d-a74ed87b6315"/>
  </appSettings>
From Vault Client - all logs in Messages:

Code: Select all

[6/5/2014 12:58:56 PM] Version Check:  This Vault Professional client is version 7.1.0.32028
[6/5/2014 12:58:56 PM] Version Check:  Your Vault Professional server is version 7.1.0.32028
[6/5/2014 12:58:56 PM] Version Check:  The following information was retrieved from the SourceGear website.  No information was sent to SourceGear.  You can disable this part of the version check from the Options dialog.
[6/5/2014 12:58:56 PM] Version Check:  The most recent Server release is version 7.1.0.32028
[6/5/2014 2:47:41 PM] An error occurred retrieving application notification messages from http://www.mmsvault.com/VaultNotifyService/VaultNotifyService.asmx -  Failure	
[6/5/2014 3:37:23 PM]     Fetched $/Project Track/Project Management/Estimated Man Hour/Estimated Man Hour.xlsx
[6/5/2014 5:38:34 PM] Getting latest version of $/NT-002 - New Lens AOI & Taping Machine/Source Code/MCSP/SeqServer/Machine Sequence/TnRIndexer.cs
[6/5/2014 5:38:35 PM]     Fetched $/NT-002 - New Lens AOI & Taping Machine/Source Code/MCSP/SeqServer/Machine Sequence/TnRIndexer.cs
[6/5/2014 5:38:35 PM] Finished get latest of $/NT-002 - New Lens AOI & Taping Machine/Source Code/MCSP/SeqServer/Machine Sequence/TnRIndexer.cs
[6/5/2014 5:38:58 PM]     Fetched $/NT-001 - Lens AVI & Taping Machine/Source Code/MCSP/SeqServer/Machine Sequence/TnRIdx.cs
[6/5/2014 6:52:18 PM] An error occurred retrieving application notification messages from http://www.mmsvault.com/VaultNotifyService/VaultNotifyService.asmx -  Failure	
[6/5/2014 6:57:39 PM] An error occurred retrieving application notification messages from http://www.mmsvault.com/VaultNotifyService/VaultNotifyService.asmx -  Failure	
[6/5/2014 7:02:39 PM] An error occurred retrieving application notification messages from http://www.mmsvault.com/VaultNotifyService/VaultNotifyService.asmx -  Failure	
[6/5/2014 7:07:39 PM] An error occurred retrieving application notification messages from http://www.mmsvault.com/VaultNotifyService/VaultNotifyService.asmx -  Failure	
[6/5/2014 7:12:39 PM] Too many errors occurred retrieving application notification messagesfrom http://www.mmsvault.com/VaultNotifyService/VaultNotifyService.asmx. Notifications retrieval has been disabled.
Joel
Micro Modular System
http://www.mmsis.com

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

Re: Error retrieve notification message

Post by Beth » Wed May 07, 2014 8:09 am

Are there corresponding errors in the sgvault.log at the same time as the errors in the notify log?
Beth Kieler
SourceGear Technical Support

jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Re: Error retrieve notification message

Post by jkp*74 » Wed May 07, 2014 7:06 pm

sgvault.log - Nothing unusual during that time [6/5/2014 6:52:18 PM]

Code: Select all

----5/6/2014 7:52:03 AM      cctong--VIRTUAL-WIN7PRO(192.0.0.57)--SSL Disabled	Login 
----5/6/2014 8:27:29 AM      jwliaw--SDD-JW_LIAW(192.0.0.86)--SSL Disabled	Login 
----5/6/2014 8:33:07 AM      chlim--192.0.0.41(192.0.0.41)--SSL Disabled	Login 
----5/6/2014 8:33:40 AM      wychooi--SDD-CHOOIWINGYI(192.0.0.63)--SSL Disabled	Login 
----5/6/2014 8:34:27 AM      pwkok--HP-CNU0123M6G(192.0.0.191)--SSL Disabled	Login 
----5/6/2014 8:40:42 AM      wychooi--SDD-CHOOIWINGYI(192.0.0.63)--SSL Disabled	Login 
----5/6/2014 8:41:42 AM      jwliaw--SDD-JW_LIAW(192.0.0.86)--SSL Disabled	Login 
----5/6/2014 8:47:04 AM      ktkhoo--CHRIS-VM(192.0.0.133)--SSL Disabled	Login 
----5/6/2014 8:50:31 AM      cctong--VIRTUAL-WIN7PRO(192.0.0.57)--SSL Disabled	Login 
----5/6/2014 8:58:13 AM      sychew--SDD-SY_CHEW(192.0.0.211)--SSL Disabled	Login 
----5/6/2014 8:58:40 AM      pschai--TESTER-PSCHAI(192.0.0.87)--SSL Disabled	Login 
----5/6/2014 8:58:49 AM      ps_chai--TESTER-PSCHAI(192.0.0.87)--SSL Disabled	Rolling Back a transaction   at VaultServiceSQL.VaultSqlConn.RollbackTransaction()
   at VaultServiceAPILib.VaultServiceAPI.Login(VaultSqlConn conn, Boolean bAllowWebOnly, 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 VaultService.VaultWeb.Login.DoLoginStuff(String strLogin, String strPassword, LoginToken lt)
   at System.Web.UI.WebControls.Button.RaisePostBackEvent(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 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
   at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
   at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
   at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
   at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
   at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
 
----5/6/2014 8:58:49 AM      ps_chai--TESTER-PSCHAI(192.0.0.87)--SSL Disabled	Login failed:  FailNotValidLogin 
----5/6/2014 8:58:56 AM      pschai--TESTER-PSCHAI(192.0.0.87)--SSL Disabled	Login 
----5/6/2014 8:59:06 AM      pschai--TESTER-PSCHAI(192.0.0.87)--SSL Disabled	Login 
----5/6/2014 8:59:20 AM      ps_chai--TESTER-PSCHAI(192.0.0.87)--SSL Disabled	Rolling Back a transaction   at VaultServiceSQL.VaultSqlConn.RollbackTransaction()
   at VaultServiceAPILib.VaultServiceAPI.Login(VaultSqlConn conn, Boolean bAllowWebOnly, 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 VaultService.VaultWeb.Login.DoLoginStuff(String strLogin, String strPassword, LoginToken lt)
   at System.Web.UI.WebControls.Button.RaisePostBackEvent(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 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
   at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
   at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
   at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
   at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
   at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
 
----5/6/2014 8:59:20 AM      ps_chai--TESTER-PSCHAI(192.0.0.87)--SSL Disabled	Login failed:  FailNotValidLogin 
----5/6/2014 9:00:03 AM      pschai--TESTER-PSCHAI(192.0.0.87)--SSL Disabled	Login 
----5/6/2014 9:00:16 AM      sychew--SDD-SY_CHEW(192.0.0.211)--SSL Disabled	Login 
----5/6/2014 9:00:51 AM      pwkok--HP-CNU0123M6G(192.0.0.191)--SSL Disabled	Logout 
----5/6/2014 9:00:51 AM      pwkok--HP-CNU0123M6G(192.0.0.191)--SSL Disabled	Login 
----5/6/2014 9:04:31 AM      pschai--TESTER-PSCHAI(192.0.0.87)--SSL Disabled	Login 
----5/6/2014 9:05:04 AM      cctong--VIRTUAL-WIN7PRO(192.0.0.57)--SSL Disabled	Login 
----5/6/2014 9:05:56 AM      pschai--TESTER-PSCHAI(192.0.0.87)--SSL Disabled	Login 
----5/6/2014 9:06:21 AM      pw_kok--HP-CNU0123M6G(192.0.0.191)--SSL Disabled	Rolling Back a transaction   at VaultServiceSQL.VaultSqlConn.RollbackTransaction()
   at VaultServiceAPILib.VaultServiceAPI.Login(VaultSqlConn conn, Boolean bAllowWebOnly, 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 VaultService.VaultWeb.Login.DoLoginStuff(String strLogin, String strPassword, LoginToken lt)
   at System.Web.UI.WebControls.Button.RaisePostBackEvent(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 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
   at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
   at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
   at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
   at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
   at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
 
----5/6/2014 9:06:21 AM      pw_kok--HP-CNU0123M6G(192.0.0.191)--SSL Disabled	Login failed:  FailNotValidLogin 
----5/6/2014 9:06:29 AM      pwkok--HP-CNU0123M6G(192.0.0.191)--SSL Disabled	Login failed:  FailInvalidPassword 
----5/6/2014 9:06:36 AM      pwkok--HP-CNU0123M6G(192.0.0.191)--SSL Disabled	Login 
----5/6/2014 9:06:39 AM      pschai--TESTER-PSCHAI(192.0.0.87)--SSL Disabled	Login 
----5/6/2014 9:06:50 AM      ps_chai--TESTER-PSCHAI(192.0.0.87)--SSL Disabled	Rolling Back a transaction   at VaultServiceSQL.VaultSqlConn.RollbackTransaction()
   at VaultServiceAPILib.VaultServiceAPI.Login(VaultSqlConn conn, Boolean bAllowWebOnly, 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 VaultService.VaultWeb.Login.DoLoginStuff(String strLogin, String strPassword, LoginToken lt)
   at System.Web.UI.WebControls.Button.RaisePostBackEvent(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 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
   at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
   at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
   at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
   at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
   at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
 
----5/6/2014 9:06:50 AM      ps_chai--TESTER-PSCHAI(192.0.0.87)--SSL Disabled	Login failed:  FailNotValidLogin 
----5/6/2014 9:06:51 AM      pwkok--HP-CNU0123M6G(192.0.0.191)--SSL Disabled	Login 
----5/6/2014 9:18:32 AM      zhlee--SDD-ZHLEE(192.0.0.59)--SSL Disabled	Login 
----5/6/2014 9:24:54 AM      pwkok--HP-CNU0123M6G(192.0.0.191)--SSL Disabled	Login 
----5/6/2014 9:30:44 AM      jwliaw--SDD-JW_LIAW(192.0.0.86)--SSL Disabled	Login 
----5/6/2014 9:39:36 AM      wk_ang--MAC-WKANG(192.0.0.25)--SSL Disabled	Login 
----5/6/2014 10:06:48 AM     wk_ang--MAC-WKANG(192.0.0.25)--SSL Disabled	Logout 
----5/6/2014 10:26:27 AM     chlim--192.0.0.41(192.0.0.41)--SSL Disabled	Logout 
----5/6/2014 10:35:06 AM     pschai--TESTER-PSCHAI(192.0.0.87)--SSL Disabled	Login 
----5/6/2014 11:50:50 AM     mhweng--CSD-MHWENGNB(192.0.0.210)--SSL Disabled	Login 
----5/6/2014 12:45:48 PM     joel--SDD-JOEL_N(192.0.0.108)--SSL Disabled	Logout 
----5/6/2014 12:46:25 PM     joel--SDD-JOEL_N(192.0.0.108)--SSL Disabled	Logout 
----5/6/2014 12:58:55 PM     joel--SDD-JOEL_N(192.0.0.108)--SSL Disabled	Login 
----5/6/2014 1:04:06 PM      mhweng--CSD-MHWENGNB(192.0.0.210)--SSL Disabled	Logout 
----5/6/2014 1:05:03 PM      joel--SDD-JOEL_N(192.0.0.108)--SSL Disabled	Login 
----5/6/2014 1:07:56 PM      joel--SDD-JOEL_N(192.0.0.108)--SSL Disabled	Login 
----5/6/2014 1:10:08 PM      wcchew--VIRTUALXP_WC(192.0.0.91)--SSL Disabled	Login 
----5/6/2014 1:10:46 PM      zhlee--SDD-ZHLEE(192.0.0.59)--SSL Disabled	Login 
----5/6/2014 1:11:05 PM      zhlee--SDD-ZHLEE(192.0.0.59)--SSL Disabled	Logout 
----5/6/2014 1:15:21 PM      cctong--VIRTUAL-WIN7PRO(192.0.0.57)--SSL Disabled	Logout 
----5/6/2014 1:16:43 PM      ktkhoo--CHRIS-VM(192.0.0.133)--SSL Disabled	Login 
----5/6/2014 1:17:58 PM      pwkok--HP-CNU0123M6G(192.0.0.191)--SSL Disabled	Logout 
----5/6/2014 1:19:34 PM      ktkhoo--CHRIS-VM(192.0.0.133)--SSL Disabled	Login 
----5/6/2014 1:26:50 PM      pwkok--HP-CNU0123M6G(192.0.0.191)--SSL Disabled	Login 
----5/6/2014 1:30:35 PM      pwkok--HP-CNU0123M6G(192.0.0.191)--SSL Disabled	Login failed:  FailInvalidPassword 
----5/6/2014 1:30:41 PM      pwkok--HP-CNU0123M6G(192.0.0.191)--SSL Disabled	Login 
----5/6/2014 1:31:07 PM      wychooi--SDD-CHOOIWINGYI(192.0.0.63)--SSL Disabled	Login 
----5/6/2014 1:34:19 PM      pwkok--HP-CNU0123M6G(192.0.0.191)--SSL Disabled	Logout 
----5/6/2014 1:37:03 PM      pwkok--HP-CNU0123M6G(192.0.0.191)--SSL Disabled	Login 
----5/6/2014 1:42:56 PM      sychew--SDD-SY_CHEW(192.0.0.211)--SSL Disabled	Logout 
----5/6/2014 1:43:19 PM      sychew--SDD-SY_CHEW(192.0.0.211)--SSL Disabled	Logout 
----5/6/2014 1:43:24 PM      sychew--SDD-SY_CHEW(192.0.0.221)--SSL Disabled	Login 
----5/6/2014 1:45:09 PM      sychew--SDD-SY_CHEW(192.0.0.221)--SSL Disabled	Login 
----5/6/2014 1:47:16 PM      sychew--CSD-SYCHEW(192.0.0.66)--SSL Disabled	Login 
----5/6/2014 1:48:53 PM      kc_kho--CSD-KCKHO(192.0.0.71)--SSL Disabled	Login 
----5/6/2014 2:03:04 PM      wychooi--SDD-CHOOIWINGYI(192.0.0.63)--SSL Disabled	Login 
----5/6/2014 2:03:17 PM      wcchew--VIRTUALXP_WC(192.0.0.91)--SSL Disabled	Login 
----5/6/2014 2:03:30 PM      wcchew--VIRTUALXP_WC(192.0.0.91)--SSL Disabled	Logout 
----5/6/2014 2:05:18 PM      pschai--TS-PSCHAI(192.0.0.76)--SSL Disabled	Logout 
----5/6/2014 2:10:20 PM      lskim--LSKIM(192.0.0.28)--SSL Disabled	Login 
----5/6/2014 2:12:37 PM      pschai--TS-PSCHAI(192.0.0.76)--SSL Disabled	Login 
----5/6/2014 2:12:39 PM      pschai--TS-PSCHAI(192.0.0.76)--SSL Disabled	Logout 
----5/6/2014 2:12:43 PM      pschai--TS-PSCHAI(192.0.0.76)--SSL Disabled	Login 
----5/6/2014 2:24:29 PM      wcchew--VIRTUALXP_WC(192.0.0.91)--SSL Disabled	Login 
----5/6/2014 2:25:59 PM      cctong--VIRTUAL-WIN7PRO(12.0.0.0)--SSL Disabled	Login 
----5/6/2014 2:31:10 PM      cctong--VIRTUAL-WIN7PRO(12.0.0.0)--SSL Disabled	Logout 
----5/6/2014 2:49:08 PM      wychooi--SDD-CHOOIWINGYI(192.0.0.63)--SSL Disabled	Logout 
----5/6/2014 2:49:22 PM      wychooi--SDD-CHOOIWINGYI(192.0.0.63)--SSL Disabled	Login 
----5/6/2014 2:52:47 PM      wychooi--SDD-CHOOIWINGYI(192.0.0.63)--SSL Disabled	Login 
----5/6/2014 3:06:10 PM      sychew--CSD-SYCHEW(192.0.0.222)--SSL Disabled	Login 
----5/6/2014 3:41:31 PM      wychooi--SDD-CHOOIWINGYI(192.0.0.63)--SSL Disabled	Login 
----5/6/2014 3:44:47 PM      wychooi--SDD-CHOOIWINGYI(192.0.0.63)--SSL Disabled	Logout 
----5/6/2014 3:46:19 PM      wychooi--SDD-CHOOIWINGYI(192.0.0.63)--SSL Disabled	Logout 
----5/6/2014 3:46:28 PM      wychooi--SDD-CHOOIWINGYI(192.0.0.63)--SSL Disabled	Login 
----5/6/2014 3:48:11 PM      ktkhoo--CHRIS-VM(192.0.0.133)--SSL Disabled	Logout 
----5/6/2014 3:48:59 PM      cctong--VIRTUAL-WIN7PRO(12.0.0.0)--SSL Disabled	Login 
----5/6/2014 3:50:48 PM      wcchew--WC_CHEW(192.0.0.85)--SSL Disabled	Login 
----5/6/2014 3:51:02 PM      cctong--VIRTUAL-WIN7PRO(12.0.0.0)--SSL Disabled	Login 
----5/6/2014 3:54:41 PM      sychew--CSD-SYCHEW(192.0.0.222)--SSL Disabled	Login 
----5/6/2014 4:09:50 PM      cctong--VIRTUAL-WIN7PRO(12.0.0.0)--SSL Disabled	Logout 
----5/6/2014 4:16:30 PM      cychoo--XPYANGI7(192.0.0.88)--SSL Disabled	Login 
----5/6/2014 4:29:15 PM      ktkhoo--CHRIS-VM(192.0.0.133)--SSL Disabled	Logout 
----5/6/2014 4:33:36 PM      wychooi--SDD-CHOOIWINGYI(192.0.0.63)--SSL Disabled	Login 
----5/6/2014 4:33:49 PM      wychooi--SDD-CHOOIWINGYI(192.0.0.63)--SSL Disabled	Logout 
----5/6/2014 4:34:26 PM      wychooi--SDD-CHOOIWINGYI(192.0.0.63)--SSL Disabled	Logout 
----5/6/2014 4:36:15 PM      joel--SDD-JOEL_N(192.0.0.108)--SSL Disabled	Logout 
----5/6/2014 4:36:16 PM      joel--SDD-JOEL_N(192.0.0.108)--SSL Disabled	Login 
----5/6/2014 4:37:29 PM      joel--SDD-JOEL_N(192.0.0.108)--SSL Disabled	Login 
----5/6/2014 4:42:39 PM      sychew--SDD-SY_CHEW(192.0.0.221)--SSL Disabled	Login 
----5/6/2014 4:44:51 PM      cychoo--XPYANGI7(192.0.0.88)--SSL Disabled	Logout 
----5/6/2014 4:47:06 PM      clboo--CL_BOO(192.0.0.35)--SSL Disabled	Login 
----5/6/2014 4:51:00 PM      clboo--CL_BOO(192.0.0.35)--SSL Disabled	Logout 
----5/6/2014 4:57:29 PM      clboo--CL_BOO(192.0.0.35)--SSL Disabled	Login 
----5/6/2014 5:02:06 PM      clboo--CL_BOO(192.0.0.35)--SSL Disabled	Logout 
----5/6/2014 5:14:37 PM      zhlee--SDD-ZHLEE(192.0.0.59)--SSL Disabled	Logout 
----5/6/2014 5:38:18 PM      wk_ang--MAC-WKANG(192.0.0.25)--SSL Disabled	Login 
----5/6/2014 5:40:17 PM      jwliaw--SDD-JW_LIAW(192.0.0.86)--SSL Disabled	Logout 
----5/6/2014 5:41:29 PM      cctong--VIRTUAL-WIN7PRO(12.0.0.0)--SSL Disabled	Login 
----5/6/2014 5:43:19 PM      cctong--VIRTUAL-WIN7PRO(12.0.0.0)--SSL Disabled	Login 
----5/6/2014 5:43:26 PM      zhlee--SDD-ZHLEE(192.0.0.59)--SSL Disabled	Login 
----5/6/2014 5:45:00 PM      wychooi--SDD-CHOOIWINGYI(192.0.0.63)--SSL Disabled	Logout 
----5/6/2014 5:46:40 PM      wk_ang--MAC-WKANG(192.0.0.25)--SSL Disabled	Logout 
----5/6/2014 5:48:06 PM      kc_kho--CSD-KCKHO(192.0.0.71)--SSL Disabled	Logout 
----5/6/2014 5:51:28 PM      zhlee--SDD-ZHLEE(192.0.0.59)--SSL Disabled	Login 
----5/6/2014 6:00:45 PM      jwliaw--SDD-JW_LIAW(192.0.0.86)--SSL Disabled	Login 
----5/6/2014 6:09:47 PM      cctong--VIRTUAL-WIN7PRO(12.0.0.1)--SSL Disabled	Login 
----5/6/2014 6:09:49 PM      cctong--VIRTUAL-WIN7PRO(12.0.0.1)--SSL Disabled	Login 
----5/6/2014 6:12:37 PM      cctong--VIRTUAL-WIN7PRO(12.0.0.0)--SSL Disabled	Login 
----5/6/2014 6:13:42 PM      jwliaw--SDD-JW_LIAW(192.0.0.86)--SSL Disabled	Logout 
----5/6/2014 6:13:52 PM      jwliaw--SDD-JW_LIAW(192.0.0.86)--SSL Disabled	Logout 
----5/6/2014 6:14:04 PM      jwliaw--SDD-JW_LIAW(192.0.0.86)--SSL Disabled	Login 
----5/6/2014 6:14:53 PM      jwliaw--SDD-JW_LIAW(192.0.0.86)--SSL Disabled	Logout 
----5/6/2014 6:16:39 PM      lskim--LSKIM(192.0.0.28)--SSL Disabled	Logout 
----5/6/2014 6:45:58 PM      bkchung--MAC-SPARE-PC(192.0.0.78)--SSL Disabled	Login 
----5/6/2014 6:48:04 PM      pwkok--HP-CNU0123M6G(192.0.0.191)--SSL Disabled	Logout 
----5/6/2014 6:48:59 PM      pwkok--HP-CNU0123M6G(192.0.0.191)--SSL Disabled	Logout 
----5/6/2014 6:56:16 PM      zhlee--SDD-ZHLEE(192.0.0.59)--SSL Disabled	Logout 
----5/6/2014 7:03:07 PM      sychew--SDD-SY_CHEW(192.0.0.221)--SSL Disabled	Logout 
----5/6/2014 7:03:14 PM      sychew--SDD-SY_CHEW(192.0.0.221)--SSL Disabled	Logout 
----5/6/2014 7:03:59 PM      sychew--SDD-SY_CHEW(192.0.0.221)--SSL Disabled	Logout 
----5/6/2014 7:06:33 PM      sychew--CSD-SYCHEW(192.0.0.222)--SSL Disabled	Login 
----5/6/2014 7:06:54 PM      sychew--CSD-SYCHEW(192.0.0.222)--SSL Disabled	Logout 
----5/6/2014 7:12:11 PM      clboo--CL_BOO(192.0.0.35)--SSL Disabled	Login 
----5/6/2014 7:12:27 PM      zhlee--SDD-ZHLEE(192.0.0.59)--SSL Disabled	Logout 
----5/6/2014 7:49:23 PM      bkchung--MAC-SPARE-PC(192.0.0.78)--SSL Disabled	Logout 
----5/6/2014 8:07:24 PM      chlim--CSD-CHLIM(192.0.0.41)--SSL Disabled	Login 
----5/6/2014 8:10:01 PM      chlim--CSD-CHLIM(192.0.0.41)--SSL Disabled	Logout 
----5/6/2014 8:10:47 PM      chlim--192.0.0.41(192.0.0.41)--SSL Disabled	Login 
----5/6/2014 8:16:59 PM      chlim--192.0.0.41(192.0.0.41)--SSL Disabled	Logout 
----5/6/2014 9:54:44 PM      clboo--CL_BOO(192.0.0.35)--SSL Disabled	Logout 

Error message still appear in Vault Client. I was leaving my laptop in standby mode.

Code: Select all

[7/5/2014 4:39:44 PM]     Fetched $/NT-001 - Lens AVI & Taping Machine/Source Code/MCSP/SeqServer/Machine Sequence/Unwinder.cs
[7/5/2014 7:22:29 PM] An error occurred retrieving application notification messages from http://www.mmsvault.com/VaultNotifyService/VaultNotifyService.asmx -  Failure	
sgvault.log

Code: Select all

----5/7/2014 7:16:20 PM      sychew--SDD-SY_CHEW(192.0.0.67)--SSL Disabled	Logout 
----5/7/2014 7:16:36 PM      sychew--SDD-SY_CHEW(192.0.0.67)--SSL Disabled	Logout 
----5/7/2014 7:25:48 PM      pwkok--SDD-PW_KOK(192.0.0.60)--SSL Disabled	Logout 
----5/7/2014 7:25:48 PM      pwkok--SDD-PW_KOK(192.0.0.60)--SSL Disabled	Logout 
----5/7/2014 7:37:41 PM      wcchew--VIRTUALXP_WC(192.0.0.91)--SSL Disabled	Logout 
----5/7/2014 7:37:41 PM      wcchew--VIRTUALXP_WC(192.0.0.90)--SSL Disabled	Login 
----5/7/2014 7:48:25 PM      chlim--192.0.0.41(192.0.0.41)--SSL Disabled	Logout 
----5/7/2014 8:16:32 PM      cctong--VIRTUAL-WIN7PRO(192.0.0.57)--SSL Disabled	Logout 
Joel
Micro Modular System
http://www.mmsis.com

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

Re: Error retrieve notification message

Post by Beth » Thu May 08, 2014 7:48 am

Do you have Application Notifications turned on? To check that setting, go to Vault - Tools - Options - Notifications.
Beth Kieler
SourceGear Technical Support

jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Re: Error retrieve notification message

Post by jkp*74 » Thu May 08, 2014 8:25 pm

Yes
You do not have the required permissions to view the files attached to this post.
Joel
Micro Modular System
http://www.mmsis.com

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

Re: Error retrieve notification message

Post by Beth » Fri May 09, 2014 7:32 am

What I suspect might be happening is that whenever your computer sleeps, Vault notifications might not be able to update. What you might try to just test that idea is to turn off the Application Notifications, then let your computer sleep, and then see if you get an error. Then turn them back on, let the computer sleep, and see if you get an error.
Beth Kieler
SourceGear Technical Support

jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Re: Error retrieve notification message

Post by jkp*74 » Fri May 09, 2014 9:24 pm

I figure that is the cause.

What happen to the notification service after this message?
[6/5/2014 7:12:39 PM] Too many errors occurred retrieving application notification messagesfrom http://www.mmsvault.com/VaultNotifyServ ... rvice.asmx. Notifications retrieval has been disabled.

Will the notification service resume when i continue to use the computer?
Joel
Micro Modular System
http://www.mmsis.com

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

Re: Error retrieve notification message

Post by Beth » Mon May 12, 2014 9:49 am

Notifications are turned off until the client is restarted.
Beth Kieler
SourceGear Technical Support

jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Re: Error retrieve notification message

Post by jkp*74 » Mon May 12, 2014 7:10 pm

Thanks for the feedback.
I personally like the notification service feature (which was not found in Vault 5).
However, i would like to add to my wishlist to allow notification service to continue to run - after the computer wakes up from sleep mode.
Joel
Micro Modular System
http://www.mmsis.com

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

Re: Error retrieve notification message

Post by Beth » Tue May 13, 2014 8:26 am

I've put in a request for notifications to resume from sleep mode. Thank you for your feedback.

F: 17668
Beth Kieler
SourceGear Technical Support

Post Reply