WA/SD WS – Timeout after confirrming various actions – Notifications are not send
This article is about product releases
ALVAO Service Desk 11.0 and higher
Symptoms
SD WS is trying to send notification, but error 500 is instead showed in Web App.
Problem is only with databases that have collation other than 1029 (Czech).
Cause
The cause is a bug in ALVAO products.
Solution
Fixed in release 11.0.2043 - 11.0/SP1 (2022-09-15)
Workaround
Create new statistic for column oDocument in tDocument table.
Please be aware that statistic may not be created if FILE STREAM is activated.
Apply scrip tbelow...
IF NOT EXISTS(select 1 from sys.tables t join sys.filegroups g on g.data_space_id=t.filestream_data_space_id where t.name = 'tDocument') and not exists(select 1 from sys.stats where name = 'ST_tDocument_oDocument')
BEGIN
CREATE STATISTICS ST_tDocument_oDocument ON dbo.tDocument(oDocument) WITH SAMPLE 0 ROWS, NORECOMPUTE
END
Steps to reproduce this behavior
Begin approval
Resolve ticket
And some other actions...
Attachments
Issue number
T129218ALVAO