Pilot district is unable to drill down on schools

Date
11/10/2015
Level
Level 4
Jitbit #
3700730
Summary
Pilot district is unable to drill down on schools
Impacted
Dashboard
Service Impact
Access to school lists on the dashboards.
Incident Detail
Joy Nolting, a system administrator at BANCROFT-ROSALIE COMM SCHOOLS reported a 500 error when trying to access school lists within the dashboards. We reviewed the error logs and .NET code for the dashboard and found that she was getting a 500 error code because of an issue with the data that was inserted into the dashboard.LocalEducationAgency table in the application database - NeDOE_Application_NeDOEStaging. The value entered into the Code column of the dashbaord.LocalEducationAgency table for this district had a space. The .NET code errors out when there is a space in the values entered into this column. It expects that all spaces be replaced with a dash.
Technical Detail/Fix
The issue was resolved by updating the dashboard.LocalEducationAgency with the following script:
Update[NeDOE_Application_NeDOEStaging].[dashboard].[LocalEducationAgency] set code = 'BANCROFT-ROSALIE-COMM-SCHOOLS' where LocalEducationAgencyId = '200020000'and Name = 'BANCROFT-ROSALIE COMM SCHOOLS' The value in the Code column was changed from 'BANCROFT-ROSALIE COMM-SCHOOLS' to 'BANCROFT-ROSALIE-COMM-SCHOOLS'. This was the only record that had the space issue.
Creation date: 12/4/2015 9:31 AM ()      Updated: 12/4/2015 9:31 AM ()