Problem Note 67118: An exception message occurs in SAS® Data Explorer during profiling if a text field contains an invalid UTF-8 character
 |  |  |  |  |
The Profile function in SAS Data Explorer fails if the table that is being profiled contains invalid UTF-8 characters. This message appears in the user interface:
Also, the sas-dataprofiles log contains messages that are similar to the following:
o.h.engine.jdbc.spi.SqlExceptionHelper : service SQL Error: 0, SQLState: 22021
2020-10-27 14:34:55.783 ERROR 1868 --- [ool-82-thread-2]
o.h.engine.jdbc.spi.SqlExceptionHelper : service ERROR: invalid byte sequence
for encoding "UTF8": 0x00
2020-10-27 14:34:55.783 ERROR 1868 --- [ool-82-thread-2]
o.h.i.ExceptionMapperStandardImpl : service HHH000346: Error during
managed flush [org.hibernate.exception.DataException: could not execute
statement]
2020-10-27 14:34:55.784 ERROR 1868 --- [ool-82-thread-2]
c.s.p.p.t.service.TableAdvancedProfiler : service Exception:
2020-10-27 14:34:55.785 ERROR 1868 --- [ool-82-thread-2]
c.s.p.p.t.service.TableAdvancedProfiler : service
org.springframework.dao.DataIntegrityViolationException: could not execute
statement; SQL [n/a]; nested exception is org.hibernate.exception.DataException:
could not execute statement
2020-10-27 14:34:55.785 ERROR 1868 --- [ool-82-thread-2]
c.s.p.p.t.service.TableAdvancedProfiler : service [JobExecutionFailure] Error
executing job could not execute statement; SQL [n/a]; nested exception is
org.hibernate.exception.DataException: could not execute statement.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Viya | Linux for x64 | 3.5 | Viya | ||
Viya on Windows: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Windows Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesWinViya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-01-13 10:36:08 |
| Date Created: | 2020-12-16 16:47:34 |