Skip to main content
SRB SIS Knowledge Base

Error: Could not find Stored Procedure

Error Message

When going into Demographics for any student: Could not find Stored Procedure.

Stack Trace: 

[SqlException (0x80131904): Could not find stored procedure '                                                  '.]
   SLDA.UserControlDA.GetLookupData(String strSproc, Int32 intDatatypesID, Int32 intID) +730
   FieldLookup.set_UserdefinedFieldID(Int32 intValue) +107
   DemographicsFields.DrillDown(ControlCollection Control_Collection, DataTable& dtLayout, String iStaffID, Int32 iStudentID) +10151
   Demographics.Page_PreInit(Object sender, EventArgs e) +5072
   System.EventHandler.Invoke(Object sender, EventArgs e) +0
   System.Web.UI.Page.OnPreInit(EventArgs e) +2009836
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +521

Resolution

This challenge is due to duplicate rows in the UserFields table for each of the User Defined fields. The error disappears when the duplicates disappear. For help removing the duplicates, contact our Support Team