ORA-29275 - partial multibyte character (Analytics Pro)

Reply
Occasional Learner
Posts: 1

ORA-29275 - partial multibyte character (Analytics Pro)

Hi,

I'm new to SAS Analytics Pro.

Got the following error when reading data from Oracle database.

It seems like the character set between SAS and Oracle DB does not match.

2    Data test;
3    set orapmkt.v_dw_hk_misc_clickthrough;
4    run;

ERROR: Error fetching from cursor. ORACLE error is ORA-29275: partial multibyte character and no result.
NOTE: The DATA step has been abnormally terminated.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 500 observations read from the data set ORAPMKT.V_DW_HK_MISC_CLICKTHROUGH.
WARNING: The data set WORK.TEST may be incomplete.  When this step was stopped there were 500
         observations and 15 variables.

I have searched related documents on web and cannot find some sample script on how to set the character set to UTF-8 in the SAS section when retrieving the data.

Can someone help to answer where to put ENCODING=UTF-8?

Thanks a lot.

Respected Advisor
Posts: 4,173

Re: ORA-29275 - partial multibyte character (Analytics Pro)

You will find the doc for this area of questions under NLS (national language support).

Not sure if below link is the answer:

http://support.sas.com/documentation/cdl/en/nlsref/63072/HTML/default/viewer.htm#n08gwe43ne71imn1oz7...

Try to get support from your SAS Admin at your site for this. It's not really something a SAS "business" user should have to solve on it's own.

Ask a Question
Discussion stats
  • 1 reply
  • 2312 views
  • 0 likes
  • 2 in conversation