Group 19 Debug Session

group19.md

• First Error: ORA-02437: cannot validate (LEEPDEV.SYS_C00109990456) - primary key violated
  • ONT should not be attached to multiple MST Ports (seeing up to six in DataTDEL)

    • select distinct
        house,
        street,
        street_suffix,
        worker_type,
        AP_LOCATION,
        AP_PORT,
        park_flag
      from data_tdel
      where ont = 'ONT CASA-8 1717 E BELL RD'
      

  • ONTs shouldn't have multiple SYS_TYP

    • select distinct
          house,
          street,
          street_suffix,
          worker_type,
          AP_LOCATION,
          AP_PORT,
          park_flag,
          sys_typ
      from data_tdel
      where ont = 'ONT CASA-4 6669 SW CANYON DR';
      -- where ont = 'ONT CASA-8 2708 BLAISDELL AVE S'
      

  • ONTs shouldn't be attatched to multiple street addresses

    • select distinct
          house,
          street,
          street_suffix,
          prov_state,
          postal_zip,
          worker_type,
          ont,
          AP_LOCATION,
          AP_PORT,
          park_flag,
          sys_typ
      from data_tdel
      where ont = 'ONT 2101 EMERSON AVE N';
      -- where ont = 'ONT 1416 27TH AVE NE';
      -- (also has multiple systypes)
      

• Second Error: ORA-02298: cannot validate (LEEPDEV.FK_ONT_MST_PORT) - parent keys not found

  • Should not recieve ONTs which are qual or desktop, without MST assignments

    • select * from ont 
      where mst_port_id not in (select distinct id from mst_port)
      and mst_port_id = 'PYLPWA010ONT2603MERIDIANAVEEUNITG106';
      
      select distinct
        fdh_dn,
        central_office,
        house,
        street,
        street_suffix,
        prov_state,
        postal_zip,
        worker_type,
        ont,
        AP_LOCATION,
        AP_PORT,
        park_flag,
        sys_typ
      from data_tdel
      where ont = 'ONT 2603 MERIDIAN AVE E UNIT G106';
      

    • NDS needs to be updated OR we need an mst_capacity column in data_tdel
      • if an MST does not exist in NDS we cannot determine it's attributes
      • MST not found in NDS '%2537 S BLACKHAWK ST%'

  • side notes from debug session

    • CLEANED_AP_LOCATION has trailing white-space in migration_cleaned_data table - found it in mst_data_tdel as well
    • Are there missing LD Cables?
    • Some MSTs don't exist in the MST Table
      • Searched for an MST in NDS, did not find
      • Searched for same MST in mst_data_tdel and found it
• Third Error: ORA-00001: unique constraint (LEEPDEV.PK_WMS_OUTPUT_TRIPLET) violated