search

bcgov / foi-flow

Freedom of Information modernization
Apache License 2.0
5 stars 3 forks source link

Redash - Deleted Requests Still Showing #3591

Open m-prodan opened 1 year ago

m-prodan commented 1 year ago

Describe the bug in current situation We had been receiving reports that the numbers returned in the TRA dashboard, are not consistent with the active request count in the mod platform.

After some investigation, it was determined that the requests in question may have been created in AXIS, and pulled into the data warehouse overnight, and later deleted from AXIS. It appears that when a request is deleted from AXIS, it is not being removed from the data warehouse, this is causing an inaccurate reporting figure for active FOI Requests.

Link bug to the User Story

Impact of this bug Will present an inaccurate picture of current active requests

Chance of Occurring (high/medium/low/very low) Low - in order for bug to happen, a request needs to be created in AXIS in error, and pulled into the request warehouse with the overnight data pull. The request then has to be deleted after it has been pulled into the warehouse.

The two requests in the data warehouse, that were deleted from AXIS, but still returning as active TRAN requests are: TRA-2023-30520, and TRA-2023-30868

Pre Conditions: which Env, any pre-requisites or assumptions to execute steps?

Steps to Reproduce Steps to reproduce the behavior:

  1. Create Request in AXIS
  2. Have request pulled into reporting application - confirm it is showing
  3. Delete Request from AXIS
  4. Await next refresh, confirm request is still present

Actual/ observed behaviour/ results

Expected behaviour A clear and concise description of what you expected to happen. Use the gherking language.

Screenshots/ Visual Reference/ Source If applicable, add screenshots to help explain your problem. You an use screengrab.

m-prodan commented 1 year ago

If anyone looks at this ticket - disregard for now, have to reproduce the issue I saw last week.