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)

sourceforge.net | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    OpenNMS / Mailing Lists

    sourceforge.net | 8 months ago
    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)
  2. 0

    OpenNMS / Mailing Lists

    sourceforge.net | 11 months ago
    java.lang.Exception: property "importer.requisition.dir" not set from bundled installer.properties file
  3. 0

    OpenNMS / Mailing Lists

    sourceforge.net | 11 months ago
    java.lang.Exception: property "importer.requisition.dir" not set from bundled installer.properties file
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. org.opennms.install
      Installer.main
      1. org.opennms.install.Installer.install(Installer.java:221)
      2. org.opennms.install.Installer.main(Installer.java:679)
      2 frames