All pastes #287424 Raw Edit

Anonymous

public text v1 · immutable
#287424 ·published 2006-12-21 13:44 UTC
rendered paste body
Exception in thread "main" java.lang.Exception: Error changing table 'ipinterface'.  Nested exception: Statement.execute() threw an SQLException while inserting a row: "INSERT INTO ipinterface (ifindex, ipaddr, iphostname, iplastcapsdpoll, ipstatus, ismanaged, issnmpprimary, nodeid) values (7, 172.31.128.241, 172.31.128.241, 2006-07-12 06:56:39.312000 +0200, 1, N, N, 9)".  Original exception: org.postgresql.util.PSQLException: ERROR: IpInterface Trigger Notice, Condition 1: No SnmpInterface found for... nodeid: 9 ifindex: 7
        at org.opennms.netmgt.dao.db.InstallerDb.createTables(InstallerDb.java:607)
        at org.opennms.install.Installer.install(Installer.java:208)
        at org.opennms.install.Installer.main(Installer.java:729)
Caused by: java.sql.SQLException: Statement.execute() threw an SQLException while inserting a row: "INSERT INTO ipinterface (ifindex, ipaddr, iphostname, iplastcapsdpoll, ipstatus, ismanaged, issnmpprimary, nodeid) values (7, 172.31.128.241, 172.31.128.241, 2006-07-12 06:56:39.312000 +0200, 1, N, N, 9)".  Original exception: org.postgresql.util.PSQLException: ERROR: IpInterface Trigger Notice, Condition 1: No SnmpInterface found for... nodeid: 9 ifindex: 7
        at org.opennms.netmgt.dao.db.InstallerDb.transformData(InstallerDb.java:1255)
        at org.opennms.netmgt.dao.db.InstallerDb.changeTable(InstallerDb.java:1051)
        at org.opennms.netmgt.dao.db.InstallerDb.createTables(InstallerDb.java:605)
        ... 2 more