Problem Note 56715: SAS® Model Manager fails to publish a project to a Teradata database and an error "Invalid option name @ ..." is displayed
 |  |  |  |  |
When you publish a SAS Model Manager project to a Teradata database, publishing might fail. An error similar to the following is displayed in the log:
NOTE: Line generated by the macro variable "INDCONN".
122 server="TeradataHost" user=mm@user password=XXXXXXX daXXXXXXXnlssort
mode=Teradata
_
22
ERROR: Libref INDB is not assigned.
ERROR: Error in the LIBNAME statement.
WARNING: Libref INDB is not assigned.
ERROR 22-7: Invalid option name @.
EPERRCODE=1
The problem occurs when your user ID contains the @ ("at") symbol.
To work around this problem, select the Replace scoring functions that have the same publish name option in the publish dialog box. By default, the option is not selected.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Model Manager | Microsoft Windows Server 2012 R2 Datacenter | 13.1 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 Datacenter | 13.1 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2008 for x64 | 13.1 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2008 R2 | 13.1 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2008 | 13.1 | 9.4 TS1M2 | ||||
| Microsoft Windows 8.1 Pro | 13.1 | 9.4 TS1M2 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 13.1 | 9.4 TS1M2 | ||||
| Microsoft Windows 8 Pro x64 | 13.1 | 9.4 TS1M2 | ||||
| Microsoft Windows 8 Enterprise x64 | 13.1 | 9.4 TS1M2 | ||||
| Microsoft® Windows® for x64 | 13.1 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2012 R2 Std | 13.1 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2012 Std | 13.1 | 9.4 TS1M2 | ||||
| Windows 7 Enterprise x64 | 13.1 | 9.4 TS1M2 | ||||
| Windows 7 Home Premium x64 | 13.1 | 9.4 TS1M2 | ||||
| Windows 7 Professional x64 | 13.1 | 9.4 TS1M2 | ||||
| Windows 7 Ultimate x64 | 13.1 | 9.4 TS1M2 | ||||
| 64-bit Enabled AIX | 13.1 | 9.4 TS1M2 | ||||
| 64-bit Enabled Solaris | 13.1 | 9.4 TS1M2 | ||||
| HP-UX IPF | 13.1 | 9.4 TS1M2 | ||||
| Linux for x64 | 13.1 | 9.4 TS1M2 | ||||
| Solaris for x64 | 13.1 | 9.4 TS1M2 | ||||
A fix for this issue for SAS Model Manager 14.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/V85.html#56715A fix for this issue for SAS Model Manager 13.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/S15.html#56715| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2015-10-21 10:07:16 |
| Date Created: | 2015-10-06 10:27:46 |