java.lang.Exception: Unique index 'catenode_uniq= ue_idx' cannot be added to table 'category_node' because 502 rows are not = unique. See the install guide for details on how to correct this problem. = You can use the following SQL to see which rows are not unique: SELECT * FROM category_node WHERE ( categoryId, nodeId ) IN ( SELECT = categoryId, nodeId FROM category_node GROUP BY categoryId, nodeId HAVING = count(categoryId) > 1 ORDER BY categoryId, nodeId ) ORDER BY categoryId, = nodeId at org.opennms.netmgt.dao.db.InstallerDb.checkIndexUniqueness(Insta= llerDb.java:2135)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via sourceforge.net by Unknown author, 1 year ago
Unique index 'catenode_uniq= ue_idx' cannot be added to table 'category_node' because 502 rows are not = unique. See the install guide for details on how to correct this problem. = You can use the following SQL to see which rows are not unique
java.lang.Exception: Unique index 'catenode_uniq= ue_idx' cannot be added to table 'category_node' because 502 rows are not = unique. See the install guide for details on how to correct this problem. = You can use the following SQL to see which rows are not unique: SELECT * FROM category_node WHERE ( categoryId, nodeId ) IN ( SELECT = categoryId, nodeId FROM category_node GROUP BY categoryId, nodeId HAVING = count(categoryId) > 1 ORDER BY categoryId, nodeId ) ORDER BY categoryId, = nodeId at org.opennms.netmgt.dao.db.InstallerDb.checkIndexUniqueness(Insta= llerDb.java:2135)
at org.opennms.install.Installer.install(Installer.java:221)
at org.opennms.install.Installer.main(Installer.java:679)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.