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 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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| 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 | ||
A fix for this issue for SAS Business Data Network Mid-Tier 3.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B7K.html#63042| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-10-15 14:35:15 |
| Date Created: | 2018-10-09 02:47:07 |