Blackbaud Community
Connect and collaborate with fellow Blackbaud users.
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()
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:
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
