SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 64058: An issue with memory leaks occurs with certain versions of SAS® Embedded Process that are used with Teradata or Greenplum data

DetailsHotfixAboutRate It

When certain versions of SAS Embedded Process are installed for use with Teradata or Greenplum data, DS2 and FEDSQL procedures and DATA step code can fail. Long-running jobs where programs are compiled many times consume extra memory.

The relevant SAS Embedded Process versions are those that have file names that contain the version number 13 (for example, sepcoretera-13.00000-1.sh) or a higher version number.

Here is an example of this issue.

You call a Teradata table, SAS_SYSFNLIB.SAS_SCORE_EP, created in SAS® Scoring Accelerator for Teradata, in a Basic Teradata Query (BTEQ).

The following error then occurs in the Teradata Database Query Log (DBQL):

UDF/XSP/UDM SAS_SYSFNLIB.SASTblOp: SQLSTATE U1010: DS2 program failed to be
prepared. TKTSPrepare returned 0x80fff802.

The following failure notice also appears in the BTEQ log:

Failure 7504 in UDF/XSP/UDM SAS_SYSFNLIB.SAS_SCORE_EP: SQLSTATE U0058: Insert
into OUTTABLE failed, probable column mismatch: Statement# 1, Info =

A workaround is to free up memory by restarting the SAS Embedded Process before running a new program.

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS In-Database Code Accelerator for TeradataMicrosoft Windows Server 2003 for x64
Microsoft Windows Server 2008
Microsoft Windows Server 2008 R2
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows NT Workstation
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Server
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
Microsoft Windows 95/98
Microsoft Windows 10
Microsoft Windows 8.1 Pro x64
Microsoft Windows 8.1 Pro 32-bit
Microsoft Windows 8.1 Enterprise x64
Microsoft Windows 8.1 Enterprise 32-bit
Microsoft Windows 8 Pro x64
Microsoft Windows 8 Pro 32-bit
Microsoft Windows 8 Enterprise x64
Microsoft Windows 8 Enterprise 32-bit
Microsoft® Windows® for x64
z/OS
Microsoft Windows Server 2008 for x64
Microsoft Windows Server 2012 Datacenter
Microsoft Windows Server 2012 R2 Datacenter
Microsoft Windows Server 2012 R2 Std
Microsoft Windows Server 2012 Std
Microsoft Windows Server 2016
Microsoft Windows Server 2019
Microsoft Windows XP Professional
Windows 7 Enterprise 32 bit
Windows 7 Enterprise x64
Windows 7 Home Premium 32 bit
Windows 7 Home Premium x64
Windows 7 Professional 32 bit
Windows 7 Professional x64
Windows 7 Ultimate 32 bit
Windows 7 Ultimate x64
Windows Millennium Edition (Me)
Windows Vista
Windows Vista for x64
64-bit Enabled AIX
64-bit Enabled Solaris
HP-UX IPF
Linux for x64
Solaris for x64
SAS SystemSAS In-Database Code Accelerator for GreenplumMicrosoft Windows XP Professional
Microsoft Windows Server 2019
Microsoft Windows Server 2016
Microsoft Windows Server 2012 Std
Microsoft Windows Server 2012 R2 Std
Microsoft Windows Server 2012 R2 Datacenter
Microsoft Windows Server 2012 Datacenter
Microsoft Windows Server 2008 for x64
Microsoft Windows Server 2008 R2
Microsoft Windows Server 2008
Microsoft Windows Server 2003 for x64
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows NT Workstation
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Server
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
Microsoft Windows 95/98
Microsoft Windows 10
Microsoft Windows 8.1 Pro x64
Microsoft Windows 8.1 Pro 32-bit
Microsoft Windows 8.1 Enterprise x64
Microsoft Windows 8.1 Enterprise 32-bit
Microsoft Windows 8 Pro x64
Microsoft Windows 8 Pro 32-bit
Microsoft Windows 8 Enterprise x64
Microsoft Windows 8 Enterprise 32-bit
Microsoft® Windows® for x64
Windows 7 Enterprise 32 bit
Windows 7 Enterprise x64
Windows 7 Home Premium 32 bit
Windows 7 Home Premium x64
Windows 7 Professional 32 bit
Windows 7 Professional x64
Windows 7 Ultimate 32 bit
Windows 7 Ultimate x64
Windows Millennium Edition (Me)
Windows Vista
Windows Vista for x64
64-bit Enabled AIX
64-bit Enabled Solaris
HP-UX IPF
Linux for x64
Solaris for x64
* 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.