SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 35534: Text expression length exceeds maximum length error when publishing a large number of plans

DetailsHotfixAboutRate It
In SAS® Size Profiling, errors occur when there are too many profiles to be published. The error messages are similar to the one listed below:

ERROR: The text expression length (119672) exceeds maximum length (65534). 
The text expression has been truncated to 65534 characters.

To work around the problem, limit the number of profiles published to fewer than 8,000 profiles.

Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Size ProfilingMicrosoft Windows 2000 Server1.29.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition1.22.29.1 TS1M3 SP49.2 TS2M0
Microsoft Windows Server 2003 Enterprise Edition1.22.29.1 TS1M3 SP49.2 TS2M0
Microsoft Windows Server 2003 Standard Edition1.22.29.1 TS1M3 SP49.2 TS2M0
Microsoft Windows XP Professional1.22.29.1 TS1M3 SP49.2 TS2M0
Windows Vista1.22.29.1 TS1M3 SP49.2 TS2M0
64-bit Enabled AIX1.22.29.1 TS1M3 SP49.2 TS2M0
* 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.