DB001 : Migration failed for change set /changelogs/201809_04.xml::julienr-19092018-1::julienr

Symptom

DB001 : Migration failed for change set /changelogs/201809_04.xml::julienr-19092018-1::julienr: Reason: liquibase.exception.DatabaseException: Invalid column name 'dtype'. [Failed SQL: update options set dtype = 'sourceoptions' where id in (select id from sourceoptions)]

Environment

360Suite Web Platform
SQL Server (any version)

Reproducing the issue

Connect to the 360Suite Web Platform Administration Console.
Fill in the details to configure the deployed SQL Server database.
Click Save.
The error occurs.

Cause

To manage database objects properly, the database collation configuration must not be case sensitive. Some collation settings aren't supported by the application.

Resolution

The database collation settings must be set to ignore case sensitivity. Several collations are available for that; The default recommended one is: SQL_Latin1_General_CP1_CI_AS.

It is possible to identify some compatible collations by their name: if it contains CS it is case sensitive, therefore not supported; if it contains CI it is case insensitive, therefore supported.

You can find more explanation and examples on the following websites:

- https://support.microsoft.com/en-us/help/325335/how-to-transfer-a-database-from-one-collation-to-another-collation-in

- https://www.mssqltips.com/sqlservertip/3519/changing-sql-server-collation-after-installation/

Keywords

DB001, SQL Server, changeset, database, three60suite, 360suite, WP

Product

360Suite Web Platform

Languages

English US
English UK
French

Last updated over 4 years ago