Behind the Blackboard! Duplicate Tests, Surveys and Pools can Accumulate to Problematic Levels - Behind the Blackboard Skip Navigation
Download PDF  Icon Download PDF    Print article

Duplicate Tests, Surveys and Pools can Accumulate to Problematic Levels

Date Published: Jul 30,2021


CategoryPlanned First Fix Release:Future Reference; Product:Course Tools,Performance; Version:Learn 9.1, 3900.0.0,Learn 9.1 Q4 2019 (3800.0.0),Learn 9.1, 3900.2.0,Learn 9.1, 3900.4.0,Learn 9.1 Q2 2019 (3700.0.0),Learn 9.1, 3900.8.0,Learn 9.1, 3900.6.0,Learn 9.1, 3900.15.0,Learn 9.1, 3900.13.0,Learn 9.1, 3900.17.0,Learn 9.1, 3900.19.0,SaaS
Article No.: 000075738
Product:
Blackboard Learn
Release:
9.1;SaaS
Service Pack(s):
Learn 9.1, 3900.0.0, Learn 9.1 Q4 2019 (3800.0.0), Learn 9.1, 3900.2.0, Learn 9.1, 3900.4.0, Learn 9.1 Q2 2019 (3700.0.0), Learn 9.1, 3900.8.0, Learn 9.1, 3900.6.0, Learn 9.1, 3900.15.0, Learn 9.1, 3900.13.0, Learn 9.1, 3900.17.0, Learn 9.1, 3900.19.0, SaaS
Description:
Due to cyclical or recursive copying: duplicates of Tests, Surveys and Pools can accumulate in Original Experience Courses. Eventually, they can grow to such a level as to cause performance problems.
Steps to Repeat:
  1. Log into Blackboard Learn as an Administrator
  2. Create a Course: "course a"
  3. Create a couple of Tests, Surveys or Pools
  4. Create another Course "course b"
  5. Repeatedly Copy course "a" into "b" and "b" into "a", or copy indirectly via a third course

Observed Behavior
Over time, Duplicate Tests, Surveys or Pools accumulate significantly.

Expected Behavior
Duplicate Tests, Surveys or Pools do not accumulate to a significant degree.

 

Symptoms:

Tests, Surveys or Pools ("QTI Items") can accumulate to an excessive amount. The following symptoms can occur:
  1. End-user Slowness issues in the Tests areas and related areas can happen
  2. Database ASH report shows top queries on qti_asi_data table
  3. Course Copying, Archiving and Exporting, Deletion and Bulk Delete processing time dilates
  4. Systemic performance effects are possible


Resolution/Workaround:

It is possible to clean up severely affected courses in Oracle and SaaS hosted sites. Contact Blackboard Support for a workaround to this issue.


Target Release:

Future Reference

Patch Available:

No






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. © 2021 Blackboard Inc. All rights reserved