Hearings | every hearing load causes 3 selects to three different tables

[anyakhvost]

VACOLS::Case Load (26.0ms)  SELECT  "VACOLS"."BRIEFF".* FROM "VACOLS"."BRIEFF" WHERE "VACOLS"."BRIEFF"."BFKEY" = :a1 AND ROWNUM <= 1   [["bfkey", "2372015"]] 

VACOLS::Folder Load (26.7ms)  SELECT "VACOLS"."FOLDER".* FROM "VACOLS"."FOLDER" WHERE "VACOLS"."FOLDER"."TICKNUM" IN ('2372015')

VACOLS::Correspondent Load (48.9ms)  SELECT "VACOLS"."CORRES".* FROM "VACOLS"."CORRES" WHERE "VACOLS"."CORRES"."STAFKEY" IN ('299384')

The issue is here:

delegate \
    :veteran_age, \
    :veteran_name, \
    :appellant_last_first_mi, \
    :appellant_city, \
    :appellant_state, \
    :vbms_id, \
    :number_of_documents, \
    :number_of_documents_after_certification, \
    :representative, \
    :veteran,  \
    to: :appeal, allow_nil: true

AC:

1. Ensure all pages work as accepted with no errors
2. When loading upcoming dockets page, ensure the above select statements are not in the logs
3. Let Anya know if noticing that performance is still lagging.

[astewarttistatech]

@aroltsch This ticket looks to be blocked as of now

[astewarttistatech]

PASSED

Validated in: UAT Browser: Chrome

Steps to Validate:

1. Go through the Hearings Prep flow with console in Inspector open
2. Verify that there are no errors.
3. Verify the information in the logs don't include variables and values from the AC

Screenshots:

[anyakhvost]

Re-opening this issue. It started happening again.

[sharonwarner]

Whoops. Sorry!

[ghost]

PASSED

VACOLS::CaseHearing Load (4484.9ms)  SELECT VACOLS.HEARING_VENUE(vdkey) as hearing_venue, staff.sdomainid as css_id, "VACOLS"."HEARSCHED"."HEARING_DISP", "VACOLS"."HEARSCHED"."HEARING_PKSEQ", "VACOLS"."HEARSCHED"."HEARING_DATE", "VACOLS"."HEARSCHED"."HEARING_TYPE", "VACOLS"."HEARSCHED"."NOTES1", "VACOLS"."HEARSCHED"."FOLDER_NR", "VACOLS"."
HEARSCHED"."VDKEY", "VACOLS"."HEARSCHED"."AOD", "VACOLS"."HEARSCHED"."HOLDDAYS", "VACOLS"."HEARSCHED"."TRANREQ", "VACOLS"."HEARSCHED"."REPNAME", "VACOLS"."HEARSCHED"."ADDON", "VACOLS"."HEARSCHED"."BOARD_MEMBER", "VACOLS"."HEARSCHED"."MDUSER", "VACOLS"."HEARSCHED"."MDTIME", "SATTYID", "BFREGOFF", "BFSO", "BFCORKEY", corres.snamef, corres.snamemi,
             corres.snamel, corres.sspare1,                                                                                                                                                                              corres.sspare2, corres.sspare3 FROM "VACOLS"."HEARSCHED" left outer join vacols.staff on staff.sattyid = board_member left outer join vacols.brieff on brieff.bfkey = folder_nr left outer join
 vacols.corres on corres.stafkey = bfcorkey WHERE "VACOLS"."HEARSCHED"."HEARING_TYPE" IN ('V', 'T', 'C') AND (staff.sdomainid = 'CF_WORF_317') AND (hearing_date > TO_TIMESTAMP('2017-10-17 01:25:03:092592','YYYY-MM-DD HH24:MI:SS:FF6'))
dsva-appeals-certification-uat/opt/caseflow-certification/src/log/caseflow-certification.out i-04cb6c31ff49155f3-172.30.70.211 [appeals.cf.uat.ds.va.gov] [377c0eef-42a0-4a16-89c2-ffc932f839b2] [172.30.70.211] [CF_WORF_317   caseflow@va.gov] [2017-10-23 21:25:09 -0400]    (204.9ms)  SELECT column_name AS name, data_type AS sql_type, data_default, nullable, virtual_column, hidden_column, data_type_owner AS
sql_type_owner, DECODE(data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale FROM all_tab_cols WHERE owner = 'VACOLS' AND table_name = 'TBSCHED' AND hid
den_column = 'NO' ORDER BY column_id                                                                                                                                                                        dsva-appeals-certification-uat/opt/caseflow-certification/src/log/caseflow-certification.out i-04cb6c31ff49155f3-172.30.70.211 [appeals.cf.uat.ds.va.gov] [377c0eef-42a0-4a16-89c2-ffc932f839b2] [172.30.70.
211] [CF_WORF_317   caseflow@va.gov] [2017-10-23 21:25:09 -0400]   VACOLS::TravelBoardSchedule Load (11.5ms)  SELECT (TBSCHED.TBYEAR||'-'||TBSCHED.TBTRIP||'-'||TBSCHED.TBLEG) as tbsched_vdkey, "VACOLS"."TBSCHED"."TBMEM1", "VACOLS"."TBSCHED"."TBMEM2", "VACOLS"."TBSCHED"."TBMEM3", "VACOLS"."TBSCHED"."TBMEM4", "VACOLS"."TBSCHED"."TBRO", "VACOLS"."TBSCHED"."TBSTDATE", "VACOLS"."TBSCHED"."TBENDDATE" FROM "VACO
LS"."TBSCHED" join vacols.staff on                                                                                                                                                                                          staff.sattyid = tbmem1 OR
                staff.sattyid = tbmem2 OR                                                                                                                                                                                   staff.sattyid = tbmem3 OR
                staff.sattyid = tbmem4 WHERE (staff.sdomainid = 'CF_WORF_317') AND (tbstdate > TO_TIMESTAMP('2017-10-17 01:25:03:093091','YYYY-MM-DD HH24:MI:SS:FF6'))

damn that's a query