trafodion-development team mailing list archive

[Radu Marias <radumarias@xxxxxxxxx>]

Hi,

Using Trafodion Sandbox 1.1 with VirtualBox I get this error while loading
data in a table. The scenario is:

*>>create TABLE sna_persons (*
*    id NUMERIC not null,*
*    last_name varchar(70),*
*    first_name varchar(30),*
*    middle_name varchar(30),*
*    sex char(1),*
*    fraud_flag char(1),*
*    party_id varchar(24),*
*    primary key (id)*
*)*
*salt using 8 partitions on (id);*

*>>create index sna_persons_i1 on sna_persons(first_name)*
*salt like table;*

*>>create index sna_persons_i2 on sna_persons(last_name)*
*salt like table;*

*>>create index sna_persons_i3 on sna_persons(party_id) salt like table;*

*>>load into TRAFODION.SEABASE.SNA_PERSONS select * from
hive.hive.sna_persons;*
*Task: LOAD             Status: Started    Object:
TRAFODION.SEABASE.SNA_PERSONS*
*Task:  CLEANUP         Status: Started    Object:
TRAFODION.SEABASE.SNA_PERSONS*
*Task:  CLEANUP         Status: Ended      Object:
TRAFODION.SEABASE.SNA_PERSONS*
*Task:  DISABLE INDEXE  Status: Started    Object:
TRAFODION.SEABASE.SNA_PERSONS*
*Task:  DISABLE INDEXE  Status: Ended      Object:
TRAFODION.SEABASE.SNA_PERSONS*
*Task:  PREPARATION     Status: Started    Object:
TRAFODION.SEABASE.SNA_PERSONS*

**** ERROR[8690] An invalid character value encountered in TRANSLATE
function.*

If I skip the LAST_NAME column it works. I cannot see anything specific in
logs, how can I determine which value is invalid? I have 1 million rows in
table, will not be easy to isolate it ;)

-- 
And in the end, it's not the years in your life that count. It's the life
in your years.