VERIFIED SOLUTION i

Following an upgrade of EngageOne Deliver to version 2.6 user receiving messages about missing column in database

Product Feature: User Interfaces
 

Issue

The following error is returned when the user attempts to update an inbound profile:

SEVERE [http-nio-8090-exec-9] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [faces] in context with path [/EODeliver] threw exception [javax.servlet.ServletException: javax.el.ELException: org.hibernate.exception.SQLGrammarException: Invalid column name 'relay_message'.] with root cause
java.sql.SQLException: Invalid column name 'relay_message'

Cause

Missing column in the database.  This column should be present in the in_profile, and should also be present in the inbound_relay_message table.  If this is not present, then the reported error is likely to occur.

Resolution

UPDATED: February 15, 2019
If this column does not exist, and/or the inbound_relay_message table is missing, and this too does not contain the relay_message column, then a script can be provided to add the missing column or table and column.  Please contact software.support@pb.com in this instance.

Alternatively, a new database could be created and this should then contain the relevant tables and columns.