Unable to send email when Revenue Splits Amount is included in Export Definition

When attempting to send emails through BBIS, Revenue Splits> Amount has been included in the Export Definition. However, the email will not send with this field included-- if it is removed from the Export Definition, the email will send.

[8/25/2014 2:33:20 PM] - [Processing]
Using processor Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.ConstituentExportDataProcessor.
 
[8/25/2014 2:33:27 PM] - [Exception]
System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'nvarchar'.
Cannot find the object 'EMAILFORMAT8635F723_842B_46FB_B098_F57490D00D5F', because it does not exist or you do not have permission.
Cannot find the object 'EMAILFORMAT8635F723_842B_46FB_B098_F57490D00D5F', because it does not exist or you do not have permission.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Blackbaud.AppFx.SpWrap.USP_BUSINESSPROCESS_CREATEOUTPUTTABLE.WrapperRoutines.ExecuteNonQuery(SqlConnection conn, String TABLENAME, String FIELDLIST, Int32& returnIntValue, Int32 timeOut)
   at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.ExportEmailListProcessorBase.CreateDBTable()
   at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.ExportEmailListProcessorBase.ProcessFormatting()
   at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.ExportDataProcessorBase.get_PreparedListProcessor()
   at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.ExportDataProcessorBase.BuildRecipientsSelectionSQL()
   at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.EmailProcessor.ProcessEmail()
   at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.ProcessCMSEmailBusinessProcess.StartBusinessProcess()
 
We are currently evaluating this issue and will update this article when we have more information.

Environment

 3.0.516.42

Was this article helpful?