IBM Support

Query with order by clause causes error when opened to add items to reference list

Troubleshooting


Problem

In IBM Rational ClearQuest, a query with an order by clause causes error when opened to add items to a reference list.

Symptom

If a query with an ORDER BY ASC or DESC clause is used to add items to a reference list, an error occurs. When a browse adds ,T1.id ASC to the query SQL syntax, this error occurs:
---------------------------
IBM Rational ClearQuest
---------------------------
ERROR! CRMDB0001E SQLExecDirect: RETCODE=-1, State=37000, Native Error=169
[Microsoft][ODBC SQL Server Driver][SQL Server]A column has been
specified more than once in the order by list. Columns in the order by list must be unique.
SQL statement='select distinct T1.dbid,T1.id,T1.headline,T2.name,T1.id from request T1,statedef
T2 where T1.state = T2.id and (T1.dbid ?? 0) order by T1.id ASC,T1.id ASC'
---------------------------
OK
---------------------------

[{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Client - Native Windows","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.1.2.1;7.1.2.10;7.1.2.11;8.0.0.5;8.0.0.6;8.0.0.7;8.0.1","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
11 October 2018

UID

swg21651689

Page Feedback