Data could not be saved. A .NET Framework error occurred during execution of user-defined routine or aggregate USP_SMARTFIELD_UPDATESMARTFIELDVIEW""

Occurs when adding value groups to a smartfield.
Affects Webshell and SmartClient
Occurs when the smartfield valuegroup is monetary based
client is Dutch and works with euro.

Blackbaud CRM
 
Data could not be saved.  A .NET Framework error occurred during execution of user-defined routine or aggregate "USP_SMARTFIELD_UPDATESMARTFIELDVIEW": 
 
System.Data.SqlClient.SqlException: Incorrect syntax near ','.

System.Data.SqlClient.SqlException: 
 
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
 
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQuerySmi(Boolean sendToPipe)
 
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
 
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
 
   at Blackbaud.AppFx.Platform.SqlClr.QueryViewSpecProcessor.ExecuteSqlNonQuery(String sqlToExecute)
 
   at Blackbaud.AppFx.Platform.SqlClr.QueryViewSpecProcessor.ProcessSpec(String specXml, String specExtensionXml, Nullable`1 changeAgentID)
 
   at Blackbaud.AppFx.Platform.SqlClr.QueryViewSpecProcessor.ProcessSpec(String specXml, Nullable`1 changeAgentID)
 
   at Blackbaud.AppFx.Platform.SqlClr.SmartFiel
 
BBERR_ORIGINAL_ERROR:6522
 
BBERR_ORIGINAL_PROCEDURE:USP_SMARTFIELD_UPDATESMARTFIELDVIEW
 
BBERR_ORIGINAL_LINE_NUMBER:0
   
  OK
Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Environment

 2.94.1524 patch 66
 3.0.516, Service Pack 10 ; 2.94.1524, patch 107

Was this article helpful?