Problem Note 53154: The error "The submitted line exceeds maximum line length - 32768 bytes" occurs when you generate SAS® Web Report Studio reports
An error that is similar to the following might occur when you are generating SAS Web Report Studio reports:
An error occurred in processing the report element. Refresh the page to
try again. Contact your administrator if this problem persists.
[a13994681373750.23854876694882166_0_0] Error Rendering the Report
Error while submitting SAS code 1 options Locale=en_US; 2 LIBNAME
HCMData MYSQL DBCREATE_TABLE_OPTS="TYPE=InnoDB" INSERTBUFF=1
DBCONINIT="set names 'latin1', session sql_mode='';" AUTOCOMMIT=NO
MYSQL_PORT=3306 SERVER="PGHQHRCMAPPW01.fxg.ds.fedex.com" DATABASE=HCM
USER=hcmdbadm 3 PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ; 4
5 PROC SQL; 6 Create table WORK.A1 as 7 SELECT 8 table0.EMPLOYEE_ID AS
DIR_1 LABEL='Employee ID' FORMAT=$32., 9 SUM(table0.AGE) AS DIR_2
LABEL='Age' 10 FROM ERROR: The submitted line exceeds maximum line
length - 32768 bytes.
This problem occurs under the following conditions:
- The data source is a table in the HCMData library.
- The Honor Table Security option is set to Y in the table
properties (on the Extended Attributes tab).
- The user is a member of the HR user group.
This error occurs because the filter that is generated as a result of
turning on Honor Table Security is longer than 32,768 characters.
To obtain a fix for this issue, contact SAS Technical Support.
Operating System and Release Information
| SAS System | SAS Human Capital Management | Microsoft® Windows® for x64 | 5.21 | 5.21 | 9.3 TS1M2 | 9.3 TS1M2 |
| 64-bit Enabled AIX | 5.21 | 5.21 | 9.3 TS1M2 | 9.3 TS1M2 |
| 64-bit Enabled Solaris | 5.21 | 5.21 | 9.3 TS1M2 | 9.3 TS1M2 |
| Linux for x64 | 5.21 | 5.21 | 9.3 TS1M2 | 9.3 TS1M2 |
*
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: | medium |
| Date Modified: | 2014-06-06 12:29:54 |
| Date Created: | 2014-06-05 10:33:58 |