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.
[Vertica][VJDBC](100172) One or more rows were rejected ...
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: [Vertica][VJDBC](100172) One or more rows were rejected
Did you look in the CopyErrorLogs directory which is in your catalog directory? That is where rejected and exceptions records are placed.
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: [Vertica][VJDBC](100172) One or more rows were rejected
I tried, but the directory is empty.
Do I need to enable some kind of logging to get those logs ?
Kleyson Rios.
Do I need to enable some kind of logging to get those logs ?
Kleyson Rios.
Re: [Vertica][VJDBC](100172) One or more rows were rejected
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.
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.
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: [Vertica][VJDBC](100172) One or more rows were rejected
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
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: [Vertica][VJDBC](100172) One or more rows were rejected
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.
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.
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: [Vertica][VJDBC](100172) One or more rows were rejected
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.
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.