SQL Error In Enrollment Request

Last updated on JULY 13, 2018

Applies to:

Symptoms

On : Canpus solutions 9 version, Student Records Enrollment

When attempting to run an enrollment request using an override date
the following error occurs.

ERROR
-----------------------
2,-1
  
Application Program Failed
 Action Type : SQL SELECT
 In Pgm Section : SQLRT: EXECUTE-STMT
 With Return Code: 08605
 Error Message : [Microsoft][SQL Server Native Client 11.0][SQL Server]An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.
[Microsoft][SQL Server
 Stored Stmt : SRPCEOVD_S_APRG
 SQL Statement : SELECT A.PROG_ACTION FROM PS_ACAD_PROG A WHERE A.EMPLID=:1 A
  ND A.ACAD_CAREER=:2 AND A.EFFDT=(SELECT MAX(A1.EFFDT) FROM
  PS_ACAD_PROG A1 WHERE A1.EMPLID=A.EMPLID AND A1.ACAD_CAREE
  R=A.ACAD_CAREER AND A1.STDNT_CAR_NBR = A.STDNT_CAR_NBR AND
  A1.EFFDT<=:3) AND A.EFFSEQ = (SELECT MAX(A.EFFSEQ) FROM PS
  _ACAD_PROG A2 WHERE A2.EMPLID = A.EMPLID AND A2.ACAD_CAREER
  = A.ACAD_CAREER AND A2.STDNT_CAR_NBR = A.STDNT_CAR_NBR AND A
  2.EFFDT = A.EFFDT) AND A.INSTITUTION=:4 AND A.ACAD_PROG=:5
  AND A.PROG_STATUS='AC'
 
 
---------------SQL ERROR----------------------
  PGM SECTION:EOVD:SQ:8050-CHECK-ACA



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Records and Enrollment > Enroll students > enrollment request.
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot enroll student in this circumstance.

Cause