Data Warehouse ETL error Derive DATEIDS

When running the data warehouse ETL, the following error occurs: "The "Derive DATEIDS" failed because error code 0xC0049063 occurred, and the error row disposition on "Derive DATEIDS.Outputs[Derived Column Output].Columns[POSTDATEDIMID]" specifies failure on error."
This error was caused by invalid data in the database. Run the database integrity utility to find issues such as trailing spaces and invalid dates. Use its results to correct the data. If the error persists, create a script to check every date field in the system to verify if it is valid. Check for dates outside of the range of Jan/1/1800 to Jan/1/2100.

Steps to Duplicate

1) Begin ETL job on the data warehouse
2) An error occurs
3) View the log. See error:

Error: 2017-10-19 16:09:15.62
   Code: 0xC0049063
   Source: Load Changed Rows Derive DATEIDS [44]
   Description: The conditional operation failed.
End Error
Error: 2017-10-19 16:09:15.62
   Code: 0xC0209029
   Source: Load Changed Rows Derive DATEIDS [44]
   Description: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "Derive DATEIDS" failed because error code 0xC0049063 occurred, and the error row disposition on "Derive DATEIDS.Outputs[Derived Column Output].Columns[POSTDATEDIMID]" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.
End Error

Environment

 Blackbaud CRM
 4.0
 4.0
 4.0.173

Was this article helpful?