Skip to content

Location Action Without Assignee Id

Description:

A POST request was made to the location/action/list service, and we received a 500 error with the following message:

{ "error": "Invalid column name 'assignee_id'.\ncould not extract ResultSet\ncould not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet", "localizedError": "could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet" }

Upon verification, we noticed that the liquibase script is missing the alter table for LocationAction. The assignee_id has been added to the other tables, but it is missing in location_action. Attached is a screenshot that proves this:

image

We appreciate it if you could prioritize this bug, as it is holding back the progress of the applications we are currently developing.

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information