System.NullReferenceException: Object reference not set to an instance of an object.
   at IncidentReporter.API.BLL.IncidentManagementBLL.<GetMultiSiteFIRRequestCounts>d__69.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\IncidentManagementBLL.cs:line 5693


System.InvalidOperationException: An invalid request URI was provided. The request URI must either be an absolute URI or BaseAddress must be set.
   at System.Net.Http.HttpClient.PrepareRequestMessage(HttpRequestMessage request)
   at System.Net.Http.HttpClient.SendAsync(HttpRequestMessage request, HttpCompletionOption completionOption, CancellationToken cancellationToken)
   at IncidentReporter.DAL.Helpers.HttpRequestHelper.<SendRequestAsync>d__3.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Helpers\HttpRequestHelper.cs:line 86
--- 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 IncidentReporter.API.Handlers.EntityStateWorkflowHandler.<GetStateTypesAsync>d__8.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\Handlers\EntityStateWorkflowHandler.cs:line 275
--- 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 IncidentReporter.API.BLL.WorkflowsBll.<GetStateTypesAsync>d__2.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\WorkflowsBll.cs:line 25


System.ArgumentNullException: Value cannot be null.
Parameter name: format
   at System.String.FormatHelper(IFormatProvider provider, String format, ParamsArray args)
   at IncidentReporter.API.Handlers.EntityStateWorkflowHandler.<GetStartableWorkflowStatesAsync>d__5.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\Handlers\EntityStateWorkflowHandler.cs:line 145
--- 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 IncidentReporter.API.BLL.OrganisationBLL.<GetEntityWorkflowStartableStatesAsync>d__69.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\OrganisationBLL.cs:line 10364


System.ArgumentNullException: Value cannot be null.
Parameter name: format
   at System.String.FormatHelper(IFormatProvider provider, String format, ParamsArray args)
   at IncidentReporter.API.Handlers.EntityStateWorkflowHandler.<GetInitialWorkflowStateAsync>d__4.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\Handlers\EntityStateWorkflowHandler.cs:line 106
--- 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 IncidentReporter.API.BLL.SafetyAlertsBll.<CreateSafetyAlertAsync>d__8.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\SafetyAlertsBll.cs:line 99


System.NullReferenceException: Object reference not set to an instance of an object.
   at IncidentReporter.DAL.Repositories.IncidentsRepo.BuildIncidentFilters(IncidentsFilter objIncidentFilter) in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\IncidentsRepo.cs:line 7936
   at IncidentReporter.DAL.Repositories.IncidentsRepo.Get(IncidentsFilter objIncidentFilter, Int32& recordCount) in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\IncidentsRepo.cs:line 39
   at IncidentReporter.API.BLL.IncidentsBLL.<Get>d__10.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\IncidentsBLL.cs:line 144


System.NullReferenceException: Object reference not set to an instance of an object.
   at IncidentReporter.DAL.Repositories.IncidentsRepo.GetTicketStatusCount(IncidentsFilter objIncidentFilter) in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\IncidentsRepo.cs:line 7536
   at IncidentReporter.API.BLL.IncidentsBLL.<GetAllTicketStatusCountAsync>d__128.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\IncidentsBLL.cs:line 8594


System.InvalidOperationException: An invalid request URI was provided. The request URI must either be an absolute URI or BaseAddress must be set.
   at System.Net.Http.HttpClient.PrepareRequestMessage(HttpRequestMessage request)
   at System.Net.Http.HttpClient.SendAsync(HttpRequestMessage request, HttpCompletionOption completionOption, CancellationToken cancellationToken)
   at IncidentReporter.DAL.Helpers.HttpRequestHelper.<SendRequestAsync>d__3.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Helpers\HttpRequestHelper.cs:line 86
--- 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 IncidentReporter.API.Handlers.EntityStateWorkflowHandler.<GetInitialWorkflowStateAsync>d__4.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\Handlers\EntityStateWorkflowHandler.cs:line 113
--- 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 IncidentReporter.API.BLL.SafetyAlertsBll.<CreateSafetyAlertAsync>d__8.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\SafetyAlertsBll.cs:line 99


System.Exception: User details not found for the given user and organisation.


The file path you provided is not Valid

System.Exception: The file path you provided is not Valid
   at DocumentService.Pdf.PdfDocumentGenerator.GeneratePdfByTemplate(String toolFolderAbsolutePath, String templatePath, List`1 metaDataList, String outputFilePath)
   at IncidentReporter.API.Helpers.ExportRiskAssessmentPDFHelper.ExportRiskAssessmentPDF(RiskAssessmentExportDataDTO exportData, Boolean hideRiskAssessmentName, Boolean hideSubActivityName, Dictionary`2 riskScoreColorConfig, List`1 signatureData) in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\Helpers\ExportRiskAssessmentPDF.cs:line 362
   at IncidentReporter.API.BLL.RiskAssessmentBLL.<ExportRiskAssessmentPdf>d__42.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\RiskAssessmentBLL.cs:line 3014


The file path you provided is not Valid


Unknown column 'it.id' in 'on clause'

MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'it.id' in 'on clause'
   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.<QueryImpl>d__138`1.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)
   at IncidentReporter.DAL.Repositories.InspectionsRepo.GetAllInspectionTypes(Int32 orgId, InspectionTypeFilter filter, List`1 siteIds) in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\InspectionsRepo.cs:line 2909
   at IncidentReporter.API.BLL.InspectionsBLL.<GetAllInspectionTypes>d__22.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\InspectionsBLL.cs:line 2145


Unknown column 'it.id' in 'on clause'


Unknown column 'imfc.id' in 'on clause'

MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'imfc.id' in 'on clause'
   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 IncidentReporter.DAL.Repositories.IncidentManagementRepo.<GetAllIncidentCategories>d__11.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\IncidentManagementRepo.cs:line 433
--- 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 IncidentReporter.API.BLL.IncidentManagementBLL.<GetAllIncidentManagementCategories>d__12.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\IncidentManagementBLL.cs:line 824


Unknown column 'imfc.id' in 'on clause'


Unknown column 'd.id' in 'on clause'

MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'd.id' in 'on clause'
   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 IncidentReporter.DAL.Repositories.DivisionsRepo.<GetAllDivisionsList>d__100.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\DivisionsRepo.cs:line 2929
--- 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 IncidentReporter.API.BLL.DivisionsBLL.<GetList>d__28.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\DivisionsBLL.cs:line 1913


Unknown column 'rat.id' in 'on clause'

MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'rat.id' in 'on clause'
   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.<QueryImpl>d__138`1.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)
   at IncidentReporter.DAL.Repositories.RiskAssessmentRepo.<GetRiskAssessmentTypes>d__13.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\RiskAssessmentRepo.cs:line 569
--- 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 IncidentReporter.API.BLL.RiskAssessmentBLL.<GetRiskAssessmentTypes>d__13.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\RiskAssessmentBLL.cs:line 764


Error returned from access module

System.Exception: Error returned from access module
   at IncidentReporter.API.Helpers.OsmoguardApiHelper.ValidateAccessAsync(Int32 roleId, Nullable`1 moduleId, String moduleName, Nullable`1 read, Nullable`1 create, Nullable`1 update, Nullable`1 delete) in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\Helpers\OsmoguardApiHelper.cs:line 77
   at IncidentReporter.API.Handlers.AcmAuthorise.OnActionExecuting(HttpActionContext actionContext) in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\Handlers\AcmAuthorise.cs:line 185
   at System.Web.Http.Filters.ActionFilterAttribute.OnActionExecutingAsync(HttpActionContext actionContext, 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 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.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.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.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.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.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.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext()


Error returned from access module


System.Net.Http.HttpRequestException: Response status code does not indicate success: 500 (Internal Server Error).
   at System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode()
   at IncidentReporter.API.Helpers.OsmoguardApiHelper.<GetAsync>d__1`1.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\Helpers\OsmoguardApiHelper.cs:line 16
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at IncidentReporter.API.BLL.UsersBLL.<GetUserOrganisation>d__50.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\UsersBLL.cs:line 3599


System.Net.Http.HttpRequestException: Response status code does not indicate success: 500 (Internal Server Error).
   at System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode()
   at IncidentReporter.API.Helpers.OsmoguardApiHelper.<GetAsync>d__1`1.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\Helpers\OsmoguardApiHelper.cs:line 16
--- 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 IncidentReporter.API.BLL.OsmoguardBLL.<GetAllModules>d__8.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\OsmoguardBLL.cs:line 73


System.Net.Http.HttpRequestException: Response status code does not indicate success: 500 (Internal Server Error).
   at System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode()
   at IncidentReporter.API.Helpers.OsmoguardApiHelper.<GetAsync>d__1`1.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\Helpers\OsmoguardApiHelper.cs:line 16
--- 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 IncidentReporter.API.BLL.OsmoguardBLL.<GetAllRoles>d__14.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\OsmoguardBLL.cs:line 644


System.Net.Http.HttpRequestException: Response status code does not indicate success: 500 (Internal Server Error).
   at System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode()
   at IncidentReporter.API.Helpers.OsmoguardApiHelper.<GetAsync>d__1`1.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\Helpers\OsmoguardApiHelper.cs:line 16
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at IncidentReporter.API.BLL.OrganisationBLL.<GetMergedPrivilegesAsync>d__73.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\OrganisationBLL.cs:line 10504
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at IncidentReporter.API.BLL.OrganisationBLL.<PopulatePrivilegesAsync>d__72.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\OrganisationBLL.cs:line 10489
--- 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 IncidentReporter.API.BLL.OrganisationBLL.<GetOwnedOrgsAsync>d__70.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\OrganisationBLL.cs:line 10393


System.Net.Http.HttpRequestException: Response status code does not indicate success: 500 (Internal Server Error).
   at System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode()
   at IncidentReporter.API.Helpers.OsmoguardApiHelper.<GetAsync>d__1`1.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\Helpers\OsmoguardApiHelper.cs:line 16
--- 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 IncidentReporter.API.BLL.OsmoguardBLL.<GetRoleById>d__11.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\OsmoguardBLL.cs:line 291


MySql.Data.MySqlClient.MySqlException (0x80004005): Authentication to host '10.0.1.10' for user 'ir365_user' using method 'mysql_native_password' failed with message: Too many connections ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Too many connections
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at IncidentReporter.DAL.Repositories.BaseRepo.OpenConnection() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\BaseRepo.cs:line 27
   at IncidentReporter.DAL.Repositories.OrganisationRepo.GetOrganisationPreferencesByOrgId(Int32 orgId) in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\OrganisationRepo.cs:line 5338
   at IncidentReporter.API.BLL.NotificationsBLL.<GetPendingActionsNotificationsCount>d__22.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\NotificationsBLL.cs:line 1121


Unknown column 'mc.id' in 'on clause'

MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'mc.id' in 'on clause'
   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 IncidentReporter.DAL.Repositories.WorkPermitRepo.<GetAllWorkPermitCategories>d__65.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\WorkPermitRepo.cs:line 2331
--- 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 IncidentReporter.API.BLL.WorkPermitBLL.<GetAllWorkPermitCategories>d__29.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\WorkPermitBLL.cs:line 2871


Unknown column 'mc.id' in 'on clause'


MySql.Data.MySqlClient.MySqlException (0x80004005): error connecting: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at IncidentReporter.DAL.Repositories.BaseRepo.OpenConnection() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\BaseRepo.cs:line 27
   at IncidentReporter.DAL.Repositories.UsersRepo.GetFailedLoginAttempt(String loginIdentifier, String ipAddress) in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\UsersRepo.cs:line 9453
   at IncidentReporter.API.BLL.UsersBLL.<LoginUsingPassword>d__22.MoveNext() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\UsersBLL.cs:line 1115


MySql.Data.MySqlClient.MySqlException (0x80004005): error connecting: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at IncidentReporter.DAL.Repositories.BaseRepo.OpenConnection() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\BaseRepo.cs:line 27
   at IncidentReporter.DAL.Repositories.AppVersionsRepo.Get(AppVersionsFilter appVersionsFilter, Int32& recordCount) in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\AppVersionsRepo.cs:line 120
   at IncidentReporter.API.BLL.AppVersionsBLL.Get(AppVersionsFilter appVersionsFilter) in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\AppVersionsBLL.cs:line 40


MySql.Data.MySqlClient.MySqlException (0x80004005): error connecting: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at IncidentReporter.DAL.Repositories.BaseRepo.OpenConnection() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\BaseRepo.cs:line 27
   at IncidentReporter.DAL.Repositories.UsersRepo.GetCountries() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\UsersRepo.cs:line 4755
   at IncidentReporter.API.BLL.UsersBLL.GetCountries() in D:\osmosys\oqsha\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\UsersBLL.cs:line 4649


Unknown column 'it.id' in 'on clause'


Unknown column 'imfc.id' in 'on clause'