Duplicate Enumvalue

From IMSMA Wiki
Jump to: navigation, search
Warning.jpg Duplicate enumvalues will cause import problems that are difficult to detect because there is no error message.
Note.jpg The import problem will also happen in cases where one enumeration value is active and the other are inactive. The import problem does not apply to CDFs.

If this SQL gives a result set, contact your GICHD IM advisor:

SELECT
        imsmaenum.enumcategory,
        imsmaenum.enumvalue,
        COUNT(imsmaenum.imsmaenum_guid)
FROM
        imsmaenum
GROUP BY
        imsmaenum.enumcategory,
        imsmaenum.enumvalue
HAVING
        COUNT(imsmaenum.imsmaenum_guid) > 1
ORDER BY
        imsmaenum.enumcategory ASC,
        imsmaenum.enumvalue ASC