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)