ET_WITH_MISSING_SNAME

SNAME in ET is the default name if NNAME or GNAME are blank. Therefore it is very important to put a value here.

If SNAME is blank, no ELEMENT_SUBNATIONAL record can be successfully created in HDMS. This will in turn cascade down to any EO records for those ELEMENT_SUBNATIONAL records.

QC Procedure:

In ET:

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

Resolution:

In all cases, data must be modified. There is no configuration work-around. In nearly all cases, the missing SNAME values are for Community Elements that have an SCOMNAME value assigned. In the absence of better data, put SCOMNAME into the SNAME field in order to successfully generate ELEMENT_SUBNATIONAL records in the HDMS.

Back to HdmsQcBatchProcess
Back to DataQc