Request URL : https://api-qa-staging-2.oqsha.com/Organisations/248/IncidentManagement/Incident/1134


Request URL : https://api-qa-staging-2.oqsha.com/AccessControl/Modules/248


Request URL : https://api-qa-staging-2.oqsha.com/AppFilterUsers?Role=fieldStaff&OrgId=248&LocationId=708


Request URL : https://api-qa-staging-2.oqsha.com/Organisation/248/Users/DropDown?ModuleName=Tasks


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


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/248


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/248/Statuses


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/248/Tasks/List


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/248/Module/46/Entity/502/tasks


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/248/Reports/Dashboards


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/248/TaskCategories/Dropdown


Request Body : {"SiteId":[],"UserId":5889}


Request URL : https://api-qa-staging-2.oqsha.com/Resources/app-language-eng?orgId=232


Request URL : https://api-qa-staging-2.oqsha.com/Modules/APIs


Request URL : https://api-qa-staging-2.oqsha.com/Languages


Request URL : https://api-qa-staging-2.oqsha.com/Health


Request URL : https://api-qa-staging-2.oqsha.com/Modules/Version/All?Appversion=5.12.0


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


Request URL : https://api-qa-staging-2.oqsha.com/AppVersions?DeviceType=ios&Version=5.12.0&IsOqsha=true


Request URL : https://api-qa-staging-2.oqsha.com/AccessControl/Modules/232


Request URL : https://api-qa-staging-2.oqsha.com/Incidents


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/232/TicketStatus/Counts


Request Body : {"ReportedByUserIds":[],"OrgId":[232],"LocationId":[],"DivisionId":[],"DepartmentId":[],"StartDate":"2026-04-16","EndDate":"2026-04-30","PageNumber":1,"PageLimit":10}


Request URL : https://api-qa-staging-2.oqsha.com/Organisation/248/AccessControl/Roles


Request URL : https://api-qa-staging-2.oqsha.com/CheckTypes


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/248/Departments


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/248/IncidentManagement/Statuses


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/248/IncidentManagement/Incident/Category/96


Request URL : https://api-qa-staging-2.oqsha.com/AccessControl/Modules/248


Request URL : https://api-qa-staging-2.oqsha.com/TrackHistory


Request Body : {"OrganisationId":248,"ModuleId":46,"EntityId":"96","EntityType":"IncidentManagementIncidentCategory"}


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/248/IncidentManagement/Category/96


Sanitized JSON passed validation: {
  "Sections": [
    {
      "SectionId": 1,
      "SectionName": "Risk Assessment Matrix",
      "SectionType": "select",
      "MandatoryChecksCount": 0,
      "OrganisationId": null,
      "Status": 1,
      "Rank": 1,
      "AllowAttachments": false,
      "FileUploadControl": {
        "IsCameraAllowed": false,
        "IsImageUploadAllowed": false,
        "IsVideoUploadAllowed": false,
        "IsAudioUploadAllowed": false,
        "IsFileUploadAllowed": false
      },
      "Checks": [
        {
          "Id": "1_1",
          "Check": "Severity (F9)",
          "Type": "select",
          "Value": "",
          "IsMandatory": 0,
          "CheckOptions": [
            {
              "OptionId": 1,
              "OptionText": "Very Low"
            },
            {
              "OptionId": 2,
              "OptionText": "Low"
            },
            {
              "OptionId": 3,
              "OptionText": "Medium"
            },
            {
              "OptionId": 4,
              "OptionText": "High"
            },
            {
              "OptionId": 5,
              "OptionText": "Very High"
            }
          ],
          "CheckConfiguration": {
            "Validations": {
              "Required": false,
              "RequiredMessage": "This field is required",
              "MinLength": null,
              "MinLengthMessage": null,
              "MaxLength": null,
              "MaxLengthMessage": null,
              "Min": null,
              "MinMessage": null,
              "Max": null,
              "MaxMessage": null,
              "Pattern": null,
              "PatternMessage": null
            },
            "Placeholder": "",
            "DisplayOrientation": "vertical",
            "Multiselect": false,
            "ShouldReset": true,
            "FloatingLabel": false,
            "DisplayAsColumn": false,
            "DisplayAsFilter": false,
            "ReadOnly": false,
            "ConditionalRules": [],
            "VisibilityRules": [],
            "AccessControlRules": [],
            "DynamicLabels": [],
            "Alignment": "center"
          },
          "LayoutMetadata": {
            "RowNumber": 0,
            "ColumnOrder": 0,
            "WidthPercentage": 33
          }
        },
        {
          "Id": "1_2",
          "Check": "Probability (G9)",
          "Type": "select",
          "Value": "",
          "IsMandatory": 0,
          "CheckOptions": [
            {
              "OptionId": 1,
              "OptionText": "Light"
            },
            {
              "OptionId": 2,
              "OptionText": "Serious"
            },
            {
              "OptionId": 3,
              "OptionText": "Major"
            },
            {
              "OptionId": 4,
              "OptionText": "Catastrophic"
            },
            {
              "OptionId": 5,
              "OptionText": "M-Catastrophic"
            }
          ],
          "CheckConfiguration": {
            "Validations": {
              "Required": false,
              "RequiredMessage": "This field is required",
              "MinLength": null,
              "MinLengthMessage": null,
              "MaxLength": null,
              "MaxLengthMessage": null,
              "Min": null,
              "MinMessage": null,
              "Max": null,
              "MaxMessage": null,
              "Pattern": null,
              "PatternMessage": null
            },
            "Placeholder": "",
            "DisplayOrientation": "vertical",
            "Multiselect": false,
            "ShouldReset": true,
            "FloatingLabel": false,
            "DisplayAsColumn": false,
            "DisplayAsFilter": false,
            "ReadOnly": false,
            "ConditionalRules": [],
            "VisibilityRules": [],
            "AccessControlRules": [],
            "DynamicLabels": [],
            "Alignment": "center"
          },
          "LayoutMetadata": {
            "RowNumber": 0,
            "ColumnOrder": 1,
            "WidthPercentage": 33
          }
        },
        {
          "Id": "1_3",
          "Check": "Risk Score",
          "Type": "logical-equation",
          "Value": "",
          "IsMandatory": 0,
          "LogicalEquationCheckConfiguration": {
            "version": 1,
            "expressionText": "IF(AND(check_1_1=\"Very Low\",check_1_2=\"Light\"),\"Insignificant (-1)\",IF(AND(check_1_1=\"Very Low\",check_1_2=\"Serious\"),\"Low (-2)\",IF(AND(check_1_1=\"Very Low\",check_1_2=\"Major\"),\"Low (-3)\",IF(AND(check_1_1=\"Very Low\",check_1_2=\"Catastrophic\"),\"Low (-4)\",IF(AND(check_1_1=\"Very Low\",check_1_2=\"M-Catastrophic\"),\"Medium (-5)\",IF(AND(check_1_1=\"Low\",check_1_2=\"Light\"),\"Low (-2)\",IF(AND(check_1_1=\"Low\",check_1_2=\"Serious\"),\"Low (-4)\",IF(AND(check_1_1=\"Low\",check_1_2=\"Major\"),\"Medium (-6)\",IF(AND(check_1_1=\"Low\",check_1_2=\"Catastrophic\"),\"Medium (-8)\",IF(AND(check_1_1=\"Low\",check_1_2=\"M-Catastrophic\"),\"High (-10)\",IF(AND(check_1_1=\"Medium\",check_1_2=\"Light\"),\"Low (-3)\",IF(AND(check_1_1=\"Medium\",check_1_2=\"Serious\"),\"Medium (-6)\",IF(AND(check_1_1=\"Medium\",check_1_2=\"Major\"),\"Medium (-9)\",IF(AND(check_1_1=\"Medium\",check_1_2=\"Catastrophic\"),\"High (-12)\",IF(AND(check_1_1=\"Medium\",check_1_2=\"M-Catastrophic\"),\"High (-15)\",IF(AND(check_1_1=\"High\",check_1_2=\"Light\"),\"Low (-4)\",IF(AND(check_1_1=\"High\",check_1_2=\"Serious\"),\"Medium (-8)\",IF(AND(check_1_1=\"High\",check_1_2=\"Major\"),\"High (-12)\",IF(AND(check_1_1=\"High\",check_1_2=\"Catastrophic\"),\"High (-15)\",IF(AND(check_1_1=\"High\",check_1_2=\"M-Catastrophic\"),\"Extreme (-20)\",IF(AND(check_1_1=\"Very High\",check_1_2=\"Light\"),\"Medium (-5)\",IF(AND(check_1_1=\"Very High\",check_1_2=\"Serious\"),\"High (-10)\",IF(AND(check_1_1=\"Very High\",check_1_2=\"Major\"),\"High (-15)\",IF(AND(check_1_1=\"Very High\",check_1_2=\"Catastrophic\"),\"Extreme (-20)\",IF(AND(check_1_1=\"Very High\",check_1_2=\"M-Catastrophic\"),\"Extreme (-25)\",\" \")))))))))))))))))))))))))))",
            "tokens": [],
            "program": [],
            "referencedControls": [
              "check_1_1",
              "check_1_2"
            ],
            "resultType": "string"
          },
          "CheckConfiguration": {
            "Validations": {
              "Required": false,
              "RequiredMessage": "This field is required",
              "MinLength": null,
              "MinLengthMessage": null,
              "MaxLength": null,
              "MaxLengthMessage": null,
              "Min": null,
              "MinMessage": null,
              "Max": null,
              "MaxMessage": null,
              "Pattern": null,
              "PatternMessage": null
            },
            "Placeholder": "",
            "DisplayOrientation": "vertical",
            "Multiselect": false,
            "ShouldReset": true,
            "FloatingLabel": false,
            "DisplayAsColumn": false,
            "DisplayAsFilter": false,
            "ReadOnly": false,
            "ConditionalRules": [],
            "VisibilityRules": [],
            "AccessControlRules": [],
            "DynamicLabels": [],
            "Alignment": "center"
          },
          "LayoutMetadata": {
            "RowNumber": 0,
            "ColumnOrder": 2,
            "WidthPercentage": 34
          }
        }
      ],
      "IsMainSection": false,
      "AllowTaskAssociation": false,
      "IsMandatoryAttachment": false,
      "IsSectionTable": false,
      "ConditionalRules": [],
      "VisibilityRules": [],
      "AccessControlRules": []
    }
  ]
}


Audit log sent successfully.


Generic audit log saved for Module: 46, Entity: 96, Type: IncidentManagementIncidentCategory


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/248/IncidentManagement/Categories


Request Body : {"PageNumber":1,"PageLimit":10,"SortingColumn":["CreatedOn"],"SortingOrder":["desc"]}


Request URL : https://api-qa-staging-2.oqsha.com/Resources/app-language-eng?orgId=232


Request URL : https://api-qa-staging-2.oqsha.com/Languages


Request URL : https://api-qa-staging-2.oqsha.com/Modules/APIs


Request URL : https://api-qa-staging-2.oqsha.com/Modules/Version/All?Appversion=5.12.0


Request URL : https://api-qa-staging-2.oqsha.com/Health


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


Request URL : https://api-qa-staging-2.oqsha.com/AccessControl/Modules/232


Request URL : https://api-qa-staging-2.oqsha.com/Incidents


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/232/TicketStatus/Counts


Request Body : {"ReportedByUserIds":[],"OrgId":[232],"LocationId":[],"DivisionId":[],"DepartmentId":[],"StartDate":"2026-04-16","EndDate":"2026-04-30","PageNumber":1,"PageLimit":10}


Request URL : https://api-qa-staging-2.oqsha.com/AppVersions?DeviceType=ios&Version=5.12.0&IsOqsha=true


Request URL : https://api-qa-staging-2.oqsha.com/Resourceds/app-language-eng


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/211


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/211/Users/11591


Request URL : https://api-qa-staging-2.oqsha.com/Organisation/211/UserDetails


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/211/TicketStatus/Counts


Request URL : https://api-qa-staging-2.oqsha.com/AppVersions?DeviceType=android&IsLatestVersion=true&IsOqsha=true


Request URL : https://api-qa-staging-2.oqsha.com/AppVersions?DeviceType=android&Version=5.12.0&IsOqsha=true


Request URL : https://api-qa-staging-2.oqsha.com/Resourceds/app-language-eng?orgId=232


Request URL : https://api-qa-staging-2.oqsha.com/Languages


Request URL : https://api-qa-staging-2.oqsha.com/Modules/APIs


Request URL : https://api-qa-staging-2.oqsha.com/Health


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


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


Request URL : https://api-qa-staging-2.oqsha.com/AccessControl/Modules/232


Request URL : https://api-qa-staging-2.oqsha.com/Incidents


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/232/TicketStatus/Counts


Request Body : {"ReportedByUserIds":[],"OrgId":[232],"LocationId":[],"DivisionId":[],"DepartmentId":[],"StartDate":"2026-04-16","EndDate":"2026-04-30","PageNumber":1,"PageLimit":10}


Request URL : https://api-qa-staging-2.oqsha.com/Resources/app-language-eng?orgId=232


Request URL : https://api-qa-staging-2.oqsha.com/Modules/Version/All?Appversion=5.12.0


Request URL : https://api-qa-staging-2.oqsha.com/AppVersions?DeviceType=ios&Version=5.12.0&IsOqsha=true


Request URL : https://api-qa-staging-2.oqsha.com/Packages/List


Request URL : https://api-qa-staging-2.oqsha.com/Dashboard/Organisation/248


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/248/Comments


Request URL : https://api-qa-staging-2.oqsha.com/Organisation/248/FieldstaffsStats


Request URL : https://api-qa-staging-2.oqsha.com/Organisation/248/DivisionStats


Request URL : https://api-qa-staging-2.oqsha.com/Dashboard/Organisations/248/PageFlags


Request URL : https://api-qa-staging-2.oqsha.com/Dashboard/Organisations/248/Divisions?OrgId=248


Request URL : https://api-qa-staging-2.oqsha.com/AdminPortal/Organisations/248/Users


Request URL : https://api-qa-staging-2.oqsha.com/Dashboard/Organisations/248/PtwPreferences


Request URL : https://api-qa-staging-2.oqsha.com/Modules


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


Request URL : https://api-qa-staging-2.oqsha.com/AccessControl/Modules/248


Request URL : https://api-qa-staging-2.oqsha.com/Health


Request URL : https://api-qa-staging-2.oqsha.com/Resources/package-features-eng


Request URL : https://api-qa-staging-2.oqsha.com/Notifications


Request Body : {"OrgId":[248],"PageLimit":10,"SearchTerm":"","PageNumber":1,"SortingColumn":["CreatedOn"],"SortingOrder":["desc"]}


Request URL : https://api-qa-staging-2.oqsha.com/Incidents


You are not part of the requested organisation UserId: 2, OrgId: 248, Module: Notifications


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/248/PermitToWork/All?PageNumber=1&PageLimit=10&SearchTerm=&SortingColumn=PermitToWorkStartDate&SortingOrder=desc&IsAdminUser=true


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/248/Users/5538


You are not part of the requested organisation UserId: 2, OrgId: 248, Module: Tickets


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/248


You are not part of the requested organisation UserId: 2, OrgId: 248, Module: PermitToWork


Request URL : https://api-qa-staging-2.oqsha.com/Organisation/248/Modules


Request URL : https://api-qa-staging-2.oqsha.com/Languages


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/248/PendingActionsNotifications


Request URL : https://api-qa-staging-2.oqsha.com/Dashboard/Timezones


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/248/Users/4094


Request URL : https://api-qa-staging-2.oqsha.com/AccessControl/Modules/248


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/248/Reports/Dashboards


Request URL : https://api-qa-staging-2.oqsha.com/Resourceds/app-language-eng?orgId=257


Request URL : https://api-qa-staging-2.oqsha.com/Modules/APIs


Request URL : https://api-qa-staging-2.oqsha.com/Health


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


Request URL : https://api-qa-staging-2.oqsha.com/AppVersions?DeviceType=android&IsLatestVersion=true&IsOqsha=true


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 IncidentReporter.DAL.Repositories.VersionsRepo.<InsertUserHistoryAsync>d__9.MoveNext() in C:\GitLab-Runner\builds\27n6lYj0J\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 IncidentReporter.API.BLL.VersionsBLL.<GetAllModuleVersions>d__6.MoveNext() in C:\GitLab-Runner\builds\27n6lYj0J\0\incident-reporter\incident-reporter-api\IncidentReporter\IncidentReporter.API\BLL\VersionsBLL.cs:line 68


Request URL : https://api-qa-staging-2.oqsha.com/Dashboard/UpdateOrganisation/248


Audit log sent successfully.


Request URL : https://api-qa-staging-2.oqsha.com/Packages/List


Request URL : https://api-qa-staging-2.oqsha.com/Organisations/248/IncidentManagement/Category/96


Request URL : https://api-qa-staging-2.oqsha.com/Dashboard/Organisations?Pagination=true&PageNumber=1&PageLimit=10&SortingColumn=CreatedOn&SortingOrder=desc&SearchTerm=fal