Issue

"Column 'SC, DT' is constrained to be unique" error received when accessing pages related to the Calendar (DAY) table


Environment

  • Pages include but are not limited to Student Attendance, Teacher Portal Attendance, Course Attendance
  • Initialize Attendance process errors out


Cause

This error usually indicates that certain unique values are duplicated. 

  • In this example, it appears that the 1/5/2026 date may be in the Calendar twice. 

 


Resolution

THIS SHOULD ONLY BE DONE PRIOR TO THE START OF SCHOOL, AND PRIOR TO INITIALIZING ATT/CAR. IF A CALENDAR CORRECTION NEEDS TO HAPPEN AFTER INITIALIZING ATT/CAR, PLEASE SUBMIT A TICKET TO AERIES SUPPORT PRIOR TO MAKING ANY CHANGES.



1. Navigate to the Calendar at the school affected.
  • Select the last month
  • Select the Delete button
  • Working backwards, select the next prior month and delete as necessary


2. When the Months are deleted up to and including the month that needs correction, make the correction and re-create the Months going forward