Monthly Attendance Report gives an error that indicates: 

"Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IndexOutOfRangeException: Index was outside the bounds of the array.

Environment

  • Scheduling type-Flex
  • Attendance type-Daily
  • Track Primary Classes

Cause

This error occurs when there is at least one student with the Attendance Audit Error of "AM: Student is enrolled in multiple primary classes"

Resolution

A student may only have one primary class. Remove the primary classes that are incorrect by either:

  • Attendance Audit Report - Clear the errors called "AM: Student is enrolled in multiple primary classes." 
    • Edit the student's Classes (or Course Attendance if it is a class that is no longer current), and remove one of the classes marked as Primary.

OR


  • Use SQL to find the overlapping primary classes:
SELECT * FROM ATT
INNER JOIN (SELECT * FROM DAY WHERE DEL = 0) DAY ON ATT.SC = DAY.SC AND ATT.DT = DAY.DT
WHERE ATT.SC = xx  AND ATT.DY <>DAY.DY 
SELECT * FROM CAR
INNER JOIN (SELECT * FROM DAY WHERE DEL = 0) DAY ON CAR.SC = DAY.SC AND CAR.DS = DAY.DT
WHERE CAR.DEL = 0 AND CAR.SC = xx AND CAR.D1 <> DAY.DY 
SELECT * FROM CAR
INNER JOIN (SELECT * FROM DAY WHERE DEL = 0) DAY ON CAR.SC = DAY.SC AND CAR.DE = DAY.DT
WHERE CAR.DEL = 0 AND CAR.SC = xx AND CAR.D2 <> DAY.DY
SQL


Error Message: The report specified could not be created!
Report: PrintMonthlyAttendanceSummary
Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IndexOutOfRangeException: Index was outside the bounds of the array.
at AeriesLib.YTD_Functions.CreateWRK(String USR, Int32 SC, Int32 passMonth, Int32[]& numDay, Int32[]& nonApp, Boolean doUnexcusedExcused, Hashtable intTotalSSD, Hashtable intTotalDays, DataTable& dtWRK, String ConnectionString, KeepSkip ks) in D:\a\1\s\Src\AeriesLib\Tables\Attendance Tables\YTD_Table.vb:line 0
at AeriesLib.YTD_Functions.ComputeYTD(String USR, String SC, Int32 passMonth, Boolean doUnexcusedExcused, String ConnectionString, Boolean RecomputeYTD, KeepSkip ks) in D:\a\1\s\Src\AeriesLib\Tables\Attendance Tables\YTD_Table.vb:line 122
at AeriesReporting.PrintMonthlyAttendanceSummary..ctor(ReportOptions o) in D:\a\1\s\Src\AeriesReporting\Reports\ATT\PrintMonthlyAttendanceSummary.vb:line 146
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, StackCrawlMark& stackMark)
at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at System.Activator.CreateInstance(Type type, Object[] args)
at AeriesReporting.Reporting.GetReportByClassName(String passReportClass, Object[] Arguments) in D:\a\1\s\Src\AeriesReporting\ReportProcessing\Reporting.vb:line 104
Error Dump:
The report specified could not be created!
Report: PrintMonthlyAttendanceSummary
Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IndexOutOfRangeException: Index was outside the bounds of the array.
at AeriesLib.YTD_Functions.CreateWRK(String USR, Int32 SC, Int32 passMonth, Int32[]& numDay, Int32[]& nonApp, Boolean doUnexcusedExcused, Hashtable intTotalSSD, Hashtable intTotalDays, DataTable& dtWRK, String ConnectionString, KeepSkip ks) in D:\a\1\s\Src\AeriesLib\Tables\Attendance Tables\YTD_Table.vb:line 0
at AeriesLib.YTD_Functions.ComputeYTD(String USR, String SC, Int32 passMonth, Boolean doUnexcusedExcused, String ConnectionString, Boolean RecomputeYTD, KeepSkip ks) in D:\a\1\s\Src\AeriesLib\Tables\Attendance Tables\YTD_Table.vb:line 122
at AeriesReporting.PrintMonthlyAttendanceSummary..ctor(ReportOptions o) in D:\a\1\s\Src\AeriesReporting\Reports\ATT\PrintMonthlyAttendanceSummary.vb:line 146
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, StackCrawlMark& stackMark)
at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at System.Activator.CreateInstance(Type type, Object[] args)
at AeriesReporting.Reporting.GetReportByClassName(String passReportClass, Object[] Arguments) in D:\a\1\s\Src\AeriesReporting\ReportProcessing\Reporting.vb:line 104