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

The filter for the foreign source in the outages view caused an SQLGrammarException

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 17.0.0, 17.1.0
    • Fix Version/s: Meridian-2016.1.0, 18.0.1
    • Component/s: Web UI - General
    • Security Level: Default (Default Security Scheme)
    • Labels:
    • Environment:

      Description

      If you want to filer the outages by the foreign source you get a "The OpenNMS Web User Interface Has Experienced an Error" - Site with the hint that a "org.hibernate.exception.SQLGrammarException" is occurred.
      You can seen in the web.log that this exception is caused by an org.postgresql.util.PSQLException. These ecxeption says that the column this_.nodeid does not exist.

        Attachments

        1. FilterError.pdf
          55 kB
        2. ForeignSourceFilter.java
          3 kB
        3. NegativeForeignSourceFilter.java
          3 kB
        4. opennms-webapp-17.1.1.jar
          1.18 MB
        5. web.log
          23 kB

          Issue Links

            Activity

              People

              • Assignee:
                seth Seth Leger
                Reporter:
                AndreasFuchs Andreas Fuchs
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: