2023-04-04 00:36:59.0439 System.Web.HttpException (0x80004005): The file '/owa/auth/logon.aspx' does not exist. at System.Web.UI.Util.CheckVirtualFileExists(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.UI.PageHandlerFactory.GetHandler(HttpContext context, String requestType, String virtualPath, String path) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) System.Web.HttpException (0x80004005): The file '/owa/auth/logon.aspx' does not exist. at System.Web.UI.Util.CheckVirtualFileExists(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.UI.PageHandlerFactory.GetHandler(HttpContext context, String requestType, String virtualPath, String path) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 2023-04-04 09:03:16.6560 System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.ApplicationException: Response.Redirect cannot be called in a Page callback. at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at System.Web.HttpResponse.Redirect(String url) at SilSolver.WEB.Services.SecurityService.AssertLoggedIn() in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services\SecurityService.cs:line 187 at SilSolver.WEB.ProjectMain.Page_Load(Object sender, EventArgs e) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProjectMain.aspx.cs:line 103 at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 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.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.projectmain_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\1ad9780d\73f7e456\App_Web_ejvl0jyh.3.cs:line 0 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.ApplicationException: Response.Redirect cannot be called in a Page callback. at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at System.Web.HttpResponse.Redirect(String url) at SilSolver.WEB.Services.SecurityService.AssertLoggedIn() in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services\SecurityService.cs:line 187 at SilSolver.WEB.ProjectMain.Page_Load(Object sender, EventArgs e) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProjectMain.aspx.cs:line 103 at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 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.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.projectmain_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\1ad9780d\73f7e456\App_Web_ejvl0jyh.3.cs:line 0 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 2023-04-04 11:39:11.5141 System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Exception: Unauthorized at SilSolver.WEB.Services.SecurityService.AssertHasAccessToProject(Int32 projectId) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services\SecurityService.cs:line 107 at SilSolver.BLL.ProtectiveFunctionService.DT_GetProtectiveFunction_By_ProjectKey(Int32 ProjectId) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services\ProtectiveFunctionService.cs:line 60 at SilSolver.WEB.ProjectEdit.Load_ProtectiveFunction_Grid() in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProjectEdit.aspx.cs:line 294 at SilSolver.WEB.ProjectEdit.Page_Load(Object sender, EventArgs e) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProjectEdit.aspx.cs:line 89 at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 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.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.projectedit_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\1ad9780d\73f7e456\App_Web_tlzf4y01.9.cs:line 0 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Exception: Unauthorized at SilSolver.WEB.Services.SecurityService.AssertHasAccessToProject(Int32 projectId) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services\SecurityService.cs:line 107 at SilSolver.BLL.ProtectiveFunctionService.DT_GetProtectiveFunction_By_ProjectKey(Int32 ProjectId) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services\ProtectiveFunctionService.cs:line 60 at SilSolver.WEB.ProjectEdit.Load_ProtectiveFunction_Grid() in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProjectEdit.aspx.cs:line 294 at SilSolver.WEB.ProjectEdit.Page_Load(Object sender, EventArgs e) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProjectEdit.aspx.cs:line 89 at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 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.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.projectedit_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\1ad9780d\73f7e456\App_Web_tlzf4y01.9.cs:line 0 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 2023-04-04 11:39:14.5621 System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Exception: Unauthorized at SilSolver.WEB.Services.SecurityService.AssertHasAccessToProject(Int32 projectId) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services\SecurityService.cs:line 107 at SilSolver.BLL.ProtectiveFunctionService.DT_GetProtectiveFunction_By_ProjectKey(Int32 ProjectId) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services\ProtectiveFunctionService.cs:line 60 at SilSolver.WEB.ProjectEdit.Load_ProtectiveFunction_Grid() in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProjectEdit.aspx.cs:line 294 at SilSolver.WEB.ProjectEdit.Page_Load(Object sender, EventArgs e) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProjectEdit.aspx.cs:line 89 at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 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.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.projectedit_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\1ad9780d\73f7e456\App_Web_tlzf4y01.9.cs:line 0 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Exception: Unauthorized at SilSolver.WEB.Services.SecurityService.AssertHasAccessToProject(Int32 projectId) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services\SecurityService.cs:line 107 at SilSolver.BLL.ProtectiveFunctionService.DT_GetProtectiveFunction_By_ProjectKey(Int32 ProjectId) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services\ProtectiveFunctionService.cs:line 60 at SilSolver.WEB.ProjectEdit.Load_ProtectiveFunction_Grid() in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProjectEdit.aspx.cs:line 294 at SilSolver.WEB.ProjectEdit.Page_Load(Object sender, EventArgs e) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProjectEdit.aspx.cs:line 89 at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 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.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.projectedit_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\1ad9780d\73f7e456\App_Web_tlzf4y01.9.cs:line 0 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 2023-04-04 11:39:18.0350 System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Exception: Unauthorized at SilSolver.WEB.Services.SecurityService.AssertHasAccessToProject(Int32 projectId) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services\SecurityService.cs:line 107 at SilSolver.BLL.ProtectiveFunctionService.DT_GetProtectiveFunction_By_ProjectKey(Int32 ProjectId) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services\ProtectiveFunctionService.cs:line 60 at SilSolver.WEB.ProjectEdit.Load_ProtectiveFunction_Grid() in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProjectEdit.aspx.cs:line 294 at SilSolver.WEB.ProjectEdit.Page_Load(Object sender, EventArgs e) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProjectEdit.aspx.cs:line 89 at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 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.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.projectedit_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\1ad9780d\73f7e456\App_Web_tlzf4y01.9.cs:line 0 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Exception: Unauthorized at SilSolver.WEB.Services.SecurityService.AssertHasAccessToProject(Int32 projectId) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services\SecurityService.cs:line 107 at SilSolver.BLL.ProtectiveFunctionService.DT_GetProtectiveFunction_By_ProjectKey(Int32 ProjectId) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services\ProtectiveFunctionService.cs:line 60 at SilSolver.WEB.ProjectEdit.Load_ProtectiveFunction_Grid() in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProjectEdit.aspx.cs:line 294 at SilSolver.WEB.ProjectEdit.Page_Load(Object sender, EventArgs e) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProjectEdit.aspx.cs:line 89 at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 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.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.projectedit_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\1ad9780d\73f7e456\App_Web_tlzf4y01.9.cs:line 0 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 2023-04-04 11:46:10.5191 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40246, INP2, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40246, INP2, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 11:46:10.5660 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40246, INP2, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40246, INP2, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 252 ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 11:46:10.5816 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40246, INP2, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40246, INP2, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 256 at SilSolver.WEB.ProtectiveFunctionHTML.BindAndSaveDevice(String Source, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId, Decimal PositionInput, PSF_ProtectiveFunctionComments psf_ProtectiveFunctionComments, String divId, String voting) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1257 ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 11:49:58.0809 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40246, A1O1, D11 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40246, A1O1, D11 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 11:49:58.0965 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40246, A1O1, D11 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40246, A1O1, D11 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 252 ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 11:49:58.0965 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40246, A1O1, D11 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40246, A1O1, D11 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 256 at SilSolver.WEB.ProtectiveFunctionHTML.BindAndSaveDevice(String Source, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId, Decimal PositionInput, PSF_ProtectiveFunctionComments psf_ProtectiveFunctionComments, String divId, String voting) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1257 ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 11:58:20.0729 Divide by zero error encountered. System.Data.SqlClient.SqlException (0x80131904): Divide by zero error encountered. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at SilSolver.DAL.DbProviderHelper.ExecuteNonQuery(DbCommand dbCommand) ClientConnectionId:d8824551-6e87-46e8-8e5a-f77ef0ed669d Error Number:8134,State:1,Class:16 2023-04-04 11:58:20.0729 Divide by zero error encountered. System.Data.SqlClient.SqlException (0x80131904): Divide by zero error encountered. at SilSolver.DAL.DbProviderHelper.ExecuteNonQuery(DbCommand dbCommand) at SilSolver.DAL.PT_ProtectiveFunctionService.CalculationProcedure(Int32 ProtectiveId_FK, String Redundant, Decimal In1Beta, Decimal In2Beta, Decimal In3Beta, Decimal In4Beta, Decimal In5Beta, Decimal In6Beta, Decimal In7Beta, Decimal In8Beta, Decimal In9Beta, Decimal In10Beta, String In1Voting, String In2Voting, String In3Voting, String In4Voting, String In5Voting, String In6Voting, String In7Voting, String In8Voting, String In9Voting, String In10Voting, Int32 UserID, String deviceVersion) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 444 ClientConnectionId:d8824551-6e87-46e8-8e5a-f77ef0ed669d Error Number:8134,State:1,Class:16 2023-04-04 11:58:20.0729 Divide by zero error encountered. System.Data.SqlClient.SqlException (0x80131904): Divide by zero error encountered. at SilSolver.DAL.PT_ProtectiveFunctionService.CalculationProcedure(Int32 ProtectiveId_FK, String Redundant, Decimal In1Beta, Decimal In2Beta, Decimal In3Beta, Decimal In4Beta, Decimal In5Beta, Decimal In6Beta, Decimal In7Beta, Decimal In8Beta, Decimal In9Beta, Decimal In10Beta, String In1Voting, String In2Voting, String In3Voting, String In4Voting, String In5Voting, String In6Voting, String In7Voting, String In8Voting, String In9Voting, String In10Voting, Int32 UserID, String deviceVersion) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 454 at SilSolver.WEB.ProtectiveFunctionHTML.Calculation(Int32 Pid, String reduntantvalue, Decimal ccfval1, Decimal ccfval2, Decimal ccfval3, Decimal ccfval4, Decimal ccfval5, Decimal ccfval6, Decimal ccfval7, Decimal ccfval8, Decimal ccfval9, Decimal ccfval10, String inputvoting1, String inputvoting2, String inputvoting3, String inputvoting4, String inputvoting5, String actionvoting1, String actionvoting2, String actionvoting3, String actionvoting4, String actionvoting5) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2804 ClientConnectionId:d8824551-6e87-46e8-8e5a-f77ef0ed669d Error Number:8134,State:1,Class:16 2023-04-04 12:04:40.3892 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 12:04:40.3892 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 252 ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 12:04:40.3892 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 256 at SilSolver.WEB.ProtectiveFunctionHTML.BindAndSaveDevice(String Source, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId, Decimal PositionInput, PSF_ProtectiveFunctionComments psf_ProtectiveFunctionComments, String divId, String voting) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1257 ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 12:06:21.3302 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, LSO1, ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, LSO1, ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 12:06:21.3302 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, LSO1, ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, LSO1, ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 252 ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 12:07:44.3867 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16. at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt16(String value) at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926 2023-04-04 12:08:02.7987 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D21 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D21 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 12:08:02.7987 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D21 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D21 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 252 ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 12:08:02.7987 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D21 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D21 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 256 at SilSolver.WEB.ProtectiveFunctionHTML.BindAndSaveDevice(String Source, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId, Decimal PositionInput, PSF_ProtectiveFunctionComments psf_ProtectiveFunctionComments, String divId, String voting) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1257 ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 12:08:03.3634 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D21 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D21 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 12:08:03.3634 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D21 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D21 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 252 ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 12:08:03.3634 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D21 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D21 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 256 at SilSolver.WEB.ProtectiveFunctionHTML.BindAndSaveDevice(String Source, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId, Decimal PositionInput, PSF_ProtectiveFunctionComments psf_ProtectiveFunctionComments, String divId, String voting) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1257 ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 12:08:19.8011 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D11 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D11 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) ClientConnectionId:1805ef79-be11-436b-814e-f5434c94bf0c Error Number:2601,State:1,Class:14 2023-04-04 12:08:19.8011 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D11 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D11 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 252 ClientConnectionId:1805ef79-be11-436b-814e-f5434c94bf0c Error Number:2601,State:1,Class:14 2023-04-04 12:08:19.8011 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D11 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D11 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 256 at SilSolver.WEB.ProtectiveFunctionHTML.BindAndSaveDevice(String Source, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId, Decimal PositionInput, PSF_ProtectiveFunctionComments psf_ProtectiveFunctionComments, String divId, String voting) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1257 ClientConnectionId:1805ef79-be11-436b-814e-f5434c94bf0c Error Number:2601,State:1,Class:14 2023-04-04 12:08:59.8614 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16. at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt16(String value) at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926 2023-04-04 12:09:04.6106 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D22 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D22 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) ClientConnectionId:1805ef79-be11-436b-814e-f5434c94bf0c Error Number:2601,State:1,Class:14 2023-04-04 12:09:04.6106 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D22 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D22 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 252 ClientConnectionId:1805ef79-be11-436b-814e-f5434c94bf0c Error Number:2601,State:1,Class:14 2023-04-04 12:09:04.6106 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D22 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D22 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 256 at SilSolver.WEB.ProtectiveFunctionHTML.BindAndSaveDevice(String Source, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId, Decimal PositionInput, PSF_ProtectiveFunctionComments psf_ProtectiveFunctionComments, String divId, String voting) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1257 ClientConnectionId:1805ef79-be11-436b-814e-f5434c94bf0c Error Number:2601,State:1,Class:14 2023-04-04 12:09:04.9700 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D22 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D22 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 12:09:04.9857 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D22 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D22 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 252 ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 12:09:04.9857 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D22 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D22 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 256 at SilSolver.WEB.ProtectiveFunctionHTML.BindAndSaveDevice(String Source, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId, Decimal PositionInput, PSF_ProtectiveFunctionComments psf_ProtectiveFunctionComments, String divId, String voting) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1257 ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 12:09:07.3457 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) ClientConnectionId:1805ef79-be11-436b-814e-f5434c94bf0c Error Number:2601,State:1,Class:14 2023-04-04 12:09:07.3457 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 252 ClientConnectionId:1805ef79-be11-436b-814e-f5434c94bf0c Error Number:2601,State:1,Class:14 2023-04-04 12:09:07.3457 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 256 at SilSolver.WEB.ProtectiveFunctionHTML.BindAndSaveDevice(String Source, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId, Decimal PositionInput, PSF_ProtectiveFunctionComments psf_ProtectiveFunctionComments, String divId, String voting) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1257 ClientConnectionId:1805ef79-be11-436b-814e-f5434c94bf0c Error Number:2601,State:1,Class:14 2023-04-04 12:09:07.4082 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) ClientConnectionId:1805ef79-be11-436b-814e-f5434c94bf0c Error Number:2601,State:1,Class:14 2023-04-04 12:09:07.4082 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 252 ClientConnectionId:1805ef79-be11-436b-814e-f5434c94bf0c Error Number:2601,State:1,Class:14 2023-04-04 12:09:07.4082 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 256 at SilSolver.WEB.ProtectiveFunctionHTML.BindAndSaveDevice(String Source, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId, Decimal PositionInput, PSF_ProtectiveFunctionComments psf_ProtectiveFunctionComments, String divId, String voting) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1257 ClientConnectionId:1805ef79-be11-436b-814e-f5434c94bf0c Error Number:2601,State:1,Class:14 2023-04-04 12:10:57.5881 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16. at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt16(String value) at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926 2023-04-04 12:11:26.2241 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16. at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt16(String value) at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926 2023-04-04 12:11:57.6634 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16. at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt16(String value) at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926 2023-04-04 12:12:05.0228 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 12:12:05.0384 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 252 ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 12:12:05.0384 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 256 at SilSolver.WEB.ProtectiveFunctionHTML.BindAndSaveDevice(String Source, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId, Decimal PositionInput, PSF_ProtectiveFunctionComments psf_ProtectiveFunctionComments, String divId, String voting) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1257 ClientConnectionId:2ca26901-aa2d-43bf-b21f-ec6d0229c6f4 Error Number:2601,State:1,Class:14 2023-04-04 12:12:22.7790 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16. at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt16(String value) at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926 2023-04-04 12:12:53.5178 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16. at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt16(String value) at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926 2023-04-04 12:14:12.5278 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16. at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt16(String value) at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926 2023-04-04 12:23:47.6468 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D11 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D11 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) ClientConnectionId:1805ef79-be11-436b-814e-f5434c94bf0c Error Number:2601,State:1,Class:14 2023-04-04 12:23:47.6468 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D11 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D11 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForPasteData(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 PM_Id, Int32 userid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 648 ClientConnectionId:1805ef79-be11-436b-814e-f5434c94bf0c Error Number:2601,State:1,Class:14 2023-04-04 12:23:47.6468 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D11 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D11 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForPasteData(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 PM_Id, Int32 userid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 653 at SilSolver.WEB.ProtectiveFunctionHTML.BindPasteSaveDevice(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1304 ClientConnectionId:1805ef79-be11-436b-814e-f5434c94bf0c Error Number:2601,State:1,Class:14 2023-04-04 12:23:51.2098 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) ClientConnectionId:1805ef79-be11-436b-814e-f5434c94bf0c Error Number:2601,State:1,Class:14 2023-04-04 12:23:51.2098 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForPasteData(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 PM_Id, Int32 userid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 648 ClientConnectionId:1805ef79-be11-436b-814e-f5434c94bf0c Error Number:2601,State:1,Class:14 2023-04-04 12:23:51.2098 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40248, A1O1, D12 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForPasteData(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 PM_Id, Int32 userid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 653 at SilSolver.WEB.ProtectiveFunctionHTML.BindPasteSaveDevice(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1304 ClientConnectionId:1805ef79-be11-436b-814e-f5434c94bf0c Error Number:2601,State:1,Class:14 2023-04-04 12:43:00.5770 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16. at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt16(String value) at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926 2023-04-04 14:44:22.5845 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16. at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt16(String value) at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926 2023-04-04 14:44:45.8475 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16. at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt16(String value) at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926 2023-04-04 14:45:36.7878 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16. at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt16(String value) at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926 2023-04-04 14:50:29.0483 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16. at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt16(String value) at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926 2023-04-04 14:50:56.3411 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16. at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt16(String value) at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926 2023-04-04 14:55:55.4321 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40251, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40251, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) ClientConnectionId:ccbaa573-894f-4f71-9fb9-363ac6a45932 Error Number:2601,State:1,Class:14 2023-04-04 14:55:55.4477 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40251, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40251, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 252 ClientConnectionId:ccbaa573-894f-4f71-9fb9-363ac6a45932 Error Number:2601,State:1,Class:14 2023-04-04 14:55:55.4477 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40251, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40251, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 256 at SilSolver.WEB.ProtectiveFunctionHTML.BindAndSaveDevice(String Source, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId, Decimal PositionInput, PSF_ProtectiveFunctionComments psf_ProtectiveFunctionComments, String divId, String voting) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1257 ClientConnectionId:ccbaa573-894f-4f71-9fb9-363ac6a45932 Error Number:2601,State:1,Class:14 2023-04-04 14:56:09.3250 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16. at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt16(String value) at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926 2023-04-04 14:56:20.6984 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16. at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt16(String value) at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926 2023-04-04 14:56:25.8065 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16. at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt16(String value) at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926 2023-04-04 14:56:43.4716 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16. at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt16(String value) at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926 2023-04-04 14:56:58.8852 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40251, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40251, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) ClientConnectionId:68cc9ae1-3f7c-4e5e-b420-87751245749d Error Number:2601,State:1,Class:14 2023-04-04 14:56:58.9008 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40251, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40251, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 252 ClientConnectionId:68cc9ae1-3f7c-4e5e-b420-87751245749d Error Number:2601,State:1,Class:14 2023-04-04 14:56:58.9008 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40251, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40251, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 256 at SilSolver.WEB.ProtectiveFunctionHTML.BindAndSaveDevice(String Source, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId, Decimal PositionInput, PSF_ProtectiveFunctionComments psf_ProtectiveFunctionComments, String divId, String voting) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1257 ClientConnectionId:68cc9ae1-3f7c-4e5e-b420-87751245749d Error Number:2601,State:1,Class:14 2023-04-04 15:00:14.5500 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40251, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40251, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) ClientConnectionId:ccbaa573-894f-4f71-9fb9-363ac6a45932 Error Number:2601,State:1,Class:14 2023-04-04 15:00:14.5656 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40251, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40251, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter) at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 252 ClientConnectionId:ccbaa573-894f-4f71-9fb9-363ac6a45932 Error Number:2601,State:1,Class:14 2023-04-04 15:00:14.5656 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40251, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40251, INP1, D23 ). Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForData(PT_ProtectiveFunction oPT_ProtectiveFunction) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 256 at SilSolver.WEB.ProtectiveFunctionHTML.BindAndSaveDevice(String Source, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId, Decimal PositionInput, PSF_ProtectiveFunctionComments psf_ProtectiveFunctionComments, String divId, String voting) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1257 ClientConnectionId:ccbaa573-894f-4f71-9fb9-363ac6a45932 Error Number:2601,State:1,Class:14