Problem Note 37985: Metadata generation in SAS® Customer Intelligence fails with an error if the length of a field name in the underlying database exceeds 28 characters
In SAS Customer Intelligence, generation of metadata fails with the following error if the length of a field name in the underlying database exceeds 28 characters:
java.lang.IllegalArgumentException: An invalid resultset ID was specified. An
ID of length less than 1 or greater than 32 or it may have contained an invalid
character or was a reserved word. The ID specified was '[DATABASE_FIELD_NAME_EXCEEDS_28]'.
If you are using double-byte characters, the maximum length for this field is 16 characters.
There are two workarounds for this issue:
- Ensure that the names of all database fields that require metadata are 28 or fewer characters.
- Use the custom attribute, OutputColumnName, in the information map to define an alternative name for the field with a length
that is less than 28 characters.
Operating System and Release Information
| SAS System | SAS Customer Intelligence Plug-ins for SAS Management Console | Microsoft® Windows® for x64 | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Enterprise Edition | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Standard Edition | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows Server 2008 | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows XP Professional | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 |
| Windows Vista | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 |
| 64-bit Enabled AIX | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 |
| 64-bit Enabled Solaris | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 |
| HP-UX IPF | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 |
| Linux for x64 | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 |
| Solaris for x64 | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 |
*
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.
Metadata generation fails if the length of a field name in the underlying database exceeds 28 characters (16 if you are using double-byte characters). The error "java.lang.IllegalArgumentException: An invalid resultset ID was specified." is displayed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2010-02-01 15:05:41 |
| Date Created: | 2009-12-01 13:54:36 |
