Preview Users Cannot be Removed from a Course
Date Published: Apr 11,2025 Category: Planned_First_Fix_Release:Learn_9_1_3900_69_0_Release; Product:Blackboard_Learn_MH,Blackboard_Learn_SaaS,Blackboard_Learn_Software; Version:Learn_9_1_3900_60_0,Learn_9_1_3900_62_0,Learn_9_1_3900_65_0,Learn_9_1_3900_67_0,Learn_9_1_3900_69_0,SaaS Article No.: 000077694
Date Published: Apr 11,2025 Category: Planned_First_Fix_Release:Learn_9_1_3900_69_0_Release; Product:Blackboard_Learn_MH,Blackboard_Learn_SaaS,Blackboard_Learn_Software; Version:Learn_9_1_3900_60_0,Learn_9_1_3900_62_0,Learn_9_1_3900_65_0,Learn_9_1_3900_67_0,Learn_9_1_3900_69_0,SaaS Article No.: 000077694
Producto: Learn SaaS
Versión: 9.1;SaaS
Paquetes de servicio: 3900.60.0, 3900.62.0, 3900.65.0, 3900.67.0, 3900.69.0, SaaS
Descripción: Preview users cannot be removed from a course.
Pasos para repetir:
- Log into Blackboard Learn as an administrator
- Go to the Admin Panel
- Access a course
- Select the down arrow > Course Enrollment
- 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.
Causa: 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.
Versión de destino: Learn 9.1, 3900.69.0 Release
SaaS - Fixed (v3900.69.0)