SAS Institute. The Power to Know
 
 
 

SAS Federation Server 4.2

Hot Fix Downloads

* General Information about Hot Fixes

Y46001
SAS Federation Server 4.2
Issue(s) Addressed:Introduced:
57737 "I/O error during 'open' operation" or "No such file or directory" occurs when you use the SAS® Federation Server 4.1 backup utility with SQL Logging Y46001
Windows Released: March 01, 2016     Documentation: Y46001wn.html D       Download: Y46001wn.zip  
Windows for x64 Released: March 01, 2016     Documentation: Y46001x6.html D       Download: Y46001x6.zip  
64-bit Enabled Solaris Released: March 01, 2016     Documentation: Y46001s6.html D       Download: Y46001s6.tar  
64-bit Enabled AIX Released: March 01, 2016     Documentation: Y46001r6.html D       Download: Y46001r6.tar  
HP-UX IPF Released: March 01, 2016     Documentation: Y46001hx.html D       Download: Y46001hx.tar  
Linux for x64 Released: March 01, 2016     Documentation: Y46001la.html D       Download: Y46001la.tar  
Solaris for x64 Released: March 01, 2016     Documentation: Y46001sx.html D       Download: Y46001sx.tar  
D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment.
Top ^

Y46002 was replaced by Y46013

Y46003 was replaced by Y46013

Y46004 was replaced by Y46013

Y46005 was replaced by Y46013

Y46006 was replaced by Y46013

Y46007 was replaced by Y46013

Y46008 was replaced by Y46013

Y46009 was replaced by Y46013

Y46010 was replaced by Y46013

Y46011 was replaced by Y46013

Y46012 was replaced by Y46013

Y46013
SAS Federation Server 4.2
Issue(s) Addressed:Introduced:
58386 In SAS® Federation Server, cached views created using TPT do not correctly display rows Y46002
57792 SAS® Real-Time Decision Manager campaign fails with "org.apache.commons.dbcp.SQLNestedException: Borrow callableStatement from pool failed" Y46003
58789 SAS® Federation Server clients generate "ERROR: Multiple DBMS credentials of equal precedence configured for the current authorization and rejected" Y46003
59346 In SAS® Federation Server, an SQL query returns "An exception was thrown while waiting for a reply from the peer" when querying large volumes of data Y46004
59348 Code generated by SAS® Federation Server Manager is incorrectly formatted Y46004
59349 Logging on to SAS® Federation Server from the SAS® Federation Server Manager user interface takes a long time Y46004
59396 SAS® Federation Server returns column names from a query in uppercase letters regardless of their case in the underlying table Y46004
59426 Viewing data from SAS® Federation Server Manager 4.2 returns the error “The data cannot be shown..." Y46004
59431 In SAS® Federation Server 4.1, the Trace driver crashes due to a memory overwrite Y46004
59499 SAS® Federation Server 4.2 fails to retrieve data source contents when connecting to the SPD Server via an ODBC driver Y46006
61390 Using UNION ALL with two views returns the "Table 'XXXX' not found in FROM clause" error Y46006
61391 Using the UNION ALL query returns invalid data Y46006
59933 When you use a null value in data-masking functions in SAS® Federation Server 4.2, "Error: HY000 Error occurred building the Execution Tree..." occurs Y46007
60076 You are not able to see your privileges in SAS® Federation Server Manager Y46007
60546 Incorrect results are returned from a wildcard % query on PostgreSQL Threaded Kernel Table Services (TKTS) tables Y46007
60600 SAS® Federation Server becomes unresponsive to SAS® Real-Time Decision Manager Y46007
60676 Issues such as system call failures and unresponsive SAS® processes occur with long-running processes that use DS2 or DATA step programming language Y46007
60714 SAS® Scalable Performance Data Server fails to connect to a domain with "Connection does not exist...zdcrypt local buffer too small..." Y46007
60715 SAS® Enterprise Guide® cannot display Latin5 characters that come from SAS® Federation Server Y46007
60726 SAS® Federation Server Manager shows invalid characters for SAS® Scalable Performance Data Server data Y46007
60755 SAS® Real-Time Decision Manager experiences intermittent high response times when you use DS2 and SAS® Federation Server 4.1 Y46007
61393 Count(*) returns incorrect and random results for a UNION ALL query between two tables Y46007
61394 Table field names are not displayed in the field list if the schema name contains escape characters Y46007
61399 A "Syntax error or access violation" occurs when you use nested functions and a WHERE clause Y46007
61402 Using the ENCRYPT data masking function with the AES algorithm yields poor performance Y46007
61403 You experience poor performance when you use the FEDSRV engine because sub-queries are not pushed to the database in cross-database joins Y46007
61423 In SAS® QKB Pattern Logic nodes, the "Full phrase" option in the extraction definition does not work properly Y46007
61425 When you run SQL queries in SAS® Federation Server, the error "postprocess_setop-tlist: resjunk output columns are not implemented" occurs Y46007
61897 SAS® Federation Server becomes non-responsive in SAS® Real-Time Decision Manager and errors are generated Y46008
62411 You cannot view BLOB or CLOB data from an Oracle table when you use a LIBNAME statement with the FEDSVR engine Y46009
62488 Writing numeric values to Oracle might cause precision loss Y46009
62563 A large number of 'UNPREPARE' error messages appear in the Microsoft SQL Server log when you execute campaigns in SAS® Real-Time Decision Manager Y46010
62661 A "Numeric Value out of range" error occurs under certain conditions when you filter data in a FedSQL view via a WHERE clause Y46011
63231 Opening an Oracle table with the Federation Server engine causes SAS® Federation Server to fail with "ERROR: CLI cursor fetch error..." Y46012
60709 When you insert text data containing a question mark (?) into an Oracle database table from SAS® Federation Server, the ? is converted to :1 Y46013
61314 A SAS® process of code type "SAS DS2" fails to run and generates an error Y46013
61759 When you run the FEDSQL procedure on Oracle tables, it generates "ERROR: FEDSQL does not support 'long data when pushdown fails'" Y46013
62519 A DATASETS procedure that requests a large number of Oracle tables from SAS® Federation Server takes a long time to complete Y46013
63212 ALERT - The CI_PACKAGE_X_TREATMENT table becomes locked in Teradata during the DS2 contact-history process Y46013
63468 Running a large Oracle SQL query causes SAS® Federation Server to stop responding with "General Error - invalid Exception" Y46013
63490 You encounter slow performance when fetching large amounts of data using the SAS® Federation Server Engine Y46013
NOTE: If you install this hot fix and have SAS Drivers for Federation Server 4.2 installed, you must also install hot fix Z51002.
If you install this hot fix and have SAS Threaded Kernel 9.4_M4 installed, you must also install hot fix A5D006.
If you install this hot fix and have SAS Threaded Kernel Drivers for Scalable Performance Data 5.3_M1 installed, you must also install hot fix A4U002.
If you install this hot fix and have SAS Threaded Kernel 9.4_M3 installed, you must also install hot fix Y81004.
If you install this hot fix and have SAS Scalable Performance Data Server 5.3 installed, you must also install hot fix A3J005.
If you install this hot fix and have SAS Federation Server Manager Mid-Tier 4.2 installed, you must also install hot fix A1A004.
Windows Released: December 20, 2018     Documentation: Y46013wn.txt D       Download: Y46013wn.zip  
Windows for x64 Released: December 20, 2018     Documentation: Y46013x6.txt D       Download: Y46013x6.zip  
64-bit Enabled Solaris Released: December 20, 2018     Documentation: Y46013s6.txt D       Download: Y46013s6.tar.gz  
64-bit Enabled AIX Released: December 20, 2018     Documentation: Y46013r6.txt D       Download: Y46013r6.tar.gz  
HP-UX IPF Released: December 20, 2018     Documentation: Y46013hx.txt D       Download: Y46013hx.tar.gz  
Linux for x64 Released: December 20, 2018     Documentation: Y46013la.txt D       Download: Y46013la.tar.gz  
Solaris for x64 Released: December 20, 2018     Documentation: Y46013sx.txt D       Download: Y46013sx.tar.gz  
D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment.
Top ^

Y46014
SAS Federation Server 4.2
Issue(s) Addressed:Introduced:
63612 "ERROR...DSN 'BASE' not found or user not authorized" occurs when you access a SAS® Federation Server definer’s rights view Y46014
NOTE: If you install this hot fix, you must first install hot fix Y46013 for SAS Federation Server 4.2.
If you install this hot fix, you must also install hot fix E2A005 for Threaded Kernel Metadata Component 9.4_M6.
64-bit Enabled AIX Released: January 06, 2021     Documentation: Y46014r6.docx D       Download: Y46014r6.tar  
Linux for x64 Released: February 19, 2019     Documentation: Y46014la.docx D       Download: Y46014la.tar  
D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment.
Top ^

Y46015
SAS Federation Server 4.2
Issue(s) Addressed:Introduced:
63718 You encounter slow performance when you use SAS® Federation Server to read in SAS® data sets Y46015
63741 Retrieving compressed SAS® data sets via SAS® Federation Server occurs more slowly than expected Y46015
NOTE: Before you install this hot fix, you must first install these SAS Federation Server 4.2 hot fixes in this order:
Y46013 (first)
Y46014 (second)
To enable prefetch capabilities for SAS 9.4M5, in addition to Y46015, you must also install hot fix C1S006 for SAS Threaded Kernel 9.4_M5 and hot fix C7Z002 for SAS Threaded Kernel Extensions for FedSQL and DS2 Standalone 9.4_M5.
To enable prefetch capabilities for SAS 9.4M6, in addition to Y46015, you must also install hot fix E2G017 for SAS Threaded Kernel 9.4_M6 and hot fix E5Q001 for SAS Threaded Kernel Extensions for FedSQL and DS2 Standalone 9.4_M6.
Windows for x64 Released: February 26, 2019     Documentation: Y46015x6.docx D       Download: Y46015x6.zip  
64-bit Enabled AIX Released: January 06, 2021     Documentation: Y46015r6.docx D       Download: Y46015r6.tar  
Linux for x64 Released: February 26, 2019     Documentation: Y46015la.docx D       Download: Y46015la.tar  
D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment.
Top ^

Y46016
SAS Federation Server 4.2
Issue(s) Addressed:Introduced:
63776 The error "Pack/Unpack buffer too small" occurs when you open a data service using the SAS® Scalable Performance Data Server driver Y46016
NOTE: Before you install this hot fix, you must first install these SAS Federation Server 4.2 hot fixes in this order:
Y46013 (first)
Y46014 (second)
Y46015 (third)
Linux for x64 Released: March 05, 2019     Documentation: Y46016la.docx D       Download: Y46016la.tar  
D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment.
Top ^

Y46017 was replaced by Y46018

Y46018
SAS Federation Server 4.2
Issue(s) Addressed:Introduced:
64298 You might experience a slow response time when using the SHA-256 algorithm for masking values in federated views in SAS® Federation Server 4.2 Y46017
64303 You experience a slow response time while using federated views on SAS data sets with SAS® Federation Server 4.2 Y46017
64304 The error "File libref.table.DATA does not exist" occurs in SAS® Federation Server 4.2 Y46017
NOTE: Before you install this hot fix, you must first install these SAS Federation Server 4.2 hot fixes in this order:
Y46013 (first)
Y46014 (second) (Linux for x64 only)
Y46015 (third)
Y46016 (fourth) (Linux for x64 only)
Windows for x64 Released: July 15, 2019     Documentation: Y46018x6.docx D       Download: Y46018x6.zip  
Linux for x64 Released: July 15, 2019     Documentation: Y46018la.docx D       Download: Y46018la.tar  
D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment.
Top ^

Y46019
SAS Federation Server 4.2
Issue(s) Addressed:Introduced:
58789 SAS® Federation Server clients generate "ERROR: Multiple DBMS credentials of equal precedence configured for the current authorization and rejected" Y46019
65682 Running FedSQL with an Oracle table is slow, even when you use a LIMIT clause Y46019
65740 A FedSQL query can return incorrect results when a data set has LATIN1 encoding, and the query contains a WHERE IN clause with more than 10 values Y46019
65901 You might encounter a parsing error when you configure a data service in SAS® Federation Server Manager as a non-admin user Y46019
65904 SAS® Federation Server stops responding when you run queries against X_OBJECT_PRIVILEGES in SYSCAT and the queries run for hours Y46019
Windows for x64 Released: May 01, 2020     Documentation: Y46019x6.docx D       Download: Y46019x6.zip  
Linux for x64 Released: May 01, 2020     Documentation: Y46019la.docx D       Download: Y46019la.tar  
D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment.
Top ^

Y46020
SAS Federation Server 4.2
Issue(s) Addressed:Introduced:
66299 DataDirect ODBC drivers for SAS® Federation Server 4.2 do not support Microsoft SQL Server on Azure or Oracle 19c Y46020
NOTE: After installing this hot fix, customers who have SAS Federation Server Secure software installed should contact SAS Technical Support and reference SAS NOTE 66299.
Windows for x64 Released: July 16, 2020     Documentation: Y46020x6.txt D       Download: Y46020x6.exe  
64-bit Enabled AIX Released: May 12, 2023     Documentation: Y46020r6.txt D       Download: Y46020r6.tar.gz  
Linux for x64 Released: July 16, 2020     Documentation: Y46020la.txt D       Download: Y46020la.tar.gz  
D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment.
Top ^

Y46021
SAS Federation Server 4.2
Issue(s) Addressed:Introduced:
66372 An HTTP package in the DS2 procedure does not have properly encoded URL values Y46021
Linux for x64 Released: August 14, 2020     Documentation: Y46021la.docx D       Download: Y46021la.tar  
D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment.
Top ^

Y46023
SAS Federation Server 4.2
Issue(s) Addressed:Introduced:
66899 PROC DS2 might cause slow response times when you access an Oracle table with VARCHAR2 bind variables Y46023
Linux for x64 Released: December 18, 2020     Documentation: Y46023la.docx D       Download: Y46023la.tar  
D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment.
Top ^

Y46024
SAS Federation Server 4.2
Issue(s) Addressed:Introduced:
66815 A DS2 SAS® process fails with the error "T_EXECDIRECT2: Table Service: Function failed. ERROR: Access violation" Y46024
67195 The number of Oracle ocius.msb open files in SAS® Federation Server increases over time Y46024
Windows for x64 Released: February 08, 2021     Documentation: Y46024x6.docx D       Download: Y46024x6.zip  
Linux for x64 Released: February 08, 2021     Documentation: Y46024la.docx D       Download: Y46024la.tar  
D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment.
Top ^

Y46025
SAS Federation Server 4.2
Issue(s) Addressed:Introduced:
67778 Views that are created with SAS® Federation Server might lose alias names for columns Y46025
Windows for x64 Released: April 23, 2021     Documentation: Y46025x6.docx D       Download: Y46025x6.zip  
Linux for x64 Released: April 23, 2021     Documentation: Y46025la.docx D       Download: Y46025la.tar  
D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment.
Top ^

Y46026
SAS Federation Server 4.2
Issue(s) Addressed:Introduced:
67829 Support for bulk loading is enabled for SAS® Federation Server Y46026
Windows for x64 Released: May 20, 2021     Documentation: Y46026x6.docx D       Download: Y46026x6.zip  
64-bit Enabled AIX Released: May 20, 2021     Documentation: Y46026r6.docx D       Download: Y46026r6.tar  
Linux for x64 Released: May 20, 2021     Documentation: Y46026la.docx D       Download: Y46026la.tar  
D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment.
Top ^

Y46027
SAS Federation Server 4.2
Issue(s) Addressed:Introduced:
67778 Views that are created with SAS® Federation Server might lose alias names for columns Y46027
Windows for x64 Released: September 10, 2021     Documentation: Y46027x6.docx D       Download: Y46027x6.zip  
64-bit Enabled AIX Released: September 10, 2021     Documentation: Y46027r6.docx D       Download: Y46027r6.tar  
Linux for x64 Released: September 10, 2021     Documentation: Y46027la.docx D       Download: Y46027la.tar  
D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment.
Top ^




PLEASE CAREFULLY READ THE TERMS AND CONDITIONS OF THIS LICENSE AGREEMENT ("AGREEMENT") BEFORE DOWNLOADING MATERIALS FROM THIS SITE. BY DOWNLOADING ANY MATERIALS FROM THIS SITE, YOU ARE AGREEING TO THESE TERMS.
You are downloading software code ("Code") which will become part of a product ("Software") you currently have licensed from SAS Institute Inc. or one of its subsidiaries ("the Institute"). this Code is designed to either correct an error in the Software or to add functionality to the Software. The code is governed by the same agreement which governs the Software. If you do not have an existing agreement with the Institute governing the Software, you may not download the Code.
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand and product names are registered trademarks or trademarks of their respective companies.

Copyright © SAS Institute Inc. All Rights Reserved.