SD WA - Impact and Urgency - Edit values - Error 500 - Subquery returned more then 1 value

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

ALVAO Service Desk 10.0 a vyšší

Příznaky

Impact or Urgency is defined on the form for the new ticket or on the process.
User wants to change one of its values.
He gets error: Subquery returned more then 1 value.

Příčina

The cause is a bug in ALVAO products.

Řešení

Oprava naplánována do verze 11.2/FIX1 (release 2024-05-02)

Náhradní řešení

Either upgrade your ALVAO instance to the specified version, or:

1. Delete custom column in the Administration
2. Run the following script: select * from tColumn order by iColumnId desc -> and find the row/s with Urgency or Impact in the sColumn column.
3. Run the following script: delete from tColumn where iColumnId = ID (replace ID with the ID of the custom field from the step 2)

Kroky pro reprodukci tohoto chování

In the customer database, there is one or more custom fields that have Urgency or Impact as name of the sColumn column (real name of the custom column in the database; not display name).

Číslo problému

T156407ALVAO

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