Problem Note 63042: A Resource label for a relationship in an XML import is more than 50 characters, and "…ERROR: value too long for type character varying(50)…" occurs
In SAS® Business Data Network, the Resource label for a relationship for a related business term in an XML import is limited to 50 characters. If you import a file that contains a Resource label with more than 50 characters, you see errors that are similar to the following:
### Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(50)
### The error may involve com.sas.svcs.dm.businessdata.server.mappers.ITermMapper.insertRelatedTermAssociation-Inline
### The error occurred while setting parameters
### Cause: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(50)
; SQL []; ERROR: value too long for type character varying(50); nested exception is org.postgresql.util.PSQLException: ERROR: value too long for type character varying(50)
The workaround is to ensure that you use no more than 50 characters for a Resource label.
Click the Hot Fix tab in this note to access the hot fix for this issue.
After you apply the hot fix, the character limit for the Resource label is increased to 100 characters. The hot fix is valid for SAS® Business Data Network 3.2.
Operating System and Release Information
SAS System | SAS Business Data Network | Solaris for x64 | 3.1 | 3.2 | 9.4 TS1M2 | 9.4 TS1M4 |
Linux for x64 | 3.1 | 3.2 | 9.4 TS1M2 | 9.4 TS1M4 |
HP-UX IPF | 3.1 | 3.2 | 9.4 TS1M2 | 9.4 TS1M4 |
64-bit Enabled Solaris | 3.1 | 3.2 | 9.4 TS1M2 | 9.4 TS1M4 |
64-bit Enabled AIX | 3.1 | 3.2 | 9.4 TS1M2 | 9.4 TS1M4 |
Microsoft® Windows® for x64 | 3.1 | 3.2 | 9.4 TS1M2 | 9.4 TS1M4 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2018-10-15 14:35:15 |
Date Created: | 2018-10-09 02:47:07 |