Sorting by the column specified is not allowed

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

I have a portlet page with a filter included. The filter was created to reference a Lookup with static values.

When I filter for a single specific value I get the error:

Sorting by the column specified is not allowed

In the app-ca logs you might see an error related to "Expected  char"

Filtering by different values works without an issue.

 

Cause

A special character may be in the ID of the problematic value. For example, including an apostrophe in the ID value may cause an issue. If you look at the logs you may notice as part of the query that the ID value is being enclosed in quotes, for example:

('clarity's_value')

When the query is completed, the apostrophe is treated as closing the section, which breaks the query.

Environment

Release : 15.9.3 and previous releases

Resolution

Since the ID cannot be changed of a Value when it is created, the existing Value should be disabled, and a new Value can be created that does not have the character.