Error: An error occurred before executing the process ‘Data Mart Stat ETL Refresh Job Business Process’: Job finished with outcome 0 – Failed. – when running ETL refresh after editing constituency criteria in the Loyal Donor Constituency

When attempting to run an ETL Refresh the following errors are presented in the ETL Status Logs:

Progress: 2016-03-07 17:33:36.35
   Source: Remove deleted members
   Executing query "--Get Member constituency information
declare @CON...".: 100% complete
End Progress
Error: 2016-03-07 17:33:36.58
   Code: 0xC002F210
   Source: Loyal Donors Execute SQL Task
   Description: Executing the query "--Get Loyal Donor constituency information
declare..." failed with the following error: "Adding a value to a 'datetime' column caused an overflow.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
End Error
Warning: 2016-03-07 17:33:36.58
   Code: 0x80019002
   Source: Load Derived Constituencies
   Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
End Warning
This issue was caused by Loyal Donor Constituency date ranges that extended beyond the valid date range for the data warehouse refresh. This can be addressed by extending the valid date range for the data warehouse refresh. 

To do this: 
  1. Access Administration functional area
  2. Click "Data warehouses" under the Administration heading
  3. Click the name of the data warehouse to update 
  4. In the left-hand pane Configuration tasks, click "Edit valid date range" 
  5. Adjust the valid date range to include the same time period as the loyal donor constituency
The above approach assumes the Loyal Donor data is set at the correct level.  An alternative approach may be to adjust Loyal Donor Constituency data to fit within the data warehouse refresh range, if applicable.  
 

Steps to Duplicate

  1. Go to Constituents > Constituencies
  2. Expand Loyal Donor constituency, click Edit constituency criteria
  3. Enter criteria of "468 consecutive Month" for example, click Save
  4. Go to Administration > Data warehouse
  5. Click Blackbaud Data warehouse
  6. Expand "Refresh data" section on left-hand tool bar
  7. Click "Start ETL refresh"

Environment

 Blackbaud CRM
 4.0
 4.0.157.0

Was this article helpful?