Knowlege base

Error at the updating database phase during the Imagicle UC suite upgrade

Article ID: 863
Last updated: 01 Sep, 2021

Applies to

Summer 2021 and later

Description

If coming from a very old Imagicle suite installation, even if kept up to date, it may occur that upgrading to the 2021.6.1 release, the operation fails at the database updating phase.

Logs contained in BillyBlues.Core.Wizard folder show the following error: 

Exception Type {System.Data.SqlClient.SqlException}
Message {Column 'dbo.Siti.sNome' is not the same data type as referencing column 'Users.user_SiteName' in foreign key 'FK_Users_Siti'.
Could not create constraint or index. See previous errors.}
StackTrace {
  in Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
  in Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType, Boolean retry)}
}

Cause

The “sNome” column type of table “Siti” is VARCHAR(50) instead of NVARCHAR(50)

With 2021.Summer.1 has been introduced into DB schema an FK that references the “sNome” Column on “Siti” table that could trigger the issue.

Solution

Manually change the type of the column “sNome” to NVARCHAR(50) by executing below query on the database with the SQL Management Studio (to be done on both nodes in case of cluster):


ALTER TABLE Siti ALTER COLUMN sNome NVARCHAR(50) NULL

Article ID: 863
Last updated: 01 Sep, 2021
Revision: 2
Views: 28
Print Export to PDF Subscribe Share
This article was:  
Prev   Next
How to Apply Transparent Data Encryption (TDE) in SQL Server     Call Analytics