String Transformation In Endeca Integrator ETL.
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.
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.
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