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