[Vertica][VJDBC](100172) One or more rows were rejected ...

Moderator: NorbertKrupa

kleysonr
Newbie
Newbie
Posts: 17
Joined: Thu Oct 10, 2013 2:09 pm

[Vertica][VJDBC](100172) One or more rows were rejected ...

Post by kleysonr » Thu Oct 10, 2013 3:09 pm

How to debug or figure out the reason for the following error message:

ERROR 10-10 09:25:45,581 - D_LIQUIDACAO - org.pentaho.di.core.exception.KettleDatabaseException:
Error inserting/updating row
[Vertica][VJDBC](100172) One or more rows were rejected by the server.


I tried to check on vertica.log, but it's not showing the values to insert statement:

2013-10-10 10:27:09.230 Init Session:0x7f8050014e60-a00000000835e3 [Session] <INFO> [PQuery] TX:a00000000835e3(triceps-5743:0x1131) INSERT INTO dimensao.d_liquidacao( dliq_id, dliq_numero_doc_liquidacao, dliq_desc_doc_liquidacao, dliq_tipo_documento, dliq_desc_tipo_documento) VALUES (?,?,?,?,? )

Kleyson Rios.

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1804
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: [Vertica][VJDBC](100172) One or more rows were rejected

Post by JimKnicely » Thu Oct 10, 2013 3:53 pm

Did you look in the CopyErrorLogs directory which is in your catalog directory? That is where rejected and exceptions records are placed.
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

kleysonr
Newbie
Newbie
Posts: 17
Joined: Thu Oct 10, 2013 2:09 pm

Re: [Vertica][VJDBC](100172) One or more rows were rejected

Post by kleysonr » Thu Oct 10, 2013 4:21 pm

I tried, but the directory is empty.

Do I need to enable some kind of logging to get those logs ?

Kleyson Rios.

kleysonr
Newbie
Newbie
Posts: 17
Joined: Thu Oct 10, 2013 2:09 pm

Re: [Vertica][VJDBC](100172) One or more rows were rejected

Post by kleysonr » Thu Oct 10, 2013 4:59 pm

The command

select distinct error_level, message from error_messages where message;

helped-me to identify the problem for this issue. Somes strings it was bigger than the field size on the table.

But, the question about how to see the values to insert statement is still open.

Like I said before, CopyErrorLogs directory is empty :(.

Thanks for the help.

Kleyson Rios.

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1804
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: [Vertica][VJDBC](100172) One or more rows were rejected

Post by JimKnicely » Thu Oct 10, 2013 5:09 pm

Hi,

You should be able to see all of the insert statements in dc_requests_issued table:

select request_type, request from dc_requests_issued where request ilike 'insert%' order by time desc;

Although, I am not sure if you'll see the ? place holders or actual values :?:
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

kleysonr
Newbie
Newbie
Posts: 17
Joined: Thu Oct 10, 2013 2:09 pm

Re: [Vertica][VJDBC](100172) One or more rows were rejected

Post by kleysonr » Thu Oct 10, 2013 5:46 pm

Unfortunately I can see only:

LOAD | COPY dimensao.d_liquidacao ( dliq_id, dliq_numero_doc_liquidacao, dliq_desc_doc_liquidacao, dliq_tipo_documento, dliq_desc_tipo_documento ) FROM LOCAL STDIN NATIVE VARCHAR ENFORCELENGTH RETURNREJECTED AUTO NO COMMIT

I've also find on commutiy vertica forum saying:

dc_requests_issued - The COPY command does not keep track of values that have been copied.

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1804
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: [Vertica][VJDBC](100172) One or more rows were rejected

Post by JimKnicely » Thu Oct 10, 2013 5:54 pm

I'm confused. So you are running COPY commands? The original post showed an insert statement with question marks.

If so, the CopyErrorLogs directory will contain the exceptions and errors. How many nodes do you have? Make sure to look on all nodes.
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Error Codes”