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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| 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 | ||
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2014-06-06 12:29:54 |
| Date Created: | 2014-06-05 10:33:58 |