Problem Note 40671: Errors occur when you submit code in SAS® Business Intelligence or SAS® Enterprise Guide® that has a text string that exceeds 65,534 characters
 |  |  |  |
In SAS® Business Intelligence or SAS® Enterprise Guide®, when you submit code that has a text string that exceeds 65,534 characters, errors occur. The issue happens when you submit the code as a SAS® Stored Process from SAS Business Intelligence or as a program node in SAS Enterprise Guide. In these instances, two error messages appear.
The first error message that appears is as follows:
ERROR: The text expression length (nnnnn) exceeds maximum length (65534). The text expression has been truncated to 65534 characters.
Depending on which version of SAS you are using, the second error message that appears might be similar to one of the following messages:
Segmentation Violation In Task [ <taskname> ( ] Fault Occurred at [/data/sas/software/SAS_9.1/sasexe/sasxml:_memcpy+0xec] Task Traceback /data/sas/software/SAS_9.1/sasexe/sasxml:_memcpy+0xec /data/sas/software/SAS_9.1/sasexe/sasxml:sasxml+0x10170 /data/sas/software/SAS_9.1/sasexe/sasxml:sasxml+0xae58 /data/sas/software/SAS_9.1/sasexe/sasxml:sasxml+0xbb14 /data/sas/software/SAS_9.1/sasexe/sasoda:sasoda+0xbe0 /data/sas/software/SAS_9.1/sasexe/sasxml:sasxml+0x3170 /data/sas/software/SAS_9.1/sasexe/sasods:odssm+0x368 /data/sas/software/SAS_9.1/sasexe/sasods:odsfact+0x39d0 /data/sas/software/SAS_9.1/hotfix/sasexe/sasrepmn.e9ba45:repmain+0x2c30 /data/sas/software/SAS_9.1/hotfix/sasexe/sasrepor.e9ba45:sasrepor+0x94 /data/sas/software/SAS_9.1/hotfix/sasexe/sas.e9bc18:vvtentr+0x120
An error occurred executing the workspace job "<jobname>".
Integration technologies failed to retrieve the log.
Unable to cast COM object of type ‘SAS.LanguageServiceClass‘
to interface type ‘SAS.ILanguageService_1_1‘. This operation
failed because the QueryInterface call on the COM component for
the interface with IID‘{C32A4D4B-410D-9669-97F241D3435A} ‘ failed
due to the following error: No such interface supported
(Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
The server is disconnected.ERROR: An exception has been encountered. Please contact technical support and provide them with the following traceback information: The SAS task name is [<taskname> (2)] ERROR: Read Access Violation <taskname> (2) Exception occurred at (07787C0A)
To resolve these errors, reduce the length of the text string to fewer than 65,534 characters.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | z/OS | 9.1 TS1M3 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 | |||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 | |||
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | |||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |||
| Microsoft Windows 2000 Server | 9.1 TS1M3 | |||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | |||
| Microsoft Windows NT Workstation | 9.1 TS1M3 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | |||
| Microsoft Windows XP Professional | 9.1 TS1M3 | |||
| Windows Vista | 9.1 TS1M3 | |||
| Windows Vista for x64 | 9.1 TS1M3 | |||
| 64-bit Enabled AIX | 9.1 TS1M3 | |||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | |||
| 64-bit Enabled Solaris | 9.1 TS1M3 | |||
| HP-UX IPF | 9.1 TS1M3 | |||
| Linux | 9.1 TS1M3 | |||
| OpenVMS Alpha | 9.1 TS1M3 | |||
| Tru64 UNIX | 9.1 TS1M3 | |||
| Type: | Problem Note |
| Priority: | medium |
| Topic: | Query and Reporting |
| Date Modified: | 2010-12-14 15:36:56 |
| Date Created: | 2010-08-24 11:00:53 |