SD - Request - Status - cannot change to the target status that has required fields defined in process

This article is about product releases

ALVAO Service Desk 10.3 and higher

Symptoms

An error occurred while processing the page 'Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Czech_CI_AS" in the equal to operation.'.

Cause

The cause is a bug in ALVAO products.

Solution

Fixed in release 11.0.2043 - 11.0/SP1 (2022-09-15)

Workaround

Modify the stored procedure spStateReqCol. Change the following line: JOIN vColumnLoc ON sTable = tab AND sColumn = col AND ColumnLocaleId = ' + CAST(@LocaleId AS nvarchar) + to this: JOIN vColumnLoc ON sTable = tab COLLATE DATABASE_DEFAULT AND sColumn = col COLLATE DATABASE_DEFAULT AND ColumnLocaleId = ' + CAST(@LocaleId AS nvarchar) +

Steps to reproduce this behavior

Use Azure SQL database with Alvao. Define required items in the status of the process. Try to change some request to the status with required items.

Issue number

T128367ALVAO

Did not find what you were looking for? Ask our technical support team.