Hotfix 155 for Analytics for Learn – DimCourse and DimStudent processing performance issue




 
Hotfix 155 for Analytics for Learn – DimCourse and DimStudent processing performance issue

Date Published: Feb 05,2019 Category: Product:Installs_and_Configurations_Learn,Implementation_Process; Version:Learn_9_1_Q2_2017_3200_0_0,X4_3_2,X4_3_3,Learn_9_1_Q4_2017,Learn_9_1_Q2_2018,Learn_9_1_Q4_2018,Learn_9_1_Q4_2016_3100_0_0_rel_107_401e,SaaS,Learn_9_1_Q4_2015_9_1_201510_1171621,Learn_9_1_Q2_2016_3000_1_0_rel_52_991d   Article No.: 000050084

Product:  Analytics

 
Announcement Details:

Blackboard is pleased to announce the availability of Hotfix 155 for Analytics for Learn that addresses performance issue in processing of Course and Student dimension.  This hotfix applies to Analytics for Learn versions 4.3.2 through 4.3.3.

ISSUE RESOLVED

This hotfix moves the translation logic from transform view of Course and Student dimension to source helper which loads the new prestage table with all translations used in affected dimensions to appropriate language set up in HEA.GLOBAL. Transform views then only use these translations instead of calling translation function repetitively and therefore severely affecting performance by breaking the execution plan.

HOTFIX PROCESS

  1. Execute the script in the SQL hotfix file corresponding to your product version in SQL Server Management Studio on the Analytics for Learn database (iBBLA).

HOTFIX VERIFICATION

After application of this hotfix processing time of affected dimensions should be significantly lower.

REQUIREMENTS

  • Appropriate knowledge of SQL Server to apply the hotfix script

AVAILABILITY

The hotfix was made available on April 11, 2017.

Please reach out to Blackboard Support with any questions or issues regarding this hotfix or any prerequisites.