ConnectALL Upgrade Issue when MYSQL parameter sql_required_primary_key is enabled

Products

• ConnectALL

Issue/Introduction

We have see ConnectALL Installer failing the create table scripts with MYSQL database when sql_required_primary_key is enabled on DB level which makes it mandatory to have the primary key in the create table scripts.
This will upgrade the ConnectALL but all the DB scripts will not execute which may result in issues with some functionalities of ConnectALL, like login issue ect.

Environment

3.3.0.2

Cause

DE80109
Some tables does not require the primary key constraint hence there are some scripts without primary key and if sql_required_primary_key is enabled, it won't let those script run.

 

Resolution

Workaround:
If you are using MYSQL DB and have parameter sql_required_primary_key enabled, make sure you disable it before running the upgrade and it can be re-enabled post upgrade.
Always review the installation logs(..\.install4j\installation.log) post the upgrade completion.

DE80109 is resolved in ConnectALL 3.5.0