Problem Note 47790: In-database publishing macros return "Syntax error, expecting one of the following.." with certain Teradata databases
In SAS® Model Manager, the following error might occur when publishing a scoring function to the Teradata 13.1 database server:
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted
string, a numeric constant, a datetime constant, a missing value, INPUT,
PUT.
The error occurs because the query to get the platform of the server returns incorrect values.
There is no workaround for this issue.
Operating System and Release Information
| SAS System | SAS Model Manager | Microsoft® Windows® for x64 | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 for x64 | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows XP Professional | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Enterprise 32 bit | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Enterprise x64 | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Home Premium 32 bit | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Home Premium x64 | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Professional 32 bit | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Professional x64 | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Ultimate 32 bit | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Ultimate x64 | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| 64-bit Enabled Solaris | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| HP-UX IPF | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Linux for x64 | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Solaris for x64 | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
*
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.
In-database publishing macros return errors with certain Teradata databases
| Type: | Problem Note |
| Priority: | high |
| Topic: | Analytics ==> Model Management
|
| Date Modified: | 2020-05-20 13:19:14 |
| Date Created: | 2012-09-04 16:58:37 |
