Issue: Attendance History totals are not being updated by the nightly Attendance History Configuration process.



Cause: Multiple Causes, including but not limited to: Attendance History Configuration page is not set up, Course Attendance/Attendance Audit Listing errors, Calendar is missing at district level, Administrative Functions need to be run, duplicate Student ID's at the same school, Nightly Process is pointing at the incorrect database year.


Steps to take toward resolution: 

  • Steps 1-4 may be sent to the customer and are written as such:


If the AHS process is not updating during the nightly process, please complete the following items. Once you have completed everything, if AHS is not updated overnight, please let me know.

1. Ensure the AHS Config page is properly configured.

  • If you are hosted by Aeries, set the nightly AHS process to happen outside the Aeries maintenance window which is 10 PM-11 PM. 
    How to Configure Attendance History Nightly Update
  • If you are self hosted, set the nightly AHS process to happen outside the district’s maintenance window if applicable


2. Ensure there is a DAY Calendar at the District level. You can push a Calendar from one of your sites if one does not already exist at the District, you do not need to create a whole new Calendar.

How to push a calendar from one school to another


3. Clear the Attendance Audit Listing and Course Attendance Audit Report errors. 


4. Run the Administrative Functions. 
 How to run admin functions

 

AERIES HOSTED STEPS 5-6:

  • These steps should be completed internally and should be completed once the district is notified that they should be working on steps 1-4.


5. Run the following SQL script and ensure there are NO duplicate records for the same student with the same ID in the same school, (including the inactive school). 

select SC, ID, del, count(*) as count
from STU
group by SC, ID, del
having count(*) > 1

If there are any duplicates, the district must choose one to hard-delete. 

NOTE: If both student records contain data that needs to be retained, it must be transferred to the desired record before the record can be deleted. TSE can help with this if needed.


Then run the Administrative Functions again.

 


6. Create a Child Ticket for TSE to do the following - Run the following script against the Aeries Reporting Server to ensure the AHS process is pointing toward the current year (in SQL)

 

SELECT ProcessType, DbSuffix, DbYear, LastRunTime, LastCompleted, StatusOfLastRun, DaysOfWeek, Disabled
FROM ScheduledProcesses
WHERE DbSuffix LIKE '%District Name Here%'
AND ProcessType LIKE '%attendance%'


--UPDATE ScheduledProcesses (if applicable)
SET DByear = 'two-digit year here'
WHERE ProcessType = 'AttendanceHistoryUpdate' 
AND DbSuffix LIKE '%District Name Here%'

 

 

 

SELF HOSTED STEPS 5-6:

  • Steps 5-6 may be sent to self hosted customer and are written as such


5. Run the following SQL script and ensure there are NO duplicate records for the same student with the same ID in the same school, (including the inactive school). If you find any duplicates, you must hard-delete one via SQL. Then run the Administrative Functions.

select SC, ID, del, count(*) as count
from STU
group by SC, ID, del
having count(*) > 1

 

6. Run the following script against the Aeries Reporting Server to ensure the AHS process is pointing toward the current year (in SQL)

 

SELECT ProcessType, DbSuffix, DbYear, LastRunTime, LastCompleted, StatusOfLastRun, DaysOfWeek, Disabled
FROM ScheduledProcesses
WHERE DbSuffix LIKE '%District Name Here%'
AND ProcessType LIKE '%attendance%'


--UPDATE ScheduledProcesses
SET DByear = 'two-digit year here'
WHERE ProcessType = 'AttendanceHistoryUpdate' 
AND DbSuffix LIKE '%District Name Here%'