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()
Article
Number:100593
Products:
Blackbaud_CRM
Blackbaud_Internet_Solutions
In reported instance this occurred due to a environmental issue with a local copy of CRM/BBIS.