NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
{{Warning | Duplicate enumvalues will cause import problems that are difficult to detect because there is no error message. }}
{{Note | The import problem will also occur happen in cases where one enumvalue enumeration value is active and the others other are inactive. The import problem does not apply to CDFs. }}
If this SQL gives a result set, contact your [[Information Management Team | GICHD IM advisor]]:
<pre>
SELECT
imsmaenum.enumcategory,
imsmaenum.enumvalue,
COUNT (imsmaenum.imsmaenum_guid)
FROM
imsmaenum
imsmaenum.enumvalue
HAVING
COUNT ( imsmaenum.imsmaenum_guid ) > 1
ORDER BY
imsmaenum.enumcategory ASC,
[[Category:SQL Queries]]
[[Category:NAA]]
[[Category:Known Issues]]
