1/5/2026 8:10:18 AM - Message: Mailbox unavailable. The server response was: relay not permitted, authentication required StackTrace: at System.Net.Mail.SmtpTransport.SendMail(MailAddress sender, MailAddressCollection recipients, String deliveryNotify, Boolean allowUnicode, SmtpFailedRecipientException& exception) at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 8:11:58 AM - Message: Mailbox unavailable. The server response was: relay not permitted, authentication required StackTrace: at System.Net.Mail.SmtpTransport.SendMail(MailAddress sender, MailAddressCollection recipients, String deliveryNotify, Boolean allowUnicode, SmtpFailedRecipientException& exception) at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 8:18:08 AM - Message: Mailbox unavailable. The server response was: relay not permitted, authentication required StackTrace: at System.Net.Mail.SmtpTransport.SendMail(MailAddress sender, MailAddressCollection recipients, String deliveryNotify, Boolean allowUnicode, SmtpFailedRecipientException& exception) at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 8:22:46 AM - Message: Mailbox unavailable. The server response was: relay not permitted, authentication required StackTrace: at System.Net.Mail.SmtpTransport.SendMail(MailAddress sender, MailAddressCollection recipients, String deliveryNotify, Boolean allowUnicode, SmtpFailedRecipientException& exception) at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 8:27:18 AM - Message: Mailbox unavailable. The server response was: relay not permitted, authentication required StackTrace: at System.Net.Mail.SmtpTransport.SendMail(MailAddress sender, MailAddressCollection recipients, String deliveryNotify, Boolean allowUnicode, SmtpFailedRecipientException& exception) at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 8:29:25 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 8:34:17 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 8:34:39 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 8:39:55 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 8:40:47 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 8:44:01 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 8:45:22 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 9:04:48 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 9:17:49 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 9:20:32 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 9:20:42 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 9:20:42 AM - Message: Inner Exception StackTrace: System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__Response__3214EC277B4DD248'. Cannot insert duplicate key in object 'dbo.Responses'. The duplicate key value is (5667afb9-e19f-45b9-8b02-e6b773a45c1e). The statement has been terminated. at System.Data.SqlClient.SqlConnection.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 System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TInterceptionContext,TResult](Func`1 operation, TInterceptionContext interceptionContext, Action`1 executing, Action`1 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Core.Mapping.Update.Internal.DynamicUpdateCommand.Execute(Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() --- End of inner exception stack trace --- at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy) at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.SaveChanges(SaveOptions options) at System.Data.Entity.Internal.InternalContext.SaveChanges() 1/5/2026 9:20:42 AM - Message: An error occurred while updating the entries. See the inner exception for details. StackTrace: at System.Data.Entity.Internal.InternalContext.SaveChanges() at Surveya_Service.Surveya_Service.UploadEmailedSurveyResponse(String id, String syncID, String responseID, String dateCreated, String isCompleted, String responseQuestions, String version, String surveyName, String providedEmail) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Surveya_Service.svc.cs:line 35936 1/5/2026 9:20:47 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 9:20:47 AM - Message: Inner Exception StackTrace: System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__Response__3214EC277B4DD248'. Cannot insert duplicate key in object 'dbo.Responses'. The duplicate key value is (5667afb9-e19f-45b9-8b02-e6b773a45c1e). The statement has been terminated. at System.Data.SqlClient.SqlConnection.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 System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TInterceptionContext,TResult](Func`1 operation, TInterceptionContext interceptionContext, Action`1 executing, Action`1 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Core.Mapping.Update.Internal.DynamicUpdateCommand.Execute(Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() --- End of inner exception stack trace --- at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy) at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.SaveChanges(SaveOptions options) at System.Data.Entity.Internal.InternalContext.SaveChanges() 1/5/2026 9:20:47 AM - Message: An error occurred while updating the entries. See the inner exception for details. StackTrace: at System.Data.Entity.Internal.InternalContext.SaveChanges() at Surveya_Service.Surveya_Service.UploadEmailedSurveyResponse(String id, String syncID, String responseID, String dateCreated, String isCompleted, String responseQuestions, String version, String surveyName, String providedEmail) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Surveya_Service.svc.cs:line 35936 1/5/2026 9:22:43 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 9:31:27 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 9:34:10 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 9:59:54 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 10:00:16 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 10:05:17 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 10:08:00 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 10:09:33 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 10:21:19 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 10:21:27 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 10:30:32 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 10:38:46 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 10:38:49 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 10:38:49 AM - Message: Inner Exception StackTrace: System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__Response__3214EC277B4DD248'. Cannot insert duplicate key in object 'dbo.Responses'. The duplicate key value is (0415a77d-e856-4047-b955-32712eabf966). The statement has been terminated. at System.Data.SqlClient.SqlConnection.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 System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TInterceptionContext,TResult](Func`1 operation, TInterceptionContext interceptionContext, Action`1 executing, Action`1 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Core.Mapping.Update.Internal.DynamicUpdateCommand.Execute(Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() --- End of inner exception stack trace --- at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy) at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.SaveChanges(SaveOptions options) at System.Data.Entity.Internal.InternalContext.SaveChanges() 1/5/2026 10:38:49 AM - Message: An error occurred while updating the entries. See the inner exception for details. StackTrace: at System.Data.Entity.Internal.InternalContext.SaveChanges() at Surveya_Service.Surveya_Service.UploadEmailedSurveyResponse(String id, String syncID, String responseID, String dateCreated, String isCompleted, String responseQuestions, String version, String surveyName, String providedEmail) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Surveya_Service.svc.cs:line 35936 1/5/2026 10:38:50 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 10:38:50 AM - Message: Inner Exception StackTrace: System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__Response__3214EC277B4DD248'. Cannot insert duplicate key in object 'dbo.Responses'. The duplicate key value is (0415a77d-e856-4047-b955-32712eabf966). The statement has been terminated. at System.Data.SqlClient.SqlConnection.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 System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TInterceptionContext,TResult](Func`1 operation, TInterceptionContext interceptionContext, Action`1 executing, Action`1 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Core.Mapping.Update.Internal.DynamicUpdateCommand.Execute(Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() --- End of inner exception stack trace --- at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy) at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.SaveChanges(SaveOptions options) at System.Data.Entity.Internal.InternalContext.SaveChanges() 1/5/2026 10:38:50 AM - Message: An error occurred while updating the entries. See the inner exception for details. StackTrace: at System.Data.Entity.Internal.InternalContext.SaveChanges() at Surveya_Service.Surveya_Service.UploadEmailedSurveyResponse(String id, String syncID, String responseID, String dateCreated, String isCompleted, String responseQuestions, String version, String surveyName, String providedEmail) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Surveya_Service.svc.cs:line 35936 1/5/2026 10:44:36 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 10:44:37 AM - Message: Failure sending mail. StackTrace: at System.Net.Mail.SmtpClient.Send(MailMessage message) at Surveya_Service.Helper.SendMail(String to, String subject, String message, Boolean isHTML, String from, Attachment mailAttachment) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Helper.cs:line 64 1/5/2026 10:44:38 AM - Message: Inner Exception StackTrace: System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__Response__3214EC277B4DD248'. Cannot insert duplicate key in object 'dbo.Responses'. The duplicate key value is (432c6537-4d0f-4ca5-b60f-1a2dac17bbbc). The statement has been terminated. at System.Data.SqlClient.SqlConnection.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 System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TInterceptionContext,TResult](Func`1 operation, TInterceptionContext interceptionContext, Action`1 executing, Action`1 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Core.Mapping.Update.Internal.DynamicUpdateCommand.Execute(Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() --- End of inner exception stack trace --- at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy) at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.SaveChanges(SaveOptions options) at System.Data.Entity.Internal.InternalContext.SaveChanges() 1/5/2026 10:44:38 AM - Message: An error occurred while updating the entries. See the inner exception for details. StackTrace: at System.Data.Entity.Internal.InternalContext.SaveChanges() at Surveya_Service.Surveya_Service.UploadEmailedSurveyResponse(String id, String syncID, String responseID, String dateCreated, String isCompleted, String responseQuestions, String version, String surveyName, String providedEmail) in C:\Projects\Surveya\surveya_service_and_webapp\Surveya Service\Surveya_Service.svc.cs:line 35936