Behind the Blackboard! Preview Users Cannot be Removed from a Course - Behind the Blackboard Skip Navigation
Download PDF Icon Download PDF    Print article

Preview Users Cannot be Removed from a Course

Date Published: Apr 11,2025


CategoryPlanned First Fix Release:3900.69.0 Release; Product:Blackboard Learn MH,Blackboard Learn SaaS,Blackboard Learn Software; Version:3900.60.0,3900.62.0,3900.65.0,3900.67.0,3900.69.0,SaaS
Article No.: 000077694
Product:
Learn SaaS
Release:
9.1;SaaS
Service Pack(s):
3900.60.0, 3900.62.0, 3900.65.0, 3900.67.0, 3900.69.0, SaaS
Description:
Preview users cannot be removed from a course. 
Steps to Repeat:
  1. Log into Blackboard Learn as an administrator 
  2. Go to the Admin Panel
  3. Access a course 
  4. Select the down arrow > Course Enrollment
  5. Select a Preview User > Remove from Course > Ok

Observed Behavior:
The preview user cannot be deleted and the following type of error is displayed: 

ERROR: update or delete on table "course_users" violates foreign key constraint "gradebook_grade_c_up_fk1" on table "gradebook_grade_calc_up"
Detail: Key (pk1)=(1007528) is still referenced from table "gradebook_grade_calc_up".
Where: SQL statement "DELETE FROM course_users WHERE pk1 = p1"

Expected Behavior:
The preview user should be deleted successfully. 
 


Cause:

Deletes from the gradebook_grade_calc_up table for sorting are not implemented properly. It seems there is a violation from the foreign key constraint gradebook-grade-c-up-fk1 on the table gradebook-grade-calc-up.



Target Release:

Learn 9.1, 3900.69.0 Release

SaaS - Fixed (v3900.69.0)







The information contained in the Knowledge Base was written and/or verified by Blackboard Support. It is approved for client use. Nothing in the Knowledge Base shall be deemed to modify your license in any way to any Blackboard product. If you have comments, questions, or concerns, please send an email to kb@blackboard.com. © 2025 Blackboard Inc. All rights reserved