Re: AWS Database Migration Errors Post migration

Hi,

On 28/03/18 01:23, bala jayaram wrote:
> Hi Team,
>
> We are seeing this error after the migration from EC2 plain instance
> into RDS based Postgresql.
>
> Version: 9.5
> Error/Exception:
> Occuring Frequently.
>
> 2018-02-05T20:12:19 [TARGET_LOAD ]E: Command failed to load data with
> exit error code 1, Command output: psql: /usr/lib64/libcom_err.so.2:
> no version information available (required by
> /rdsdbbin/attunity-2.4.0.R2/lib/libgssapi_krb5.so.2), psql:
> /usr/lib64/libcom_err.so.2: no version information available (required
> by /rdsdbbin/attunity-2.4.0.R2/lib/libkrb5.so.3), ERROR: date/time
> field value out of range: "0000-00-00 00:00:00.000000", CONTEXT: COPY
> ******, line 445050, column end_date: "0000-00-00 00:00:00.000000"
> [1020403] (csv_target.c:883)
>
> Could you please comment on this?
>
>
This is the problem:

ERROR: date/time field value out of range: "0000-00-00 00:00:00.000000",

that 'all zero' date is not a valid date as far as Postgres is
concerned. I don't think the error is specific to RDS - no Postgres
version will load such a value into any actual date type field.

regards
Mark