Error: General ODBC Error: Microsoft][ODBC SQL Server Driver][SQL Server]The DELETE statement conflicted with the REFERENCE constraint...when deleting assignment

The system yields the following error when clicking Save after deleting an assignment in FAWEb:

 General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_EA7CLASSASSIGNMENTS_MAINASSIGNMENTID". The conflict occurred in database "FE_59719", table "dbo.EA7CLASSASSIGNMENTS", column 'MAINASSIGNMENTID'.\rNative error:547\r[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.\rNative error:3621\r
 
Contact Support for assistance.

Steps to Duplicate

Steps to Duplicate:

1. Log into FAWeb as sarah_case, password1
2. Open class Phy Ed 5B
3. Open either of the assignments: Participation grades dated 9/2, 9/28
4. Click Delete
5. Click Save
6. Receive error

Environment

 Education Edge
 7.87

Was this article helpful?