SUPPORT / SAMPLES & SAS NOTES
Problem Note 64933: Scoring of a model might fail with various errors due to a lack of available memory
 |  |  |  |  |
The scoring of a model might cause the virtual memory usage on Teradata nodes to increase to a level that results in the system running out of memory. When scoring a very complicated model, you might encounter an error similar to one of the following:
-
CALL Failed. 7504: in UDF/XSP/UDM SAS_SYSFNLIB.SAS_SCORE_EP: SQLSTATE U0031: SASTblOp failed: Error Code 7504: in UDF/XSP/UDM SAS_SYSFNLIB.SASTblOp: SQLState U1030: DS2 program failed on execution. TKTSExecute returned 0x80fff802.
-
in UDF/XSP/UDM SAS_SYSFNLIB.SASTblOp: SQLSTATE U1010: DS2 program failed to be prepared. TKTSPrepare returned 0x80fff802.
-
Failure 7504 in UDF/XSP/UDM SAS_SYSFNLIB.SAS_SCORE_EP: SQLSTATE U0058: Insert into OUTTABLE failed, probable column mismatch: Statement# 1, Info =0
-
ERROR: Teradata execute: in UDF/XSP/UDM SAS_SYSFNLIB.SAS_SCORE_EP: SQLSTATE U0031: SASTransform failed: Error Code 9134: DS2 program failed to be prepared. TKTSPrepare returned 0x80fff802.
-
CALL Failed. 7504: in UDF/XSP/UDM SAS_SYSFNLIB.SAS_SCORE_EP: SQLSTATE U0031: SASTblOp failed: Error Code 7504: in UDF/XSP/UDM SAS_SYSFNLIB.SASTblOp_Contract: SQLSTATE U1010: DS2 program failed to be prepared. TKTSPrepare returned 0x80fff802.
The workaround is to restart SAS® Embedded Process, which sets the virtual memory back to zero.
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 Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Scoring Accelerator for Teradata | 64-bit Enabled Solaris | 9.4 TS1M4 | |||
| 64-bit Enabled AIX | 9.4 TS1M4 | |||||
| Windows 7 Ultimate x64 | 9.4 TS1M4 | |||||
| Windows 7 Ultimate 32 bit | 9.4 TS1M4 | |||||
| Windows 7 Professional x64 | 9.4 TS1M4 | |||||
| Windows 7 Professional 32 bit | 9.4 TS1M4 | |||||
| Windows 7 Home Premium x64 | 9.4 TS1M4 | |||||
| Windows 7 Home Premium 32 bit | 9.4 TS1M4 | |||||
| Windows 7 Enterprise x64 | 9.4 TS1M4 | |||||
| Windows 7 Enterprise 32 bit | 9.4 TS1M4 | |||||
| Microsoft Windows Server 2012 Std | 9.4 TS1M4 | |||||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M4 | |||||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M4 | |||||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M4 | |||||
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M4 | |||||
| Microsoft Windows Server 2008 R2 | 9.4 TS1M4 | |||||
| Microsoft Windows Server 2008 | 9.4 TS1M4 | |||||
| Microsoft Windows 10 | 9.4 TS1M4 | |||||
| Microsoft Windows 8.1 Pro x64 | 9.4 TS1M4 | |||||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M4 | |||||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M4 | |||||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M4 | |||||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M4 | |||||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M4 | |||||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M4 | |||||
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M4 | |||||
| Microsoft® Windows® for x64 | 9.4 TS1M4 | |||||
| HP-UX IPF | 9.4 TS1M4 | |||||
| Linux for x64 | 9.4 TS1M4 | |||||
| Solaris for x64 | 9.4 TS1M4 | |||||
| SAS System | SAS In-Database Technologies for Teradata | Linux for x64 | V.03.03 | V.03.05 | Viya | Viya |