E-PIA: Getting Error "A column has been specified more than once in the order by list. Columns in the order by list must be unique" While Performing Standard Search for Fluid Component in MS SQL Server (Doc ID 2949520.1)

Last updated on JULY 28, 2023

Applies to:

Symptoms

On : 8.60 version, PIA Core Technology

While performing standard search in the fluid components, users get the following error.

ERROR
-----------------------
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique.

Failed SQL stmt: SELECT DISTINCT TOP 101 SSR_OPRID, EMPLID, INSTITUTION, TSCRPT_TYPE, RPT_DATE, (CONVERT(CHAR(10),RPT_DATE,121)), ANALYSIS_DB_SEQ, SAA_RPT_IDENTIFIER, OPRID, SAA_PROCESSED_DATE, (CONVERT(CHAR(10),SAA_PROCESSED_DATE,121)), SAA_PROCESSING_CD FROM PS_SAA_RPTRQSTSRCH WHERE UPPER(SSR_OPRID) LIKE UPPER('*******') || '%' ESCAPE '\' AND EMPLID=:1 AND INSTITUTION=:2 AND TSCRPT_TYPE=:3 ORDER BY SSR_OPRID, EMPLID, INSTITUTION, TSCRPT_TYPE, EMPLID, INSTITUTION, TSCRPT_TYPE, RPT_DATE DESC


The issue can be reproduced at will with the following steps:

1. Login to a Campus Solution database.

2. Navigate to Academic Advisements > Student Advisement > Request Advisement Report.

3. Provide EMPLID.

4. Hit Search Button.

5. Observe the error.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.