Invalid characters by using CLOB
Posted: Mon Aug 28, 2017 1:25 am
Hello,
i have a Problem trying to transfer a CLOB Field from a Oracle DB to another.
The job contains only 3 stages:
- ORACLE 11g Stage for reading
- Transformer (which doesnt realy transform data)
- ORACLE 11g Stage for writing
In the Source DB there are 2 CLOB Fields which are configured to read as LONGVARCHAR. The writting stage is also configured as LONGVARCHAR. NLS Mapping is used by ProjectDefault (UTF8). I got the following error message:
Any ideas where the problem is? Is it the fieldsize or a problem mit the nls mapping? fieldlength is unspecified in both, input and output.
i have a Problem trying to transfer a CLOB Field from a Oracle DB to another.
The job contains only 3 stages:
- ORACLE 11g Stage for reading
- Transformer (which doesnt realy transform data)
- ORACLE 11g Stage for writing
In the Source DB there are 2 CLOB Fields which are configured to read as LONGVARCHAR. The writting stage is also configured as LONGVARCHAR. NLS Mapping is used by ProjectDefault (UTF8). I got the following error message:
Code: Select all
WRITE_DB,1: Invalid character(s) ([xED][xA0][xBD]) found converting string (code point(s): <div class="rte-line"><span class="rte-highlight" style="background-color: rgb(1...) from codepage UTF-8 to Unicode, substituting.
Code: Select all
READ_DB,0: Internal Error: (!(stat.statusBits() & APT_DMStatus::eRecordTooBig)):api/dataset_rep1.C: 1795: Virtual data set.; output of "READ_DB": the record is too big to fit in a block;
the length requested is: 798202.
Traceback: Could not obtain stack trace; check that 'gdb' and 'sed' are installed and on your PATH