Problem Note 67197: An error such as "ERROR: CLI execute error: Syntax error or access violation" occurs when you use single sign-on (SSO) in SAS® Federation Server 4.4
 |  |  |  |  |
When trying to create, read, drop, or write data using an SSO connection in SAS Federation Server 4.4, you might see an error similar to the following:
ERROR: Error attempting to CREATE a DBMS table. ERROR: CLI execute error: Syntax error or access violation
To address this issue, the hot fix in this note enables full SSO support for SAS Federation Server 4.4.
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 | 64-bit Enabled AIX | 4.4 | 9.4 TS1M7 | 9.4 TS1M7 | |
| 64-bit Enabled Solaris | 4.4 | 9.4 TS1M7 | 9.4 TS1M7 | |||
| HP-UX IPF | 4.4 | 9.4 TS1M7 | 9.4 TS1M7 | |||
| Linux for x64 | 4.4 | 9.4 TS1M7 | 9.4 TS1M7 | |||
| Solaris for x64 | 4.4 | 9.4 TS1M7 | 9.4 TS1M7 | |||
A fix for this issue for SAS Threaded Kernel Extensions for FedSQL and DS2 Standalone 9.4_M7 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J1F.html#67197
SAS Federation Server 4.4 supports SSO connections from a SAS Federation Server to a back-end data source such as SQL Server or Teradata. To access this functionality, you must install the hot fix in this note.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> data management |
| Date Modified: | 2021-01-12 09:37:41 |
| Date Created: | 2021-01-08 15:13:20 |