Tickets - Ticket: Actions like Resolve, Reopen (or New ticket creation) throws an error - Error parsing column 0 (LastResolutionDate=)

This article is about product releases

ALVAO Service Desk 11.0 and higher

Symptoms

Some actions cannot be performed (Resolve, Reopen).
Error can even occur while creating a new ticket - An error occurred while processing the page 'Value cannot be null'.
It has a connection to the cache for Opening hours.
Error can occur if Opening hour definition was created a long time ago (like 5-10 years) and was never edited since then.

Cause

The cause is a bug in ALVAO products.

Solution

-

Workaround

Workaround 1:
Go to the definition for Opening hour for the selected SLA on the ticket (you can find the specific Opening hour in the SLA settings)
Select that Opening hour -> from the menu or detail select Operating hours -> Edit -> Select interval (any of them) -> Save

Workaround 2:
In the SQL Server Management Studio run the following script (you need to replace {OPENING_HOUR_ID} with the ID from URL, for example: https://contoso.com/OpeningHour/WeekOpeningHours/2?Popup=True)

exec spOpeningHoursCache_Update {OPENING_HOUR_ID}


                

                    
Steps to reproduce this behavior
                    
New ticket creation 

Resolve ticket 

Reopen ticket
                

                

                    
Attachments
                    
                

                
Issue number
                
T192807ALVAO