SUPPORT / SAMPLES & SAS NOTES
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:
could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.DataException: could not execute statement.
Also, the sas-dataprofiles log contains messages that are similar to the following:
2020-10-27 14:34:55.782 WARN 1868 --- [ool-82-thread-2]
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.
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 | ||