Symptoms: The delete fails with the following exception recorded in the logs
 

YYYY-MM-DD HH:MM:SS -TZTZ - [ERROR] Failed deleting course COURSE_ID_HERE - blackboard.persist.PersistenceException: A database error occurred.
	at blackboard.persist.impl.AbstractBaseDbPersister.runQuery(AbstractBaseDbPersister.java:199)
	at blackboard.persist.impl.AbstractBaseDbPersister.runQuery(AbstractBaseDbPersister.java:139)
	at blackboard.persist.course.impl.CourseDbPersisterImpl.deleteById(CourseDbPersisterImpl.java:303)
	at blackboard.persist.course.impl.CourseDbPersisterImpl.deleteById(CourseDbPersisterImpl.java:284)
	at blackboard.data.course.impl.CourseManagerImpl.remove(CourseManagerImpl.java:220)
	at blackboard.apps.platform.course.CourseDeleteQueuedOperation.execute(CourseDeleteQueuedOperation.java:137)
	at blackboard.platform.queue.QueuedTaskManager.processTask(QueuedTaskManager.java:488)
	at blackboard.platform.queue.QueuedTaskManager$WorkerThread.doRun(QueuedTaskManager.java:937)
	at blackboard.db.LeakCheckThread.run(LeakCheckThread.java:38)
Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "groups" violates foreign key constraint "collab_session_fk3" on table "collab_session"
  Detail: Key (pk1)=(nnnnnn) is still referenced from table "collab_session".
  Where: SQL statement "DELETE FROM groups a WHERE a.crsmain_pk1=v_crsmain_pk1"
PL/pgSQL function groups_rm(bigint,bigint) line 37 at SQL statement
SQL statement "SELECT groups_rm(crsmain_pk1 := p1)"
PL/pgSQL function course_main_rm(bigint,character varying,timestamp without time zone,integer) line 37 at PERFORM
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190)
	at org.postgresql.jdbc.PgCallableStatement.executeWithFlags(PgCallableStatement.java:84)
	at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:177)
	at jdk.internal.reflect.GeneratedMethodAccessor284.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:118)
	at com.sun.proxy.$Proxy64.execute(Unknown Source)
	at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)
	at blackboard.db.impl.MonitoringConnectionPool$SQLRecorder.execute(MonitoringConnectionPool.java:225)
	at blackboard.db.impl.MonitoringConnectionPool$MonitoringCallableStatement.execute(MonitoringConnectionPool.java:667)
	at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)
	at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)
	at blackboard.db.impl.SafetyNetCallableStatement.execute(SafetyNetCallableStatement.java:58)
	at blackboard.persist.impl.StoredProcedureQuery.doExecute(StoredProcedureQuery.java:319)
	at blackboard.persist.impl.Query.executeQuery(Query.java:143)
	at blackboard.persist.impl.AbstractBaseDbPersister$DbConnectivityPrivilege.run(AbstractBaseDbPersister.java:280)
	at java.base/java.security.AccessController.doPrivileged(Native Method)
	at blackboard.persist.impl.AbstractBaseDbPersister.runQuery(AbstractBaseDbPersister.java:170)
	... 8 more

 

Resolution/Workaround:

1. If necessary: re-enable the course
2. Enter the course
3. Go to Users & Groups ➔ Groups ➔ Group Sets
4. Check the boxes on all group sets
5. Click delete
6. Retry the course deletion

Information: All issues are important, but some issues naturally take precedence over others. After carefully reviewing this issue we have determined this issue should not be fixed.

• The issue is reported solely in conjunction with the long-discontinued Original Collaborate product line
• There is an easy workaround
• The impact of the issue is minimal.
• It is not possible for new instances of this issue to be created. Class Collaborate (Formerly: Collaborate Ultra) which is the sole supported product of the Collaborate line is not affected by this issue
• Anthology, Inc sold the Collaborate product line to Class Technologies, Inc in Q2 2022.

This issue is very old. The last five released versions of Learn are selected as a convenience. In effect, the issue can be treated as not being specific to any version of Learn.
Target Release: Will Not Fix
Patch Available: No