level: Error

severity: ERROR

stackTrace:
MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'ts.task_statuses' in 'field list'
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Dapper.SqlMapper.<QueryAsync>d__33`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at IncidentReporter.DAL.Repositories.AuditRepo.<GetAuditAssociatedTasksAsync>d__27.MoveNext() in C:\Gitlab-Runner\builds\pmbcEkqkx\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\AuditRepo.cs:line 951
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at IncidentReporter.API.BLL.AuditBLL.<GetAuditAssociatedTasks>d__26.MoveNext() in C:\Gitlab-Runner\builds\pmbcEkqkx\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\AuditBLL.cs:line 1094


message: Unknown column 'ts.task_statuses' in 'field list'


stackTrace:
MySql.Data.MySqlClient.MySqlException (0x80004005): Duplicate entry 'lakhan.b@osmosys.co' for key 'email_UNIQUE'
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)
   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)
   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)
   at IncidentReporter.DAL.Repositories.UsersRepo.UpdateUserLoginDetailsAndConditionallyUpdatePassword(UserLoginDBO userLoginDetails) in C:\Gitlab-Runner\builds\pmbcEkqkx\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\UsersRepo.cs:line 4194
   at IncidentReporter.API.BLL.UsersBLL.UpdateUserLoginIfRequired(UserLoginInfoDto loginDto, AddAllUserTypeRequest regRequest, String& originalPassword, UserLoginDBO existingUserLoginRecord, OrganisationSettings orgSettings) in C:\Gitlab-Runner\builds\pmbcEkqkx\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\UsersBLL.cs:line 5456
   at IncidentReporter.API.BLL.UsersBLL.<AddAllUserTypes>d__77.MoveNext() in C:\Gitlab-Runner\builds\pmbcEkqkx\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\UsersBLL.cs:line 4971


message: Duplicate entry 'lakhan.b@osmosys.co' for key 'email_UNIQUE'


message: The operation was canceled.

stackTrace:
System.OperationCanceledException: The operation was canceled.
   at System.Threading.CancellationToken.ThrowOperationCanceledException()
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext()


stackTrace:
System.ArgumentNullException: Value cannot be null.
Parameter name: path1
   at System.IO.Path.Combine(String path1, String path2)
   at IncidentReporter.API.Helpers.AttachmentsHelper.ProcessUploadedFiles(HttpRequest request, String baseTargetFolder, String basePath, List`1 uploadedFiles) in C:\Gitlab-Runner\builds\pmbcEkqkx\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.API\Helpers\AttachmentsHelper.cs:line 279
   at IncidentReporter.API.BLL.HealthBLL.<UploadFiles>d__20.MoveNext() in C:\Gitlab-Runner\builds\pmbcEkqkx\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\HealthBLL.cs:line 1156


stackTrace:
System.ArgumentOutOfRangeException: StartIndex cannot be less than zero.
Parameter name: startIndex
   at System.String.Substring(Int32 startIndex, Int32 length)
   at IncidentReporter.API.Helpers.AttachmentsHelper.GetExtension(String fileName) in C:\Gitlab-Runner\builds\pmbcEkqkx\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.API\Helpers\AttachmentsHelper.cs:line 180
   at IncidentReporter.API.Helpers.AttachmentsHelper.ConvertToAttachment(HttpPostedFile file) in C:\Gitlab-Runner\builds\pmbcEkqkx\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.API\Helpers\AttachmentsHelper.cs:line 155
   at IncidentReporter.API.BLL.HealthBLL.<UploadFiles>d__20.MoveNext() in C:\Gitlab-Runner\builds\pmbcEkqkx\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\HealthBLL.cs:line 1129


message:
Value cannot be null.
Parameter name: path1


message: Specified cast is not valid.

stackTrace:
System.InvalidCastException: Specified cast is not valid.
   at IncidentReporter.API.BLL.InspectionsBLL.<UpdateInspectionDetails>d__29.MoveNext() in C:\Gitlab-Runner\builds\pmbcEkqkx\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\InspectionsBLL.cs:line 2014


stackTrace:
MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND date(i.created) >= (date(timestamp('2025-08-27 00:00:00'))) AND date(i.creat' at line 49
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)
   at Dapper.SqlMapper.QueryMultipleImpl(IDbConnection cnn, CommandDefinition& command)
   at Dapper.SqlMapper.QueryMultiple(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)
   at IncidentReporter.DAL.Repositories.IncidentsRepo.Get(IncidentsFilter objIncidentFilter, Int32& recordCount) in C:\Gitlab-Runner\builds\pmbcEkqkx\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\IncidentsRepo.cs:line 287
   at IncidentReporter.API.BLL.UsersBLL.ExportUserData() in C:\Gitlab-Runner\builds\pmbcEkqkx\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\UsersBLL.cs:line 4486


message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND date(i.created) >= (date(timestamp('2025-08-27 00:00:00'))) AND date(i.creat' at line 49


stackTrace:
MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot add or update a child row: a foreign key constraint fails (`qa_stg_oqsha`.`user_history`, CONSTRAINT `user_history_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE)
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at System.Data.Common.DbCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Dapper.SqlMapper.<ExecuteImplAsync>d__39.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at IncidentReporter.DAL.Repositories.VersionsRepo.<InsertUserHistoryAsync>d__9.MoveNext() in C:\Gitlab-Runner\builds\pmbcEkqkx\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\VersionsRepo.cs:line 194
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
   at IncidentReporter.API.BLL.VersionsBLL.<GetAllModuleVersions>d__6.MoveNext() in C:\Gitlab-Runner\builds\pmbcEkqkx\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\VersionsBLL.cs:line 68