Trellis logs indicate a SQL syntax error on MySQL and UIM 8.51

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

In the trellis log level you see the following:

 

 

Environment

MySQL: 5.6Unified Infrastructure Management: 8.51

Cause

On rare occasions the update script may have failed to run.

Resolution

Run the following:

Alter table CM_GROUP Add IS_UNIFIED INT default '0' not null;

 

This will resolve the error in the logs