Error: F_JD228E: Date Containing Time Information Encountered

Issue

Refresh jobs fail with the following error:

F_JD228E: Date containing time information encountered while converting to DB2 date column <column> of table <table>. Use action TableProperties with parameter CoerceErrorPolicy=WARNING CoerceErrorType=ROUNDING to silently ignore time part.

Environment

• HVR 6
• Source: Db2
• Target: Snowflake

Resolution

To resolve this issue:

1. Define the TableProperties action with the following parameters:
   • CoerceErrorType=ROUNDING
   • CoerceErrorType=DATE_RANGE
2. Run Activate Replication with the Jobs option selected.

Cause

This issue occurs when the source column contains date and time values, while the target column is defined as a DATE data type. The DATE type doesn't store time information. As a result, replication fails when we attempt to convert a timestamp value to a date.