ET_WITH_MISSING_GNAME

GNAME in ET

If GNAME is blank, no ELEMENT_GLOBAL record can be successfully created in HDMS. This will in turn cascade down to the ELEMENT_NATIONAL, then the ELEMENT_SUBNATIONAL, on to any EO records for those ELEMENT_SUBNATIONAL records.

QC Procedure:

In ET:

1. SELECT ET WITHOUT GNAME AND WITH SNAME
2. SAVELIST ET_WITH_MISSING_GNAME
3. GETLIST ET_WITH_MISSING_GNAME
4. LIST ET GNAME SNAME
5. Fix the data manually, or execute the following UPDATE command to put SNAME into the GNAME field.
6. UPDATE ET GETLIST ET_WITH_MISSING_GNAME SET GNAME = {SNAME}

Resolution:

In all cases, data must be modified. There is no configuration work-around.

Back to HdmsQcBatchProcess
Back to DataQc