String data code page conversion error
Moderators: chulett, rschirm, roy
String data code page conversion error
I am hitting this error while executing the job to load a table containing 18 columns and 2.5 lac rows ....the job simply uses 3 equi joins and some hard coded strings....after processing some 2,500 rows it is throwing this "string data code page conversion error"....please can anybody help?
dev,
welcome to DSXchange! You really need to supply some more information on what is happening in your case - you've done the car equivalent of driving into a car repair shop, walking to the mechanic and pointing at your saying "It sometimes doesn't run well, can you fix it?"
Do you have an NLS installation, and if so what are your settings. Which stage is generating the conversion warning? Do you expect non-convertible characters in your data stream? Have you found the row with the "bogus" data?
welcome to DSXchange! You really need to supply some more information on what is happening in your case - you've done the car equivalent of driving into a car repair shop, walking to the mechanic and pointing at your saying "It sometimes doesn't run well, can you fix it?"
Do you have an NLS installation, and if so what are your settings. Which stage is generating the conversion warning? Do you expect non-convertible characters in your data stream? Have you found the row with the "bogus" data?
</a>String Data Code Page Conversion Failed
Hi,
Thanks for your input. I am loading Spanish data and using MS1252 as the NLS while reading data and the same while loading data onto a table.
I have an impression that all European characters can be read with this NLS setting, but not sure on this. Can someone throw light on this?
Here you go with the error message that it throws:
file..ins_contact.Spa_link5: DSD.BCIGetNext call to SQLFetch failed.
SQL statement:SELECT CONTACT_ID, ADDR_PER_ID, FST_NAME, LAST_NAME, MIDDLE_NAME, TITLE_ID, TITLE_VAL, SEX, LANG, PHONE, FAX, EMAIL, PAGER, MOBILE, OFF_HRS, BIRTH_DT, GRAD_YR, PRIV_ADDR1, PRIV_ADDR2, PRIV_ZIP, PRIV_CITY, M_BRICK_ID, M_BRICK_VAL, PRIV_CNTRY, PRIV_PHONE, PRIV_FAX, PRIV_EMAIL, MEMBERSHIP, NOMAIL, PRE_NAME, LAST_UPD, DB_SOURCE, REC_TYPE, STATUS, CNTRY_CD, REQ_ID, REQ_TYPE, RESP_CD, RESP_DESC, TITLE_VAL_FULL FROM P_CONTACT1
SQLSTATE=S1000, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver]String data code page conversion failed. Error in column 4.
Thanks for your input. I am loading Spanish data and using MS1252 as the NLS while reading data and the same while loading data onto a table.
I have an impression that all European characters can be read with this NLS setting, but not sure on this. Can someone throw light on this?
Here you go with the error message that it throws:
file..ins_contact.Spa_link5: DSD.BCIGetNext call to SQLFetch failed.
SQL statement:SELECT CONTACT_ID, ADDR_PER_ID, FST_NAME, LAST_NAME, MIDDLE_NAME, TITLE_ID, TITLE_VAL, SEX, LANG, PHONE, FAX, EMAIL, PAGER, MOBILE, OFF_HRS, BIRTH_DT, GRAD_YR, PRIV_ADDR1, PRIV_ADDR2, PRIV_ZIP, PRIV_CITY, M_BRICK_ID, M_BRICK_VAL, PRIV_CNTRY, PRIV_PHONE, PRIV_FAX, PRIV_EMAIL, MEMBERSHIP, NOMAIL, PRE_NAME, LAST_UPD, DB_SOURCE, REC_TYPE, STATUS, CNTRY_CD, REQ_ID, REQ_TYPE, RESP_CD, RESP_DESC, TITLE_VAL_FULL FROM P_CONTACT1
SQLSTATE=S1000, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver]String data code page conversion failed. Error in column 4.
It looks like column 4 (LAST_NAME) has a character in that line that cannot be mapped from MS1252 and might not even be legal in that representation. Can you see what the contents of that field for that row are in the database? Also, what are the Oracle NLS settings for your session (check the ENV variables in the job log to make certain that they are what you expect)