ConnectALL database migration from MySQL to Postgres fails when you have business scripts- migrator-1.1.0-250702.jar

Products

• ConnectALL
• ConnectAll On-Prem

Issue/Introduction

Steps to Reproduce: 

1. Install/upgrade ConnectALL to 3.9.x version with mysql
2. Add business script.
3. Migration database using migrator utility version migrator-1.1.0-250702.jar

 

Actual Results: 
Migration fails for business_script_version table with error below.

ERROR: column "skip_failure" is of type integer but expression is of type boolean
  Hint: You will need to rewrite or cast the expression.

 

Expected Results: 
Utility should run fine and take care of any data conversion.

Environment

3.9.x

Resolution

Fixed in next release for migrator utility,

 

Workaround:

Change datatype of skip_failure in MySQL temporarily for migration for tables business_scripts and business_script_version table.

ALTER TABLE business_script_versions CHANGE COLUMN skip_failure skip_failure INT NULL DEFAULT 1 COMMENT '0-False, 1 - True';
ALTER TABLE business_scripts CHANGE COLUMN skip_failure skip_failure INT NULL DEFAULT 1 COMMENT '0-False, 1 - True';

RUN MIGRATION and ROLLBACK the datatype change.

ALTER TABLE business_script_versions CHANGE COLUMN skip_failure skip_failure TINYINT(1) NULL DEFAULT 1 COMMENT '0-False, 1 - True';
ALTER TABLE business_scripts CHANGE COLUMN skip_failure skip_failure TINYINT(1) NULL DEFAULT 1 COMMENT '0-False, 1 - True';