Fix tasks that were put on hold without a child TimedHoldTask when reassigned #12480

tomas-nava · 2019-10-24T21:49:28Z

Connects #12365

Description

Before #11293 and #12419 were merged, reassigning tasks that were on hold with a child TimedHoldTask could result in a new on hold task with no TimedHoldTask child:

before reassign

PrivacyActTask on_hold
└── PrivacyActTask on_hold
    └── TimedHoldTask assigned

after reassign

PrivacyActTask on_hold
├── PrivacyActTask cancelled
│   └── TimedHoldTask cancelled
└── PrivacyActTask on_hold

This results in an open task that causes the case to be seen in a user's queue, but cannot be acted upon.

This ticket exists to repair any cases with tasks in this state.

I believe they can all be found with this query:

> ids = Task.where("type <> ?", RootTask.name).on_hold.select { |task| task.children.empty? }.map(&:id)
=> [177386, 203412, 250519, 254971, 254972, 254973, 254983, 254988, 254991, 254992, 254993, 254994, 254995, 254996, 255003, 265650]

and they are affecting the following appeals:

> pp ids.map { |id| [id, Task.find(id).appeal_type, Task.find(id).appeal_type == Appeal.name ? Task.find(id).appeal.uuid : Task.find(id).appeal.vacols_id] }
[[177386, "Appeal", "82800170-3ecd-4408-a40c-81097d06f045"],
 [203412, "LegacyAppeal", "3807661"],
 [250519, "LegacyAppeal", "2882804"],
 [254971, "LegacyAppeal", "3161750"],
 [254972, "LegacyAppeal", "3105550"],
 [254973, "LegacyAppeal", "3625287"],
 [254983, "LegacyAppeal", "3526082"],
 [254988, "LegacyAppeal", "3670743"],
 [254991, "LegacyAppeal", "3336119"],
 [254992, "LegacyAppeal", "3608213"],
 [254993, "LegacyAppeal", "3238813"],
 [254994, "LegacyAppeal", "3580469"],
 [254995, "LegacyAppeal", "3347420"],
 [254996, "LegacyAppeal", "3331577"],
 [255003, "LegacyAppeal", "3788542"],
 [265650, "Appeal", "b03f034d-c3cf-4fcf-8d26-bf8a8bde1687"]]

The text was updated successfully, but these errors were encountered:

msj0nes · 2019-11-04T14:51:01Z

YourIT Tickets Impacted

YourIT Ticket Number	Date Ticket Created	Case Details URL
INC7848607	10/10/2019	Among the affected listed

hschallhorn · 2020-01-09T15:18:58Z

What is this graph?

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

For timed holds that have expired, se what would be the new parent to assigned. For timed holds that have not expired, move them under the new parent and set the TimedHoldTask to assigned. Double check that this covers all tasks. Open new ticket if we find other tasks that need to be migrated. Grab a buddy to ride along when changing production data.

hschallhorn · 2020-02-14T23:48:13Z

Looks like we've lost one task! Lets fix these geese.

old_ids = [177386, 203412, 250519, 254971, 254972, 254973, 254983, 254988, 254991, 254992, 254993, 254994, 254995, 254996, 255003, 265650]
old_ids.count
=> 16
ids = Task.where("type <> ?", RootTask.name).on_hold.select { |task| task.children.empty? }.map(&:id)
ids.count
=> 15
old_ids - ids
=> [203412]

# Lets confirm we can find the twin of these tasks
Task.find(ids).map { |task| Task.where(parent: task.parent, type: task.type).where.not(id: task.id).count }
=> [1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1]
# Let's confirm these have a timed hold child
=> [["TimedHoldTask"], [], ["TimedHoldTask"], ["TimedHoldTask"], ["TimedHoldTask"], ["TimedHoldTask"], ["TimedHoldTask"], ["TimedHoldTask"], ["TimedHoldTask"], ["TimedHoldTask"], ["TimedHoldTask"], ["TimedHoldTask"], ["TimedHoldTask"], ["TimedHoldTask"], ["TimedHoldTask"]]
# 🤔 What's going on with number 2?
Task.find(ids.second).appeal.treee :status, :placed_on_hold_at
                                            ┌───────────────────────────────────────┐
Appeal 1666 (direct_review) ─────────────── │ STATUS      │ PLACED_ON_HOLD_AT       │
└── RootTask                                │ on_hold     │ 2019-02-19 21:06:25 UTC │
    ├── TrackVeteranTask                    │ in_progress │                         │
    ├── DistributionTask                    │ completed   │                         │
    │   └── InformalHearingPresentationTask │ completed   │                         │
    ├── JudgeAssignTask                     │ cancelled   │                         │
    └── JudgeAssignTask                     │ on_hold     │ 2019-04-19 11:56:55 UTC │
                                            └───────────────────────────────────────┘
# Holy moley, this is unrelated, but let's get this task back to assigned
Task.find(ids.second).update!(status: Constants.TASK_STATUSES.assigned)

# Moving on! Let's make sure we don't have any oddballs left
ids = Task.where("type <> ?", RootTask.name).on_hold.select { |task| task.children.empty? }.map(&:id)
ids.count
=> 14
tasks = Task.where(id: ids)
tasks.map { |task| Task.where(parent: task.parent, type: task.type).where.not(id: task.id).first.children.map(&:type) }.all?(["TimedHoldTask"])
=> true
tasks.group(:type).count
=> {"PrivacyActTask"=>12, "Task"=>1, "TranslationTask"=>1}
# Let's see if any of these should have expired by now. The max days on hold is 120 days
# https://github.com/department-of-veterans-affairs/caseflow/blob/df26f44a1397441e19cbfde1892b38d70a1d06a5/app/models/tasks/timed_hold_task.rb#L13
timed_hold_tasks = tasks.map { |task| Task.where(parent: task.parent, type: task.type).where.not(id: task.id).first.children.first }
pp timed_hold_tasks.map(&:created_at).map { |created_at| (created_at + 120.days) < Time.zone.now }
[true,
 true,
 true,
 true,
 true,
 true,
 true,
 true,
 true,
 true,
 true,
 true,
 true,
 true]

# Alright, let's just move these timed hold tasks over to the new task and set their new parent to assigned
tasks.each do |task|
  timed_hold_task = Task.where(parent: task.parent, type: task.type).where.not(id: task.id).first.children.first
  timed_hold_task.update!(parent_id: task.id)
  task.update!(status: Constants.TASK_STATUSES.assigned)
end
puts tasks.each(&:reload).map(&:appeal).map(&:tree)
                                    ┌───────────────────────────────────────────────────────────────────────────┐
LegacyAppeal 459664 (legacy) ────── │ ID     │ STATUS    │ ASGN_BY      │ ASGN_TO     │ UPDATED_AT              │
├── RootTask                        │ 10088  │ assigned  │              │ Bva         │ 2018-12-19 18:58:15 UTC │
└── PreRoutingFoiaColocatedTask     │ 10092  │ on_hold   │ BVADTCHERRY  │ Colocated   │ 2019-07-19 14:55:26 UTC │
    ├── PreRoutingFoiaColocatedTask │ 10093  │ cancelled │ BVADTCHERRY  │ BVALCLANTON │ 2019-07-19 14:49:49 UTC │
    │   └── Task                    │ 11839  │ completed │ BVALCLANTON  │ PrivacyTeam │ 2019-11-21 20:18:21 UTC │
    │       └── Task                │ 15401  │ completed │ BVAJRETAN    │ Colocated   │ 2019-11-21 20:18:22 UTC │
    │           └── Task            │ 15402  │ completed │ BVAJRETAN    │ BVAMWALLACE │ 2019-11-21 20:18:25 UTC │
    └── PreRoutingFoiaColocatedTask │ 152161 │ on_hold   │ BVACBENJAMIN │ BVATHUNTER  │ 2019-07-19 14:50:19 UTC │
        ├── Task                    │ 182584 │ on_hold   │ BVATHUNTER   │ PrivacyTeam │ 2019-11-21 20:18:29 UTC │
        │   ├── Task                │ 231749 │ cancelled │ VACOMCDONR2  │ VACOMCDONR2 │ 2019-11-21 20:18:24 UTC │
        │   └── Task                │ 250519 │ assigned  │ VACOMCDONR2  │ BVAJRETAN   │ 2020-02-14 23:45:36 UTC │
        │       └── TimedHoldTask   │ 231766 │ cancelled │ VACOMCDONR2  │ VACOMCDONR2 │ 2020-02-14 23:42:58 UTC │
        └── PrivacyActTask          │ 463742 │ completed │ BVATHUNTER   │ PrivacyTeam │ 2019-10-28 22:00:47 UTC │
            └── PrivacyActTask      │ 492554 │ completed │ BVAJRETAN    │ BVATPLOWDEN │ 2019-10-28 22:00:47 UTC │
                                    └───────────────────────────────────────────────────────────────────────────┘
                                    ┌───────────────────────────────────────────────────────────────────────────┐
LegacyAppeal 358603 (legacy) ────── │ ID     │ STATUS    │ ASGN_BY      │ ASGN_TO     │ UPDATED_AT              │
├── RootTask                        │ 225913 │ assigned  │              │ Bva         │ 2019-06-05 13:07:33 UTC │
├── PreRoutingFoiaColocatedTask     │ 225914 │ completed │ BVAJHWA      │ Colocated   │ 2019-10-21 15:00:28 UTC │
│   └── PreRoutingFoiaColocatedTask │ 225915 │ completed │ BVAJHWA      │ BVAMWALLACE │ 2019-10-21 15:00:28 UTC │
│       └── PrivacyActTask          │ 226709 │ on_hold   │ BVAMWALLACE  │ PrivacyTeam │ 2019-06-14 14:02:06 UTC │
│           ├── PrivacyActTask      │ 236411 │ cancelled │ VACOMCDONR2  │ VACOMCDONR2 │ 2019-06-28 18:03:51 UTC │
│           └── PrivacyActTask      │ 254971 │ assigned  │ VACOMCDONR2  │ BVAJRETAN   │ 2020-02-14 23:45:36 UTC │
│               └── TimedHoldTask   │ 241537 │ cancelled │ VACOMCDONR2  │ VACOMCDONR2 │ 2020-02-14 23:42:58 UTC │
└── FoiaColocatedTask               │ 516577 │ on_hold   │ BVACCYKOWSKI │ PrivacyTeam │ 2019-11-13 18:36:49 UTC │
    └── FoiaTask                    │ 516578 │ assigned  │ BVACCYKOWSKI │ PrivacyTeam │ 2019-11-13 18:36:49 UTC │
                                    └───────────────────────────────────────────────────────────────────────────┘
                                    ┌──────────────────────────────────────────────────────────────────────────┐
LegacyAppeal 276261 (legacy) ────── │ ID     │ STATUS    │ ASGN_BY     │ ASGN_TO     │ UPDATED_AT              │
├── RootTask                        │ 180332 │ assigned  │             │ Bva         │ 2019-04-22 16:41:14 UTC │
└── PreRoutingFoiaColocatedTask     │ 209970 │ on_hold   │ VACOBIRDEM  │ Colocated   │ 2019-07-19 14:50:13 UTC │
    └── PreRoutingFoiaColocatedTask │ 209971 │ on_hold   │ VACOBIRDEM  │ BVARSEAY    │ 2019-07-19 14:50:12 UTC │
        └── PrivacyActTask          │ 216791 │ on_hold   │ BVARSEAY    │ PrivacyTeam │ 2019-06-14 13:04:42 UTC │
            ├── PrivacyActTask      │ 236305 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2 │ 2019-06-28 18:04:45 UTC │
            └── PrivacyActTask      │ 254972 │ assigned  │ VACOMCDONR2 │ BVAJRETAN   │ 2020-02-14 23:45:36 UTC │
                └── TimedHoldTask   │ 241461 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2 │ 2020-02-14 23:42:58 UTC │
                                    └──────────────────────────────────────────────────────────────────────────┘
                                    ┌──────────────────────────────────────────────────────────────────────────┐
LegacyAppeal 782099 (legacy) ────── │ ID     │ STATUS    │ ASGN_BY     │ ASGN_TO     │ UPDATED_AT              │
├── RootTask                        │ 222661 │ assigned  │             │ Bva         │ 2019-06-02 21:20:15 UTC │
└── PreRoutingFoiaColocatedTask     │ 222662 │ on_hold   │ BVARKESSEL  │ Colocated   │ 2019-07-19 14:55:06 UTC │
    └── PreRoutingFoiaColocatedTask │ 222663 │ on_hold   │ BVARKESSEL  │ BVATHUNTER  │ 2019-07-19 14:55:15 UTC │
        └── PrivacyActTask          │ 225453 │ on_hold   │ BVATHUNTER  │ PrivacyTeam │ 2019-06-14 13:48:39 UTC │
            ├── PrivacyActTask      │ 236378 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2 │ 2019-06-28 18:05:22 UTC │
            └── PrivacyActTask      │ 254973 │ assigned  │ VACOMCDONR2 │ BVAJRETAN   │ 2020-02-14 23:45:36 UTC │
                └── TimedHoldTask   │ 241541 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2 │ 2020-02-14 23:42:58 UTC │
                                    └──────────────────────────────────────────────────────────────────────────┘
                                    ┌──────────────────────────────────────────────────────────────────────────┐
LegacyAppeal 657696 (legacy) ────── │ ID     │ STATUS    │ ASGN_BY     │ ASGN_TO     │ UPDATED_AT              │
├── RootTask                        │ 200415 │ assigned  │             │ Bva         │ 2019-05-13 14:26:12 UTC │
├── PreRoutingFoiaColocatedTask     │ 212798 │ completed │ VACOBODIB   │ Colocated   │ 2019-09-05 15:02:31 UTC │
│   └── PreRoutingFoiaColocatedTask │ 212799 │ completed │ VACOBODIB   │ BVAMWALLACE │ 2019-09-05 15:02:31 UTC │
│       └── PrivacyActTask          │ 214162 │ on_hold   │ BVAMWALLACE │ PrivacyTeam │ 2019-06-14 12:46:13 UTC │
│           ├── PrivacyActTask      │ 236250 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2 │ 2019-06-28 18:06:11 UTC │
│           └── PrivacyActTask      │ 254983 │ assigned  │ VACOMCDONR2 │ BVAJRETAN   │ 2020-02-14 23:45:36 UTC │
│               └── TimedHoldTask   │ 241396 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2 │ 2020-02-14 23:42:58 UTC │
├── OtherColocatedTask              │ 397217 │ completed │ VACOBODIB   │ Colocated   │ 2020-02-06 15:41:50 UTC │
│   └── OtherColocatedTask          │ 397218 │ completed │ VACOBODIB   │ BVAMWALLACE │ 2020-02-06 15:41:50 UTC │
└── FoiaColocatedTask               │ 417529 │ on_hold   │ VACOBODIB   │ PrivacyTeam │ 2019-09-18 15:50:27 UTC │
    └── FoiaTask                    │ 417530 │ assigned  │ VACOBODIB   │ PrivacyTeam │ 2019-09-18 15:50:27 UTC │
                                    └──────────────────────────────────────────────────────────────────────────┘
                                    ┌──────────────────────────────────────────────────────────────────────────┐
LegacyAppeal 205368 (legacy) ────── │ ID     │ STATUS    │ ASGN_BY     │ ASGN_TO     │ UPDATED_AT              │
├── RootTask                        │ 208066 │ completed │             │ Bva         │ 2019-12-09 14:52:12 UTC │
└── PreRoutingFoiaColocatedTask     │ 236059 │ completed │ VACOSTRINA  │ Colocated   │ 2019-10-21 15:03:02 UTC │
    └── PreRoutingFoiaColocatedTask │ 236060 │ completed │ VACOSTRINA  │ BVAMWALLACE │ 2019-10-21 15:03:02 UTC │
        └── PrivacyActTask          │ 236381 │ on_hold   │ BVAMWALLACE │ PrivacyTeam │ 2019-06-14 17:07:44 UTC │
            ├── PrivacyActTask      │ 236831 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2 │ 2019-06-28 18:06:39 UTC │
            └── PrivacyActTask      │ 254988 │ assigned  │ VACOMCDONR2 │ BVAJRETAN   │ 2020-02-14 23:45:36 UTC │
                └── TimedHoldTask   │ 241553 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2 │ 2020-02-14 23:42:58 UTC │
                                    └──────────────────────────────────────────────────────────────────────────┘
                                    ┌──────────────────────────────────────────────────────────────────────────┐
LegacyAppeal 221219 (legacy) ────── │ ID     │ STATUS    │ ASGN_BY     │ ASGN_TO     │ UPDATED_AT              │
├── RootTask                        │ 211549 │ assigned  │             │ Bva         │ 2019-05-21 22:29:23 UTC │
└── PreRoutingFoiaColocatedTask     │ 215055 │ on_hold   │ VACOULLERJ  │ Colocated   │ 2019-07-19 14:50:00 UTC │
    └── PreRoutingFoiaColocatedTask │ 215056 │ on_hold   │ VACOULLERJ  │ BVAMJKOROMA │ 2019-07-19 14:49:59 UTC │
        └── PrivacyActTask          │ 216944 │ on_hold   │ BVAMJKOROMA │ PrivacyTeam │ 2019-06-14 13:06:28 UTC │
            ├── PrivacyActTask      │ 236308 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2 │ 2019-06-28 18:07:18 UTC │
            └── PrivacyActTask      │ 254991 │ assigned  │ VACOMCDONR2 │ BVAJRETAN   │ 2020-02-14 23:45:36 UTC │
                └── TimedHoldTask   │ 241486 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2 │ 2020-02-14 23:42:58 UTC │
                                    └──────────────────────────────────────────────────────────────────────────┘
                                    ┌───────────────────────────────────────────────────────────────────────────┐
LegacyAppeal 273067 (legacy) ────── │ ID     │ STATUS    │ ASGN_BY     │ ASGN_TO      │ UPDATED_AT              │
├── RootTask                        │ 227155 │ completed │             │ Bva          │ 2020-01-16 13:41:03 UTC │
├── PreRoutingFoiaColocatedTask     │ 227156 │ completed │ VACOREIDJ   │ Colocated    │ 2019-07-23 12:21:44 UTC │
│   └── PreRoutingFoiaColocatedTask │ 227157 │ completed │ VACOREIDJ   │ BVAMWALLACE  │ 2019-07-23 12:21:44 UTC │
│       └── PrivacyActTask          │ 230984 │ on_hold   │ BVAMWALLACE │ PrivacyTeam  │ 2019-06-14 14:14:28 UTC │
│           ├── PrivacyActTask      │ 236468 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2  │ 2019-06-28 18:07:49 UTC │
│           └── PrivacyActTask      │ 254992 │ assigned  │ VACOMCDONR2 │ BVAJRETAN    │ 2020-02-14 23:45:36 UTC │
│               └── TimedHoldTask   │ 241560 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2  │ 2020-02-14 23:42:58 UTC │
└── FoiaColocatedTask               │ 342992 │ completed │ VACOREIDJ   │ PrivacyTeam  │ 2019-12-08 18:10:37 UTC │
    └── FoiaTask                    │ 342993 │ completed │ VACOREIDJ   │ PrivacyTeam  │ 2019-12-08 18:10:37 UTC │
        └── FoiaTask                │ 549771 │ completed │ BVAJRETAN   │ BVAAMILHOUSE │ 2019-12-08 18:10:37 UTC │
                                    └───────────────────────────────────────────────────────────────────────────┘
                                    ┌──────────────────────────────────────────────────────────────────────────┐
LegacyAppeal 343599 (legacy) ────── │ ID     │ STATUS    │ ASGN_BY     │ ASGN_TO     │ UPDATED_AT              │
├── RootTask                        │ 216447 │ assigned  │             │ Bva         │ 2019-05-28 13:25:28 UTC │
└── PreRoutingFoiaColocatedTask     │ 216458 │ on_hold   │ BVAAJAEGER  │ Colocated   │ 2019-07-19 14:50:13 UTC │
    └── PreRoutingFoiaColocatedTask │ 216459 │ on_hold   │ BVAAJAEGER  │ BVAMJKOROMA │ 2019-07-19 14:50:38 UTC │
        └── PrivacyActTask          │ 216948 │ on_hold   │ BVAMJKOROMA │ PrivacyTeam │ 2019-06-14 13:08:45 UTC │
            ├── PrivacyActTask      │ 236315 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2 │ 2019-06-28 18:08:06 UTC │
            └── PrivacyActTask      │ 254993 │ assigned  │ VACOMCDONR2 │ BVAJRETAN   │ 2020-02-14 23:45:36 UTC │
                └── TimedHoldTask   │ 241570 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2 │ 2020-02-14 23:42:58 UTC │
                                    └──────────────────────────────────────────────────────────────────────────┘
                                    ┌──────────────────────────────────────────────────────────────────────────┐
LegacyAppeal 257174 (legacy) ────── │ ID     │ STATUS    │ ASGN_BY     │ ASGN_TO     │ UPDATED_AT              │
├── RootTask                        │ 227890 │ assigned  │             │ Bva         │ 2019-06-06 15:54:58 UTC │
└── PreRoutingFoiaColocatedTask     │ 227895 │ on_hold   │ VACOWALKEK3 │ Colocated   │ 2019-07-19 14:50:20 UTC │
    └── PreRoutingFoiaColocatedTask │ 227896 │ on_hold   │ VACOWALKEK3 │ BVATHUNTER  │ 2019-07-19 14:55:01 UTC │
        └── PrivacyActTask          │ 229579 │ on_hold   │ BVATHUNTER  │ PrivacyTeam │ 2019-06-14 14:11:16 UTC │
            ├── PrivacyActTask      │ 236449 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2 │ 2019-06-28 18:08:28 UTC │
            └── PrivacyActTask      │ 254994 │ assigned  │ VACOMCDONR2 │ BVAJRETAN   │ 2020-02-14 23:45:36 UTC │
                └── TimedHoldTask   │ 241576 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2 │ 2020-02-14 23:42:58 UTC │
                                    └──────────────────────────────────────────────────────────────────────────┘
                                    ┌──────────────────────────────────────────────────────────────────────────┐
LegacyAppeal 283596 (legacy) ────── │ ID     │ STATUS    │ ASGN_BY     │ ASGN_TO     │ UPDATED_AT              │
├── RootTask                        │ 215382 │ assigned  │             │ Bva         │ 2019-05-24 21:03:16 UTC │
└── PreRoutingFoiaColocatedTask     │ 215383 │ on_hold   │ BVATASMITH  │ Colocated   │ 2019-07-19 14:50:03 UTC │
    └── PreRoutingFoiaColocatedTask │ 215384 │ on_hold   │ BVATASMITH  │ BVAMJKOROMA │ 2019-07-19 14:50:03 UTC │
        └── PrivacyActTask          │ 216989 │ on_hold   │ BVAMJKOROMA │ PrivacyTeam │ 2019-06-14 13:11:15 UTC │
            ├── PrivacyActTask      │ 236317 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2 │ 2019-06-28 18:08:53 UTC │
            └── PrivacyActTask      │ 254995 │ assigned  │ VACOMCDONR2 │ BVAJRETAN   │ 2020-02-14 23:45:36 UTC │
                └── TimedHoldTask   │ 241588 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2 │ 2020-02-14 23:42:58 UTC │
                                    └──────────────────────────────────────────────────────────────────────────┘
                                    ┌──────────────────────────────────────────────────────────────────────────┐
LegacyAppeal 391108 (legacy) ────── │ ID     │ STATUS    │ ASGN_BY     │ ASGN_TO     │ UPDATED_AT              │
├── RootTask                        │ 233276 │ assigned  │             │ Bva         │ 2019-06-12 12:35:29 UTC │
└── PreRoutingFoiaColocatedTask     │ 233320 │ on_hold   │ BVACWENDELL │ Colocated   │ 2019-07-19 14:55:13 UTC │
    └── PreRoutingFoiaColocatedTask │ 233321 │ on_hold   │ BVACWENDELL │ BVATHUNTER  │ 2019-07-19 14:55:19 UTC │
        └── PrivacyActTask          │ 234688 │ on_hold   │ BVATHUNTER  │ PrivacyTeam │ 2019-06-14 15:27:02 UTC │
            ├── PrivacyActTask      │ 236637 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2 │ 2019-06-28 18:09:14 UTC │
            └── PrivacyActTask      │ 254996 │ assigned  │ VACOMCDONR2 │ BVAJRETAN   │ 2020-02-14 23:45:36 UTC │
                └── TimedHoldTask   │ 241606 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2 │ 2020-02-14 23:42:58 UTC │
                                    └──────────────────────────────────────────────────────────────────────────┘
                                    ┌──────────────────────────────────────────────────────────────────────────┐
LegacyAppeal 433732 (legacy) ────── │ ID     │ STATUS    │ ASGN_BY     │ ASGN_TO     │ UPDATED_AT              │
├── RootTask                        │ 216021 │ assigned  │             │ Bva         │ 2019-05-28 09:44:31 UTC │
└── PreRoutingFoiaColocatedTask     │ 216022 │ on_hold   │ BVACMURRAY  │ Colocated   │ 2019-07-19 14:50:10 UTC │
    └── PreRoutingFoiaColocatedTask │ 216023 │ on_hold   │ BVACMURRAY  │ BVATHUNTER  │ 2019-07-19 14:50:09 UTC │
        └── PrivacyActTask          │ 219145 │ on_hold   │ BVATHUNTER  │ PrivacyTeam │ 2019-06-14 13:28:42 UTC │
            ├── PrivacyActTask      │ 236341 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2 │ 2019-06-28 18:10:59 UTC │
            └── PrivacyActTask      │ 255003 │ assigned  │ VACOMCDONR2 │ BVAJRETAN   │ 2020-02-14 23:45:36 UTC │
                └── TimedHoldTask   │ 241616 │ cancelled │ VACOMCDONR2 │ VACOMCDONR2 │ 2020-02-14 23:42:58 UTC │
                                    └──────────────────────────────────────────────────────────────────────────┘
                                                       ┌────────────────────────────────────────────────────────────────────────────┐
Appeal 2280 (direct_review) ────────────────────────── │ ID     │ STATUS      │ ASGN_BY     │ ASGN_TO     │ UPDATED_AT              │
└── RootTask                                           │ 148720 │ on_hold     │             │ Bva         │ 2019-03-21 18:19:51 UTC │
    ├── TrackVeteranTask                               │ 148721 │ cancelled   │             │ FieldVso    │ 2019-04-04 18:23:55 UTC │
    ├── DistributionTask                               │ 148722 │ completed   │             │ Bva         │ 2019-03-21 18:30:17 UTC │
    ├── TranslationTask                                │ 148723 │ completed   │             │ Translation │ 2019-09-25 20:18:01 UTC │
    │   └── TranslationTask                            │ 268043 │ completed   │ BVAMCOWAN   │ VACOHUGHES2 │ 2019-09-25 20:18:01 UTC │
    │       └── TimedHoldTask                          │ 269586 │ cancelled   │ VACOHUGHES2 │ VACOHUGHES2 │ 2019-09-25 20:18:01 UTC │
    ├── JudgeAssignTask                                │ 148738 │ on_hold     │             │ BVAAJAEGER  │ 2019-04-18 12:00:02 UTC │
    │   └── AttorneyTask                               │ 177210 │ on_hold     │ BVAAJAEGER  │ BVAMOLSON   │ 2019-05-01 17:49:43 UTC │
    │       ├── PreRoutingTranslationColocatedTask     │ 190566 │ cancelled   │ BVAMOLSON   │ Colocated   │ 2020-01-23 22:24:20 UTC │
    │       │   └── PreRoutingTranslationColocatedTask │ 190567 │ cancelled   │ BVAMOLSON   │ BVATHUNTER  │ 2020-01-23 22:24:20 UTC │
    │       └── TranslationTask                        │ 210675 │ on_hold     │ BVATHUNTER  │ Translation │ 2020-01-23 22:23:53 UTC │
    │           ├── TranslationTask                    │ 213145 │ cancelled   │ VACOHUGHES2 │ VACOHUGHES2 │ 2019-07-09 18:08:32 UTC │
    │           └── TranslationTask                    │ 265650 │ assigned    │ VACOHUGHES2 │ BVAMCOWAN   │ 2020-02-14 23:45:36 UTC │
    │               └── TimedHoldTask                  │ 258993 │ cancelled   │ VACOHUGHES2 │ VACOHUGHES2 │ 2020-02-14 23:42:58 UTC │
    ├── TrackVeteranTask                               │ 165444 │ cancelled   │             │ Vso         │ 2019-08-23 02:07:07 UTC │
    └── TrackVeteranTask                               │ 347466 │ in_progress │             │ PrivateBar  │ 2019-08-23 02:07:07 UTC │
                                                       └────────────────────────────────────────────────────────────────────────────┘

# Looks good other than gross PreRoutingFoiaColocatedTasks that will be cleaned up in #13266

tomas-nava added Source: Bat Team Team: Echo 🐬 labels Oct 24, 2019

jimruggiero added Stakeholder: BVA Functionality associated with the Board of Veterans' Appeals workflows/feature requests Product: caseflow-queue Priority: Medium Blocking issue w/workaround, or "second in" priority for new work. labels Feb 6, 2020

hschallhorn mentioned this issue Feb 10, 2020

Echo engineering team lines of effort 2020 #13175

Closed

hschallhorn self-assigned this Feb 14, 2020

hschallhorn mentioned this issue Feb 14, 2020

Clean up open tasks with closed parents #13438

Closed

1 task

hschallhorn closed this as completed Feb 18, 2020

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Fix tasks that were put on hold without a child TimedHoldTask when reassigned #12480

Fix tasks that were put on hold without a child TimedHoldTask when reassigned #12480

tomas-nava commented Oct 24, 2019 •

edited

Loading

msj0nes commented Nov 4, 2019 •

edited

Loading

hschallhorn commented Jan 9, 2020

hschallhorn commented Feb 14, 2020

Fix tasks that were put on hold without a child TimedHoldTask when reassigned #12480

Fix tasks that were put on hold without a child TimedHoldTask when reassigned #12480

Comments

tomas-nava commented Oct 24, 2019 • edited Loading

Description

msj0nes commented Nov 4, 2019 • edited Loading

YourIT Tickets Impacted

hschallhorn commented Jan 9, 2020

hschallhorn commented Feb 14, 2020

tomas-nava commented Oct 24, 2019 •

edited

Loading

msj0nes commented Nov 4, 2019 •

edited

Loading