Problem Note 20236: "Data too long for column" errors when executing fixsqlforspm23.vbs
When you run fixsqlforspm23.vbs to update your SAS Strategic Performance
Management project from a previous version to version 2.3, you may
receive the following errors:
"Data too long for column 'ATTRTEXT' at row 1"
"Data too long for column 'DISPLAYLABEL' at row 1"
The error occurs when the project element names are longer than the
maximum 255 characters.
To fix this issue, you can do 1 of 2 things:
1. Edit and shorten the text to 255 characters or fewer in the fixed
new_spm23.sql file which is generated by the fixsqlforspm23.vbs script.
You will need to fix this prior to running the update query in MYSQL
Control Center.
2. In Mysql Control Center, open table spm.sas_elemntattributetext and
modify Column ATTRITEXT to text. Open table spm.sas_elemntattrlinkemail
and modify Column ATTREMAIL to text. Open table spm.sas_displaylabel
and modify Column DISPLAYLABEL to text.
Operating System and Release Information
| SAS System | SAS Strategic Performance Management | Microsoft Windows Server 2003 Datacenter Edition | 2.3 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows NT Workstation | 2.3 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Standard Edition | 2.3 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Enterprise Edition | 2.3 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Server | 2.3 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Advanced Server | 2.3 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Professional | 2.3 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Datacenter Server | 2.3 | | 9.1 TS1M3 SP4 | |
*
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: | 2007-07-10 13:07:49 |
| Date Created: | 2007-05-21 11:10:44 |