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.


 Blackbaud NetCommunity

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.