ORA-12704 character set mismatch after Oct 2020 release

[Anonymous]

Running desktop version: 2.86.1321.0 64-bit (October 2020)

Was perfectly fine in the May 2020 version. 

This is affecting reports with data from Oracle that has "Merged Columns" (Table.CombineColumns)

It looks like only erroring on columns of type Text from Oracle

Help please?

[v-deddai1-msft]

Hi @Anonymous ,

First of first, would you please try to update the desktop for rs to the latest version and try again. This error looks like the result of inconsistent data types in the table during the query, you may refer to  https://knowledge.informatica.com/s/article/123056?language=en_US

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai