Im currently trying to consume (extract) an Oracle Table in Tableau. I keep getting an Oracle database error 29275: ORA-29275: partial multibyte character UTF-8.
just querying (selecting )the table in TOAD as well as in Tableau, doesnt give an error.
The tablea consists of 15 columns (10 dimensions and 5 measures). all the measures have a MAX aggregated function .
I seem to get the error for all the 5 measure columns and also for one of the dimension column. My table has close to 2 million rows of data
Source DB : Oracle 11G
Source Character Set : AL32UTF8
What I tried :
1) I converted all the affected columns to source db characterset .
Eg.
select CONVERT(name,'AL32UTF8','UTF8') from test1@remote;
when I just select a single column it does seem to work but when I select more than one column I keep getting the error for the affected columns.
2) converted to_char and to_number for the affected columns.
3) tried to use TRIM function
4)on the contrary, I also tried to update the affected column by adding an '' (empty sting ) to the end of the column
5)sorted the column to identify any affected rows with special characters . I couldn't find any special characters or affected rows.
6) when I just do top 100 rows, the table works perfectly in tableau.
I have tried all the above to prevent this error. I still get the error.
I just started using Oracle and Im unable to solve this issue.
any help is appreciated.