Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Migrate pending incomplete and uncancelled task timers alert from Looker #12111

Closed
1 task
lowellrex opened this issue Sep 16, 2019 · 2 comments · Fixed by #12428
Closed
1 task

Migrate pending incomplete and uncancelled task timers alert from Looker #12111

lowellrex opened this issue Sep 16, 2019 · 2 comments · Fixed by #12428
Labels
Eng: Data Mark when data has been backfilled, or the issue has any data integrity concerns Feature: generic-queue Product: caseflow-queue Team: Echo 🐬

Comments

@lowellrex
Copy link
Contributor

Looker is going away and we need to migrate the pending incomplete and uncanceled task timers alert from Looker into Caseflow application code.

Acceptance criteria

  • Pending incomplete and uncanceled task timers alert is running in Caseflow application code.
@lowellrex lowellrex added Product: caseflow-queue Feature: generic-queue Eng: Data Mark when data has been backfilled, or the issue has any data integrity concerns labels Sep 16, 2019
@lomky lomky changed the title Migrate pending incomplete and uncanceled task timers alert from Looker Migrate pending incomplete and uncancelled task timers alert from Looker Sep 19, 2019
@kevmo
Copy link
Contributor

kevmo commented Sep 19, 2019

Possibly helpful references:
example SQL: #12065

https://github.com/department-of-veterans-affairs/caseflow/blob/master/app/jobs/data_integrity_checks_job.rb

@hschallhorn
Copy link
Contributor

What is this graph?

1 | |||
2 | |||||||
3 | ||
5 | 
8 |

Could be a one as we already have the data integrity check written and testing is straightforward. Replicating behavior from one environment to another could introduce unseen bugs.

@kevmo kevmo mentioned this issue Oct 6, 2019
Closed
@kevmo kevmo self-assigned this Oct 7, 2019
@kevmo kevmo mentioned this issue Feb 26, 2020
Merged
va-bot pushed a commit that referenced this issue Mar 31, 2020
@kevmo
Migrate task timer Looker view to data integrity checker (#12428)
070a6db 
Resolves #12111 

### Description
Ports the old Looker SQL snippet to a modern Query object. The SQL is included for reference.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Eng: Data Mark when data has been backfilled, or the issue has any data integrity concerns Feature: generic-queue Product: caseflow-queue Team: Echo 🐬
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Migrate task timer Looker view to data integrity checker department-of-veterans-affairs/caseflow
4 participants
@kevmo @lowellrex @hschallhorn @araposo-tistatech