Difference between revisions of "Duplicate Enumvalue"
From IMSMA Wiki
| Line 2: | Line 2: | ||
{{Note | 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. }} | {{Note | 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: | + | If this SQL gives a result set, contact your [[Management Consulting Team | GICHD IM advisor]]: |
<pre> | <pre> | ||
SELECT | SELECT | ||
Revision as of 11:18, 6 November 2014
 |
Duplicate enumvalues will cause import problems that are difficult to detect because there is no error message. |
 |
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
