Duplicate Enumvalue

From IMSMA Wiki
Revision as of 09:29, 7 July 2014 by Dionysia (talk | contribs)
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 occur in cases where one enumvalue is active and the others 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