String Transformation In Endeca Integrator ETL. (Doc ID 2116453.1)

Last updated on APRIL 28, 2016

Applies to:

Oracle Endeca Information Discovery Integrator - Version 3.1.0 and later
Information in this document applies to any platform.

Goal

I have a graph that reads several database tables one of the attributes in one of the tables is defined as varchar2(450). The integrator treats it as a string. When I read database records that have " or "" in them I receive this error message. Is there a transform that I can perform so the individual characters of the string are not interpreted?

ERROR [WatchDog_0] - Component [Trash:TRASH1] finished with status ERROR.
 Converting exception in the record: 46339.
  Exception when converting the field value: Changes: 65Duro cdl mnts, “B” constr tires, 105N/mm @ 5500N rr sprng,
  58Duro PPV strut mnt, CABJ rr trlng lnk.
  (field name: 'REQUEST_COMMENTS') to ISO-8859-1.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms