-
Notifications
You must be signed in to change notification settings - Fork 18
VRR SOP
From related SNOW ticket: APPEALS-4106 - Manually Complete VeteranRecordRequest INC22451913:
Caseflow is automatically creating VeteranRecordRequest tasks for the business line VRE. This is incorrect as VRE now uses VBMS and we don't need to get the records manually. There are currently 136 active VRE record request tasks that should be set to completed or cancelled. The tasks can be found in the database with the query
SELECT * from tasks WHERE type='VeteranRecordRequest' AND status in ('assigned', 'on_hold', 'in_progress') AND assigned_to_id=220;
-
Note: As of this writing, the root cause of these errant tasks being created has not yet been addressed in the application code. See related Slack thread.
-
Introduces rake task
remediations:cancel_vrr_tasks_open_for_vre
, which identifies any currently openVeteranRecordReqeust
Tasks that are assigned to the "Veteran Readiness and Employment"BusinessLine
and cancels them and their open descendant tasks.
From the Rails console, run the following query and note the result:
sudo su -
source /opt/caseflow-certification/caseflow-certification_env.sh; cd /opt/caseflow-certification/src; bin/rails c
RequestStore[:current_user] = User.system_user
vre_business_line =
BusinessLine.where(name: Constants::BENEFIT_TYPES["voc_rehab"])
final_count_of_open_vrr_tasks =
VeteranRecordRequest.open.where(assigned_to: vre_business_line).count
final_count_of_cancelled_vrr_tasks =
VeteranRecordRequest.cancelled.where(assigned_to: vre_business_line).count
Exit the rails console and run rake task from AWS terminal:
bin/rake remediations:cancel_vrr_tasks_open_for_vre
Reopen the Rails console, run the following query and note the result:
sudo su -
source /opt/caseflow-certification/caseflow-certification_env.sh; cd /opt/caseflow-certification/src; bin/rails c
RequestStore[:current_user] = User.system_user
vre_business_line =
BusinessLine.where(name: Constants::BENEFIT_TYPES["voc_rehab"])
final_count_of_open_vrr_tasks =
VeteranRecordRequest.open.where(assigned_to: vre_business_line).count
final_count_of_cancelled_vrr_tasks =
VeteranRecordRequest.cancelled.where(assigned_to: vre_business_line).count
The final count of open VRR tasks for VRE should now be 0
, and the final count of cancelled VRR tasks for VRE should be incremented by the initial count of the final_count_of_open_vrr_tasks
- Home
- Acronyms and Glossary
- Caseflow products
- Caseflow Intake
- Caseflow Queue
- Caseflow Reader
- Caseflow eFolder
- Caseflow Hearings
- Caseflow Certification
- Caseflow APIs
- Appeal Status API
- Caseflow Dispatch
-
CSUM Roles
- System Admin
- VHA Team Management
- Active Record Queries Resource
- External Integrations
- Caseflow Demo
- Caseflow ProdTest
- Background
- Stuck Jobs
- VA Notify
- Caseflow-Team
- Frontend Best Practices
- Accessibility
- How-To
- Debugging Tips
- Adding a Feature Flag with FeatureToggle
- Editing AMA issues
- Editing a decision review
- Fixing task trees
- Investigating and diagnosing issues
- Data and Metric Request Workflow
- Exporting and Importing Appeals
- Explain page for Appeals
- Record associations and Foreign Keys
- Upgrading Ruby
- Stuck Appeals
- Testing Action Mailer Messages Locally
- Re-running Seed Files
- Rake Generator for Legacy Appeals
- Manually running Scheduled Jobs
- System Admin UI
- Caseflow Makefile
- Upgrading Postgresql from v11.7 to v14.8 Locally
- VACOLS VM Trigger Fix M1
- Using SlackService to Send a Job Alert
- Technical Talks