Problem Note 59756: SAS® Federation Server Manager 4.2 is removing duplicate schema options when configuring data services
When you use SAS Federation Server Manager to configure data services, duplicate SCHEMA options are being removed, as illustrated in the following example.
Driver connection string:
HOST=myhost;SERV=14512;LOCALE=en_us;DBQ=PUBLIC;SCHEMA=(DBQ=public;FEDSQL_OBJECTS=NO;);SCHEMA=(DBQ=formats;FEDSQL_OBJECTS=NO;);
Notice that the SCHEMA option is listed twice. This is correct and necessary. However, SAS Federation Server Manager generates and issues the following DDL (to SAS Federation Server):
CREATE DATA SERVICE "SPDS53" TYPE GENERIC CATALOG "SPDS53" DOMAIN "SPDS" REGISTER () VALIDATE YES {OPTIONS CONOPTS(DRIVER SPDS, ADD SERV 14512,
SCHEMA(ADD FEDSQL_OBJECTS NO, ADD DBQ formats), ADD LOCALE en_us, ADD HOST myhost, ADD DBQ PUBLIC)}
Notice that there is only one set of SCHEMA options in the list. The first set of SCHEMA options was removed.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Federation Server | Microsoft® Windows® for x64 | 4.2 | 4.2.1 | 9.4 TS1M3 | 9.4 TS1M4 |
Linux for x64 | 4.2 | 4.2.1 | 9.4 TS1M3 | 9.4 TS1M4 |
*
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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2019-01-22 09:18:05 |
Date Created: | 2017-01-20 03:27:31 |