SUPPORT / SAMPLES & SAS NOTES
Problem Note 61653: The on-premises version of SAS® 360 Discover can fail with an "invalid byte sequence" error when the CXT_ETL_cxt_2000_load_page_dim job runs
 |  |  |  |  |
In SAS® Customer Intelligence 360, the on-premises SAS 360 Discover module might fail when the CXT_ETL_cxt_2000_load_page_dim job runs. When this problem occurs, the following error is generated:
NOTE: There were 16696 observations read from the data set CXTSTAGE.PAGE_DIM.
NOTE: 16695 observations added.
NOTE: The data set CXTWH.PAGE_DIM has . observations and 19 variables.
ERROR: CLI execute error: ERROR: invalid byte sequence for encoding "UTF8": 0xf8;
Error while executing the query
NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE APPEND used (Total process time):
real time 16.31 seconds
cpu time 1.75 seconds
NOTE: The SAS System stopped processing this step because of errors.
NOTE: SAS set option OBS=0 and will continue to check statements. This might cause NOTE: No observations in data set.
MPRINT(CXT_LOADTBL): ;
NOTE: 16695 observations added.
NOTE: The data set CXTWH.PAGE_DIM has . observations and 19 variables.
ERROR: CLI execute error: ERROR: invalid byte sequence for encoding "UTF8": 0xf8;
Error while executing the query
NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE APPEND used (Total process time):
real time 16.31 seconds
cpu time 1.75 seconds
NOTE: The SAS System stopped processing this step because of errors.
NOTE: SAS set option OBS=0 and will continue to check statements. This might cause NOTE: No observations in data set.
MPRINT(CXT_LOADTBL): ;
This is an invalid byte-sequence error. The problem occurs because of a UTF-8 problem.
To work around this problem and restart the SAS 360 Discover CXT ETL, you must add the following line in the cxt_clean_page_dim job to remove the UTF-8 data that causes the loader to fail:
PAGE_URL_TXT=kpropdata(ktrim(kleft(compbl(PAGE_URL_TXT))),"TRIM","UTF8");
Then navigate to SAS® Digital Integration Studio and run the Discover CXT ETL reset job. You should now be able to execute the SAS 360 Discover CXT ETL job and complete it without encountering this error again.
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 | |||