[opennms-install] Search Asset Information java error

[Jim C. <jim...@gm...>]

I ran into this while in the Search Asset Information page.  In the Assets
in Category menu, I selected "Unix Servers" (although it doesn't matter
which value I select) and end up with this on the next page:

java.lang.IllegalArgumentException: Column "category" is not a valid column name


[extra lines snipped]


As a sanity check, I re-ran the OpenNMS installer for PostgreSQL:

$ $OPENNMS_HOME/bin/install -disU
==============================================================================
OpenNMS Installer Version $Id: Installer.java 3056 2006-03-26 19:39:16Z
djgregor $
==============================================================================

Configures PostgreSQL tables, users, and other miscellaneous settings.

- checking database version... 7.2
  - Full version string: PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by
GCC 2.96
* using 'opennms' as the PostgreSQL user for OpenNMS
* using 'opennms' as the PostgreSQL password for OpenNMS
* using 'opennms' as the PostgreSQL database name for OpenNMS
- using SQL directory... /opt/OpenNMS/etc
- using create.sql... /opt/OpenNMS/etc/create.sql
- using iplike module... /opt/OpenNMS/lib/iplike.so
- checking database for old backup tables... NONE
- checking for rows that violate constraints... NONE
- creating tables...
  - checking table "serverMap"... UPTODATE
  - checking table "serviceMap"... UPTODATE
  - checking table "distPoller"... UPTODATE
  - checking table "node"... UPTODATE
  - checking table "ipInterface"... UPTODATE
  - checking table "snmpInterface"... UPTODATE
  - checking table "service"... UPTODATE
  - checking table "ifServices"... UPTODATE
  - checking table "events"... UPTODATE
  - checking table "outages"... UPTODATE
  - checking table "vulnerabilities"... UPTODATE
  - checking table "vulnPlugins"... UPTODATE
  - checking table "notifications"... UPTODATE
  - checking table "usersNotified"... UPTODATE
  - checking table "assets"... UPTODATE
- creating tables... DONE
- creating sequences...
  - checking "nodeNxtId" minimum value... 8
  - removing sequence "nodeNxtId"... REMOVED
  - creating sequence "nodeNxtId"... OK
  - checking "serviceNxtId" minimum value... 32
  - removing sequence "serviceNxtId"... REMOVED
  - creating sequence "serviceNxtId"... OK
  - checking "eventsNxtId" minimum value... 280
  - removing sequence "eventsNxtId"... REMOVED
  - creating sequence "eventsNxtId"... OK
  - checking "outageNxtId" minimum value... 1
  - removing sequence "outageNxtId"... REMOVED
  - creating sequence "outageNxtId"... OK
  - checking "notifyNxtId" minimum value... 1
  - removing sequence "notifyNxtId"... REMOVED
  - creating sequence "notifyNxtId"... OK
  - checking "vulnNxtId" minimum value... 1
  - removing sequence "vulnNxtId"... REMOVED
  - creating sequence "vulnNxtId"... OK
- creating sequences... DONE
- creating indexes...
  - creating index "server_name_idx"... EXISTS
  - creating index "servicemap_name_idx"... EXISTS
  - creating index "serviceMap_ipaddr_idx"... EXISTS
  - creating index "node_id_type_idx"... EXISTS
  - creating index "node_label_idx"... EXISTS
  - creating index "ipinterface_nodeid_ipaddr_ismanaged_idx"... EXISTS
  - creating index "ipinterface_ipaddr_ismanaged_idx"... EXISTS
  - creating index "ipinterface_ipaddr_idx"... EXISTS
  - creating index "ipinterface_nodeid_ismanaged_idx"... EXISTS
  - creating index "ipinterface_nodeid_idx"... EXISTS
  - creating index "snmpinterface_nodeid_ifindex_idx"... EXISTS
  - creating index "snmpinterface_nodeid_idx"... EXISTS
  - creating index "snmpinterface_ipaddr_idx"... EXISTS
  - creating index "ifservices_nodeid_ipaddr_status"... EXISTS
  - creating index "ifservices_nodeid_status"... EXISTS
  - creating index "ifservices_nodeid_idx"... EXISTS
  - creating index "ifservices_serviceid_idx"... EXISTS
  - creating index "ifservices_nodeid_serviceid_idx"... EXISTS
  - creating index "events_uei_idx"... EXISTS
  - creating index "events_nodeid_idx"... EXISTS
  - creating index "events_ipaddr_idx"... EXISTS
  - creating index "events_serviceid_idx"... EXISTS
  - creating index "events_time_idx"... EXISTS
  - creating index "events_severity_idx"... EXISTS
  - creating index "events_log_idx"... EXISTS
  - creating index "events_display_idx"... EXISTS
  - creating index "events_ackuser_idx"... EXISTS
  - creating index "events_acktime_idx"... EXISTS
  - creating index "outages_svclostid_idx"... EXISTS
  - creating index "outages_svcregainedid_idx"... EXISTS
  - creating index "outages_nodeid_idx"... EXISTS
  - creating index "outages_ipaddr_idx"... EXISTS
  - creating index "outages_serviceid_idx"... EXISTS
  - creating index "outages_regainedservice_idx"... EXISTS
  - creating index "vulnerabilities_nodeid_idx"... EXISTS
  - creating index "vulnerabilities_ipaddr_idx"... EXISTS
  - creating index "vulnerabilities_severity_idx"... EXISTS
  - creating index "vulnerabilities_port_idx"... EXISTS
  - creating index "vulnerabilities_protocol_idx"... EXISTS
  - creating index "vulnplugins_plugin_idx"... EXISTS
  - creating index "notifications_ipaddr_idx"... EXISTS
  - creating index "notifications_serviceid_idx"... EXISTS
  - creating index "notifications_eventid_idx"... EXISTS
  - creating index "notifications_respondtime_idx"... EXISTS
  - creating index "notifications_answeredby_idx"... EXISTS
  - creating index "userid_notifyid_idx"... EXISTS
- creating indexes... DONE
- inserting initial table data for "distPoller"... EXISTS
- checking if database "opennms" is unicode... ALREADY UNICODE
- checking for stale iplike references... REMOVED
- checking for stale eventtime.so references... CLEAN
- adding iplike database function... OK
- adding PL/pgSQL call handler... EXISTS
- adding PL/pgSQL language module... EXISTS
- adding stored procedures...
  - getManagePercentAvailIntfWindow.sql... EXISTS
  - getManagePercentAvailNodeWindow.sql... EXISTS
  - getManagedOutageForIntfInWindow.sql... EXISTS
  - getManagedOutageForNodeInWindow.sql... EXISTS
  - getManagedServiceCountForIntf.sql... EXISTS
  - getManagedServiceCountForNode.sql... EXISTS
  - getOutageTimeInWindow.sql... EXISTS
  - getPercentAvailabilityInWindow.sql... EXISTS

Installer completed successfully!

I then tried the query again, but it came back with the same error as
previously.

So, what did I misconfigure this time?

jc