Vault Pro 6: Email settings error

[mbainbridge]

Just testing Vault Pro 6 on a VM copy of our server. The live system is Vault Pro 5.1.2, Win2003 R2 with SQL 2005 Standard (both 32-bit). The VM is running trial copies of Windows 2008 R2 SP1, SQL 2012, both 64-bit, fresh from Microsoft. On the web admin pages, going to the Email Settings option gives the error "Index was outside the bounds of the array".

The server's sgvault.log has this:

----06/08/2012 10:19:12 admin--::1(::1)--SSL Disabled DB: GetEmailSettings started.
----06/08/2012 10:19:12 admin--::1(::1)--SSL Disabled DB: GetEmailSettings finished.
----06/08/2012 10:19:12 admin--::1(::1)--SSL Disabled Uncaught Exception: Exception of type 'System.Web.HttpUnhandledException' was thrown.
Inner Exception: Index was outside the bounds of the array.
----06/08/2012 10:19:12 admin--::1(::1)--SSL Disabled at System.Web.UI.Page.HandleError(Exception e)
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)
Inner Exeption Stack Trace: at VaultService.EmailSettings.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
----06/08/2012 10:19:12 admin--::1(::1)--SSL Disabled DB: GetUserRepositories started.
----06/08/2012 10:19:12 admin--::1(::1)--SSL Disabled DB: GetUserRepositories finished.
----06/08/2012 10:19:12 admin--::1(::1)--SSL Disabled DB: GetUserProjects started.
----06/08/2012 10:19:12 admin--::1(::1)--SSL Disabled DB: GetUserProjects finished.
----06/08/2012 10:19:12 admin--::1(::1)--SSL Disabled System.IndexOutOfRangeException: Index was outside the bounds of the array.
at VaultService.EmailSettings.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at VaultService.EmailSettings.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
----06/08/2012 10:19:12 admin--::1(::1)--SSL Disabled WEB: Finshed loading Error

[lbauer]

Is the email page working fine on the Vault 5.1.2 installation?

Did you restore a copy of the Vault 5.1.2 database on the new VM and then upgrade to Vault 6?

At what point do you get the error? When you click on the Email Settings link, or when you try to send a test message?

[mbainbridge]

Yes, it works fine in 5.1.2.

I took an SQL backup, transferred, restored and attached it to the 2012 server, then installed VP6. This is the same way I've tested previous releases. Only the server and SQL versions are new, so it's possibly something to do with this.

I get the error as soon as I click the "Email Settings" link.

[lbauer]

I tried upgrading my Vault Pro 5.1.2 databases on a Win 2008 R2 SP1 machine with SQL Server 2012, and was able to access the email settings with no problem.

So there may be something specific to your configuration. Is there any information in the Windows Event Viewer on the the Vault Server machine that might be helpful?

Any other links in the Vault Admin Web Client that cause an error?

[lbauer]

Also, could you run this query in SQL Server so we can see your current email settings? If you'd rather not post the results here, send them to support at sourcegear.com, Attn: Linda. Please include a link to this forum post.

select * from sgmaster.dbo.sgmastersettings

We'd also like to see a copy of the Vault Server log.

[hwapdc]

I do see the same issue after upgrading from Vault 5 til Vault 6 (Standard)

sgvault log:
----07-09-2012 18:48:12 admin--hwa-1269.pdc.xx(10.117.33.1)--SSL Disabled Uncaught Exception: Exception of type 'System.Web.HttpUnhandledException' was thrown.
Inner Exception: Index was outside the bounds of the array.
----07-09-2012 18:48:12 admin--hwa-1269.pdc.xx(10.117.33.1)--SSL Disabled at System.Web.UI.Page.HandleError(Exception e)
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)
Inner Exeption Stack Trace: at VaultService.EmailSettings.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
----07-09-2012 18:48:12 admin--hwa-1269.pdc.xx(10.117.33.1)--SSL Disabled System.IndexOutOfRangeException: Index was outside the bounds of the array.
at VaultService.EmailSettings.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at VaultService.EmailSettings.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


SQL Query
select * from sgmaster.dbo.sgmastersettings
result
schemaversion serverurl smtpserver smtpserverport smtpconnectiontimeout smtpusessl smtpauthenticationtype smtpusername smtppassword emailfromaddress activedirectorydomains protecttreeintegrity digestsendtime digestlastsent
6.0.0.2 vault.pdc.xx mail.pdc.xx 25 30 0 1 vault@pdc.xx pdc.xx 1 1900-01-01 08:00:00.000 2012-09-07 12:28:50.917

The time stamps in digestsendtime digestlastsent seems very odd

How do I correct this

[jclausius]

hwapdc,

Check out the release notes from Vault 6.0.1 - http://www.sourcegear.com/vault/release ... 6.0.1.html

"Fixed 'Index was outside the bounds of the array' error when viewing 'Email Settings' on systems configured to use a 24-hour clock."

Does this apply to you?

[hwapdc]

Yes is certainly apply to me. I have just upgraded to Version 6.0.0.477 Installed 07 september 2012. I have prepared the update for some days (using a copy of the live database)
Sigh, I will have to schedule another update
Thanks for pointing out the availability of version 6.0.1.

[lbauer]

Let us know if Vault 6.0.1 solves the email problem.