Exception messages of System.Data.SqlClient.SqlException

[Andy_Miller]

In our environment, we are receiving a Failure Rate increase on the Database alert from our monitoring software every Monday-Saturday morning. See below. Additionally, this alert occurs between 4:30am and 6:30am CST, when a very limited amount of colleagues are in the office. The fact that it doesn't occur at the same time every day is leading me away from it being a scheduled process. Our database team assures us this is not something on their end. This particular alert is referencing all the failures for hsi.doccheckout. However, a good portion of them also have a lot of failures for hsi.lockkeys. Any ideas as to what the issue would be would be appreciated! As an FYI, I did send this all to FLOS as well, but thought I would put more eyes on the issue in hopes to find a quicker resolution. And when I go into Details of Root cause, this is what displays:

Exception messages of System.Data.SqlClient.SqlException
Cannot insert duplicate key row in object 'hsi.doccheckout' with unique index '*****'. The duplicate key value is (*****, *****). The statement has been terminated.
Stacktraces of exceptions
System.Data.SqlClient.SqlConnection.OnError[-]
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning
System.Data.SqlClient.TdsParser.TryRun
System.Data.SqlClient.SqlCommand.FinishExecuteReader
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds
System.Data.SqlClient.SqlCommand.RunExecuteReader
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery
System.Data.SqlClient.SqlCommand.ExecuteNonQuery
Hyland.Data.Database.OnBaseDatabase+<>c__DisplayClass33_0.<doExecuteNonQuery>b__0[-]
Hyland.Data.Database.RepeatableExecution`1.Execute
Hyland.Data.Database.OnBaseDatabase.doExecuteNonQuery
Hyland.Data.Database.OnBaseDatabase.ExecuteNonQuery
Hyland.Data.DataOperation.executeNonQuery
Hyland.Data.ImplicitTransactionDataOperation.executeNonQuery
Hyland.Data.DataOperation.insert
Hyland.Data.DataOperation.Insert
Hyland.Core.Data.LockableItemDataAccess.InsertInTransaction[-]
Hyland.Core.LockManager+LockMethodUniqueIndex.lockItemOrGetLockState
Hyland.Core.LockManager+LockMethodUniqueIndex.TryLock
Hyland.Core.LockManager.tryLock
Hyland.Core.LockManager.TryLock
Hyland.Core.LockManager.TryLock
Hyland.Core.Document.tryLock
Hyland.Core.Document.TryLock
Hyland.Core.Forms.FormTemplateRepository.GetDocumentLock
Hyland.Canvas.Services.Common.UnityForms.UnityFormsServices.GetFormInstanceCore[-]
Hyland.Canvas.Services.Common.UnityForms.UnityFormsServices.GetFormInstanceForUnityClient
System.RuntimeMethodHandle.InvokeMethod
System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal[-]
System.Reflection.RuntimeMethodInfo.Invoke
System.Reflection.MethodBase.Invoke
Hyland.Services.Static.ServiceMethodDefinition.Execute[-]
Hyland.Services.Static.ServiceMethodInstance.Execute
Hyland.Services.Handler.InvokeStaticServiceMethodOrNull
Hyland.Services.Handler.HandleRequest
Hyland.Services.Handler.HandleRequest
Hyland.Services.Dispatcher.Dispatch
Hyland.Services.Dispatcher.dispatchAll
Hyland.Services.Dispatcher.DispatchAll
Hyland.Services.ServicePipeline.ProcessRequest
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute[-]
System.Web.HttpApplication.ExecuteStepImpl
System.Web.HttpApplication.ExecuteStep
System.Web.HttpApplication+PipelineStepManager.ResumeSteps
System.Web.HttpApplication.BeginProcessRequestNotification
System.Web.HttpRuntime.ProcessRequestNotificationPrivate
System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper
System.Web.Hosting.PipelineRuntime.ProcessRequestNotification

[James_Perry]

Do you know if there is a file application server or IIS reset, file backup process, data extraction, and/or virus scan that happens on a schedule?

Scheduled tasks may be queued to launch at specific times but in OnBase and Windows there is leeway due to system variables such as available resources, prior tasks, etc.