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 | 9 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    OpenNMS / Mailing Lists

    sourceforge.net | 9 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 | 12 months ago
    java.lang.Exception: property "importer.requisition.dir" not set from bundled installer.properties file
  3. 0

    OpenNMS / Mailing Lists

    sourceforge.net | 12 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