No Match:Student

Typically, this is because one of these fields doesn't match what is in WhippleHill: 

  • Firstname (mis-spelled or their nickname is in the file when it should be their firstname), 
  • Lastname (data may be reversed so their firstname is in the Lastname field and their lastname is in the Firstname field or their suffix is included in the lastname field when it shouldn't be or a hyphen is included/excluded, etc), or 
  • Grad_Year (either it is the wrong value or the user doesn't have a student enrollment record for the school year in the data file).
  • user isn't a student role member

No Match:Section

Team hasn't been offered for the school year+this_duration (season) identified in the file. 

Multiple Matches:AC_Offer

Either the Team has been offered twice in the same school year -or- there are two Teams with the same name (one Active and the other Inactive--change the name of the Inactive team to make it unique). 

 

DATA_SAVE_ERROR: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_ac_enrollment'. Cannot insert duplicate key in object 'dbo.ac_enrollment'. The duplicate key value is (1830032, 3174756).

This error means that one (or more) of the records in the data is either listed twice in the file, or, the student for the team listed is already on the roster.  Here is how you can help identify the culprit:

The duplicate key value is (1830032, 3174756) <--Go to Edit User Profile and search by User ID = 3174756.