Submit a ticketCall us

WebinarUpcoming Webinar: Easily Automate Backups and Simplify Log Message Management

Backing up your network configuration and logging data are a few steps to helping keep your network safe. In this in-depth webinar, we’ll show you how these tasks can be automated to save your IT team time while maintaining accurate archives of your data.

Register now.

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

Error when sorting ticket history by time

Table of contents


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'


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. 


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