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
