ConnectALL 3.6.0.2 to 3.7.0 upgrade fails for MSSQL

Products

• ConnectAll On-Prem
• ConnectALL
• ConnectAll SaaS

Issue/Introduction

Steps to Reproduce: 

1. Install ConnectALL 3.6.x with MSSQL
2. Attempt to upgrade to 3.7.0

 

Expected Results: 

Upgrade succeeds

 

Actual Results:

Migration crashes on NullPointerException

Environment

3.6.x

Cause

DE166283

Resolution

Workaround :

Run the update statement below followed by re-upgrade to 3.7.0

UPDATE properties SET data_type = 'STRING' WHERE data_type IS NULL;

 

DE166283 resolved in 3.8.0 and ported back to 3.7.0.1