Error: System.NullReferenceException: Object reference not set to an instance of an object - When sending emails using a Constituent BBDW Export Definition in the email template

If a BBIS email template uses a Constituent BBDW Export Definition, the email job fails in the Processing stage with the error, "System.NullReferenceException: Object reference not set to an instance of an object.
   at Blackbaud.AppFx.Server.ExportDefinitionProcessor.GetAllCurrencyFieldsFromExportNode(ExportDefinitionQueryViewNode exportNode, QueryViewTreeNode queryNode)
   at Blackbaud.AppFx.Server.ExportDefinitionProcessor.GetColumnsForOutputTable(SqlConnection conn, ExportDefinitionQueryViewNode exportNode, QueryViewTreeNode queryNode, String originTableName, String parentColumnPrefix)
   at Blackbaud.AppFx.Server.ExportDefinitionProcessor.LoadExportDefinitionNodeResultsToTable(SqlConnection conn, ExportDefinitionQueryViewNode node, String parentTableName, String parentColumnPrefix, SqlConnection outputConnection)
   at Blackbaud.AppFx.Server.ExportDefinitionProcessor.ProcessExportDefinition(SqlConnection conn, String outputTableNamePrefix, String outputTableKey, Boolean overrideOutputTableSuffixWithNewGuid, Boolean useDataCompression)
   at Blackbaud.AppFx.Server.ExportDefinitionProcessor.ExportDataToOutputTable(SqlConnection conn, String outputTableNamePrefix, String outputTableKey, Boolean overrideOutputTableSuffixWithNewGuid, Boolean useDataCompression)
   at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.ExportEmailListProcessorBase.RunExport()
   at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.ExportEmailListProcessorBase.PrepareForProcessing()
   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 for a fix in a future service pack.

Steps to Duplicate

1) In CRM, create an Export Definition with the source view Constituents (from the Blackbaud Data Warehouse).
2) After adding a few fields, save and close it.
3) In BBIS, go to Email > Templates > New template > Create a new email template with the constituent data source and the Constituent BBDW Export Definition you created in step 1.
4) After filling out the other fields, save the template.
5) In the design tab, Add merge fields and the required links to the email body > Save > New message
6) Send a final email message using this template and notice the email send fails in the Processing stage with the error, "System.NullReferenceException: Object reference not set to an instance of an object.
   at Blackbaud.AppFx.Server.ExportDefinitionProcessor.GetAllCurrencyFieldsFromExportNode(ExportDefinitionQueryViewNode exportNode, QueryViewTreeNode queryNode)
   at Blackbaud.AppFx.Server.ExportDefinitionProcessor.GetColumnsForOutputTable(SqlConnection conn, ExportDefinitionQueryViewNode exportNode, QueryViewTreeNode queryNode, String originTableName, String parentColumnPrefix)
   at Blackbaud.AppFx.Server.ExportDefinitionProcessor.LoadExportDefinitionNodeResultsToTable(SqlConnection conn, ExportDefinitionQueryViewNode node, String parentTableName, String parentColumnPrefix, SqlConnection outputConnection)
   at Blackbaud.AppFx.Server.ExportDefinitionProcessor.ProcessExportDefinition(SqlConnection conn, String outputTableNamePrefix, String outputTableKey, Boolean overrideOutputTableSuffixWithNewGuid, Boolean useDataCompression)
   at Blackbaud.AppFx.Server.ExportDefinitionProcessor.ExportDataToOutputTable(SqlConnection conn, String outputTableNamePrefix, String outputTableKey, Boolean overrideOutputTableSuffixWithNewGuid, Boolean useDataCompression)
   at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.ExportEmailListProcessorBase.RunExport()
   at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.ExportEmailListProcessorBase.PrepareForProcessing()
   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()"

Environment

 Blackbaud Internet Solutions
 4.0
 4.0.180.1600

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.