sequencer failing due to warnings

pradeep_nov18 · Post by **pradeep_nov18** » Mon Oct 13, 2008 11:52 pm

Hi Experts,

How to resolve this warning since it is generating for each record:

APT_CombinedOperatorController(0),0: Invalid character(s) ([xFF0C]) found converting Unicode string (code point(s): Manual payment #5100001146[xFF0C]61 ) to codepage ISO-8859-1, substituting.

Is this warning is due to this impact: I am using NLS-Map = UTF-16 in source stage and project_default in the Job level and project_default in the target(teradata).my source is sap data

and please let me know how to eliminate this warning

Nripendra Chand · Post by **Nripendra Chand** » Tue Oct 14, 2008 4:25 am

is your target database Teradata. just check the DDL of teradata table to see if columns are Unicode enabled.

Nripendra Chand · Post by **Nripendra Chand** » Tue Oct 14, 2008 4:26 am

Also which stage you are using to load records into Teradata?

pradeep_nov18 · Post by **pradeep_nov18** » Tue Oct 14, 2008 6:41 am

Thanks for the reply.

I am Using Multiload stage with Tpump has a option.

pradeep_nov18 · Post by **pradeep_nov18** » Tue Oct 14, 2008 6:42 am

Nripendra Chand wrote:Also which stage you are using to load records into Teradata?

Unicode is disabled

toshea · Post by **toshea** » Thu Oct 16, 2008 2:28 pm

Sounds like your source stage is using an NLS map of UTF-16, but your target stage is using a project default of ISO-8859-1. Your source stage is emitting a xFF0C character which apparently has no represenation in ISO-8859-1. Try setting the job NLS map to UTF-8, and set the Client character set in the Teradata stage to UTF8.