2023-04-06 06:59:40.4356 Edit button clicked. 
2023-04-06 07:10:53.7377 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40270, A1O1, 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 (40270, A1O1, 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:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:2601,State:1,Class:14
2023-04-06 07:10:53.7689 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40270, A1O1, 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 (40270, A1O1, 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_ProtectiveFunctionForPasteData(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 PM_Id, Int32 userid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 648
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:2601,State:1,Class:14
2023-04-06 07:10:53.7689 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40270, A1O1, 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 (40270, A1O1, 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_ProtectiveFunctionForPasteData(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 PM_Id, Int32 userid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 653
   at SilSolver.WEB.ProtectiveFunctionHTML.BindPasteSaveDevice(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1304
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:2601,State:1,Class:14
2023-04-06 07:11:39.8418 Divide by zero error encountered. System.Data.SqlClient.SqlException (0x80131904): Divide by zero error encountered.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at SilSolver.DAL.DbProviderHelper.ExecuteNonQuery(DbCommand dbCommand)
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:8134,State:1,Class:16
2023-04-06 07:11:39.8418 Divide by zero error encountered. System.Data.SqlClient.SqlException (0x80131904): Divide by zero error encountered.
   at SilSolver.DAL.DbProviderHelper.ExecuteNonQuery(DbCommand dbCommand)
   at SilSolver.DAL.PT_ProtectiveFunctionService.CalculationProcedure(Int32 ProtectiveId_FK, String Redundant, Decimal In1Beta, Decimal In2Beta, Decimal In3Beta, Decimal In4Beta, Decimal In5Beta, Decimal In6Beta, Decimal In7Beta, Decimal In8Beta, Decimal In9Beta, Decimal In10Beta, String In1Voting, String In2Voting, String In3Voting, String In4Voting, String In5Voting, String In6Voting, String In7Voting, String In8Voting, String In9Voting, String In10Voting, Int32 UserID, String deviceVersion) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 444
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:8134,State:1,Class:16
2023-04-06 07:11:39.8418 Divide by zero error encountered. System.Data.SqlClient.SqlException (0x80131904): Divide by zero error encountered.
   at SilSolver.DAL.PT_ProtectiveFunctionService.CalculationProcedure(Int32 ProtectiveId_FK, String Redundant, Decimal In1Beta, Decimal In2Beta, Decimal In3Beta, Decimal In4Beta, Decimal In5Beta, Decimal In6Beta, Decimal In7Beta, Decimal In8Beta, Decimal In9Beta, Decimal In10Beta, String In1Voting, String In2Voting, String In3Voting, String In4Voting, String In5Voting, String In6Voting, String In7Voting, String In8Voting, String In9Voting, String In10Voting, Int32 UserID, String deviceVersion) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 454
   at SilSolver.WEB.ProtectiveFunctionHTML.Calculation(Int32 Pid, String reduntantvalue, Decimal ccfval1, Decimal ccfval2, Decimal ccfval3, Decimal ccfval4, Decimal ccfval5, Decimal ccfval6, Decimal ccfval7, Decimal ccfval8, Decimal ccfval9, Decimal ccfval10, String inputvoting1, String inputvoting2, String inputvoting3, String inputvoting4, String inputvoting5, String actionvoting1, String actionvoting2, String actionvoting3, String actionvoting4, String actionvoting5) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2804
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:8134,State:1,Class:16
2023-04-06 07:20:48.5668 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40270, 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 (40270, 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:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:2601,State:1,Class:14
2023-04-06 07:20:48.5668 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40270, 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 (40270, 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_ProtectiveFunctionForPasteData(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 PM_Id, Int32 userid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 648
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:2601,State:1,Class:14
2023-04-06 07:20:48.5668 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40270, 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 (40270, 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_ProtectiveFunctionForPasteData(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 PM_Id, Int32 userid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 653
   at SilSolver.WEB.ProtectiveFunctionHTML.BindPasteSaveDevice(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1304
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:2601,State:1,Class:14
2023-04-06 07:23:53.8232 Edit button clicked. 
2023-04-06 07:25:53.7056 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40271, 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 (40271, 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:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:2601,State:1,Class:14
2023-04-06 07:25:53.7056 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40271, 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 (40271, 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_ProtectiveFunctionForPasteData(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 PM_Id, Int32 userid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 648
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:2601,State:1,Class:14
2023-04-06 07:25:53.7056 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40271, 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 (40271, 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_ProtectiveFunctionForPasteData(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 PM_Id, Int32 userid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 653
   at SilSolver.WEB.ProtectiveFunctionHTML.BindPasteSaveDevice(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1304
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:2601,State:1,Class:14
2023-04-06 07:40:21.3954 Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint. System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at SilSolver.DAL.DbProviderHelper.ExecuteNonQuery(DbCommand dbCommand)
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:8115,State:2,Class:16
2023-04-06 07:40:21.4111 Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint. System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint.
   at SilSolver.DAL.DbProviderHelper.ExecuteNonQuery(DbCommand dbCommand)
   at SilSolver.DAL.PT_ProtectiveFunctionService.CalculationProcedure(Int32 ProtectiveId_FK, String Redundant, Decimal In1Beta, Decimal In2Beta, Decimal In3Beta, Decimal In4Beta, Decimal In5Beta, Decimal In6Beta, Decimal In7Beta, Decimal In8Beta, Decimal In9Beta, Decimal In10Beta, String In1Voting, String In2Voting, String In3Voting, String In4Voting, String In5Voting, String In6Voting, String In7Voting, String In8Voting, String In9Voting, String In10Voting, Int32 UserID, String deviceVersion) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 444
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:8115,State:2,Class:16
2023-04-06 07:40:21.4111 Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint. System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint.
   at SilSolver.DAL.PT_ProtectiveFunctionService.CalculationProcedure(Int32 ProtectiveId_FK, String Redundant, Decimal In1Beta, Decimal In2Beta, Decimal In3Beta, Decimal In4Beta, Decimal In5Beta, Decimal In6Beta, Decimal In7Beta, Decimal In8Beta, Decimal In9Beta, Decimal In10Beta, String In1Voting, String In2Voting, String In3Voting, String In4Voting, String In5Voting, String In6Voting, String In7Voting, String In8Voting, String In9Voting, String In10Voting, Int32 UserID, String deviceVersion) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 454
   at SilSolver.WEB.ProtectiveFunctionHTML.Calculation(Int32 Pid, String reduntantvalue, Decimal ccfval1, Decimal ccfval2, Decimal ccfval3, Decimal ccfval4, Decimal ccfval5, Decimal ccfval6, Decimal ccfval7, Decimal ccfval8, Decimal ccfval9, Decimal ccfval10, String inputvoting1, String inputvoting2, String inputvoting3, String inputvoting4, String inputvoting5, String actionvoting1, String actionvoting2, String actionvoting3, String actionvoting4, String actionvoting5) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2804
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:8115,State:2,Class:16
2023-04-06 07:43:17.4704 Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint. System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at SilSolver.DAL.DbProviderHelper.ExecuteNonQuery(DbCommand dbCommand)
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:8115,State:2,Class:16
2023-04-06 07:43:17.4704 Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint. System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint.
   at SilSolver.DAL.DbProviderHelper.ExecuteNonQuery(DbCommand dbCommand)
   at SilSolver.DAL.PT_ProtectiveFunctionService.CalculationProcedure(Int32 ProtectiveId_FK, String Redundant, Decimal In1Beta, Decimal In2Beta, Decimal In3Beta, Decimal In4Beta, Decimal In5Beta, Decimal In6Beta, Decimal In7Beta, Decimal In8Beta, Decimal In9Beta, Decimal In10Beta, String In1Voting, String In2Voting, String In3Voting, String In4Voting, String In5Voting, String In6Voting, String In7Voting, String In8Voting, String In9Voting, String In10Voting, Int32 UserID, String deviceVersion) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 444
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:8115,State:2,Class:16
2023-04-06 07:43:17.4704 Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint. System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint.
   at SilSolver.DAL.PT_ProtectiveFunctionService.CalculationProcedure(Int32 ProtectiveId_FK, String Redundant, Decimal In1Beta, Decimal In2Beta, Decimal In3Beta, Decimal In4Beta, Decimal In5Beta, Decimal In6Beta, Decimal In7Beta, Decimal In8Beta, Decimal In9Beta, Decimal In10Beta, String In1Voting, String In2Voting, String In3Voting, String In4Voting, String In5Voting, String In6Voting, String In7Voting, String In8Voting, String In9Voting, String In10Voting, Int32 UserID, String deviceVersion) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 454
   at SilSolver.WEB.ProtectiveFunctionHTML.Calculation(Int32 Pid, String reduntantvalue, Decimal ccfval1, Decimal ccfval2, Decimal ccfval3, Decimal ccfval4, Decimal ccfval5, Decimal ccfval6, Decimal ccfval7, Decimal ccfval8, Decimal ccfval9, Decimal ccfval10, String inputvoting1, String inputvoting2, String inputvoting3, String inputvoting4, String inputvoting5, String actionvoting1, String actionvoting2, String actionvoting3, String actionvoting4, String actionvoting5) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2804
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:8115,State:2,Class:16
2023-04-06 07:45:26.8325 Edit button clicked. 
2023-04-06 07:45:49.4906 Edit button clicked. 
2023-04-06 07:51:05.2101 Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint. System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at SilSolver.DAL.DbProviderHelper.ExecuteNonQuery(DbCommand dbCommand)
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:8115,State:2,Class:16
2023-04-06 07:51:05.2258 Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint. System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint.
   at SilSolver.DAL.DbProviderHelper.ExecuteNonQuery(DbCommand dbCommand)
   at SilSolver.DAL.PT_ProtectiveFunctionService.CalculationProcedure(Int32 ProtectiveId_FK, String Redundant, Decimal In1Beta, Decimal In2Beta, Decimal In3Beta, Decimal In4Beta, Decimal In5Beta, Decimal In6Beta, Decimal In7Beta, Decimal In8Beta, Decimal In9Beta, Decimal In10Beta, String In1Voting, String In2Voting, String In3Voting, String In4Voting, String In5Voting, String In6Voting, String In7Voting, String In8Voting, String In9Voting, String In10Voting, Int32 UserID, String deviceVersion) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 444
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:8115,State:2,Class:16
2023-04-06 07:51:05.2258 Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint. System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint.
   at SilSolver.DAL.PT_ProtectiveFunctionService.CalculationProcedure(Int32 ProtectiveId_FK, String Redundant, Decimal In1Beta, Decimal In2Beta, Decimal In3Beta, Decimal In4Beta, Decimal In5Beta, Decimal In6Beta, Decimal In7Beta, Decimal In8Beta, Decimal In9Beta, Decimal In10Beta, String In1Voting, String In2Voting, String In3Voting, String In4Voting, String In5Voting, String In6Voting, String In7Voting, String In8Voting, String In9Voting, String In10Voting, Int32 UserID, String deviceVersion) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 454
   at SilSolver.WEB.ProtectiveFunctionHTML.Calculation(Int32 Pid, String reduntantvalue, Decimal ccfval1, Decimal ccfval2, Decimal ccfval3, Decimal ccfval4, Decimal ccfval5, Decimal ccfval6, Decimal ccfval7, Decimal ccfval8, Decimal ccfval9, Decimal ccfval10, String inputvoting1, String inputvoting2, String inputvoting3, String inputvoting4, String inputvoting5, String actionvoting1, String actionvoting2, String actionvoting3, String actionvoting4, String actionvoting5) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2804
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:8115,State:2,Class:16
2023-04-06 07:52:31.5185 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40273, INP2, 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 (40273, INP2, 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:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:2601,State:1,Class:14
2023-04-06 07:52:31.5185 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40273, INP2, 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 (40273, INP2, 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:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:2601,State:1,Class:14
2023-04-06 07:52:31.5341 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40273, INP2, 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 (40273, INP2, 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:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:2601,State:1,Class:14
2023-04-06 07:52:53.1252 Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint. System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at SilSolver.DAL.DbProviderHelper.ExecuteNonQuery(DbCommand dbCommand)
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:8115,State:2,Class:16
2023-04-06 07:52:53.1252 Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint. System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint.
   at SilSolver.DAL.DbProviderHelper.ExecuteNonQuery(DbCommand dbCommand)
   at SilSolver.DAL.PT_ProtectiveFunctionService.CalculationProcedure(Int32 ProtectiveId_FK, String Redundant, Decimal In1Beta, Decimal In2Beta, Decimal In3Beta, Decimal In4Beta, Decimal In5Beta, Decimal In6Beta, Decimal In7Beta, Decimal In8Beta, Decimal In9Beta, Decimal In10Beta, String In1Voting, String In2Voting, String In3Voting, String In4Voting, String In5Voting, String In6Voting, String In7Voting, String In8Voting, String In9Voting, String In10Voting, Int32 UserID, String deviceVersion) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 444
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:8115,State:2,Class:16
2023-04-06 07:52:53.1252 Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint. System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint.
   at SilSolver.DAL.PT_ProtectiveFunctionService.CalculationProcedure(Int32 ProtectiveId_FK, String Redundant, Decimal In1Beta, Decimal In2Beta, Decimal In3Beta, Decimal In4Beta, Decimal In5Beta, Decimal In6Beta, Decimal In7Beta, Decimal In8Beta, Decimal In9Beta, Decimal In10Beta, String In1Voting, String In2Voting, String In3Voting, String In4Voting, String In5Voting, String In6Voting, String In7Voting, String In8Voting, String In9Voting, String In10Voting, Int32 UserID, String deviceVersion) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 454
   at SilSolver.WEB.ProtectiveFunctionHTML.Calculation(Int32 Pid, String reduntantvalue, Decimal ccfval1, Decimal ccfval2, Decimal ccfval3, Decimal ccfval4, Decimal ccfval5, Decimal ccfval6, Decimal ccfval7, Decimal ccfval8, Decimal ccfval9, Decimal ccfval10, String inputvoting1, String inputvoting2, String inputvoting3, String inputvoting4, String inputvoting5, String actionvoting1, String actionvoting2, String actionvoting3, String actionvoting4, String actionvoting5) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2804
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:8115,State:2,Class:16
2023-04-06 07:54:54.9878 Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint. System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at SilSolver.DAL.DbProviderHelper.ExecuteNonQuery(DbCommand dbCommand)
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:8115,State:2,Class:16
2023-04-06 07:54:54.9878 Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint. System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint.
   at SilSolver.DAL.DbProviderHelper.ExecuteNonQuery(DbCommand dbCommand)
   at SilSolver.DAL.PT_ProtectiveFunctionService.CalculationProcedure(Int32 ProtectiveId_FK, String Redundant, Decimal In1Beta, Decimal In2Beta, Decimal In3Beta, Decimal In4Beta, Decimal In5Beta, Decimal In6Beta, Decimal In7Beta, Decimal In8Beta, Decimal In9Beta, Decimal In10Beta, String In1Voting, String In2Voting, String In3Voting, String In4Voting, String In5Voting, String In6Voting, String In7Voting, String In8Voting, String In9Voting, String In10Voting, Int32 UserID, String deviceVersion) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 444
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:8115,State:2,Class:16
2023-04-06 07:54:54.9878 Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint. System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting expression to data type bigint.
Arithmetic overflow error converting expression to data type bigint.
   at SilSolver.DAL.PT_ProtectiveFunctionService.CalculationProcedure(Int32 ProtectiveId_FK, String Redundant, Decimal In1Beta, Decimal In2Beta, Decimal In3Beta, Decimal In4Beta, Decimal In5Beta, Decimal In6Beta, Decimal In7Beta, Decimal In8Beta, Decimal In9Beta, Decimal In10Beta, String In1Voting, String In2Voting, String In3Voting, String In4Voting, String In5Voting, String In6Voting, String In7Voting, String In8Voting, String In9Voting, String In10Voting, Int32 UserID, String deviceVersion) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 454
   at SilSolver.WEB.ProtectiveFunctionHTML.Calculation(Int32 Pid, String reduntantvalue, Decimal ccfval1, Decimal ccfval2, Decimal ccfval3, Decimal ccfval4, Decimal ccfval5, Decimal ccfval6, Decimal ccfval7, Decimal ccfval8, Decimal ccfval9, Decimal ccfval10, String inputvoting1, String inputvoting2, String inputvoting3, String inputvoting4, String inputvoting5, String actionvoting1, String actionvoting2, String actionvoting3, String actionvoting4, String actionvoting5) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2804
ClientConnectionId:b979b7bd-8421-445b-9d53-b16ed343782f
Error Number:8115,State:2,Class:16
2023-04-06 09:06:46.7171 System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.ApplicationException: Response.Redirect cannot be called in a Page callback.
   at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent)
   at System.Web.HttpResponse.Redirect(String url)
   at SilSolver.WEB.Services.SecurityService.AssertLoggedIn() in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services\SecurityService.cs:line 187
   at SilSolver.WEB.ProjectMain.Page_Load(Object sender, EventArgs e) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProjectMain.aspx.cs:line 103
   at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.projectmain_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\1ad9780d\73f7e456\App_Web_ejvl0jyh.3.cs:line 0
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.ApplicationException: Response.Redirect cannot be called in a Page callback.
   at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent)
   at System.Web.HttpResponse.Redirect(String url)
   at SilSolver.WEB.Services.SecurityService.AssertLoggedIn() in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services\SecurityService.cs:line 187
   at SilSolver.WEB.ProjectMain.Page_Load(Object sender, EventArgs e) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProjectMain.aspx.cs:line 103
   at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.projectmain_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\1ad9780d\73f7e456\App_Web_ejvl0jyh.3.cs:line 0
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
2023-04-06 09:19:30.9388 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40274, LSO1, <NULL>).
Cannot insert the value NULL into column '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 (40274, LSO1, <NULL>).
Cannot insert the value NULL into column '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:0963b77f-3db2-4791-9823-6870e251ae05
Error Number:2601,State:1,Class:14
2023-04-06 09:19:30.9544 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40274, LSO1, <NULL>).
Cannot insert the value NULL into column '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 (40274, LSO1, <NULL>).
Cannot insert the value NULL into column '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:0963b77f-3db2-4791-9823-6870e251ae05
Error Number:2601,State:1,Class:14
2023-04-06 09:23:01.2244 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40274, 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 (40274, 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:4460d50f-4d7d-4d85-8672-e23e8c9955e2
Error Number:2601,State:1,Class:14
2023-04-06 09:23:01.2244 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40274, 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 (40274, A1O1, D12 ).
Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The statement has been terminated.
   at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter)
   at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForPasteData(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 PM_Id, Int32 userid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 648
ClientConnectionId:4460d50f-4d7d-4d85-8672-e23e8c9955e2
Error Number:2601,State:1,Class:14
2023-04-06 09:23:01.2244 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40274, 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 (40274, A1O1, D12 ).
Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The statement has been terminated.
   at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForPasteData(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 PM_Id, Int32 userid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 653
   at SilSolver.WEB.ProtectiveFunctionHTML.BindPasteSaveDevice(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1304
ClientConnectionId:4460d50f-4d7d-4d85-8672-e23e8c9955e2
Error Number:2601,State:1,Class:14
2023-04-06 09:27:29.8035 Divide by zero error encountered. System.Data.SqlClient.SqlException (0x80131904): Divide by zero error encountered.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at SilSolver.DAL.DbProviderHelper.ExecuteNonQuery(DbCommand dbCommand)
ClientConnectionId:0963b77f-3db2-4791-9823-6870e251ae05
Error Number:8134,State:1,Class:16
2023-04-06 09:27:29.8035 Divide by zero error encountered. System.Data.SqlClient.SqlException (0x80131904): Divide by zero error encountered.
   at SilSolver.DAL.DbProviderHelper.ExecuteNonQuery(DbCommand dbCommand)
   at SilSolver.DAL.PT_ProtectiveFunctionService.CalculationProcedure(Int32 ProtectiveId_FK, String Redundant, Decimal In1Beta, Decimal In2Beta, Decimal In3Beta, Decimal In4Beta, Decimal In5Beta, Decimal In6Beta, Decimal In7Beta, Decimal In8Beta, Decimal In9Beta, Decimal In10Beta, String In1Voting, String In2Voting, String In3Voting, String In4Voting, String In5Voting, String In6Voting, String In7Voting, String In8Voting, String In9Voting, String In10Voting, Int32 UserID, String deviceVersion) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 444
ClientConnectionId:0963b77f-3db2-4791-9823-6870e251ae05
Error Number:8134,State:1,Class:16
2023-04-06 09:27:29.8035 Divide by zero error encountered. System.Data.SqlClient.SqlException (0x80131904): Divide by zero error encountered.
   at SilSolver.DAL.PT_ProtectiveFunctionService.CalculationProcedure(Int32 ProtectiveId_FK, String Redundant, Decimal In1Beta, Decimal In2Beta, Decimal In3Beta, Decimal In4Beta, Decimal In5Beta, Decimal In6Beta, Decimal In7Beta, Decimal In8Beta, Decimal In9Beta, Decimal In10Beta, String In1Voting, String In2Voting, String In3Voting, String In4Voting, String In5Voting, String In6Voting, String In7Voting, String In8Voting, String In9Voting, String In10Voting, Int32 UserID, String deviceVersion) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 454
   at SilSolver.WEB.ProtectiveFunctionHTML.Calculation(Int32 Pid, String reduntantvalue, Decimal ccfval1, Decimal ccfval2, Decimal ccfval3, Decimal ccfval4, Decimal ccfval5, Decimal ccfval6, Decimal ccfval7, Decimal ccfval8, Decimal ccfval9, Decimal ccfval10, String inputvoting1, String inputvoting2, String inputvoting3, String inputvoting4, String inputvoting5, String actionvoting1, String actionvoting2, String actionvoting3, String actionvoting4, String actionvoting5) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2804
ClientConnectionId:0963b77f-3db2-4791-9823-6870e251ae05
Error Number:8134,State:1,Class:16
2023-04-06 09:46:10.8674 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40278, 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 (40278, 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:caa9f010-dc24-4578-a8b8-e0d85758b4fe
Error Number:2601,State:1,Class:14
2023-04-06 09:46:10.8674 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40278, 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 (40278, A1O1, D12 ).
Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The statement has been terminated.
   at SilSolver.DAL.DbProviderHelper.FillDataTable(DbDataAdapter dbDataAdapter)
   at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForPasteData(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 PM_Id, Int32 userid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 648
ClientConnectionId:caa9f010-dc24-4578-a8b8-e0d85758b4fe
Error Number:2601,State:1,Class:14
2023-04-06 09:46:10.8674 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40278, 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 (40278, A1O1, D12 ).
Cannot insert the value NULL into column 'ProtectiveFunctionID_FK', table 'SilSolverV.dbo.PM_ProtectiveFunction'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The statement has been terminated.
   at SilSolver.DAL.PT_ProtectiveFunctionService.AddPT_ProtectiveFunctionForPasteData(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 PM_Id, Int32 userid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 653
   at SilSolver.WEB.ProtectiveFunctionHTML.BindPasteSaveDevice(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1304
ClientConnectionId:caa9f010-dc24-4578-a8b8-e0d85758b4fe
Error Number:2601,State:1,Class:14
2023-04-06 10:26:14.2295 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40281, 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 (40281, 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:a6041a76-2b28-4a8e-bcc2-8fef673e4a13
Error Number:2601,State:1,Class:14
2023-04-06 10:26:14.2295 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40281, 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 (40281, 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_ProtectiveFunctionForPasteData(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 PM_Id, Int32 userid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 648
ClientConnectionId:a6041a76-2b28-4a8e-bcc2-8fef673e4a13
Error Number:2601,State:1,Class:14
2023-04-06 10:26:14.2295 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40281, 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 (40281, 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_ProtectiveFunctionForPasteData(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 PM_Id, Int32 userid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\Services121\PT_ProtectiveFunctionService.cs:line 653
   at SilSolver.WEB.ProtectiveFunctionHTML.BindPasteSaveDevice(String Source, Int32 PrimaryId, String input, String ConfigType, String functionid, Int32 Pid, String deviceposition, Int32 DataSheetId) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 1304
ClientConnectionId:a6041a76-2b28-4a8e-bcc2-8fef673e4a13
Error Number:2601,State:1,Class:14
2023-04-06 14:19:05.1682 Edit button clicked. 
2023-04-06 15:01:21.3414 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16.
   at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info)
   at System.Convert.ToInt16(String value)
   at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926
2023-04-06 15:01:54.8596 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16.
   at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info)
   at System.Convert.ToInt16(String value)
   at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926
2023-04-06 15:02:15.6023 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16.
   at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info)
   at System.Convert.ToInt16(String value)
   at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926
2023-04-06 15:03:18.4686 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16.
   at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info)
   at System.Convert.ToInt16(String value)
   at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926
2023-04-06 15:03:40.8820 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16.
   at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info)
   at System.Convert.ToInt16(String value)
   at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926
2023-04-06 15:07:37.6771 Edit button clicked. 
2023-04-06 15:08:34.5021 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16.
   at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info)
   at System.Convert.ToInt16(String value)
   at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926
2023-04-06 15:23:17.7105 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40293, 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 (40293, 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:c260a15c-6a15-4da9-9ae9-dc01fc6672e4
Error Number:2601,State:1,Class:14
2023-04-06 15:23:17.7417 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40293, 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 (40293, 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:c260a15c-6a15-4da9-9ae9-dc01fc6672e4
Error Number:2601,State:1,Class:14
2023-04-06 15:23:17.7417 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40293, 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 (40293, 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:c260a15c-6a15-4da9-9ae9-dc01fc6672e4
Error Number:2601,State:1,Class:14
2023-04-06 17:00:21.4631 System.Web.HttpException (0x80004005): The file '/owa/auth/logon.aspx' does not exist.
   at System.Web.UI.Util.CheckVirtualFileExists(VirtualPath virtualPath)
   at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
   at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
   at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound)
   at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp)
   at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath)
   at System.Web.UI.PageHandlerFactory.GetHandler(HttpContext context, String requestType, String virtualPath, String path)
   at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) System.Web.HttpException (0x80004005): The file '/owa/auth/logon.aspx' does not exist.
   at System.Web.UI.Util.CheckVirtualFileExists(VirtualPath virtualPath)
   at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
   at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
   at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound)
   at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp)
   at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath)
   at System.Web.UI.PageHandlerFactory.GetHandler(HttpContext context, String requestType, String virtualPath, String path)
   at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
2023-04-06 18:06:08.7938 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40218, 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 (40218, 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:a4ae1bb1-d14a-436e-b3ad-08b55d2c0abc
Error Number:2601,State:1,Class:14
2023-04-06 18:06:08.8531 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40218, 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 (40218, 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:a4ae1bb1-d14a-436e-b3ad-08b55d2c0abc
Error Number:2601,State:1,Class:14
2023-04-06 18:06:08.8531 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40218, 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 (40218, 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:a4ae1bb1-d14a-436e-b3ad-08b55d2c0abc
Error Number:2601,State:1,Class:14
2023-04-06 18:18:14.0870 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16.
   at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info)
   at System.Convert.ToInt16(String value)
   at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926
2023-04-06 18:18:38.8524 Value was either too large or too small for an Int16. System.OverflowException: Value was either too large or too small for an Int16.
   at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info)
   at System.Convert.ToInt16(String value)
   at SilSolver.WEB.ProtectiveFunctionHTML.SaveSFT_Targets(SFT_Targets data, Int32 Pid) in C:\Users\hunter\source\repos\SIL-Solver\SIL Solver Enterprise\Silsolver\SourceCode\SilSolver.WEB\SilSolver.WEB\ProtectiveFunctionHTML.aspx.cs:line 2926
2023-04-06 18:21:06.4730 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40219, A1O1, 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 (40219, A1O1, 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:a4ae1bb1-d14a-436e-b3ad-08b55d2c0abc
Error Number:2601,State:1,Class:14
2023-04-06 18:21:06.4730 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40219, A1O1, 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 (40219, A1O1, 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:a4ae1bb1-d14a-436e-b3ad-08b55d2c0abc
Error Number:2601,State:1,Class:14
2023-04-06 18:21:06.4730 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40219, A1O1, 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 (40219, A1O1, 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:a4ae1bb1-d14a-436e-b3ad-08b55d2c0abc
Error Number:2601,State:1,Class:14
2023-04-06 18:22:14.3507 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40219, A1O1, 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 (40219, A1O1, 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:a4ae1bb1-d14a-436e-b3ad-08b55d2c0abc
Error Number:2601,State:1,Class:14
2023-04-06 18:22:14.3507 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40219, A1O1, 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 (40219, A1O1, 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:a4ae1bb1-d14a-436e-b3ad-08b55d2c0abc
Error Number:2601,State:1,Class:14
2023-04-06 18:22:14.3507 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40219, A1O1, 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 (40219, A1O1, 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:a4ae1bb1-d14a-436e-b3ad-08b55d2c0abc
Error Number:2601,State:1,Class:14
2023-04-06 18:25:15.9747 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40219, A1O1, 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 (40219, A1O1, 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:a4ae1bb1-d14a-436e-b3ad-08b55d2c0abc
Error Number:2601,State:1,Class:14
2023-04-06 18:25:15.9747 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40219, A1O1, 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 (40219, A1O1, 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:a4ae1bb1-d14a-436e-b3ad-08b55d2c0abc
Error Number:2601,State:1,Class:14
2023-04-06 18:25:15.9904 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40219, A1O1, 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 (40219, A1O1, 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:a4ae1bb1-d14a-436e-b3ad-08b55d2c0abc
Error Number:2601,State:1,Class:14
2023-04-06 18:34:14.4501 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40220, A1O1, 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 (40220, A1O1, 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:a4ae1bb1-d14a-436e-b3ad-08b55d2c0abc
Error Number:2601,State:1,Class:14
2023-04-06 18:34:14.4501 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40220, A1O1, 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 (40220, A1O1, 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:a4ae1bb1-d14a-436e-b3ad-08b55d2c0abc
Error Number:2601,State:1,Class:14
2023-04-06 18:34:14.4658 Cannot insert duplicate key row in object 'dbo.PT_ProtectiveFunction' with unique index 'idx_UniquePTProtective'. The duplicate key value is (40220, A1O1, 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 (40220, A1O1, 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:a4ae1bb1-d14a-436e-b3ad-08b55d2c0abc
Error Number:2601,State:1,Class:14