Talend community forum / [resolved] "E_CO0015 COPY: Warning ..." in Ingres bulk operation.

PETER_LG · 2012-05-29 09:41:24

Tags: [bug, context, CSV file, database, date, db2, delimited file, deployment, development, error, error management, i18n, java, mssql, mysql, oracle, perl, positional file, PostgreSQL, schema, sybase, tos3.0.0]

Hi Experts,

Please help. I try to use the bulk operation with drive Ingres to load data into Ingres table, but it has the warning "E_CO0015 COPY: Warning ..." and failed, I spend much time to review the data, but the data seems ok, so what is root cause generally? and how to resolve it? thanks.

=====Warning:

E_CO0015 COPY: Warning: 8 character domains were truncated when copied
from the file to character type columns in the table.

E_CO0028 COPY: Warning: Copy completed with 1 warnings. 5022 rows
successfully copied.

Best Regards,
Peter.

pedro · 2012-05-29 09:50:39

Hi Peter

Judging from this warning, you'd better check the insert data. The length of this column is 8. But some of your insert data is longer than that and it has been truncated.

Regards,
Pedro

PETER_LG · 2012-05-29 10:11:01

Seems should be 8 records has the waring ... but do not understand what happen.

Last edited by PETER_LG (2012-05-29 10:11:19)

PETER_LG · 2012-05-29 10:15:29

Oh, god that's my fault, the field length in table is not correct, thank you.

Announcement

Unanswered posts

#1 2012-05-29 09:41:24

[resolved] "E_CO0015 COPY: Warning ..." in Ingres bulk operation.

#2 2012-05-29 09:50:39

Re: [resolved] "E_CO0015 COPY: Warning ..." in Ingres bulk operation.

#3 2012-05-29 10:11:01

Re: [resolved] "E_CO0015 COPY: Warning ..." in Ingres bulk operation.

#4 2012-05-29 10:15:29

Re: [resolved] "E_CO0015 COPY: Warning ..." in Ingres bulk operation.

Board footer