SUPPORT / SAMPLES & SAS NOTES
Problem Note 57986: The SAS® 360 Discover ETL job 2000_load_referrer_query_string_dim fails and generates an error
 |  |  |  |  |
In SAS 360 Discover, a failure occurs when you run the extract, transform, and load (ETL) job 2000_load_referrer_query_string_dim. In addition, the following error is generated:
ERROR: CLI execute error: ERROR: invalid byte sequence for encoding "UTF8":
0xd83d; Error while executing the query
As a workaround, modify the cleansing macro in the cxt_clean_ref_query_str_dim.sas file and apply the KPROPDATA function, as shown below:
referrer_query_string_txt=kpropdata(referrer_query_string_text,'trim','utf8');
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Customer Intelligence 360 | N/A | 1.0 | 1.0 | ||