"An export definition is limited to a total number of 1000 columns. This export definition contains a total of 14567 columns. Please remove or reduce the number of records to export for a given node in the export definition." on saving export definition

When attempting to save an export definition with the Constituent query view including the Volunteer fields and exporting 60 records for each field the error occurs.
This is due to a SQL Server limitation.  We suggest reducing the number of records to be exported for the specific record type causing the issue. 

Steps to Duplicate

1. Create an export definition using the Constituent query view
2. Add the Following fields in the order below with the Export Criteria set to 1 for the number to export:

Constituents
Name
LookupID
Age
Gender
Marital Status
Address (Primary)
City
Zip
Type

Add the following fields set the export criteria to export 8 records:
Constituencies
Constituency
Date Added
Date from

Add the following fields with the export criteria set to 1 record to export:
Model Scores and Ratings
Annual giving likelihood
Major Giving likelihood
Wealth estimator rating score

Wealth Information
Wealth indicator number - identified
Total Assets - identified
Income/compensation assets - identified

Wealth Capacity
Estimated Wealth
Overall Rating

FY16 Total Annual Giving Smart Field
Value

FY15 Total Annual Giving Smart Field
Value

FY13 Total Annual Giving Smart Field
Value

FY12 Total Annual Giving Smart Field
Value

Lifetime Giving Smart Field
Value

First Gift Amount - Smart Field
Value

First Gift Date - Smart Field
Value


Add the following fields with the export criteria set to 60 records to export:

Volunteer
Timesheets
Hours Worked
Job Occurrence
Start Date

On Behalf of Agency
Organization
Name
Lookup ID


3. Click save and Close, receive the error message.












 

Environment

 Blackbaud CRM
 4.0
 4.0.163.0

Was this article helpful?