Revision error: 905.BankAccountSEPAInfo.Table.xml- System.Data.SqlClient.SqlException: String or binary data would be truncated.

Revision error occurred when upgrading from v3.0 SP9 to v4.0 SP2 (base build installer).

The "RunServiceRevisions" task failed unexpectedly.
Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionExecutionException: An error occurred while executing a service revision. Procedure Return Code: 0
Revision text: LoadSpec: 905.BankAccountSEPAInfo.Table.xml Blackbaud.AppFx.Galileo.ServiceRevisions.Specs1390.zip ---> Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.LoadSpecException: Procedure Return Code: 0 ---> System.Exception: String or binary data would be truncated. ---> System.Data.SqlClient.SqlException: A .NET Framework error occurred during execution of user defined routine or aggregate 'USP_LOADSPEC_AS_STRING':
System.Data.SqlClient.SqlException: String or binary data would be truncated.

 
We are currently evaluating this issue.

Steps to Duplicate

1. Have CRM on v3.0 SP9 and with SEPA Banking system switched on
2. Run v4.0 SP2 full build installer

Environment

 Windows Server 2012
 SQL Server 2012
 Blackbaud CRM
 4.0
 3.0.516.53

Was this article helpful?