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

Článek se týká verzí produktů

ALVAO Service Desk 11.0 a vyšší

Příznaky

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.

Příčina

The cause is a bug in ALVAO products.

Řešení

-

Náhradní řešení

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}


			

				
Kroky pro reprodukci tohoto chování
				
New ticket creation 

Resolve ticket 

Reopen ticket
			

			

				
Přílohy
				
			

			
Číslo problému
			
T192807ALVAO
		


                
                   
 
                   

                   

Nenašli jste co jste hledali? Zeptejte se našeho týmu technické podpory.