DSD.BCIPut call to OCONV failed

pxraja · Post by **pxraja** » Wed May 27, 2009 4:26 am

Hi all,

I am getting following warnings and following that 4 records are not passed to the target. Could any one suggest on, how to avoid the mentioned warnings.

below are the warning for one of the record.

Transformer_2.DSLink4: DSD.BCIPut call to OCONV failed.
Column: PARAMDESC1, NLS mapname: ISO8859-1, Column data (after conversion): ??, Column data (in hex, before conversion) E4B8ADE59BBD

thanks in advance

ArndW · Post by **ArndW** » Wed May 27, 2009 4:33 am

What character set is your target table defined in? You will need to check each character, find the corresponding character in ISO8859-1 and see if it can be represented in your target character set.

ray.wurlod · Post by **ray.wurlod** » Wed May 27, 2009 4:27 pm

DSD.BCIPut only invokes OCONV for date and time data types, so I'd start by looking there.

And DO do something about naming stages and links meaningfully.

pxraja · Post by **pxraja** » Sat May 30, 2009 1:22 am

Hi ray & andrew,

thanks for your reply, but the field is not a date field. It is Location having value like "Janakpuri"

I had used conver(".","",Oconv(inputfieldname,MCP)) and after passing inputfieldname alone without using any conversion and added one reject sequential file. I am still getting warnings like below and I have rejected records.

ds_nlsmap() - BCI NLS input mapping error, row 142897, column Location
data 'District Centre?Janakpuri'
external 44697374726963742043656E747265A04A616E616B70757269

data type in target is VARCHAR2(255) null values are also accepted.

Also i have used NLS as NONE in both ODBC stages (i/p from SQLSERVER and o/p to ORACLE)

I need to insert all the records, any ideas would be helpful.

thanks in advance

pxraja · Post by **pxraja** » Sat May 30, 2009 1:24 am

some spelling mistake in the code

Convert(".", "", Oconv(inputlinkname, "MCP"))

chulett · Post by **chulett** » Sat May 30, 2009 7:14 am

So... these errors come when you try to write to Oracle? You need to answer the NLS question - what is the NLS_LANG setting for your Oracle database?

ray.wurlod · Post by **ray.wurlod** » Sat May 30, 2009 6:11 pm

The character between Centre and Janakpuri is 0xA0 (Char(160)). Check your source data to determine whether this actually occurs there. And do check the NLS_LANG setting for Oracle.

pxraja · Post by **pxraja** » Fri Jun 12, 2009 8:44 pm

ray.wurlod wrote:The character between Centre and Janakpuri is 0xA0 (Char(160)). Check your source data to determine whether this actually occurs there. And do check the NLS_LANG setting for Oracle. ...

I had checked in the source system its proper "Janakpuri" is present, no special character,

also i had checked the nls_language in oracle its 'AMERICAN'.

even i tried to give nls parameter as none but its throwing same warnings and the records are rejected.

please give any clues to rectify this error.

thanks in advance

ray.wurlod · Post by **ray.wurlod** » Sun Jun 14, 2009 4:29 pm

Could this be a "hard space" character from a Word document or similar?

pxraja · Post by **pxraja** » Sun Jun 14, 2009 11:01 pm

ray.wurlod wrote:Could this be a "hard space" character from a Word document or similar? ...

I had copied from director logs and pasted,

did you mean to say that '?' is present in the source which is not accepted varchar type?

when i am searching for 'district centre ? Janakpuri' in the odbc. It is throwing same warnings....

Is that indicates ''district centre ? Janakpuri' is present in the source which is not valid ?

any other information is required?