SUPPORT / SAMPLES & SAS NOTES
Problem Note 67090: The SAS® Model Manager Transfer package fails during the import step and the message "ERROR: value too long" is generated
 |  |  |  |  |
The SAS® Model Manager Transfer package might fail during the import step either via SAS® Environment Manager or via the command-line interface. When this problem happens, the following error is displayed in the model repository logs:
2020-10-30 17:13:27.847 WARN [modelRepository,0f6ac17fa0c435b8,0f6ac17fa0c435b8,false] 676 --- [0-auto-1-exec-7] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 22001
2020-10-30 17:13:27.847 ERROR [modelRepository,0f6ac17fa0c435b8,0f6ac17fa0c435b8,false] 676 --- [0-auto-1-exec-7] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: value too long for type character varying(32)
2020-10-30 17:13:27.847 ERROR [modelRepository,0f6ac17fa0c435b8,0f6ac17fa0c435b8,false] 676 --- [0-auto-1-exec-7] o.h.i.ExceptionMapperStandardImpl : HHH000346: Error during managed flush [org.hibernate.exception.DataException: could not execute statement]
2020-10-30 17:13:27.848 ERROR [modelRepository,0f6ac17fa0c435b8,0f6ac17fa0c435b8,false] 676 --- [0-auto-1-exec-7] com.sas.commons.rest.ExceptionLog : org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.DataException: could not execute statement
2020-10-30 17:13:27.848 ERROR [modelRepository,0f6ac17fa0c435b8,0f6ac17fa0c435b8,false] 676 --- [0-auto-1-exec-7] com.sas.commons.rest.ExceptionLog : caused by: org.hibernate.exception.DataException: could not execute statement
2020-10-30 17:13:27.848 ERROR [modelRepository,0f6ac17fa0c435b8,0f6ac17fa0c435b8,false] 676 --- [0-auto-1-exec-7] com.sas.commons.rest.ExceptionLog : caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(32)
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 Model Manager | Linux for x64 | 15.3 | 15.3 | Viya | Viya |