The Update Attendance History process tracks its run status in the DPT table using 3 new DPT records:

  • UpdateAttendanceHistory_LastRunGuid - If the process is currently running, this will store the unique process ID, which corresponds to a record in the RunningJobs table in the AeriesReporting database.
  • UpdateAttendanceHistory_LastRun - This will store the date/time of the last time the process started running.
  • UpdateAttendanceHistory_LastCompleted - This will store the date/time of the last time the process completed running.

If the Attendance History Configuration page is stuck on 'Processing', remove the DPT values for these records to resolve the error and restart the process. The following SQL queries can be run but should be used with caution:  


SELECT * FROM DPT WHERE NM LIKE '%ATTENDANCEHISTORY%' 


UPDATE DPT

SET CD = ''

WHERE NM = 'UpdateAttendanceHistory_LastRunGuid'


UPDATE DPT

SET CD = ''

WHERE NM = 'UpdateAttendanceHistory_LastRun''


UPDATE DPT

SET CD = ''

WHERE NM = 'UpdateAttendanceHistory_LastCompleted'