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. |