Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Web Help Desk (WHD) > Error when sorting ticket history by time

Error when sorting ticket history by time

Table of contents

Issue

When you return to History after sorting the time in a ticket note, Web Help Desk generates the following error:

We're sorry, an unexpected error occurred:

java.lang.IllegalStateException: addOrderByAttributeOrdering: attempt to generate SQL for com.webobjects.eocontrol.EOSortOrdering  failed because attribute identified by key 'jobTimeFromTechNotes' was not reachable from from entity 'JobTicket'

Cause

The Web Help Desk remembers the last-applied sort settings, which are stored in the client.sort_prefs database column. When a client sorts the data by time, the history is not available, thereby generating an error. 

Workaround

Update the client.sort_prefs database column. 

To prevent data loss, back up the PostgreSQL database using the Web Help Desk Admin Console or a command line before you perform this procedure. See Best practices for database backup for additional information. 

  1. Log in to the Web Help Desk server as an administrator.
  2. Stop the Web Help Desk services.
  3. Execute the following SQL statement:
    update client set sort_prefs = null where client_id = X
  4. Start the Web Help Desk services
Last modified
08:44, 13 Jul 2017

Tags

Classifications

Public