- 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)
-
- ONT should not be attached to multiple MST Ports (seeing up to six in DataTDEL)
- 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 indata_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 inmigration_cleaned_data
table - found it inmst_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
Created
June 22, 2023 18:32
-
-
Save GreysonElkins/bb2b03844e29e179e4b52938431b8c28 to your computer and use it in GitHub Desktop.
Group 19 Debug Session
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment