| D9T062 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 64417 | In-database procedures require engine-specific definitions for SQL syntax requirements |
D9T036 |
| 65340 | You receive "Syntax error, statement will be ignored..." when you run a procedure that supports in-database processing |
D9T062 |
NOTE: If you install this hot fix, you must also install hot fixes D9T069, D9T084, and D9T082 for Base SAS 9.4_M6.
If you install this hot fix and have SAS Threaded Kernel Extensions for FedSQL and DS2 Standalone 9.4_M6 installed, you must also install hot fix E5Q002.
If you install this hot fix and have SAS Threaded Kernel DS2 and FedSQL Language Processors 9.41_M4 installed, you must also install hot fix E9Y004.
If you install this hot fix and have SAS Threaded Kernel 9.4_M6 installed, you must also install hot fix F8C003. |
|
|
| D9T071 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 64130 | The error "Internal error. Failed to get disked NAMESTR from hptgetdiskvarno" occurs when you access an SPD Engine data set |
D9T044 |
| 65596 | The error message "The PARALLELREAD option can only be used with an HDFS library" occurs when you access SPD Engine data |
D9T071 |
NOTE: If you install this hot fix and have Base SAS 9.4_M6 installed, you must also install hot fix D9T082.
If you install this hot fix and have SAS Threaded Kernel Components for Scalable Performance Data 9.41_M6 installed, you must also install hot fix F8U001.
If you install this hot fix and have SAS Threaded Kernel Drivers for Scalable Performance Data 5.3_M3 installed, you must also install hot fix F8T001. |
|
|
| D9T075 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 65724 | A REST transformation in SAS® Data Integration Studio causes issues for a RESTful service that uses the Content-Type header attribute |
D9T075 |
NOTE: This hotfix is a pre-requisite to D8Y005. If you install this hot fix , you must also install
D8Y005 for Data Integration Studio 4.904 to fully implement updates documented in SAS Note 65724, . |
|
| D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment. |
| D9T078 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 63449 | The METALIB procedure contains a security vulnerability |
D9T015 |
| 63593 | The METALIB procedure might fail with a segmentation violation or an error when you update tables that contain multiple foreign keys |
D9T015 |
| 63869 | A segmentation violation might occur when you expand a metadata library from SAS® Enterprise Guide® or SAS® Studio or execute the DATASETS procedure |
D9T015 |
| 65449 | The METALIB procedure returns a syntax error for Google BigQuery, MongoDB, Salesforce, and Snowflake databases |
D9T066 |
| 65821 | The message "ERROR: Invalid physical name" occurs when you use a JSON Engine library and METALIB or META LIBNAME Engine |
D9T078 |
| 65900 | Registering an Oracle table to the metadata might fail and generate an error |
D9T078 |
|
|
| D9T080 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 63923 | An enhancement to the SAS® system option SQLIPONEATTEMPT prevents further attempts to run a query if an error occurs while the query is running |
D9T007 |
| 63940 | Subsetting a view in SAS® 9.4M5 (TS1M5) with a comparison operator that contains an equal sign and colon (=:) returns different results than expected |
D9T007 |
| 64015 | A memory leak occurs after multiple CONNECT and DISCONNECT statements when you use the SQL procedure with explicit pass-through |
D9T007 |
| 64342 | Performance degradation might occur when you use a PROC SQL query to access SAS® Scalable Performance Data Server 5.4 |
D9T029 |
| 64343 | A PROC SQL query that joins multiple Hive tables results in "Execute error: Error while compiling statement: FAILED: SemanticException[Error 10017]" |
D9T029 |
| 64344 | A new SAS/ACCESS® Interface to Snowflake product is available as an add-on to SAS® 9.4M6 (TS1M6) in Rev. 940_19w34 or to SAS® Viya® 3.4 (19w34) |
D9T029 |
| 64345 | A new SAS/ACCESS® Interface to Google BigQuery product is available as an add-on to SAS® 9.4TS1M6 in Rev. 940_19w34 or to SAS® Viya® 3.4 (19w34) |
D9T029 |
| 64422 | A new environment variable, SAS_PRESERVE_EMPTY_STRING, provides options for the behavior when a blank or empty string is encountered |
D9T029 |
| 64528 | Aggregate functions are not passed down through an implicit pass-through query to Apache Hive |
D9T045 |
| 64592 | "ERROR: The SQL statement contains a UDF that is not being passed to the database" occurs with Hadoop queries that contain user-defined functions |
D9T045 |
| 65036 | SAS® Customer Intelligence queries to five or more joined DBMS tables take a long time to execute |
D9T045 |
| 64819 | A DATA step that executes a PROC SQL view with a WHERE clause does not select the index |
D9T054 |
| 64931 | An incorrect index is selected by the SQL procedure when the number of distinct values exceed 2147483647 (2 GiB - 1) |
D9T054 |
| 65138 | The message "ERROR: Provided buffer is not large enough" occurs when you use the CONNECT TO statement with the SQL procedure |
D9T054 |
| 65537 | An SQL procedure might generate incorrect results when a variable is renamed in a query |
D9T069 |
| 65539 | A query might return incorrect results if it contains an SQL JOIN to a variable that was created in an SQL view |
D9T069 |
| 66193 | Joining multiple DBMS tables might result in performance issues because some of the processing is done in SAS® rather than in the database |
D9T069 |
| 65553 | A query passed to a database might not include the ORDER BY clause when a variable is renamed |
D9T074 |
| 65581 | An SQL procedure query that creates a SAS® table returns a "Write Access Violation" error |
D9T074 |
| 65563 | You encounter performance problems when a query passed to a database does not include a WHERE clause |
D9T077 |
| 65766 | Ambiguous column or duplicate column errors might occur when running a query against a database |
D9T077 |
| 65597 | An SQL procedure query with a WHERE clause that contains multiple subselects might return incorrect results |
D9T080 |
| 65835 | A series of PROC SQL queries might not generate a distinct set of rows |
D9T080 |
NOTE: If you install this hot fix, you must also install hot fixes D9T084, D9T062, and D9T082 for Base SAS 9.4_M6.
If you install this hot fix and have SAS Threaded Kernel Extensions for FedSQL and DS2 Standalone 9.4_M6 installed, you must also install hot fix E5Q002.
If you install this hot fix and have SAS Threaded Kernel DS2 and FedSQL Language Processors 9.41_M4 installed, you must also install hot fix E9Y004.
If you install this hot fix and have SAS Threaded Kernel 9.4_M6 installed, you must also install hot fix F8C003. |
|
|
| D9T082 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 63688 | Using the ODS EXCEL and ODS POWERPOINT destinations with SAS/IntrNet® software in SAS® 9.4M6 (TS1M6) generates errors |
D9T017 |
| 64028 | GRIDINSTALLLOC and GRIDRSHCOMMAND are now available as SAS® system options |
D9T020 |
| 63295 | A SAS® session can stop working in a Microsoft Windows operating environment due to incorrect syntax for an %IF macro statement in open code |
D9T025 |
| 63508 | An application that is executed multiple times ends with an exception |
D9T025 |
| 64160 | Access methods that govern when Python can be executed from SAS® code |
D9T027 |
| 64417 | In-database procedures require engine-specific definitions for SQL syntax requirements |
D9T037 |
| 64422 | A new environment variable, SAS_PRESERVE_EMPTY_STRING, provides options for the behavior when a blank or empty string is encountered |
D9T037 |
| 64430 | The IMPORT procedure fails in SAS when you use the GUESSINGROWS=MAX option or a high value for the argument in the GUESSINGROWS= statement |
D9T040 |
| 64130 | The error "Internal error. Failed to get disked NAMESTR from hptgetdiskvarno" occurs when you access an SPD Engine data set |
D9T043 |
| 63624 | An unpaired quotation mark in a LIBNAME statement generates the message "Error: Buffer overrun occurred" |
D9T051 |
| 64651 | The error "The text expression length . . . exceeds maximum length" appears after using a %SUPERQ function and a text-string value greater than 32K |
D9T051 |
| 65379 | Attempting to use a template generated by the Output Delivery System (ODS) might cause SAS® to crash |
D9T067 |
| 64543 | The message "ERROR: Recursive Segmentation Violations" appears in the SAS® log after you run code with incorrect syntax |
D9T082 |
| 65606 | Using a forward slash with the %SYSLPUT or %SYSRPUT statement in SAS® 9.4M5 causes existing code to fail with "Unrecognized option..." |
D9T082 |
| 65808 | The ODS HTML destination uses excessive memory when it is used with the TABULATE procedure |
D9T082 |
| 65983 | The LUA procedure contains an authorization-bypass vulnerability |
D9T082 |
NOTE: If you install this hot fix and have Base SAS 9.4_M6 installed, for UNIX you must also install hot fix F1E008 and
for MVS you must also install hot fix D9T092.
You have Base SAS 9.4_M6 installed, you must also install hot fix
D9T098
D9T084
D9T080
D9T062
D9T071
G2L005.
If you install this hot fix and have
SAS Threaded Kernel 9.4_M6 installed, you must also install hot fix E2G005.
SAS Threaded Kernel 9.4_M6 installed, you must also install hot fix F8C003.
SAS Threaded Kernel Message Passing Interface 2.82 installed, you must also install hot fix E8Y002.
SAS Threaded Kernel Extensions for FedSQL and DS2 Standalone 9.4_M6 installed, you must also install hot fix E5Q002.
SAS Threaded Kernel DS2 and FedSQL Language Processors 9.41_M4 installed, you must also install hot fix E9Y004.
SAS Threaded Kernel Components for Scalable Performance Data 9.41_M6 installed, you must also install hot fix F8U001.
SAS Threaded Kernel Drivers for Scalable Performance Data 5.3_M3 installed, you must also install hot fix F8T001. |
|
|
| D9T083 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 63831 | Transcoded Oracle data is truncated incorrectly by the SAS® Federation Server LIBNAME (FEDSRV) engine |
D9T013 |
| 63320 | SAS® Federation Server does not translate the DATE format as documented for a view (DSN=BASE) created from database tables |
D9T042 |
| 64387 | The APPEND procedure generates the error "Cannot insert into readonly column column-ID" when you access data through SAS® Federation Server |
D9T042 |
| 65920 | The PRINT procedure fails to work, and you see an error regarding the sorted data set from the SAS® Federation Server (FEDSVR) engine |
D9T083 |
| 65954 | You see a "String data, right-truncated LOCALE…" error when trying to copy or create a table via the SAS® Federation Server (FEDSVR) engine |
D9T083 |
| NOTE: If you install this hot fix, you must also install hot fix D9T084 for Base SAS 9.4_M6. |
|
|
| D9T084 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 63630 | Performance issues or an ORA-01841 error might occur when you query a database management system (DBMS) table |
D9T008 |
| 64417 | In-database procedures require engine-specific definitions for SQL syntax requirements |
D9T035 |
| 64422 | A new environment variable, SAS_PRESERVE_EMPTY_STRING, provides options for the behavior when a blank or empty string is encountered |
D9T035 |
| 63320 | SAS® Federation Server does not translate the DATE format as documented for a view (DSN=BASE) created from database tables |
D9T041 |
| 65789 | The "Create Date" attribute for tables in Hadoop shows as missing in SAS® Studio and in output from the CONTENTS procedure |
D9T059 |
| 65938 | Incorrect values might be written to Hadoop for columns defined with the BIGINT data type |
D9T084 |
NOTE: If you install this hot fix, you must also install hot fixes D9T080, D9T062, D9T082, and D9T083 for Base SAS 9.4_M6.
If you install this hot fix and have SAS Threaded Kernel Extensions for FedSQL and DS2 Standalone 9.4_M6 installed, you must also install hot fix E5Q002.
If you install this hot fix and have SAS Threaded Kernel DS2 and FedSQL Language Processors 9.41_M4 installed, you must also install hot fix E9Y004.
If you install this hot fix and have SAS Threaded Kernel 9.4_M6 installed, you must also install hot fix F8C003.
If you install this hot fix and have SAS/ACCESS Interface to Hadoop 9.46 installed, you must also install hot fix E4Y007. |
|
|
| D9T085 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 62319 | Connections might become disconnected and return "ERROR: Conversations terminated..." when you use SAS/CONNECT® software |
D9T001 |
| 63215 | A segmentation violation occurs in a SAS/CONNECT® client session when you use the CONNECTKEEPALIVE environment variable |
D9T001 |
| 65079 | The SAS/SHARE® server stops responding and writes VQTCP messages to the server.log file |
D9T057 |
| 65929 | A grid-enabled sign-on to SAS® 9.4M6 (TS1M6) fails with errors, including "Remote signon … canceled" |
D9T085 |
|
| D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment. |
| D9T092 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 60730 | Initialization of SAS® shows system abend 0C4 when there are more than 16 CPs |
D9T010 |
| 64028 | GRIDINSTALLLOC and GRIDRSHCOMMAND are now available as SAS® system options |
D9T022 |
| 64237 | "ERROR:The requested LPAR name...does not match the actual LPAR name" occurs when you run sub-capacity setinits and apply IBM security patches (APARs) |
D9T032 |
| 64580 | The SAS/SHARE® server might improperly validate user access to SAS® data sets |
D9T047 |
| 60629 | When you use the DFSORT configuration option, "ERROR: in dynamic allocation for DDname XXXX (rc=0 error=0000 reason=0000)" occurs |
D9T049 |
| 65041 | The SAS/SHARE® server fails when reading an HFS directory with Read-only permissions |
D9T072 |
| 65680 | SAS/ACCESS® Interface to Oracle contains a remote code execution vulnerability |
D9T086 |
| 65790 | The message "ERROR THE DATA SET SPECIFIED IS NOT ON A MOUNTED VOLUME. WARNING: DDNAME..." occurs if you allocate SASAUTOS and concatenate DD NULLFILEs |
D9T092 |
| NOTE: If you install this hot fix and have Base SAS 9.4_M6 installed, you must also install hot fix D9T082. |
|
|
| E3R004 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 63524 | The PROC S3 PUT statement fails with a segmentation violation or write thread errors |
E3R001 |
| 64079 | The message "HTTP/1.1 400 Bad Request" occurs when you run PROC S3 on Amazon Elastic Compute Cloud (Amazon EC2) |
E3R002 |
| 64158 | PROC S3 PUT fails with the message "ERROR: tks3ConnectionUploadPart..." |
E3R002 |
| 64690 | The message "The SAS System stopped processing this step because of errors" occurs when you use IAM role security credentials with PROC S3 |
E3R003 |
| 65195 | A segmentation violation exception occurs when you use a PUT statement with the S3 procedure |
E3R004 |
|
|
| E8W002 |
| SAS/Secure SSL 9.41_M3 hot fix for Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 64003 | OpenSSL vulnerabilities exist in the Secure Sockets Layer (SSL) capability in SAS® Foundation products (OpenSSL advisories through 26 February 2019) |
E8W001 |
| 66213 | Certificates that shipped in SAS® 9.4 contain an expired certificate from Sectigo AddTrust (expired on May 30, 2020) |
E8W002 |
| NOTE: Please contact SAS Technical Support for information on accessing this hot fix and reference SAS Note 66213 |
| z/OS |
Released: July 21, 2020 | | | | |
| z/OS 64-bit |
Released: July 21, 2020 | | | | |
| 64-bit Enabled Solaris |
Released: July 21, 2020 | | | | |
| 64-bit Enabled AIX |
Released: July 21, 2020 | | | | |
| HP-UX IPF |
Released: July 21, 2020 | | | | |
| Linux for x64 |
Released: July 21, 2020 | | | | |
| Solaris for x64 |
Released: July 21, 2020 | | | | |
|
| F1E008 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 63389 | Code that sets consecutive SYSTASK commands stops executing after about 6,481 consecutive attempts |
F1E001 |
| 63200 | Importing a CSV file with UTF-16LE encoding and TERMSTR=CRLF can result in data loss |
F1E001 |
| 63941 | The NOHPRUSERFILES option is available as a restricted option in SAS® High-Performance Risk 4.2 |
F1E001 |
| 63846 | CALL MODULE routines fail with the message "ERROR: Module module-name is not in whitelist..." when you use Kerberos Constrained Delegation |
F1E001 |
| 64028 | GRIDINSTALLLOC and GRIDRSHCOMMAND are now available as SAS® system options |
F1E001 |
| 64207 | A segmentation violation occurs after you submit SYSTASK and WAITFOR statements repeatedly within a macro loop |
F1E002 |
| 63143 | Windows Defender Credential Guard and SAS® Software |
F1E003 |
| 64580 | The SAS/SHARE® server might improperly validate user access to SAS® data sets |
F1E004 |
| 64979 | ALERT - An uninstallation of SAS® 9.4 using SAS® Deployment Manager fails with the error "A problem was encountered while uninstalling..." |
F1E005 |
| 65351 * | A Read Access Violation occurs with the MEMLIB system option and the MEMCACHE system option set to 4 |
F1E006 |
| 65512 | Running a SYSTASK command results in an "Access is denied" message in the SAS® log |
F1E007 |
| 65680 | SAS/ACCESS® Interface to Oracle contains a remote code execution vulnerability |
F1E008 |
| 65825 | The error message "Connection to the server is lost" can appear in SAS® Enterprise Guide® when you are also using the ACTIVEX device driver |
F1E008 |
| * Indicates that the fix for the issue described in this SAS Note does not apply to all Operating Systems. |
NOTE: If you install this hot fix, you must also install hot fix D9T082 for Base SAS 9.4_M6.
If you install this hot fix, you must also install hot fix E8Y002 for SAS Threaded Kernel Message Passing Interface 2.82. |
|
| D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment. |
| F4P003 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 63143 | Windows Defender Credential Guard and SAS® Software |
F4P001 |
| 65051 | The error message ". . . Could not authenticate to the cluster" appears in the SAS® log when you use the GRDSVC_ENABLE function |
F4P002 |
| 66395 | Long user passwords that contain Unicode characters might fail to authenticate with PAM authentication |
F4P003 |
|
| D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment. |
| G1J001 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 64671 | The FCMP procedure in a DBCS-encoded session for SAS® 9.4M6 (TS1M6) truncates the return length value to 8 bytes |
G1J001 |
NOTE: This hot fix applies to SAS components SAS Compiler and Symbolic Differentiator 9.46 (cmp) and SAS Thread-safe Compiler and Symbolic Differentiator 9.47 (tkcmp). For instructions for how to determine the release of these components you have installed see SAS Note 35968.
|
|
| D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment. |
| G2L005 |
| Base SAS 9.4_M6 |
| Issue(s) Addressed: | Introduced: |
| 64363 | You modify the COLUMNS= option value to change from a multi-column format to a single-column format, but the column width is not correct in the output |
G2L001 |
| 64824 | The image that is specified with the PREIMAGE or POSTIMAGE style attribute appears in the wrong place in a PDF file |
G2L001 |
| 64847 | An ODS PDF statement with the CONTENTS=YES option creates graphs that overlap or are partially displayed |
G2L001 |
| 65214 | The error "The font 'font-name' contains a bad /BBox" appears in Adobe Acrobat Reader while opening a secured PDF created with the ODS PDF statement |
G2L001 |
| 56784 | Inline style overrides might affect spacing in the ODS PDF destination |
G2L001 |
| 64667 | You cannot click a URL link that is used with the LINK= option in TITLE and FOOTNOTE statements when it is included in PDF output from SAS/GRAPH® |
G2L001 |
| 64669 | PDF output that is created by SAS® might not print on certain printers |
G2L001 |
| 64453 | The ODS PDF destination with the REPORT procedure generates a premature page break when page orientation and page size toggle within the PDF |
G2L002 |
| 64809 | URL links that are created in a PostScript file generated by the ODS PRINTER destination are missing when the file is distilled to PDF |
G2L002 |
| 65403 | A "List items—Failed" error occurs in the accessibility checker in Adobe Acrobat regarding a tagged file that is created by the ODS PDF destination |
G2L002 |
| 65695 | You cannot print a PDF file in Adobe Acrobat Reader, and you see the message "An error occurred while printing the document" |
G2L003 |
| 65808 | The ODS HTML destination uses excessive memory when it is used with the TABULATE procedure |
G2L004 |
| 65961 | A screen reader does not read content correctly from a tagged PDF file that contains text that wraps in a table cell |
G2L005 |
| 66210 | A PROC FREQ table that exceeds one page in a tagged PDF file generates a segmentation violation |
G2L005 |
| 66425 | Links in tagged PDF files that are created by ODS PDF are not read correctly by screen readers or displayed correctly for visual consumers |
G2L005 |
| 66428 | A PDF file that is created by the SAS® Output Delivery System (ODS) on z/OS does not have a table of contents |
G2L005 |
| NOTE: If you install this hot fix, you must also install hot fix D9T082 for Base SAS 9.4_M6. |
|
|
Important changes to Hot Fixes!