ds_nlsmap() - BCI NLS input mapping error

ray.wurlod · Post by **ray.wurlod** » Thu Sep 16, 2010 3:40 am

Hard to say with so little information. Is the NLS map actually loading when DataStage starts?

kamesh · Post by **kamesh** » Thu Sep 16, 2010 9:57 pm

Hello Ray,
I do not have access to restart the engine to see if it really loads when we start the DataStage server. But I was under assumption that NLS maps are shown in administrator/designer if & only if they are loaded when DataStage starts OR I do not completely understand what you intend to know or ask.

vijayradhika · Post by **vijayradhika** » Mon Mar 28, 2011 12:56 pm

Hi

Can anyone please let me know if there was a solution for this topic? I tried searching with keywords like migration from 7.5 to 8.1 also, but could not find a related topic. I am getting the same error during our migration from 7.5 to 8.1.

Source - AS400
Field Type - CHARACTER(15) [as defined in the source]

Project default (UTF8) used in DS and the source target mapping has Varchar(15)

Target - Oracle(but I am writing to a hash file for this job) which is also defined as Varchar(15)

There are no transformations selecting the data from ODBC stage and writing to Hashfile.

The error that I get is as follows.

Job_Name..Stage_Name.Link_Name: ds_nlsmap() - BCI NLS input mapping error, row 89645, column COLUMN_NAME
data 'CEIX0010990?'
external 4345495830303130393930A0

In the source there is a column with value CEIX0010990.

Even when I view the data and do a search for this sting I am getting the same error.

Any assistance on this issue is much appreicated.

Thanks,
Radhika

ray.wurlod · Post by **ray.wurlod** » Mon Mar 28, 2011 1:17 pm

The character on the end is 0xA0 (ASCII 160). See if you can work out how it got there. You should be able to trim it off.

vijayradhika · Post by **vijayradhika** » Mon Mar 28, 2011 2:02 pm

Hi Ray,

Thanks for your time. I did try trimming(Column Derivation level and SQL level) and it didn't work. Still getting the same error.

Thanks,
Radhika

ray.wurlod · Post by **ray.wurlod** » Mon Mar 28, 2011 4:36 pm

Did you trim Char(160)?

vijayradhika · Post by **vijayradhika** » Wed Mar 30, 2011 8:59 am

All,

I fixed the job and this issue is resolved. In NLS tab I used
"Map name to use with stage:NONE " and the job ran fine without warnings.

Actually the same record was ignored in 7.5 as it was handled internally but 8.1 captures it as we are explicity specifying to use the NLS in the user specified format.

Thanks,
Premalatha