Problem Note 38578: A UDF error occurs when you create models that are used with SASĀ® In-Database processing for Teradata
For the SAS® Scoring Accelerator for Teradata, you can receive the following error when you use the %INDTD_PUBLISH_MODEL macro program to create models that are used with in-database processing for Teradata:
ERROR: [HY000]Length of UDF function
name "tera51wa_i_r_buy_only_all_products"
exceeds Teradata 30 character limit. (0x817ff1af).
The error occurs when the combination of the user-defined fuction (UDF) model name and the variables that are stored in the score.xml file exceeds 30 characters. In the error message, the UDF name appears in double quotation marks.
To resolve the problem either shorten the variables in the SAS data set that is used in SAS® Enterprise Miner to create the model or shorten the model name.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to Teradata | Microsoft Windows 95/98 | 9.21_M2 | | | |
Microsoft Windows 2000 Advanced Server | 9.21_M2 | | | |
Microsoft Windows 2000 Datacenter Server | 9.21_M2 | | | |
Microsoft Windows 2000 Server | 9.21_M2 | | | |
Microsoft Windows 2000 Professional | 9.21_M2 | | | |
Microsoft Windows NT Workstation | 9.21_M2 | | | |
Microsoft Windows Server 2003 Datacenter Edition | 9.21_M2 | | | |
Microsoft Windows Server 2003 Enterprise Edition | 9.21_M2 | | | |
Microsoft Windows Server 2003 Standard Edition | 9.21_M2 | | | |
Microsoft Windows Server 2008 | 9.21_M2 | | | |
Microsoft Windows XP Professional | 9.21_M2 | | | |
Windows 7 Enterprise 32 bit | 9.21_M2 | | | |
Windows 7 Enterprise x64 | 9.21_M2 | | | |
Windows 7 Home Premium 32 bit | 9.21_M2 | | | |
Windows 7 Home Premium x64 | 9.21_M2 | | | |
Windows 7 Professional 32 bit | 9.21_M2 | | | |
Windows 7 Professional x64 | 9.21_M2 | | | |
Windows 7 Ultimate 32 bit | 9.21_M2 | | | |
Windows 7 Ultimate x64 | 9.21_M2 | | | |
Windows Millennium Edition (Me) | 9.21_M2 | | | |
Windows Vista | 9.21_M2 | | | |
64-bit Enabled AIX | 9.21_M2 | | | |
64-bit Enabled HP-UX | 9.21_M2 | | | |
64-bit Enabled Solaris | 9.21_M2 | | | |
HP-UX IPF | 9.21_M2 | | | |
Linux | 9.21_M2 | | | |
Linux for x64 | 9.21_M2 | | | |
Solaris for x64 | 9.21_M2 | | | |
*
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.
When you use long variable names in models to export to Teradata using in-database processing, you receive the following error: "ERROR: [HY000]Length of UDF function name "tera51wa_i_r_buy_only_all_products"
exceeds Teradata 30 character limit. (0x817ff1af)."
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2010-02-10 10:00:03 |
Date Created: | 2010-02-02 13:12:06 |