Uploaded image for project: 'OpenNMS'
  1. OpenNMS
  2. NMS-9605

Error loading node list page (column "event_id" does not exist)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 21.0.0
    • Fix Version/s: 21.0.0
    • Component/s: Web UI - General
    • Security Level: Default (Default Security Scheme)
    • Labels:
      None
    • Sprint:
      Horizon - August 30th

      Description

      The node details page fails to load with the following error:

      2017-08-31 14:23:24,730 WARN  [qtp2026604447-2921] o.e.j.s.HttpChannel: /opennms/element/node.jsp
      javax.servlet.ServletException: org.apache.jasper.JasperException: An exception occurred processing JSP page /element/node.jsp at line 805
      ...
      Caused by: org.postgresql.util.PSQLException: ERROR: column "event_id" does not exist
        Position: 48
              at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458) ~[postgresql-9.4.1211.jar:9.4.1211]
              at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2158) ~[postgresql-9.4.1211.jar:9.4.1211]
              at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:291) ~[postgresql-9.4.1211.jar:9.4.1211]
              at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432) ~[postgresql-9.4.1211.jar:9.4.1211]
      

      The following line appears to be the culprit:
      https://github.com/OpenNMS/opennms/blame/develop/opennms-webapp/src/main/java/org/opennms/web/event/EventFactory.java#L224

        Attachments

          Activity

            People

            • Assignee:
              fooker Dustin Frisch
              Reporter:
              j-white Jesse White
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: