Error running marketing effort export. Cannot insert the value NULL into column 'column name', table 'table name' - When exporting a Marketing Effort

When exporting a marketing effort, one may encounter the following error:

Error running marketing effort export. Cannot insert the value NULL into column 'SOURCEQUERYVIEWCATALOGID', table 'tempdb.dbo.#TEMP_CHUNK_RAWDATA__________________________________________________________0000000186BC': column does not allow nulls. INSERT fails. The statement has been terminated.

 
We are currently evaluating this issue for a fix in a future service pack. 

Steps to Duplicate

1.   From the Marketing Effort record in question, click Export effort under Tasks. The Edit marketing effort export process window pops up.
2.   In the Edit marketing effort export process window, confirm the selections on the General and Preview tabs. Click Start.
3.   Receive error: Error running marketing effort export. Cannot insert the value NULL into column 'SOURCEQUERYVIEWCATALOGID', table 'tempdb.dbo.#TEMP_CHUNK_RAWDATA__________________________________________________________0000000186BC': column does not allow nulls. INSERT fails. The statement has been terminated.

Environment

 Blackbaud CRM
 4.0
 4.0.166

Was this article helpful?