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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.