Error: Data could not be saved. A .NET Framework error occurred during execution of user-defined routine or aggregate USP_ATTRIBUTECATEGORY_CREATEATTRIBUTETABLE" when creating an attribute"

When a user attempts to create a revenue attribute they get Error:  Data could not be saved.   A .NET Framework error occurred during execution of user-defined routine or aggregate "USP_ATTRIBUTECATEGORY_CREATEATTRIBUTETABLE":  System.Exception: Unexpected routine type in Common.GetRoutineType. Did not expect '' System.Exception:     at Blackbaud.AppFx.Platform.SqlClr.Common.GetRoutineType(SqlConnection conn, String sp)    at Blackbaud.AppFx.Platform.SqlClr.Common.GetRoutineParamList(SqlConnection conn, String routineName, KnownRoutineType knownType)    at Blackbaud.AppFx.Platform.SqlClr.Common.GetRoutineParamList(SqlConnection conn, String routineName)    at Blackbaud.AppFx.Platform.SqlClr.BatchTypeSpecProcessor.GetParams(SqlConnection conn, String templateProc)    at Blackbaud.AppFx.Platform.SqlClr.BatchTypeSpecProcessor.GetExtensionParamsForSP(SqlConnection conn, String spName)    at Blackbaud.AppFx.Platform.SqlClr.BatchTypeSpecProcessor.GetExtensionsForBatch(SqlConnection conn, Guid batchTypeCatalogID)    at Blackbaud.AppFx.Platform.SqlClr.BatchTypeSpecProcessor.Upd.
This issue was caused by a customization. If you are experiencing a similar issue, review How to request assistance for customization issues in Blackbaud CRM for more information.

Environment

 2.91.1535, patch 39

Was this article helpful?