Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

PSQLException: column "nodeid" does not exist when using manage/unmanage services

Description

Following the database model changes, the following pages throw PSQLExceptions:

1) Node Page -> Admin -> Manage and Unmanage Interfaces and Services

Caused by: org.postgresql.util.PSQLException: ERROR: column "nodeid" does not exist
at org.opennms.web.admin.nodeManagement.GetInterfacesServlet.getInterfaces(GetInterfacesServlet.java:136) ~[opennms-webapp-17.0.0-SNAPSHOT.jar:?]

2) Admin -> Manage and Unmanage Interfaces and Services

Caused by: org.postgresql.util.PSQLException: ERROR: column "nodeid" does not exist
at org.opennms.web.admin.nodeManagement.GetNodesServlet.getAllNodes(GetNodesServlet.java:112) ~[opennms-webapp-17.0.0-SNAPSHOT.jar:?]

Acceptance / Success Criteria

None

Lucidchart Diagrams

Activity

Seth Leger July 20, 2015 at 4:31 PM

I updated the SQL in this servlet so that it queries for services correctly following the refactoring for DB trigger removal. Marking as fixed.

commit dfbfd962ab4e65dccf56bf29bd40195b5e340cbf

Fixed

Details

Assignee

Reporter

Components

Sprint

Fix versions

Affects versions

Priority

PagerDuty

Created June 8, 2015 at 2:50 PM
Updated July 20, 2015 at 8:28 PM
Resolved July 20, 2015 at 4:31 PM