ConnectALL 4.0 Installer errors with 'column "logo" is of type oid but expression is of type bytea'

Products

• ConnectAll On-Prem
• ConnectALL

Issue/Introduction

When installing ConnectALL 4.0, the following error is seen during installation:

ERROR: Exception Details
ERROR: Exception Primary Class: PSQLException
ERROR: Exception Primary Reason: ERROR: column "logo" is of type oid but expression is of type bytea
  Hint: You will need to rewrite or cast the expression.
  Position: 104
ERROR: Exception Primary Source: PostgreSQL 15.14.0

Installation then appears to complete, however services do not start up automatically

When Core is started manually, it fails to start

Environment

ConnectALL <=4.0.1

EnterpriseDB (EDB)

Cause

While EnterpriseDB is based on PostgreSQL, it identified itself differently to the installer and many of the database scripts fail as there is no direct match for it.

Resolution

Work is being done to allow the installer to correctly identify EnterpriseDB and run the correct scripts.  This work is scheduled for inclusion in v4.0.2

This database will be considered supported, but not certified, meaning no specific tests are run to ensure compatibility.