{ "timestamp": "2026-04-13 05:05:27.7153", "level": "Error", "severity": "ERROR", "message": "Object reference not set to an instance of an object.", "stackTrace": "System.NullReferenceException: Object reference not set to an instance of an object.\r\n   at IncidentReporter.DAL.Repositories.IncidentsRepo.BuildIncidentFilters(IncidentsFilter objIncidentFilter) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\IncidentsRepo.cs:line 7936\r\n   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\r\n   at IncidentReporter.API.BLL.IncidentsBLL.<Get>d__10.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\IncidentsBLL.cs:line 144" }
{ "timestamp": "2026-04-13 05:05:27.7299", "level": "Error", "severity": "ERROR", "message": "Object reference not set to an instance of an object.", "stackTrace": "System.NullReferenceException: Object reference not set to an instance of an object.\r\n   at IncidentReporter.DAL.Repositories.IncidentsRepo.GetTicketStatusCount(IncidentsFilter objIncidentFilter) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\IncidentsRepo.cs:line 7536\r\n   at IncidentReporter.API.BLL.IncidentsBLL.<GetAllTicketStatusCountAsync>d__128.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\IncidentsBLL.cs:line 8594" }
{ "timestamp": "2026-04-13 05:05:27.7818", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 05:05:27.7818", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 05:19:06.2783", "level": "Error", "severity": "ERROR", "message": "Object reference not set to an instance of an object.", "stackTrace": "System.NullReferenceException: Object reference not set to an instance of an object.\r\n   at IncidentReporter.DAL.Repositories.IncidentsRepo.BuildIncidentFilters(IncidentsFilter objIncidentFilter) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\IncidentsRepo.cs:line 7936\r\n   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\r\n   at IncidentReporter.API.BLL.IncidentsBLL.<Get>d__10.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\IncidentsBLL.cs:line 144" }
{ "timestamp": "2026-04-13 05:19:06.2783", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 05:19:06.2783", "level": "Error", "severity": "ERROR", "message": "Object reference not set to an instance of an object.", "stackTrace": "System.NullReferenceException: Object reference not set to an instance of an object.\r\n   at IncidentReporter.DAL.Repositories.IncidentsRepo.GetTicketStatusCount(IncidentsFilter objIncidentFilter) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\IncidentsRepo.cs:line 7536\r\n   at IncidentReporter.API.BLL.IncidentsBLL.<GetAllTicketStatusCountAsync>d__128.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\IncidentsBLL.cs:line 8594" }
{ "timestamp": "2026-04-13 05:19:06.2783", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 05:24:46.7091", "level": "Error", "severity": "ERROR", "message": "Object reference not set to an instance of an object.", "stackTrace": "System.NullReferenceException: Object reference not set to an instance of an object.\r\n   at IncidentReporter.API.BLL.IncidentManagementBLL.<GetMultiSiteFIRRequestCounts>d__69.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\IncidentManagementBLL.cs:line 5693" }
{ "timestamp": "2026-04-13 05:24:46.7091", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 05:25:44.0667", "level": "Error", "severity": "ERROR", "message": "Object reference not set to an instance of an object.", "stackTrace": "System.NullReferenceException: Object reference not set to an instance of an object.\r\n   at IncidentReporter.API.BLL.IncidentManagementBLL.<GetMultiSiteFIRRequestCounts>d__69.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\IncidentManagementBLL.cs:line 5693" }
{ "timestamp": "2026-04-13 05:25:44.0667", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 05:49:09.2317", "level": "Error", "severity": "ERROR", "message": "Unknown column 'it.id' in 'on clause'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'it.id' in 'on clause'\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)\r\n   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   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\r\n   at IncidentReporter.API.BLL.InspectionsBLL.<GetAllInspectionTypes>d__22.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InspectionsBLL.cs:line 2145" }
{ "timestamp": "2026-04-13 05:49:09.2317", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 05:52:43.5258", "level": "Error", "severity": "ERROR", "message": "Unknown column 'it.id' in 'on clause'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'it.id' in 'on clause'\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)\r\n   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   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\r\n   at IncidentReporter.API.BLL.InspectionsBLL.<GetAllInspectionTypes>d__22.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InspectionsBLL.cs:line 2145" }
{ "timestamp": "2026-04-13 05:52:43.5258", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 05:54:02.9833", "level": "Error", "severity": "ERROR", "message": "Unknown column 'it.id' in 'on clause'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'it.id' in 'on clause'\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)\r\n   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   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\r\n   at IncidentReporter.API.BLL.InspectionsBLL.<GetAllInspectionTypes>d__22.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InspectionsBLL.cs:line 2145" }
{ "timestamp": "2026-04-13 05:54:02.9891", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 05:54:37.7094", "level": "Error", "severity": "ERROR", "message": "Unknown column 'it.id' in 'on clause'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'it.id' in 'on clause'\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)\r\n   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   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\r\n   at IncidentReporter.API.BLL.InspectionsBLL.<GetAllInspectionTypes>d__22.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InspectionsBLL.cs:line 2145" }
{ "timestamp": "2026-04-13 05:54:37.7274", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 05:54:46.1379", "level": "Error", "severity": "ERROR", "message": "Unknown column 'it.id' in 'on clause'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'it.id' in 'on clause'\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)\r\n   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   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\r\n   at IncidentReporter.API.BLL.InspectionsBLL.<GetAllInspectionTypes>d__22.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InspectionsBLL.cs:line 2145" }
{ "timestamp": "2026-04-13 05:54:46.1379", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 05:57:03.4866", "level": "Error", "severity": "ERROR", "message": "Unknown column 'it.id' in 'on clause'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'it.id' in 'on clause'\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)\r\n   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   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\r\n   at IncidentReporter.API.BLL.InspectionsBLL.<GetAllInspectionTypes>d__22.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InspectionsBLL.cs:line 2145" }
{ "timestamp": "2026-04-13 05:57:03.4866", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 05:57:53.0020", "level": "Error", "severity": "ERROR", "message": "Unknown column 'it.id' in 'on clause'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'it.id' in 'on clause'\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)\r\n   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   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\r\n   at IncidentReporter.API.BLL.InspectionsBLL.<GetAllInspectionTypes>d__22.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InspectionsBLL.cs:line 2145" }
{ "timestamp": "2026-04-13 05:57:53.0020", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 05:57:58.9547", "level": "Error", "severity": "ERROR", "message": "Unknown column 'it.id' in 'on clause'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'it.id' in 'on clause'\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)\r\n   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   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\r\n   at IncidentReporter.API.BLL.InspectionsBLL.<GetAllInspectionTypes>d__22.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InspectionsBLL.cs:line 2145" }
{ "timestamp": "2026-04-13 05:57:58.9699", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 05:58:06.7974", "level": "Error", "severity": "ERROR", "message": "Unknown column 'it.id' in 'on clause'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'it.id' in 'on clause'\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)\r\n   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   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\r\n   at IncidentReporter.API.BLL.InspectionsBLL.<GetAllInspectionTypes>d__22.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InspectionsBLL.cs:line 2145" }
{ "timestamp": "2026-04-13 05:58:06.7974", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 06:40:02.9783", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 06:45:46.8240", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 07:45:00.8236", "level": "Error", "severity": "ERROR", "message": "Unknown column 'it.id' in 'on clause'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'it.id' in 'on clause'\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)\r\n   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   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\r\n   at IncidentReporter.API.BLL.InspectionsBLL.<GetAllInspectionTypes>d__22.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InspectionsBLL.cs:line 2145" }
{ "timestamp": "2026-04-13 07:45:00.8670", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 08:09:01.3969", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 08:12:14.3995", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 08:12:42.5322", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 08:15:56.6271", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 09:04:39.9801", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 09:04:48.5320", "level": "Error", "severity": "ERROR", "message": "The file path you provided is not Valid", "stackTrace": "System.Exception: The file path you provided is not Valid\r\n   at DocumentService.Pdf.PdfDocumentGenerator.GeneratePdfByTemplate(String toolFolderAbsolutePath, String templatePath, List`1 metaDataList, String outputFilePath)\r\n   at IncidentReporter.API.Helpers.ExportIncidentPDFHelper.ExportIncidentPDF(IncidentDBO incident, String organisationBannerRelativePath, String outputAbsoluteFilePath, String ticketModuleCustomName, Boolean enableReportedByType) in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\Helpers\\ExportIncidentPDFHelper.cs:line 621" }
{ "timestamp": "2026-04-13 10:47:48.0562", "level": "Error", "severity": "ERROR", "message": "Unknown column 'it.id' in 'on clause'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'it.id' in 'on clause'\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)\r\n   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   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\r\n   at IncidentReporter.API.BLL.InspectionsBLL.<GetAllInspectionTypes>d__22.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InspectionsBLL.cs:line 2145" }
{ "timestamp": "2026-04-13 10:47:48.1063", "level": "Error", "severity": "ERROR" }
{ "timestamp": "2026-04-13 10:48:41.2723", "level": "Error", "severity": "ERROR", "message": "Unknown column 'it.id' in 'on clause'", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'it.id' in 'on clause'\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)\r\n   at Dapper.SqlMapper.<QueryImpl>d__138`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   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\r\n   at IncidentReporter.API.BLL.InspectionsBLL.<GetAllInspectionTypes>d__22.MoveNext() in D:\\osmosys\\oqsha\\incident-reporter-api\\IncidentReporter\\IncidentReporter.API\\BLL\\InspectionsBLL.cs:line 2145" }
{ "timestamp": "2026-04-13 10:48:41.2854", "level": "Error", "severity": "ERROR" }