Error when using a export definition as part of a BBIS email

When using a export definition and merge fields as part of a BBIS email a error is seen when the email is processing if filters are used on the export definition.

Error looks like:
System.NullReferenceException: Object reference not set to an instance of an object.
   at Blackbaud.AppFx.Server.ExportDefinitionProcessor.AddChildNodeTableColumnsToOutputTable(ExportDefinitionQueryViewNode node, QueryViewTreeNode queryNode, List`1& exportColumns, String columnPrefix, Int32 index, Boolean isRootNode, SortedList`2& orderedExportColumns, Boolean useColumnPrefix, ExportDefinitionOutputMetadataNode expDefOutputMetadataNode, Boolean useColumnOrder)
   at Blackbaud.AppFx.Server.ExportDefinitionProcessor.AddTableColumnsToOutputTable(ExportDefinitionQueryViewNode node, QueryViewTreeNode queryNode, List`1& exportColumns, String columnPrefix, SortedList`2& orderedExportColumns, Boolean useColumnPrefix, ExportDefinitionOutputMetadataNode expDefOutputMetadataNode, Boolean useColumnOrder)
   at Blackbaud.AppFx.Server.ExportDefinitionProcessor.AddChildNodeTableColumnsToOutputTable(ExportDefinitionQueryViewNode node, QueryViewTreeNode queryNode, List`1& exportColumns, String columnPrefix, Int32 index, Boolean isRootNode, SortedList`2& orderedExportColumns, Boolean useColumnPrefix, ExportDefinitionOutputMetadataNode expDefOutputMetadataNode, Boolean useColumnOrder)
   at Blackbaud.AppFx.Server.ExportDefinitionProcessor.LoadTableColumnsToOutputTable(ExportDefinitionQueryViewNode node, List`1& exportColumns, SortedList`2& orderedExportColumns, Boolean useColumnPrefix, Boolean useColumnOrder)
   at Blackbaud.AppFx.Server.ExportDefinitionProcessor.GetExportColumnsForOutputTable(ExportDefinitionQueryViewNode node, Boolean includeRowIDField, Boolean useColumnOrder)
   at Blackbaud.AppFx.Server.ExportDefinitionProcessor.InitializeExportDefinition(ExportDefinition definition, List`1 queryNodesUsed)
   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()

 
In reported instance this occurred due to a environmental issue with a local copy of CRM/BBIS.

Environment

 Blackbaud Internet Solutions
 4.0
 4.0.158.0

Was this article helpful?