2022-11-21 00:29:10.8040 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) 2022-11-21 11:54:55.0787 Thread was being aborted. System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.End() at SilSolver.WEB.ProjectEdit.ExportConfirmButtonClick(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 1404 2022-11-21 12:05:52.5466 Thread was being aborted. System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.End() at SilSolver.WEB.ProjectEdit.ExportConfirmButtonClick(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 1404 2022-11-21 21:18:42.4693 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:18:42.5631 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:19:23.1351 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:19:23.1351 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:19:23.1351 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:19:47.9285 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:19:47.9285 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:19:47.9285 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:19:49.6817 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, A1O2, 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 (39976, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:19:49.6817 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, A1O2, 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 (39976, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:19:49.6817 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, A1O2, 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 (39976, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:20:04.3342 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:20:04.3342 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:20:04.3342 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:20:06.5763 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, A1O2, 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 (39976, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:20:06.5763 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, A1O2, 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 (39976, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:20:06.5763 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, A1O2, 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 (39976, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:41:24.5191 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:41:24.5191 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:41:24.5191 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:41:25.5842 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:41:25.5842 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:41:25.5842 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:41:27.3266 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, A1O2, 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 (39976, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:41:27.3266 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, A1O2, 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 (39976, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:41:27.3266 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, A1O2, 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 (39976, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:41:28.1563 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, A1O2, 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 (39976, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:41:28.1563 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, A1O2, 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 (39976, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:41:28.1563 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, A1O2, 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 (39976, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:44:16.6532 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:44:16.6532 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:44:16.6532 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:44:16.7782 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:44:16.7782 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:44:16.7782 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, 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 (39976, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:44:18.1485 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, A1O2, 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 (39976, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:44:18.1485 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, A1O2, 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 (39976, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:44:18.1485 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39976, A1O2, 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 (39976, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 21:47:09.9089 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 2022-11-21 21:47:23.4794 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 2022-11-21 21:47:42.3970 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 2022-11-21 21:47:49.0172 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 2022-11-21 21:48:08.9756 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 2022-11-21 21:57:13.4062 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 2022-11-21 21:57:55.2206 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 2022-11-21 21:58:12.8130 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 2022-11-21 21:58:28.8808 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 2022-11-21 21:58:39.8171 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 2022-11-21 22:02:07.3144 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 2022-11-21 22:03:04.9836 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, 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 (39974, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:04.9836 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, 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 (39974, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:04.9836 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, 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 (39974, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:05.1086 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, A1O2, 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 (39974, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:05.1086 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, A1O2, 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 (39974, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:05.1086 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, A1O2, 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 (39974, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:06.1417 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, A1O2, 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 (39974, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:06.1417 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, A1O2, 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 (39974, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:06.1417 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, A1O2, 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 (39974, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:06.5263 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, 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 (39974, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:06.5263 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, 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 (39974, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:06.5263 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, 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 (39974, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:18.1107 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, 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 (39974, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:18.1107 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, 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 (39974, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:18.1107 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, 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 (39974, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:19.8586 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, A1O2, 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 (39974, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:19.8586 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, A1O2, 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 (39974, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:19.8586 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, A1O2, 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 (39974, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:20.1399 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, A1O2, 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 (39974, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:20.1399 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, A1O2, 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 (39974, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:20.1399 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, A1O2, 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 (39974, A1O2, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:20.2024 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, 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 (39974, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:20.2024 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, 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 (39974, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:03:20.2024 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39974, 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 (39974, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:25:38.2232 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, 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 (39982, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:25:38.2232 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, 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 (39982, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:26:59.7164 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, D31 ). 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 (39982, INP1, D31 ). 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:26:59.7164 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, D31 ). 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 (39982, INP1, D31 ). 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:26:59.7164 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, D31 ). 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 (39982, INP1, D31 ). 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:27:00.7639 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, 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 (39982, INP1, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:27:00.7639 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, 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 (39982, INP1, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:27:00.7639 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, 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 (39982, INP1, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:27:01.9659 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, 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 (39982, INP1, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:27:01.9659 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, 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 (39982, INP1, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:27:01.9659 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, 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 (39982, INP1, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:28:24.4247 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, D32 ). 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 (39982, INP1, D32 ). 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:28:24.4247 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, D32 ). 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 (39982, INP1, D32 ). 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:28:24.4247 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, D32 ). 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 (39982, INP1, D32 ). 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:28:26.5153 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, 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 (39982, INP1, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:28:26.5153 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, 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 (39982, INP1, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:28:26.5153 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, 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 (39982, INP1, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:28:40.0948 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, D33 ). 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 (39982, INP1, D33 ). 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:28:40.0948 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, D33 ). 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 (39982, INP1, D33 ). 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:28:40.0948 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, D33 ). 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 (39982, INP1, D33 ). 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:28:41.4783 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, D13 ). 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 (39982, INP1, D13 ). 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:28:41.4783 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, D13 ). 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 (39982, INP1, D13 ). 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:28:41.4783 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, D13 ). 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 (39982, INP1, D13 ). 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:31:20.0266 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, 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 (39982, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:31:20.0266 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, 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 (39982, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:31:20.0266 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, 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 (39982, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:33:54.0522 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, 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 (39982, INP1, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:33:54.0522 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, 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 (39982, INP1, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14 2022-11-21 22:33:54.0522 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (39982, INP1, 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 (39982, INP1, 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:11f64692-5c57-4f32-a6c9-108dfc2aaa34 Error Number:2601,State:1,Class:14