[INSPECTION] No inspection reminders to process


Request URL : https://api-sandbox.oqsha.com/Organisation/258/Users/DropDown?ModuleName=app-Tasks&siteId=831


Request URL : https://api-sandbox.oqsha.com/Organisations/258/statuses


Request URL : https://api-sandbox.oqsha.com/Organisations/258/TaskCategories/DropDown


Request URL : https://api-sandbox.oqsha.com/Organisations/258/Inspection/14245/Comments


Request Body : {"SiteId":[831],"Source":"User"}


Request URL : https://api-sandbox.oqsha.com/Organisations/258/InspectionStatus


Request URL : https://api-sandbox.oqsha.com/Organisations/258/Departments?SortingColumn=Name&SortingOrder=Asc


Request URL : https://api-sandbox.oqsha.com/Organisations/258/Inspection/14245


Request URL : https://api-sandbox.oqsha.com/Resources/eng?orgId=256


Request URL : https://api-sandbox.oqsha.com/AccessControl/Modules/256


Request URL : https://api-sandbox.oqsha.com/Resources/package-features-eng


Request URL : https://api-sandbox.oqsha.com/Health


Request URL : https://api-sandbox.oqsha.com/Organisations/256/Users/2


Request URL : https://api-sandbox.oqsha.com/Organisation/256/KPI/PlantMasterLookup?isDailyComputed=true


Request URL : https://api-sandbox.oqsha.com/Organisation/256/GetDailySiteKpi


Request URL : https://api-sandbox.oqsha.com/Organisations/256


Request URL : https://api-sandbox.oqsha.com/Organisation/256/Modules


Request URL : https://api-sandbox.oqsha.com/Languages


Request URL : https://api-sandbox.oqsha.com/Organisations/256/PendingActionsNotifications


Request URL : https://api-sandbox.oqsha.com/attachments/organisations/padam-logo.png


Request URL : https://api-sandbox.oqsha.com/attachments/users/cdv_photo_001_233d3244-8eb8-4569-9cff-8f93a00080e8.jpg


Request URL : https://api-sandbox.oqsha.com/Organisations/258/Tasks


Request Body : {"TaskStatus":376,"SaveStatus":2,"CheckListData":[],"RemindersConfig":[],"InvestigationId":null,"InspectionId":14245,"SectionId":131,"SiteId":831,"TaskCategoryId":"","AssetIds":[],"TaskDetails":[{"TaskDescription":"bihknkjn - Bay-A (Sand Yard area) - 2.Workers maintaining safe distances from moving vehicles","Priority":3,"DueDate":"2026-03-29T18:30:00.000Z","AssigneeIds":[11112],"Attachments":[]}]}


[CreateTask] Started for OrgId: 258


[CreateTask] Step 1 - Initial setup: 0ms


[CreateTask] Step 2 - Fetch organization: 1ms


[CreateTask] Step 3 - Get task module ID: 1ms


[CreateTask] Step 4 - Fetch organization preferences: 1ms


[CreateTask] Step 6 - Begin transaction: 0ms


[CreateTask] Processing SiteId: 831


[CreateTask] Step 7 - Validate input for SiteId 831: 0ms


[CreateTask] Step 8 - Create task object: 0ms


[CreateTask] Step 9 - Fetch site and module details: 0ms


[CreateTask] Step 10 - Determine task category: 1ms


[CreateTask] Step 11 - Get task category short code: 0ms


[CreateTask] Step 12 - Generate task UID: 3ms


[CreateTask] Step 13 - Insert task into database (TaskId: 11088): 0ms


[CreateTask] Step 14 - Associate PSSR: 0ms


[CreateTask] Step 15 - Parse task association flag: 0ms


[CreateTask] Step 16 - Associate MOC: 0ms


[CreateTask] Step 17 - Associate Audit: 0ms


[CreateTask] Step 18 - Associate HIRA: 0ms


[CreateTask] Step 19 - Associate Investigation: 0ms


[CreateTask] Step 20 - Associate Ticket: 0ms


[CreateTask] Step 21 - Process checklist data: 0ms


[CreateTask] Step 22 - Insert assignees: 0ms


[CreateTask] Step 23 - Process asset IDs: 0ms


[CreateTask] Step 25 - Process child task details: 118ms


[CreateTask] Step 26 - Send assignee notifications: 2ms


[CreateTask] Step 28 - Fetch assignees and log audit: 70ms


[CreateTask] Total time for SiteId 831: 354ms


[CreateTask] Step 29 - Commit transaction: 37ms


[CreateTask] Step 30 - Send status update emails: 0ms


[CreateTask] Completed successfully for OrgId: 258. Total execution time: 401ms


Request URL : https://api-sandbox.oqsha.com/Organisations/258/Inspection/14245/Comments


Request URL : https://api-sandbox.oqsha.com/Organisations/258/statuses


Request URL : https://api-sandbox.oqsha.com/Organisations/258/TaskCategories/DropDown


Request URL : https://api-sandbox.oqsha.com/Organisation/258/Users/DropDown?ModuleName=app-Tasks&siteId=831


Request Body : {"SiteId":[831],"Source":"User"}


Request URL : https://api-sandbox.oqsha.com/Resources/eng?orgId=256


Request URL : https://api-sandbox.oqsha.com/AccessControl/Modules/256


Request URL : https://api-sandbox.oqsha.com/Health


Request URL : https://api-sandbox.oqsha.com/Resources/package-features-eng


Request URL : https://api-sandbox.oqsha.com/Organisations/256/Users/2


Request URL : https://api-sandbox.oqsha.com/Organisation/256/KPI/PlantMasterLookup?isDailyComputed=true


Request URL : https://api-sandbox.oqsha.com/Organisation/256/GetDailySiteKpi


Request URL : https://api-sandbox.oqsha.com/Organisation/256/Modules


Request URL : https://api-sandbox.oqsha.com/Languages


Request URL : https://api-sandbox.oqsha.com/Organisations/256


Request URL : https://api-sandbox.oqsha.com/Organisations/256/PendingActionsNotifications


Request URL : https://api-sandbox.oqsha.com/attachments/organisations/padam-logo.png


Request URL : https://api-sandbox.oqsha.com/attachments/users/cdv_photo_001_233d3244-8eb8-4569-9cff-8f93a00080e8.jpg


Request URL : https://api-sandbox.oqsha.com/Organisation/256/KPI/DailySiteKpi/Export


Request URL : https://api-sandbox.oqsha.com/Organisations/211/Inspections?pageLimit=3


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 '-3, 3; SELECT FOUND_ROWS()' at line 137
   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.<QueryMultipleAsync>d__57.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.InspectionsRepo.<GetAllInspections>d__31.MoveNext() in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.DAL\Repositories\InspectionsRepo.cs:line 1705
--- 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.InspectionsBLL.<GetAllInspection>d__8.MoveNext() in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\InspectionsBLL.cs:line 664


Request URL : https://api-sandbox.oqsha.com/Resources/app-language-eng


Request URL : https://api-sandbox.oqsha.com/Modules/APIs


Request URL : https://api-sandbox.oqsha.com/Modules/Version/All?Appversion=6.6.0


Request URL : https://api-sandbox.oqsha.com/AppVersions?DeviceType=ios&IsLatestVersion=true&IsOqsha=true


Request URL : https://api-sandbox.oqsha.com/Resources/eng?orgId=256


Request URL : https://api-sandbox.oqsha.com/AccessControl/Modules/256


Request URL : https://api-sandbox.oqsha.com/Health


Request URL : https://api-sandbox.oqsha.com/Resources/package-features-eng


Request URL : https://api-sandbox.oqsha.com/Organisations/256/Users/2


Request URL : https://api-sandbox.oqsha.com/Organisation/256/KPI/PlantMasterLookup?isDailyComputed=true


Request URL : https://api-sandbox.oqsha.com/Organisation/256/GetDailySiteKpi


Request URL : https://api-sandbox.oqsha.com/Organisation/256/Modules


Request URL : https://api-sandbox.oqsha.com/Organisations/256


Request URL : https://api-sandbox.oqsha.com/Languages


Request URL : https://api-sandbox.oqsha.com/Organisations/256/PendingActionsNotifications


Request URL : https://api-sandbox.oqsha.com/attachments/organisations/padam-logo.png


Request URL : https://api-sandbox.oqsha.com/attachments/users/cdv_photo_001_233d3244-8eb8-4569-9cff-8f93a00080e8.jpg


Request URL : https://api-sandbox.oqsha.com/Resources/eng?orgId=248


Request URL : https://api-sandbox.oqsha.com/AccessControl/Modules/248


Request URL : https://api-sandbox.oqsha.com/Organisation/256/KPI/DailySiteKpi/Export


Request URL : https://api-sandbox.oqsha.com/Organisations/248/Users/5538


Request URL : https://api-sandbox.oqsha.com/Organisations/248/IncidentManagement/Investigation/Statuses


Request URL : https://api-sandbox.oqsha.com/Organisations/248/Investigation/Categories


Request URL : https://api-sandbox.oqsha.com/Organisations/248/IncidentManagement/Statuses


Request Body : {}


Request URL : https://api-sandbox.oqsha.com/Organisations/248/PendingActionsNotifications


Request URL : https://api-sandbox.oqsha.com/Organisation/248/Modules


Request URL : https://api-sandbox.oqsha.com/Organisations/248


Request URL : https://api-sandbox.oqsha.com/Organisation/248/AccessControl/Roles


Request URL : https://api-sandbox.oqsha.com/attachments/organisations/TTK_e54e850a-a12b-4b5f-830c-e5eef42ebe61.png


Request URL : https://api-sandbox.oqsha.com/Organisations/248/ProcessLists


Request URL : https://api-sandbox.oqsha.com/Assets?orgId=248&LocationId=708&isActive=true


Request URL : https://api-sandbox.oqsha.com/Organisations/248/FieldStaffAndAppUsers?SiteIds=708


Request URL : https://api-sandbox.oqsha.com/Organisations/248/IncidentManagement/Categories


Request URL : https://api-sandbox.oqsha.com/Organisations/248/Departments?siteId=708


Request Body : {"SiteId":[708]}


Request URL : https://api-sandbox.oqsha.com/Organisations/248/IncidentManagement/Incident/Category/70


Request URL : https://api-sandbox.oqsha.com/AccessControl/Modules/253


Request URL : https://api-sandbox.oqsha.com/AccessControl/Modules/198


Request URL : https://api-sandbox.oqsha.com/AccessControl/Modules/251


Request URL : https://api-sandbox.oqsha.com/AccessControl/Modules/258


Request URL : https://api-sandbox.oqsha.com/AccessControl/Modules/159


Request URL : https://api-sandbox.oqsha.com/Organisations/198/InspectionStatus


Request URL : https://api-sandbox.oqsha.com/Organisations/198/Inspections/Feed?seeAllInspections=0&FromDate=2026-03-20&ToDate=2026-04-03


Request URL : https://api-sandbox.oqsha.com/Assets/AssetTypes?OrgId=258&SortingOrder=Asc&SortingColumn=Name&userId=4206


Request URL : https://api-sandbox.oqsha.com/Organisations/258/InspectionStatus


Request URL : https://api-sandbox.oqsha.com/Organisations/258/Departments?SiteId=831&SortingColumn=Name&SortingOrder=Asc


Request URL : https://api-sandbox.oqsha.com/Organisations/258/ProcessLists


Request URL : https://api-sandbox.oqsha.com/Resources/eng?orgId=256


Request URL : https://api-sandbox.oqsha.com/AccessControl/Modules/256


Request URL : https://api-sandbox.oqsha.com/Health


Request URL : https://api-sandbox.oqsha.com/Resources/package-features-eng


Request URL : https://api-sandbox.oqsha.com/Organisations/256/Users/2


Request URL : https://api-sandbox.oqsha.com/Organisation/256/KPI/PlantMasterLookup?isDailyComputed=true


Request URL : https://api-sandbox.oqsha.com/Organisation/256/GetDailySiteKpi


Request URL : https://api-sandbox.oqsha.com/Organisation/256/Modules


Request URL : https://api-sandbox.oqsha.com/Organisations/256


Request URL : https://api-sandbox.oqsha.com/Languages


Request URL : https://api-sandbox.oqsha.com/Organisations/256/PendingActionsNotifications


Request URL : https://api-sandbox.oqsha.com/attachments/organisations/padam-logo.png


Request URL : https://api-sandbox.oqsha.com/attachments/users/cdv_photo_001_233d3244-8eb8-4569-9cff-8f93a00080e8.jpg


Request URL : https://api-sandbox.oqsha.com/Organisations/258/InspectionTypeDropDown?ProcessIds=139


Request URL : https://api-sandbox.oqsha.com/Resources/eng?orgId=248


Request URL : https://api-sandbox.oqsha.com/AccessControl/Modules/248


Request URL : https://api-sandbox.oqsha.com/Organisations/248/Users/5538


Request URL : https://api-sandbox.oqsha.com/Organisations/248/Investigation/Categories


Request URL : https://api-sandbox.oqsha.com/Organisations/248/IncidentManagement/Investigation/Statuses


Request URL : https://api-sandbox.oqsha.com/Organisations/248/IncidentManagement/Statuses


Request Body : {}


Request URL : https://api-sandbox.oqsha.com/Organisations/248


Request URL : https://api-sandbox.oqsha.com/Organisation/248/Modules


Request URL : https://api-sandbox.oqsha.com/Organisations/248/PendingActionsNotifications


Request URL : https://api-sandbox.oqsha.com/attachments/organisations/TTK_e54e850a-a12b-4b5f-830c-e5eef42ebe61.png


Request URL : https://api-sandbox.oqsha.com/Organisation/248/AccessControl/Roles


Request URL : https://api-sandbox.oqsha.com/Organisations/258/InspectionType/609


Request URL : https://api-sandbox.oqsha.com/Organisations/248/ProcessLists


Request URL : https://api-sandbox.oqsha.com/Organisations/258/InspectionStatus


Request URL : https://api-sandbox.oqsha.com/Organisations/258/Departments?SortingColumn=Name&SortingOrder=Asc


Request URL : https://api-sandbox.oqsha.com/Resources/eng?orgId=256


Request URL : https://api-sandbox.oqsha.com/AccessControl/Modules/256


Request URL : https://api-sandbox.oqsha.com/Health


Request URL : https://api-sandbox.oqsha.com/Resources/package-features-eng


Request URL : https://api-sandbox.oqsha.com/Organisations/256/Users/2


Request URL : https://api-sandbox.oqsha.com/Organisation/256/KPI/PlantMasterLookup?isDailyComputed=true


Request URL : https://api-sandbox.oqsha.com/Organisation/256/GetDailySiteKpi


Request URL : https://api-sandbox.oqsha.com/Organisation/256/Modules


Request URL : https://api-sandbox.oqsha.com/Organisations/256


Request URL : https://api-sandbox.oqsha.com/Languages


Request URL : https://api-sandbox.oqsha.com/Organisations/256/PendingActionsNotifications


Request URL : https://api-sandbox.oqsha.com/attachments/organisations/padam-logo.png


Request URL : https://api-sandbox.oqsha.com/attachments/users/cdv_photo_001_233d3244-8eb8-4569-9cff-8f93a00080e8.jpg


Request URL : https://api-sandbox.oqsha.com/Organisations/258/Inspection