Running the Grade Report Mark Analysis results in an error message

Environment

  • OS Version - any
  • Device - any
  • Browser - any
  • Scheduling Type - Secondary, Elem w/MST, Flex


Error:

Error Message: The report specified could not be created!
Report: PrintGradeReportMarkAnalysis
Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidCastException: Operator '<>' is not defined for type 'Integer' and type 'DBNull'.
at Microsoft.VisualBasic.CompilerServices.Operators.CompareObjectNotEqual(Object Left, Object Right, Boolean TextCompare)
at AeriesReporting.PrintGradeReportMarkAnalysis..ctor(ReportOptions o) in D:\a\1\s\Src\AeriesReporting\Reports\GRD\PrintGradeReportMarkAnalysis.vb:line 39
--- 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


Cause

GRD records with a section (GRD.SE) value of 0

Run this script to identify GRD records where SE = 0

SELECT * FROM GRD WHERE DEL = 0 AND SE = 0


Resolution

Update the section number (GRD.SE) to a valid value, or delete the GRD records with a GRD.SE value of 0