Problem Note 65901: You might encounter a parsing error when you configure a data service in SAS® Federation Server Manager as a non-admin user
 |  |  |  |  |
When you create a data service from SAS Federation Server Manager as a non-admin user, you might encounter an error similar to the following:
com.sas.tkts.sql.FSException: T_EXECUTE2: Table Service: Function failed.]
SQLSTATE:[HY000] MESSAGE:[Parsing failed at or near column 2: Columns 1-17 =
"...HE=(NAME={Auth"] NATIVEERROR:[-2126518256]
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 Federation Server | Microsoft® Windows® for x64 | 4.2 | 4.2 | 9.4 TS1M7 | |
| Microsoft Windows 8 Enterprise x64 | 4.2 | 4.2 | 9.4 TS1M7 | |||
| Microsoft Windows 8 Pro x64 | 4.2 | 4.2 | 9.4 TS1M7 | |||
| Microsoft Windows 8.1 Enterprise x64 | 4.2 | 4.2 | 9.4 TS1M7 | |||
| Microsoft Windows 8.1 Pro x64 | 4.2 | 4.2 | 9.4 TS1M7 | |||
| Microsoft Windows Server 2012 R2 Datacenter | 4.2 | 4.2 | 9.4 TS1M7 | |||
| Microsoft Windows Server 2012 R2 Std | 4.2 | 4.2 | 9.4 TS1M7 | |||
| Microsoft Windows Server 2019 | 4.2 | 4.2 | 9.4 TS1M7 | |||
| 64-bit Enabled AIX | 4.2 | 4.2 | 9.4 TS1M7 | |||
| 64-bit Enabled Solaris | 4.2 | 4.2 | 9.4 TS1M7 | |||
| HP-UX IPF | 4.2 | 4.2 | 9.4 TS1M7 | |||
| Linux for x64 | 4.2 | 4.2 | 9.4 TS1M7 | |||
| Solaris for x64 | 4.2 | 4.2 | 9.4 TS1M7 | |||
A fix for this issue for SAS Federation Server 4.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Y46.html#65901
When you use the CONFIG_DATA_SERVICES view, you get a parsing error for non-admin users in certain cases. Also, you might be unable to see data services when signing in to SAS Federation Server as a non-admin user.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-05-01 13:44:55 |
| Date Created: | 2020-04-28 15:52:59 |