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