Error: System.ArgumentException: Column '0.0.0.' does not belong to table R - when sending email messages from NetCommunity

When scheduling a future email in NetCommunity the following error may occur on send:

System.ArgumentException: Column '0.0.0.' does not belong to table R.
   at System.Data.DataRow.set_Item(String columnName, Object value)
   at Blackbaud.Web.Content.Core.EmailJob.AddRequiredMergeData(DataRow& drMergeRow, String sEmailAddress, String sEmailDisplay, Int32 iAddressBookid, Int32 iUSerid, Boolean bOptOut, Boolean bInvalidAddress, Int32 iPeopleID, Int32 BackOfficeRecordID, Int32 BackOfficeSystemID, Boolean UseOriginalSubject)
   at Blackbaud.Web.Content.Core.EmailJob.PopulateMergeDataForRecipient2(String sKey, String sSourceKey, IDataProvider oData, String sEmailAddress, String sEmailDisplayName, Boolean bGlobalOptedOut, Int32 UserID, Int32 AddressBookid, Int32 BackOfficeRecordID, Int32 BackOfficeSystemID)
   at Blackbaud.Web.Content.Core.EmailJob.PopulateRecipient2(IDataProvider oRecipient, String sKey, String sSourceKey, Int32 constituentId)
   at Blackbaud.Web.Content.Core.EmailJob.ProcessImportedList(String sSourceKey, IDataSource oDS, EmailList oList)
   at Blackbaud.Web.Content.Core.EmailJob.ProcessList(Int32 iListID)
   at Blackbaud.Web.Content.Core.EmailJob.ProcessAddressees()
   at Blackbaud.Web.Content.Core.EmailJob.DoProcessMailBlast()
   at Blackbaud.Web.Content.Core.EmailJob.ProcessMailBlast()
   at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.LegacyListProcessorWrapper.PrepareForProcessing()
   at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.BasicEmailDataProcessor.BuildSelectionSQL()
   at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.BasicEmailDataProcessor.BuildRecipientsSelectionSQL()
   at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.EmailProcessor.ProcessEmail()
   at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.ProcessCMSEmailBusinessProcess.StartBusinessProcess()

Typically, copying and resending the message will allow it to send successfully.

We are currently evaluating the issue, please contact support and reference the article number above.

Environment

 Blackbaud NetCommunity
 7.1

Was this article helpful?