Console login error 'Invalid query attribute: Query attribute x has index x which clashes..."

Version 8
    Question

    Console login error for all users:  "Invalid Query Attribute: Query Attribute 'x' has index x which clashes with another Query Attribute in the same collection in the same Query."

     

    Answer

    The cause is a corrupted query.  To fix run the attached SQL or Oracle script against your Service Desk database.  You should take a full backup of the database before running and perfrom an IIS reset after running the script.

     

    If the error still persists please contact Support with the full error message plus the results of running the script.

     

    This is raised with our Product Management team as Problem 3382.  Please link any reports of this issue to that Problem record.

    Environment

    Service Desk - all versions

     

    UPDATE TO THIS ISSUE - PATCHES AVAILABLE

    There is a patch now available to stop this issue from occuring in Service Desk 7.2.4, 7.2.5 and 7.2.6.  From verion 7.3 onwards this will not occur again.  To obtain the patch for 7.2.4, 7.2.5 or 7.2.6 please contact your support provider and request patch 3382 (and your specific product version).

     

    Note that the patch will not fix a broken system so you will still also need to run the scripts attached to this document to fix the login errors.